12 votes
Accepted

Free software to reverse engineer existing complex database diagrams in SQL Server 2008+

Here's a recommendation I ended up using (after a lot more research and trying many different options): Use plain Visio for this. Here's why. Explanation of this approach: There is no tool that ...
user avatar
  • 1,645
10 votes
Accepted

A simple Java database library?

H2 Without more specific information about your needs, my first thought is the H2 Database Engine project. H2 is a pure-Java, open-source, free-of-cost, relational database that has been actively ...
user avatar
9 votes

Which database should I use? Locally stored, about 20 writes per minute, 1 read per minute, will grow 15MB each day

I would suggest you keep using SQLite3: most applications that need an embedded database for local/client storage use it, and 20 writes per minutes doesn't sound to me like a lot, all the more so as ...
user avatar
8 votes

Free software to reverse engineer existing complex database diagrams in SQL Server 2008+

Check out SQL Power Architect. It can connect to pretty much database that you can configure a JDBC connector for, and it can do all the reverse engineering that you are looking for. I only handles ...
user avatar
  • 720
8 votes

Free software to reverse engineer existing complex database diagrams in SQL Server 2008+

SchemaCrawler is a free, open-source database discovery tool that can reverse engineer your existing database. Important: SQL Server 2012 databases - SchemaCrawler works with SQL Server 2012 ...
user avatar
6 votes

A simple Java database library?

Your question is too broad to answer in anything like a definitive manner. You don't tell us at all what kind of database you want to use. Do you need an RDBMS? Key/value store? Something else? If ...
user avatar
  • 214
6 votes
Accepted

What database software to use for a personal "Stock Portfolio" tracking project?

Text Files If simply tracking a few dozen transactions per year, you don't need a database. Just write to text files, "a pile of files". Tab-delimited or CSV (comma separated values) are both ...
user avatar
6 votes
Accepted

Best Free Alternative to Tableau

Thanks for the question. I too have spent a lot of time handcrafting reports and was exposed to Tableau when others at a previous employer used it. I downloaded the trial, worked my way through the ...
user avatar
6 votes

Free lightweight database program

What I would do if you wanted something portable and lightweight is to use an application like Database Browser and have a connection to an SQLite database (an sqlite database is just a file acting ...
user avatar
  • 7,494
6 votes
Accepted

I need a software that will help me to create an diagram of a structure of my application

Try LucidChart Network Diagram Software, I think this will do it for your case.
user avatar
  • 188
5 votes

Shared contact database software

Google Docs Spreadsheet Take a look at Google Docs spreadsheet. Here is a (very simple) example I've just set up: https://docs.google.com/spreadsheets/d/1uuHm-AUWX_drwzmF5RrnH338L9FRznumk9SqjBRFKAs/...
user avatar
  • 2,291
5 votes

"End user friendly" database tool (e.g., for curating a personal collection)

You can use MySQL databases and use phpMyAdmin (see demo). License: GNU General Public License 2 (source) Platform: Runs natively under Linux on your local machine GUI support for database creation, ...
user avatar
  • 2,291
5 votes

Quick and Easy Data Model Diagrams (ERD)

I think QuickDatabaseDiagrams will suit you perfectly... but I do work there! Pros Free It really is very quick. You just type and it draws the diagram. Relationships are drawn from field to field ...
user avatar
  • 151
5 votes
Accepted

SQL Server/Oracle/MySQL database tool for developers (DDL Manipulation, stored procedures, triggers, OLEDB, ADO.NET)

You can use Eclipse with the Eclipse Data Tools Platform: SQL querying (with a GUI to create create queries visually) Can be connected to SQL Server, Oracle and MySQL. Can run on Windows and Linux ...
user avatar
5 votes
Accepted

Which DB to be use for desktop based java application

This answer makes the assumption that "medium scale" refers to a few Megabytes at max (as the question gave no further details) I'd say go with SQLite: can be used for standalone desktop application:...
user avatar
  • 18.4k
5 votes
Accepted

Database that doesn't get corrupted when killed or on power loss

Write-ahead log (WAL) Any heavy-duty enterprise-quality database uses a write-ahead log to first capture incoming data. Only after the entire chunk of data (the transaction) is captured is it then ...
user avatar
5 votes

Software tool to create/modify/view table relationships in SQLite database

The viewing part can be achieved using SchemaCrawler; amongst its features, it generates database diagrams. It supports various database formats, including SQLite. Disclaimer: I haven't used it (yet). ...
user avatar
  • 1,971
5 votes
Accepted

Is there a lightweight SQL-capable database management software that doesn't try to be a server?

Sounds like Sqlite would be just the thing. Sqlite comes as a C library and command-line utility that executes SQL statements against a database file. The software intelligently cootdinates multiple ...
user avatar
4 votes

MongoDB database administration GUI

You can use Robomongo: free and open source Windows/Linux/Mac The main difference with Mongovue is that it is shell-centric (while Mongovue is really GUI). So in some sense it is half a GUI, half a ...
user avatar
4 votes

Recommended ETL Tool

You can use Talend ETL: free and open source. It was actually the first major open source ETL, founded in 2005. supports all major DBMSs like PostgreSQL, SQL server and so on. last time I use it a ...
user avatar
4 votes

Looking for an appropriate DBMS

A free database I've used and liked is Firebird. It can be used locally or as a small-to-medium multiuser DB, has an extremely small footprint, and there are a number of libraries available for it. It ...
user avatar
4 votes

A simple Java database library?

You can take a look on HeftyDB. It is a fast key-value store, written in Java, and it's open-source.
user avatar
4 votes

A simple Java database library?

Xodus Based on your requirements, I think JetBrains Xodus is a very choice of database. It has three types of database- a key-value storage, an entity-store and a database for files and streams. #1: ...
user avatar
  • 161
4 votes
Accepted

SQL Server client for Ubuntu

Thanks for your answers. Your suggestions sound good but they weren't as easy to start as what I used, which is DBeaver, a universal database tool for developers and database administrators. Easy ...
user avatar
4 votes
Accepted

Good way to store data hierarchically?

There is an excellent PIM/outliner called Treeline that is freely available (GNU GPL) and runs under Windows and Linux. There is a small, but reasonably gentle learning curve. It comes with a number ...
user avatar
  • 1,554
4 votes
Accepted

Online public database for book readers

GoodReads matches your needs. Here is the link: GoodReads
user avatar
  • 206
3 votes

Database for storing large sets of data from web scraping

Postgres JSONB If you are scraping different kinds of data from different sources to be stored all together but varied enough or changing often enough that you don't want to define specific tables ...
user avatar
3 votes
Accepted

RDBMS for newbies in IT

I would use MySQL as RDBMS and MySQL Workbench as IDE: free works on Windows/Linux/Mac straightforward to install (to make it simpler you could even install MySQL on some server, and just have your ...
user avatar
3 votes

MySQL client for iOS?

Below is a list of SQL clients that I have tried in the past, all seem to have a limitation in one area, whilst being stronger in others. MySQL Editor Pro seems to be your best bet, IMHO. Hope this ...
user avatar
3 votes

Recommended ETL Tool

You can use Pentaho: free and open source supports all major DBMSs like PostgreSQL, SQL server and so on (even NoSQL databases). when I was reviewing ETL open source solutions a few years ago it was ...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible