SQLite
PostgreSQL
MySQL
Microsoft SQL
Oracle DBaaS
Oracle Database 12c
MongoDB
SAP HANA
Azimutt
DrawSQL
DBDiagram.io
Supabase
ChartDB
LucidChart
draw.io
TablePlus
If you are looking to explore and understand your database (relational or document), Azimutt is the tool you need. It's the first entity relationship diagram built to handle big database schema (up to 1000 tables) with dedicated features: search, find path and even schema analysis to keep it consistent.
SQLite AzimuttNo Azimutt videos yet. You could help us improve this page by suggesting one.
Azimutt's answer:
Azimutt is mainly targeted at developers working with databases, allowing them to easily explore and understand them by either importing the schema or connecting to a live instance.
As it's quite easy to use, we have seen other profile such as product owners, engineering managers and even CFOs using it to better understand the product they build or extract meaningful data on their own ^^
Azimutt's answer:
Early 2021 I joined Doctolib, a health startup very successful in France, and discovered their big Ruby on Rails monolith backed by a large PostgreSQL database with more than 700 business tables (more then 1300 in total). As an architect I worked with several teams and needed to understand their models but neither Ruby, Rails or the structure.sql were very helpful for such a big app. So I looked for a tool but they all failed with such a large database, so after a few month and tens of tools tested, I decided to build my own: Azimutt. Now it has evolved a lot and we are still very active to enable new usages every months. I believe it's a solid product and quite unique โค๏ธ
Azimutt's answer:
From development languages, Azimutt is built with Elm/TypeScript for the frontend, Elixir/Phoenix for the backend and PostgreSQL/S3 as storage.
Azimutt's answer:
It's the only ERD able to handle databases with many tables (>1000) nicely thanks to unique features:
It's also very unique in the sense it's made to explore and understand real world databases, from development to production with larges features:
Thousands of developers already love it, give it a try, we have several samples you can try right away!
Azimutt's answer:
Azimutt is the all-in-one app to explore real world databases. If you look for very specialized features some competitors may be more suited, but if you want a versatile app to explore and understand your database, we believe no competitor come close to us.
Azimutt's answer:
Azimutt is used at Doctolib (3000 people company) and some other french scale ups I can't disclose yet.
Based on our record, SQLite should be more popular than Azimutt. It has been mentiond 18 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.
Yes. A Lightroom catalog file is, after all, just a SQLite database. (Srsly, make a copy of your catalog file, rename it whatever.sqlite and use your favorite SQLite GUI to rip it open and look at the tables and fields). It's just storing the pathame to the RAW file for that file's record in the database. Source: about 3 years ago
I use visidata with a playback script I recorded to open the sheet to a specific Excel tab, add a column, save the sheet as a csv file. Then I have a sqlite script that takes the csv file and puts it in a database, partitioned by monthYear. Source: about 3 years ago
Use the most-used database in the world: https://sqlite.org/index.html. Source: over 3 years ago
With this in mind, I wrote a few versions of this post, but I hated them all. Then I realized that jodliterate PDF documents mostly do what I want. So, instead of rewriting MirrorXref.pdf, I will make a few comments about jodliterate group documents in general. If you're interested in using SQLite with J, download the self-contained GitHub files MirrorXref.ijs and MirrorXref.pdf and have a look. - Source: dev.to / almost 4 years ago
SQLite, by many estimates, is the most widely deployed SQL database system on Earth. It's everywhere. It's in your phone, your laptop, your cameras, your car, your cloud, and your breakfast cereal. SQLite's global triumph is a gratifying testament to the virtues of technical excellence and the philosophy of "less is more.". - Source: dev.to / almost 4 years ago
Not mine but someone showed me this : https://azimutt.app/. - Source: Hacker News / almost 2 years ago
I just want to get a basic overview quickly. An old colleague of mine created an interactive web app that does this. We use it internally and I find it super useful. Supports SQLite, among others: https://azimutt.app/. - Source: Hacker News / over 2 years ago
Hello Dev.to community, I'm Sam, a proud part of a dedicated trio that built Azimutt.app. - Source: dev.to / about 3 years ago
A couple of options here: - From a database. Generate ERD by connecting to your database directly. I've used this as a quick way to generate a diagram from my local or even QA DB (not prod DB for obvious security reasons). - From a schema dump file. Take a pg dump and then generate an ERD from the dump file. There are ERD tools like dbdaddy.dev and azimutt.app that support these options. Source: over 3 years ago
PostgreSQL - PostgreSQL is a powerful, open source object-relational database system.
DrawSQL - Easy database diagrams. Create, visualize and collaborate on your database entity relationship diagrams.
MySQL - The world's most popular open source database
DBDiagram.io - Free database diagrams designer for analysts & developers ๐
Microsoft SQL - Microsoft SQL is a best in class relational database management software that facilitates the database server to provide you a primary function to store and retrieve data.
Supabase - An open source Firebase alternative