Store any type of data and combine the simplicity of SQL with the scalability of NoSQL. CrateDB is an open source distributed database running queries in milliseconds, whatever the complexity, volume and velocity of data.
DrawSQL is a simple, beautiful database diagram editor for developers to ๐ง create, ๐ฌ collaborate and ๐ visualize their entity relationship diagrams.
Based on our record, DrawSQL seems to be a lot more popular than CrateDB. While we know about 11 links to DrawSQL, we've tracked only 1 mention of CrateDB. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.
Kafka is the front line of the stack, used to queue messages received from (for example) IoT sensors and devices. CrateDB will query and store the data. And between CrateDB and Kafka, it lives Apache Flink, a data processing engine. These three tools are all distributed systems that provide elastic scaling, fault tolerance, high-throughput, and low-latency performance via parallel processing. - Source: dev.to / about 4 years ago
So I started designing the DB using this cool tool. The project has 2 tables, users and categories . The user can create many categories as he wants so the first approach I took was creating a third table, a union table to store user_id and category_id. With this solution the users are able to create x numbers of categories and we can see assign the category to the user. - Source: dev.to / 3 months ago
Once you have generated the SQL code, you can convert it into a relational schema (the graphical table model) using DrawSQL. This tool offers:. - Source: dev.to / 4 months ago
DrawSQL makes it easy for teams to collaborate on creating and maintaining schema diagrams. With a single source of truth, there's no need for manually syncing diagram files between different developers and offline tools anymore. Source: almost 2 years ago
To be honest, since you are just getting started, I think you should reconsider simplifying this app to begin with. Built something easier and get some more experience before jumping in the ocean. Maybe start by focusing only on the parent company and sub-companies. However, I strongly recommend you to try and make a diagram of your database with relations and columns as it can you a lot of time. I personally use... Source: about 2 years ago
After googling some, I found DrawSQL, which is a start. But I don't like its interface, and the inability to download the schemas in any form (at least not from what I can see). Source: over 2 years ago
Supabase - An open source Firebase alternative
MySQL Workbench - MySQL Workbench is a unified visual tool for database architects, developers, and DBAs.
Prisma Schema Builder - Prisma Schema Builder is an attempt to build a visual tool for constructing Prisma database schemas.
DBDiagram.io - Free database diagrams designer for analysts & developers ๐
Arctype - Free SQL Client for developers and teams. Available for Mac, Windows, Linux, and Web.
PopSQL - Modern SQL editor for teams