johnnyfish

joined 8 months ago
 

Hi everyone! ๐Ÿ‘‹

Three months ago, I posted about ChartDB - a self-hosted, open-source tool for visualizing and designing your database schemas. Since then, weโ€™ve shipped tons of new features and fixes, and weโ€™re excited to share whatโ€™s new!

Why ChartDB?

  • โœ…ย Self-hosted - Full control, deployable anywhere via Docker
  • โœ…ย Open-source - Actively maintained and community-driven
  • โœ…ย No AI/API required - Deterministic SQL export, no external calls
  • โœ…ย Modern & Fast - Built with React + Monaco Editor
  • โœ…ย Multi-DB Support - PostgreSQL, MySQL, MSSQL, SQLite, ClickHouse, Cloudflare D1โ€ฆ and now Oracle!

Latest Updates (v1.11 โ†’ v1.13)

  • ๐Ÿ†• Oracle Support - Import and visualize Oracle schemas
  • ๐Ÿ†• Custom Types for Postgres - Enums and composite types
  • ๐Ÿ†• Areas for Diagrams - Group tables visually into logical zones
  • Transparent Image Export - Great for docs & presentations
  • PostgreSQL SQL Import - Paste DDL scripts to generate diagrams
  • Improved Canvas UX - Faster, smoother, less lag
  • Inline Foreign Key DDL - Clean, readable SQL exports
  • Better JSON Import - Sanitize broken JSON gracefully
  • Read-Only Mode - View diagrams without editing access
  • DBML Enhancements - Support for comments, enums, inline refs

โ€ฆplus 40+ bug fixes and performance improvements

๐Ÿง  Whatโ€™s Next?

  • AI-powered foreign key detection
  • Git integration for diagram versioning
  • More database support & collaboration tools

๐Ÿ”—ย GitHub:ย https://github.com/chartdb/chartdb
๐Ÿ”—ย Docs:ย https://docs.chartdb.io/ ๐Ÿ”— Live Demo / Cloud Version:ย https://chartdb.io/

Weโ€™d love to hear your feedback, contributions, or just how you're using it.
Thanks for all the support so far! ๐Ÿ™Œ

[โ€“] johnnyfish@lemmy.world 2 points 2 months ago

Awesome, glad to hear it's working for you now! ๐ŸŽ‰ We realized native SQL generation was the right move for reliability and consistency. Appreciate you sticking with it - let us know if you run into anything else!

 

Hi everyone! ๐Ÿ‘‹

Weโ€™re excited to share the latest updates to ChartDB, our self-hosted, open-source tool for visualizing and designing database diagrams - built as a free and flexible alternative to tools like dbdiagram[.]io, DrawSQL, and DBeaver's diagram feature.

Why ChartDB?

โœ… Self-hosted โ€“ Full control, deployable anywhere via Docker
โœ… Open-source โ€“ Actively developed and maintained by the community
โœ… No AI/API required โ€“ Deterministic SQL export with no external dependencies
โœ… Modern & Fast โ€“ Built with React + Monaco Editor, optimized for performance
โœ… Multi-DB support โ€“ PostgreSQL, MySQL, MSSQL, SQLite, ClickHouse, and now Cloudflare D1

Latest Updates (v1.8.0 โ†’ v1.10.0)

๐Ÿ†• Cloudflare D1 Support - Import schemas via Wrangler CLI
๐Ÿ†• Deterministic DDL Export - Replaced AI-based export with native SQL generation
๐Ÿ†• Sidebar for Diagram Objects - Quickly navigate tables, fields, indexes, and FKs
๐Ÿ†• Better Canvas UX - Right-click to create FKs, table drag-and-drop, better visibility controls
๐Ÿ†• Internationalization - Added full French & Ukrainian support

Whatโ€™s Next

  • Git integration for diagram versioning
  • SQL import support for PostgreSQL (via DDL script)
  • AI-powered table relationship detection
  • More database support and collaboration tools

๐Ÿ”— GitHub: https://github.com/chartdb/chartdb
๐Ÿ”— Docs: https://docs.chartdb.io/

Weโ€™d love your feedback, contributions, or just to hear how youโ€™re using it. Thanks!

 

Hey all!

About three weeks ago, I introduced ChartDB to this community and received a great response with tons of positive feedback and feature requests. Thank you for the amazing support!

recap of ChartDB: For those new to ChartDB, it simplifies database design and visualization, similar to tools like DBeaver, dbdiagram, and DrawSQL, but is completely open-source and self-hosted.

https://github.com/chartdb/chartdb

Key features:

  • Instant Schema Import - Import your database schema with just one query.
  • AI-Powered DDL Export - Generate scripts for easy database migration.
  • Broad Database Support - Works with PostgreSQL, MySQL, SQLite, MSSQL, ClickHouse, and more.
  • Customizable ER Diagrams - Visualize your database structure as needed.
  • Open-Source & Self-Hostable - Free, flexible, and transparent.

Whatโ€™s New in v1.20 (2024-11-17)

  • Sharing Capabilities - Import and export diagrams easily for better collaboration.
  • Duplicate table: duplicate table from the canvas and sidebar.
  • Snap to Grid - Toggle or hold shift to precisely position elements.
  • New Templates Added - Now includes templates for Laravel, Django, Twitter, and more.
  • Docker Build Support - Includes OpenAI key support for Docker builds.

Bug Fixes & Improvements:

  • Optimized Bundle Size - Leaner builds for faster loading times.
  • Internationalization (i18n) - Added support for Korean, Simplified Chinese, Russian, French, and more.
  • Improved UX - Better interactions for editing diagram titles and smoother SQL export.

Whatโ€™s Next?

  • More sharing and collaboration enhancements.
  • Expanded templates and language support.
  • New deployment options and compatibility for more databases.

Weโ€™re building ChartDB hand-in-hand with this community and contributors. Your feedback drives our progress, and weโ€™d love to hear more! Thank you to everybody who contributed!

 

Hi all, Iโ€™m one of the creators of ChartDB.

ChartDB to simplify database design and visualization, providing a powerful, intuitive tool thatโ€™s fully open-source. This database diagram tool is similar to traditional ones you can find: dbeaver, dbdiagram, drawsql, etc.

https://github.com/chartdb/chartdb

Key Features:

  • Instant schema import with just one query.
  • AI-powered export to generate DDL scripts for easy database migration.
  • Supports multiple database types: PostgreSQL, MySQL, SQLite, Mssql, ClickHouse and more.
  • Customizable ER diagrams to visualize your database structure.
  • Fully open-source and easy to self-host.

Tech Stack:

  • React + TypeScript
  • Vite
  • ReactFlow
  • Shadcn-ui
  • Dexie.js