johnnyfish

joined 6 months ago
[–] johnnyfish@lemmy.world 2 points 2 weeks 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