Questions tagged [database]
Software to create, manage, or interact with databases or software related to databases. For specific databases, please use the corresponding specific tag (see wiki).
622
questions
44
votes
8
answers
29k
views
Free software to reverse engineer existing complex database diagrams in SQL Server 2008+
Up until a few years ago I used Microsoft Visio to reverse engineer an existing database to a diagram. This feature has been deprecated for a while now, and I'm rather stuck in finding an alternative. ...
- 1,655
20
votes
2
answers
25k
views
Best Free Alternative to Tableau
Is there a good GNU/FOSS alternative to Tableau?
Tableau is a piece of software which allows you to connect to heterogeneous data sources (files, SQL databases, etc) and quickly combine data in ...
- 599
18
votes
5
answers
5k
views
Quick and Easy Data Model Diagrams (ERD)
When I'm doing documentation, I frequently want to build a small ERD by hand to demonstrate a couple of relationships that are associated with the current topic.
I can do it in Visio, and frequently ...
- 353
17
votes
5
answers
1k
views
MongoDB database administration GUI
Please suggest a good GUI-based tool for MongoDB database administration.
Requirements:
Connect to DB on local or network server.
Data view and editing features.
Free or Open Source
Support Indexing ...
- 1,502
17
votes
3
answers
16k
views
MySQL client for iOS?
I'd like to be able to manage my MySQL databases from my iPad. I currently use Sequel Pro on my Mac, and I love it.
The app must
Support connecting to remote databases
Support tunneling over SSH
...
- 4,276
15
votes
1
answer
1k
views
"End user friendly" database tool (e.g., for curating a personal collection)
I’m looking for a graphical tool that allows me to create, populate and browse/search databases.
Primary use case: Curate a personal collection (e.g., for movies, postage stamps, quotes, …). There ...
- 7,830
13
votes
1
answer
561
views
Which database should I use? Locally stored, about 20 writes per minute, 1 read per minute, will grow 15MB each day
I'm building a self-tracking system to log e.g. my phone's accelerometer, the keys I type, my mouse activity, and so on.
So which database should I use? My research so far suggests SQLite3, because ...
- 131
13
votes
2
answers
222
views
HR performance management system
I am looking for software similar to workday or successfactors for HR performance management system. But the examples I mentioned are a bit expensive. The main purpose of the software is to monitor ...
- 277
9
votes
3
answers
8k
views
Database for storing large sets of data from web scraping
I am designing a scraping system that will scrape large set of data from websites. The system is expected to collect data from websites and store it to database.
I am storing structured data parsed ...
- 211
9
votes
2
answers
730
views
Tools for maintaining and deploying database schemas and data for SQL Server?
I'd like to maintain the schema and 'static' data of a SQL Server database as code in a version control system. I'd also like to be able to deploy specific versions of the database code to actual ...
- 643
9
votes
3
answers
834
views
Database for large volume of metrics (key, value, timestamp)
I'm looking for a Database for large amounts of metrics, and i'm confused that there is nothing out there to:
store large amounts (terrabytes) of metrics data in the form:
key (string)
value (...
- 191
9
votes
1
answer
518
views
General purpose database application alternatives for iOS and Mac
I am looking for a way to manage inventory in the field. I want to use an ipad/iphone for taking inventory, and use a mac to generate reports.
This can be a single app or a pair of apps.
I can do ...
- 1,051
8
votes
6
answers
17k
views
A simple Java database library?
I'm looking for a library to manage a "database" in my Java application. I want something simple, and easy to use. Specifically, I'm looking for something which:
Is easy to start using. I'd like to ...
- 195
8
votes
5
answers
7k
views
OS X MySQL client?
I'd like to have a nice GUI for MySQL on OS X. The app must:
Support connecting to external databases
Support tunneling over SSH
Show a nice GUI for editing and creating table schema
Give access to a ...
- 4,276
8
votes
2
answers
319
views
Free software to track movies I'm watching
I am looking for either a web app or installable program that will track the
movies I have watched.
I have found a few online but I would like one that also tracks how many times I
have watched each ...
- 1
8
votes
0
answers
179
views
License management software (Open Source)
I’m trying to find a solution for keeping our license information in our database.
Let’s say a customer bought something 5 years ago, so I will create a new cutomer and assign him the license he ...
- 181
7
votes
3
answers
8k
views
SQL Server client for Ubuntu
I need to connect to a MS SQL Server database from my Ubuntu machine. Any client suggested? I found libmono-entityframework-sqlserver6.0-cil, will that work?
It doesn't sound like just a client:
...
- 221
7
votes
4
answers
5k
views
PostgreSQL front end for adding, viewing and updating values
In the scope of a small community project we were compelled to create a database in order to manage our events, the participating members, their contact details and so on. I've created a PostgreSQL DB ...
- 175
7
votes
1
answer
450
views
General-purpose, open-source, GUI relational database management application
I'm looking for a general-purpose, open-source, graphical user interface database management and manipulation application for Linux. I've been using Navicat Premium Essentials on my Mac, and am in ...
- 351
7
votes
2
answers
1k
views
multi-user photo/picture manager/organizer/database software
I work at an organization that makes extensive use of photography and we need an better way to organize all our photos. We have several staff and volunteers who take photos regularly. Then we use ...
- 374
7
votes
1
answer
219
views
A Database Management System that understands Relational Algebra Queries
I am a Computer Science student and we are currently learning Relational Algebra. I wish to be able to write Relational Algebra Queries and test to see what they return. Thus, I am looking for a ...
6
votes
1
answer
233
views
Shared contact database software
I'm looking for a way of sharing a database of contacts amongst a group of not-very-tech-savvy staff & volunteers in a non-profit.
The setup and storage of data can be technical/complex as a one-...
- 258
6
votes
2
answers
3k
views
Simple WYSIWGY CRUD web frontend for a database
It should be open source, deployable with MySQL/Postgres (or maybe some nosql thing);
It should support CRUD using web forms;
Layout of those forms should be configurable by administrator in the ...
- 1,003
6
votes
2
answers
475
views
Which RDBMS should I use for a chat application?
I'm developing a chat project (server/client), so I will need an RDBMS for saving and loading user profiles, users logging-in etc., just like Skype does.
So my question is: which RDBMS will fit my ...
- 163
6
votes
2
answers
428
views
In-app triplestore like SQLite
Is there any open-source and cross-platform triplestore that could be integrated into a C++ application?
I’m not looking for servers (i.e. 4store or Soprano). The good example for relational ...
- 183
5
votes
3
answers
4k
views
Software tool to create/modify/view table relationships in SQLite database
I would like to have a software tool to create/modify/view table relationships in a SQLite database in a visual way, something like the picture below. For a MySQL database, I can use the MySQL ...
- 163
5
votes
2
answers
722
views
Recommended ETL Tool
Goal:
Find a new ETL tool that shall replace Microsoft SQL Server Integration Services (SSIS).
Criteria:
- Open source, or free to use. No trial.
- User-friendly.
Information:
- I use different ...
- 711
5
votes
2
answers
3k
views
What DB engine should be used for a petabyte database?
Given:
The volume of data is expected to run into petabytes over a couple of years.
The full set of record types, applications and queries is not known in advance. It is expected that stakeholders ...
- 153
5
votes
4
answers
26k
views
What is the best frontend program for my database needs?
I am currently an Electrical engineer and I have been tasked to set up a database(outside my realm of expertise) that will be used by multiple users over a networked drive. There will only be a couple ...
- 153
5
votes
3
answers
130
views
Most appropriate software for data warehouse ticket tracker and encyclopedia
My university is working on a data warehouse and I was given a task to create a website (we call it "data warehouse encyclopedia, but it isn´t a widely used title"), which will have few simple ...
- 181
5
votes
2
answers
137
views
Configurable barcode reading app
At our school, we want to make our own attendance application. We would like the teacher to have an app that can read a barcode (from student id card) and send the result to a web server, where we put ...
5
votes
1
answer
332
views
COTS or OS reporting tools for Oracle?
I work for an organization that has a relatively massive Oracle 11g database. We currently invest a lot of time in producing custom reports - the queries are quite complex and not something to be ...
- 51
5
votes
2
answers
1k
views
UML to Java and Hibernate
I want to design my UML diagrams in a program, and have the program generate Java classes and Hibernate mappings.
Java to UML generator on Linux is similar but does not fulfill all my requirements.
...
- 273
5
votes
1
answer
160
views
PHP/Java/C++ frameworks for declarative SQL to REST API binding
What libraries/frameworks, if any, exist to bind/"scaffold" SQL relational databases to a RESTful API in a declarative manner?
In short, by specifying the names of the tables and fields (alongside ...
- 101
5
votes
1
answer
1k
views
Easy, Automatic REST API for a SQL (MySQL, PostgreSQL, etc) Database or DaaS
I need REST API access to my SQL database for end user queries in a mobile application.
I am trying to avoid having to program my own REST API because I come from a statistical programming (R, SAS, ...
- 599
5
votes
2
answers
179
views
Good data entry and management systems
I am a PhD student and am thinking ahead to when I start up a psychology lab---what are some of the best data entry and management systems? To avoid the "it depends" answer, below I list what I'm ...
- 151
5
votes
1
answer
117
views
Suitable product for job management
A group at my work are looking for software to help with job management in the workplace. The work environment is a laboratory and flows roughly as follows:
items come in
items may require one or ...
- 151
5
votes
0
answers
79
views
How to centralize, store and analyse spread out file logs?
TLDR: Our application generates file logs holding bits of information that we'd like to parse them and store in one place, in order to periodically consult them and compute metrics from them (in real ...
- 121
5
votes
0
answers
90
views
Local Development Databases
Currently, I work in a company with about 20 developers, give or take a few, and am looking for a way to give each developer their own development database for dev/testing purposes.
Each developers ...
- 151
4
votes
4
answers
2k
views
Convert XML to a relational database
I am looking for a program, script or web service that can take one XML file as input, and build a relational database from it (schema + populating it). Ideally, MySQL, MariaDB or Postgres.
Microsoft ...
- 38.1k
4
votes
2
answers
221
views
I need a software that will help me to create an diagram of a structure of my application
I need a software that might help me about drawing/creating something like this:
That's what I've found in my faculty book, and I need to create my own diagram of structure of my application, that ...
- 153
4
votes
2
answers
525
views
Database schema visualization for MS SQL Server
Are there any tools for schema visualization of an existing MS SQL Server database? In particular, I'd like something that reads the tables, fields, and constraints automatically, and that allows for ...
- 237
4
votes
1
answer
1k
views
Free lightweight database program
I need a smallish lightweight and free database program to keep track of items in a large collection. I don't need it to be able to do much besides being able to create entries with various fields ...
- 141
4
votes
2
answers
2k
views
Command line SQL formatter or beautifier
I am looking for a command line SQL formatter = SQL prettifier = SQL beautifier (offline, not an online formatter) for Mac. The goal is to run it on the command line and also inside the editor (Emacs) ...
- 129
4
votes
2
answers
417
views
spreadsheet alternatives Pascal:Basic :: ???:Spreadsheets
I use excel. I use google sheets. I've used Opencalc. And to really date me, I've used Visicalc.
I've come to the conclusion that spreadsheets are in essence the 'Basic' of tabular data.
I am ...
- 1,051
4
votes
2
answers
1k
views
MongoDB vs Cassandra - Which one is best for Internet of Things Data [closed]
Recently one of my client asked me to take a decision on choosing database for one Industrial project (Where there may be lots of sensors including Camera for photos or Videos) - Where data flow is ...
- 141
4
votes
2
answers
179
views
Scanning Handwritten Notes and Creating a Database
I'm looking for software capable of creating a searchable database from scanned files (probably PDFs but the file type isn't important) so that I can categorize and search all of my handwritten ...
- 143
4
votes
3
answers
231
views
In-memory database for streaming market data
I'm looking for recommendations for an in-memory database for capturing streaming market data state. While the transaction rate may reach into millions/sec, most of these transactions will be updates ...
- 141
4
votes
1
answer
137
views
Database/Scripting Language suggestion for a project involving heavy inserts? [closed]
I am looking into a project which involves large number of inserts daily.I will have a list of user's (for example a user set of 500k ) , for which I need to monitor daily certain activities ...
- 211
4
votes
3
answers
200
views
Tool for database comparison
I am looking for a tool that allows me to compare two SQL Server databases, see the differences, and move the changes from one database to another. In simpler terms, I want a tool exactly like the ...
- 337