pREST
PlanetScale
Crunchy Bridge
Hightouch Audiences
Supabase
Google Cloud PostgreSQL
Google Cloud Platform
Zesty
DrawSQL
DBDiagram.io
Azimutt
MySQL Workbench
DbSchema
PopSQL
ChartDB
LucidChart
DrawSQL is a simple, beautiful database diagram editor for developers to ๐ง create, ๐ฌ collaborate and ๐ visualize their entity relationship diagrams.
pREST DrawSQLBased on our record, DrawSQL should be more popular than pREST. It has been mentiond 12 times since March 2021. 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.
With pRest, it is possible to create a RESTFul API to access the contents of a Postgres database in a fast and straightforward way. The project, written in Go, can be found on its official website and Github. - Source: dev.to / almost 5 years ago
So this is something I've been pondering about for a while and I think I've settled to using Directus: https://directus.io/ as my db admin and dbmate for migrations. Alternatively you could use react admin: https://marmelab.com/react-admin/ . The only problem with the latter is that it requires you to build your rest endpoint for CRUD but you can use postgrest: https://postgrest.org/en/stable/ (or it's go... Source: over 5 years ago
With this, I went for designing the db. I went to http://drawsql.app/ and created my first draft. Then exported the DDL and did a bit of back and forth with AI. This is the final draft of the database:. - Source: dev.to / 9 months 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 / over 1 year 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 / over 1 year 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: about 3 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 3 years ago
PlanetScale - The last database you'll ever need. Go from idea to IPO.
DBDiagram.io - Free database diagrams designer for analysts & developers ๐
Crunchy Bridge - Crunchy Bridge is a fully managed database as a service.
Azimutt - Next-Gen ERD to Design, Explore and Document real world databases (big and messy ones ^^)
Hightouch Audiences - Use data without SQL
MySQL Workbench - MySQL Workbench is a unified visual tool for database architects, developers, and DBAs.