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).
609
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,256
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,820
13
votes
1
answer
560
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
2
answers
725
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
828
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
517
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,031
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,256
8
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 ...
- 201
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
177
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
4k
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
445
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 ...
- 359
7
votes
1
answer
208
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
232
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 ...
- 971
6
votes
2
answers
464
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
387
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
3k
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
709
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
2k
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
3
answers
129
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
323
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
2
answers
247
views
Free cross-database editing software
Is there a free software that allows to edit database ER diagrams and export for different SQL database systems (e.g. MySQL, Oracle, SQLite, Microsoft SQL Server, etc.)?
- 159
5
votes
1
answer
158
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
177
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 ...
- 111
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 ...
- 37.6k
4
votes
2
answers
212
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
508
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
966
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
412
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,031
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
164
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
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 ...
- 201
4
votes
3
answers
194
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
4
votes
2
answers
77
views
Store and run queries on political, economic, demographical, ++ country data
I'm looking to develop an analytics tool of economic, political, demographical, and geographical data on African states. The idea is to be able to:
store country data
ask one question for many ...
- 49
4
votes
1
answer
119
views
Customer management database
I work in a small company that gets around 600 new contacts every year (via email or contact forms). Right now, we are keeping all contacts information in an Excel sheet that we share on Dropbox, ...
- 43