johnnyfish

joined 3 weeks ago
[–] johnnyfish@lemmy.world 2 points 3 days ago

Thanks for the kind words and great feedback! Query capabilities are on our radar, and your input reinforces its importance. The mouse wheel suggestion for zooming is a great idea - I’ll note it for future updates. Glad to hear you'll give ChartDB a try alongside DBeaver - let us know if you have more ideas or feedback! (give a look to our next innovation - https://buckle.dev/ Would love to chat. feel free to DM me somehow :)

[–] johnnyfish@lemmy.world 3 points 3 days ago

Thank you! 😊 Really appreciate it! We’re excited to keep improving and adding new features. If you have any feedback or ideas, feel free to share!

[–] johnnyfish@lemmy.world 8 points 3 days ago (1 children)

Thanks for your interest! I appreciate the curiosity about ChartDB's growth. We’ve been fortunate to receive a lot of positive engagement from the open-source community since launch, especially after being featured on the front page of Hacker News twice, which brought significant visibility. Our goal has always been to build an open-source tool that resonates with developers, and we’re humbled by the interest so far.

Happy to share more about our journey, the challenges, and how the community has driven our development if you’re interested. Transparency and genuine community engagement have always been important to us!

 

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!

[–] johnnyfish@lemmy.world 2 points 3 weeks ago

Thanks for the thoughtful feedback, Daniel! You bring up a great point about the complexity of the current approach with the SQL script and the reliance on pbcopy. We’ll definitely consider simplifying it by providing just the raw SQL query, so users can run it in whatever way works best for them. As for the cloud version, we’re leaning towards using LocalStorage for data storage on the client side to keep everything local to the user’s machine, ensuring privacy and control. We’ll make this clearer in the UI and documentation. Appreciate the suggestions - they’re super helpful as we continue refining ChartDB!

[–] johnnyfish@lemmy.world 1 points 3 weeks ago

Thanks a ton! Glad you like the design - keeping it and user-friendly is what we’re all about. We’ll be here whenever you’re ready to give it a spin!

[–] johnnyfish@lemmy.world 5 points 3 weeks ago* (last edited 3 weeks ago)

Great question! You don’t have to send anything to a third party - exporting SQL scripts tailored to a specific dialect is optional. By default, we offer a generic SQL export, and only when you need precise, dialect-specific scripts does AI come into play. In the self-hosted version, you’d provide your own OpenAI token, so data stays entirely in your control. Hope that clears it up!

[–] johnnyfish@lemmy.world 1 points 3 weeks ago (2 children)

That’s awesome to hear! Thanks for giving ChartDB a shot! We’d love to know how it stacks up for you and if there are any features you think would make it even better. Feel free to reach out here or join our Discord if you have questions or feedback along the way.

[–] johnnyfish@lemmy.world 5 points 3 weeks ago

Hey! I get the AI hesitation - it’s everywhere, and I totally understand if you’re wary of buzzwords! With ChartDB, our focus is on making database diagramming simpler, faster, and visually intuitive without the bloat you sometimes find in other tools. The AI component is there mainly to speed up migrations and adapt the tool to specific SQL dialects, so it’s helpful but not in your face.

As for why it might work better for you than DBeaver, ChartDB shines if you’re looking for a minimal, open-source way to visualize schemas quickly without needing a full database management suite. It’s lightweight, community-driven, and designed to do one thing really well: diagram and share schemas with simplicity. Plus, we’re always open to feedback and building features that our community finds valuable!

[–] johnnyfish@lemmy.world 3 points 3 weeks ago

Lmk how was it pls :) Thank you!

[–] johnnyfish@lemmy.world 3 points 3 weeks ago

So happy to read that! Hope you will enjoy and find it as useful as you imagine! Thanks for sharing :)

 

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