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
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

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,007
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
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,574
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 ...
Mawg says reinstate Monica's user avatar
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 ...
bogdan's user avatar
  • 61
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

MongoDB vs Cassandra - Which one is best for Internet of Things Data

tldr; I'm going to say that Cassandra is probably the better choice for you. may be lots of sensors including Camera for photos or Videos] - Where data flow is huge. Due to its log-based nature, ...
Aaron's user avatar
  • 135
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

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 also make some intelligent ...
a_good_swan'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
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
  • 196
2 votes

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

Visio 2016 now has an add-in for the reverse engineering https://support.office.com/en-us/article/Reverse-engineer-an-existing-database-into-a-database-model-fb034862-acfc-45bc-88b2-f33d1e1f8614#...
EthR's user avatar
  • 121
2 votes

OS X MySQL client?

You may like my app SQLPro for MySQL (App Store). The app supports all the features you requested except being free/open source. If you are a student, I can happily provide a free license key. You ...
Kyle's user avatar
  • 141
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

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

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