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 ...
- 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 ...
- 3,058
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 ...
- 36.7k
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 ...
- 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 ...
- 365
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 ...
- 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 ...
- 3,058
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 ...
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 ...
- 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.
- 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/...
- 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, ...
- 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 ...
- 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 ...
- 36.7k
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:...
Izzy♦
- 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 ...
- 3,058
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).
...
- 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 ...
- 213
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 ...
- 36.7k
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 ...
- 36.7k
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 ...
- 381
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.
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: ...
- 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 ...
- 201
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 ...
- 1,554
4
votes
Accepted
Online public database for book readers
GoodReads matches your needs. Here is the link: GoodReads
- 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 ...
- 3,058
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 ...
- 36.7k
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 ...
- 321
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 ...
- 36.7k
Only top scored, non community-wiki answers of a minimum length are eligible