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
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
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,138
5
votes
Accepted
Online public database for book readers
GoodReads matches your needs. Here is the link: GoodReads
- 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).
...
- 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 ...
- 213
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
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,138
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,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 ...
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
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.
...
- 365
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, ...
- 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 ...
- 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). ...
- 313
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 ...
- 152
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 ...
- 131
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. ...
- 31
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 ...
- 3,138
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 ...
- 3,138
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 ...
- 3,138
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.
- 192
3
votes
NoSQL database for Windows with Offline sync capability
Couchbase Mobile (i.e. Couchbase Lite + Sync Gateway) might fit the bill.
- 131
3
votes
Accepted
Command line SQL formatter or beautifier
Prettier integrates with editors and Git, has a command-line interface, and a SQL plugin.
- 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#...
- 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 ...
- 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 ...
- 121
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. ...
- 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....
- 3,138
Only top scored, non community-wiki answers of a minimum length are eligible