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,078
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,078
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 ...
- 3,078
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:...
Izzy♦
- 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 ...
- 213
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
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,078
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
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