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 ...
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 ...
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 ...
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,574
6 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 ...
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

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

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:...
  • 18.5k
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). ...
  • 2,009
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 ...
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 ...
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 ...
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

General-purpose, open-source, GUI relational database management application

The only thing that springs to mind here is LibreOffice Base, in terms of multi-database support. It's free and open source, available in all (as far as I'm aware) Linux repos, has a query editor, and ...
  • 1,616
3 votes

Is MS Access suitable for my use case?

I don't know anything about certifications but I wouldn't use Access for storage. I would use it for the user interface and use SQL Express for storage. You can link the tables into Access and use ...
  • 61
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 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 ...
3 votes
Accepted

Convert .mbox files to .sql

"Free and open source" - given that requirements, I guess your best shot is to create a small Perl script, utilizing the modules Mail::Mbox::MessageParser and SQL::Generator. For Python, the module "...
  • 190
3 votes

Create a local MS SQL Database on OSX Yosemite

Unfortunately, you cannot install MS SQL server directly on OS X operating system. Only option is Windows servers/OS. See this Then do you have any option? Yes. VMs Parallels: Virtualize the window ...
  • 213
3 votes

spreadsheet alternatives Pascal:Basic :: ???:Spreadsheets

I would suggest taking a look at ipython specifically with notebooks Full power and flexibility of python available. Allows a mix of data, calculations, formatted notes in markdown & html, ...
  • 31.1k
3 votes
Accepted

Free options to MySQL Query Analyzer

The one that I know is TOra, which seems to do what you ask for (and much more). TOra is an open-source multi-platform database management GUI that supports accessing most of the common database ...
  • 1,780
3 votes
Accepted

What software do I need to convert a pdf to text that can then be processed using regex to extract specific pieces of data?

It's possible to convert .pdf document to a text file. After doing that it should be possible to extract a piece of text depending on how regular will it be using regular expressions. You did not ...
3 votes

Best Free Alternative to Tableau

I don't think you have the right approach. You are supposing that an exact clone of Tableau is the best answer. It might not be. Notice that if Tableau (which I don't know and don't care about) was ...
3 votes

Simple WYSIWGY CRUD web frontend for a database

You don't say which language you are coding in. I will take a guess sand say it's PHP, as opposed to Node.Js or other. If you code in PHP and don't mind using the veyy popular and easy to learn ...
3 votes

Database schema visualization for MS SQL Server

SAP PowerDesigner does the job but it's superexpensive (I think ~5000+ EUR per seat). The feature is called "reverse engineering a database". You just point it to a database (not just SQL Server but ...
  • 61

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