Skip to main content
The 2024 Developer Survey results are live! See the results
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 ...
Sualeh Fatehi's user avatar
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.
Polish's user avatar
  • 188
6 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). ...
Glorfindel's user avatar
  • 2,035
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 ...
TrevorJ's user avatar
  • 151
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 ...
Basil Bourque's user avatar
5 votes
Accepted

Online public database for book readers

GoodReads matches your needs. Here is the link: GoodReads
dannemp's user avatar
  • 216
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 ...
Ari Fordsham's 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: ...
dipu's user avatar
  • 161
4 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 ...
Basil Bourque's user avatar
4 votes

Convert XML to a relational database

DISCLAIMER: I WORK AT SQLIZER.IO An online tool called 'SQLizer' exists (I work here) which can take XML (or JSON & XLS) and convert it into MySQL table definitions and insert statements. It will ...
a_good_swan's 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 ...
Dɑvïd's user avatar
  • 1,560
4 votes
Accepted

Command line SQL formatter or beautifier

Prettier integrates with editors and Git, has a command-line interface, and a SQL plugin.
mustaccio's user avatar
  • 206
3 votes

Database schema visualization for MS SQL Server

SchemaCrawler is a free, open-source database discovery tool that can reverse engineer your existing Microsoft SQL Server 2008 database. Take a look at examples of the SchemaCrawler Database Diagrams. ...
Sualeh Fatehi's user avatar
3 votes

Web based solution for large point clouds

I don't think that either MapServer or GeoServer will be able to handle large point cloud datasets, though they can both use PostgreSQL/PostGIS as a data source. If you want some open source software ...
nmtoken's user avatar
  • 147
3 votes

Convert XML to a relational database

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). ...
Pimp Juice IT's user avatar
3 votes

Convert XML to a relational database

You can easily convert XML or JSON to MariaDB / MySQL using Flexter. Have a look at this blog post that shows how to convert TransXchange XML to MariaDB. Flexter will auto-generate the target schema ...
Uli Bethke's user avatar
3 votes

Alternative to ELK, but based on PostgreSQL

I'm very excited about TimescaleDB, which is an extension to Postgres that creates hyper tables that handle all the time series partitioning magic and supposedly bring huge scale to write throughput. ...
quickdraw's user avatar
3 votes
Accepted

Offline database for Java

Spreadsheet or FileMaker For a mere 10 megs of data in a single table (list), consider using a spreadsheet or FileMaker rather than building your own app. Database versus File If your data is ...
Basil Bourque's user avatar
3 votes
Accepted

Embedded database on Java

H2 H2 Database is a relational database engine built in pure Java. Actively developed by someone with a long history of making such products. Open-source and free-of-cost. Can be used either ...
Basil Bourque's user avatar
3 votes

Which DB should I use in my case?

You should do some more study on database technology. A database system acts as a black box, a mediator between the user or calling programmer and the data being managed by the DBMS. The actual data ...
Basil Bourque's user avatar
3 votes
Accepted

Alternative to SQL Server Management Studio for Ubuntu

Azure Data Studio from Microsoft should be an easy start for previous SSMS users.
Ross Presser's user avatar
3 votes

NoSQL database for Windows with Offline sync capability

Couchbase Mobile (i.e. Couchbase Lite + Sync Gateway) might fit the bill.
Matthew Groves's user avatar
3 votes

Command line SQL formatter or beautifier

Try out sqlformat, shipped with sqlparse Python library. The easiest way to install it is using pipx: pipx install sqlparse Here is an example of running it: $ echo "sElECt address,country,fName ...
Flimm's user avatar
  • 157
2 votes

Database for large volume of metrics (key, value, timestamp)

Completely agree about graphite, influx, opentsdb. Been there, ran into the same issues. The best answer is probably AWS Redshift or Cassandra. Redshift: Postgres but with columnar data store. ...
Alex I's user avatar
  • 121
2 votes

Simple storage engines or low-level databases embeddable in Java

H2 Database, MVStore The pure-Java relational database engine, H2 Database, has an explicit key-value store called MVStore. Each store contains a number of maps that can be accessed using the java....
Basil Bourque's user avatar
2 votes

Scanning Handwritten Notes and Creating a Database

If you would like to OCR the handwritten notes, so as be able to perform full text searches, etc., then there is a very good tutorial here on using a software stack for deep learning to train and ...
Steve Barnes's user avatar
  • 31.7k
2 votes

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

I just had the same requirements as the original question, but Visio already had an advantage for our choice as the ERD diagrams were once generated via reverse-engineering in 2007. Since, we already ...
Ozair Kafray's user avatar
2 votes

Free options to MySQL Query Analyzer

If you are looking for something to help you analyze and optimize queries, the two tools that I can recommend most are Percona's PMM and Shattered Silicon's SSM (fork of PMM v1). Both support ...
Charlotte Ruddick's user avatar
2 votes
Accepted

What are good candidates for a fixed, externally accessible database for Qt/C++?

You may like the QSQLITE database driver from QSqlDatabase. Data is stored in compact files. No typical database setup required. The Sqlite project provides the command line tool sqlite3 for ...
Harri's user avatar
  • 239
2 votes

Desktop-native graphical db management tool for RethinkDB?

Try this: RethinkDB GUI Client for Mac OS X, Windows, and Linux ReQLPro is free Desktop GUI that was built to help fill that void for RethinkDB. Right now it mostly covers the "poking data with the ...
Cass's user avatar
  • 31

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