DrawSQL
DBDiagram.io
Azimutt
MySQL Workbench
DbSchema
PopSQL
ChartDB
LucidChart
Amazon RDS for PostgreSQL
Amazon Aurora
Aiven
Heroku Postgres
Azure Database for PostgreSQL
Supabase
Nearbase
Application Load Balance
DrawSQL is a simple, beautiful database diagram editor for developers to ๐ง create, ๐ฌ collaborate and ๐ visualize their entity relationship diagrams.
DrawSQL
Amazon RDS for PostgreSQLAmazon RDS for PostgreSQL might be a bit more popular than DrawSQL. We know about 16 links to it since March 2021 and only 12 links to DrawSQL. 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 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
Amazon RDS for MySQL (for managed MySQL) or Amazon RDS for PostgreSQL (for managed PostgreSQL). - Source: dev.to / over 1 year ago
Amazon RDS is a managed service for relational databases that makes PostgreSQL setup, scaling, and management automatic. This lets developers concentrate on creating applications instead of handling database tasks. - Source: dev.to / about 2 years ago
Yay! We have now deployed our Django web application with ECS Service + Fargate on AWS. But now it works with SQLite file database. This file will be recreated on every service restart. So, our app cannot persist any data for now. In the next article weโll connect Django to AWS RDS PostgreSQL. - Source: dev.to / over 2 years ago
Today, AWS announces the general availability of pgactive: Active-active Replication Extension for PostgreSQL, available for Amazon Relational Database Service (RDS) for PostgreSQL. Pgactive lets you use asynchronous active-active replication for streaming data between database instances to provide additional resiliency and flexibility in moving data between database instances, including writers located in... Source: almost 3 years ago
Best practice would definitely be setting up a separately hosted database (I swear I'm not an AWS shill) for production as this ensures much better data integrity. Plus it manages backups etc. For you. Source: over 3 years ago
DBDiagram.io - Free database diagrams designer for analysts & developers ๐
Amazon Aurora - MySQL and PostgreSQL-compatible relational database built for the cloud. Performance and availability of commercial-grade databases at 1/10th the cost.
Azimutt - Next-Gen ERD to Design, Explore and Document real world databases (big and messy ones ^^)
Aiven - Leverage the complete open source ecosystem of extensions and tools to create highly-performant data pipelines for event-driven applications on all major clouds.
MySQL Workbench - MySQL Workbench is a unified visual tool for database architects, developers, and DBAs.
Heroku Postgres - Heroku Postgres is an SQL database as a service.