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).

Filter by
Sorted by
Tagged with
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. ...
Jeroen's user avatar
  • 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 ...
Hack-R's user avatar
  • 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 ...
Steve Kallestad's user avatar
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 ...
rahulroy9202's user avatar
  • 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 ...
Undo's user avatar
  • 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 ...
unor's user avatar
  • 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 ...
Stephen's user avatar
  • 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 ...
user899893's user avatar
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 ...
Kenny Evitt's user avatar
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 (...
aep's user avatar
  • 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 ...
Sherwood Botsford's user avatar
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 ...
Jonas Czech's user avatar
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 ...
Undo's user avatar
  • 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 ...
Surabhil Sergy's user avatar
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 ...
Zombo's user avatar
  • 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 ...
Alex's user avatar
  • 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: ...
Mario Trucco's user avatar
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 ...
Ratnanil's user avatar
  • 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 ...
Jens Erat's user avatar
  • 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 ...
Sean's user avatar
  • 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 ...
WeirdestQuestions's user avatar
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-...
drfrogsplat's user avatar
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 ...
Vi.'s user avatar
  • 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 ...
randydom's user avatar
  • 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 ...
polkovnikov.ph's user avatar
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 ...
user1824987's user avatar
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 ...
HelloWorld1's user avatar
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 ...
rwallace's user avatar
  • 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 ...
Martin Čejka's user avatar
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 ...
Michiel van der Blonk's user avatar
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 ...
susan's user avatar
  • 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. ...
jasilva's user avatar
  • 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.)?
Mikel's user avatar
  • 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 ...
Vittorio Romeo's user avatar
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, ...
Hack-R's user avatar
  • 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 ...
itpetersen's user avatar
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 ...
timbo's user avatar
  • 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 ...
Pierre's user avatar
  • 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 ...
B-M's user avatar
  • 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 ...
Franck Dernoncourt's user avatar
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 ...
Roxy'Pro's user avatar
  • 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 ...
feetwet's user avatar
  • 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 ...
John Doe's user avatar
  • 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 ...
Sherwood Botsford's user avatar
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 ...
AskMe's user avatar
  • 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 ...
Shoddy Weather's user avatar
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 ...
Surabhil Sergy's user avatar
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 ...
scubaFun's user avatar
  • 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 ...
fredrikrab's user avatar
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, ...
N496's user avatar
  • 43

1
2 3 4 5
13