johnnyfish

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

Thanks! Glad you like it ๐Ÿ™Œ We donโ€™t have a forum yet, but we do have a Discord where users share feedback and ask questionsl, youโ€™re more than welcome to join: https://discord.com/invite/QeFwyWSKwC

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

Thanks! DuckDB is definitely on our radar, a few others have asked for it too in this GitHub issue: #865. Iโ€™d suggest dropping a ๐Ÿ‘ there so we can keep track of interest!

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

Awesome, thanks! Hope youโ€™ll like it, would love to hear what you think once youโ€™ve played with it a bit.

[โ€“] johnnyfish@lemmy.world 4 points 5 months ago (1 children)

Hey! We actually support some of these already, for example, in PostgreSQL we handle jsonb and array-like types pretty well. Curious, which database are you referring to?

 

Hi everyone! ๐Ÿ‘‹

Back again with a fresh update on ChartDB - a self-hosted, open-source tool for visualizing and designing your database schemas.

Since our last post, weโ€™ve shipped v1.16 and v1.17, focusing on better canvas interactions, smarter imports, and improved database coverage. Hereโ€™s whatโ€™s new ๐Ÿ‘‡

Why ChartDB?

โœ… Self-hosted - Full control, deploy via Docker
โœ… Open-source - Community-driven and actively maintained
โœ… 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, Oracle, Cloudflare D1

๐Ÿ”ฅ New in v1.16 & v1.17

  • Canvas Editing Upgrades - Create tables, open table editors, and define relationships directly on the canvas
  • Array Support - Full support for array fields across import/export and DBML
  • Views Support - Import and visualize database views
  • Quick Edit Mode - One-click edit for tables without switching modes
  • DBML Diff Preview - Preview changes to field types and relationships before applying
  • Smarter Imports - Detect auto-increment fields, parse more SQL variants
  • Improved PostgreSQL & SQL Server Support - Includes default values, new types, and ALTER TABLE handling
  • Canvas Filters 2.0 - Improved tree state, toggle logic, and filter behaviors
  • UI Polish & Fixes - 50+ fixes including performance, layout, field handling, and DDL exports

๐Ÿ”ฎ Whatโ€™s Next

  • Version control - Git-backed diagram history
  • Sticky notes - Annotate diagrams visually
  • Docker improvements - Support for sub-route deployments

๐Ÿ”— Live Demo / Cloud
๐Ÿ”— GitHub
๐Ÿ”— Docs

We're continuing to build based on community feedback, feel free to open issues, suggest features, or share how youโ€™re using it!

Thanks again to everyone in selfhosted whoโ€™s supported ChartDB so far ๐Ÿ™Œ

 

Hi everyone! ๐Ÿ‘‹

Back again with another update on ChartDB - a self-hosted, open-source tool for visualizing and designing your database schemas.

Since our last post, weโ€™ve shipped v1.14 and v1.15, packed with features and fixes based on community feedback. Here's whatโ€™s new ๐Ÿ‘‡

Why ChartDB?

  • โœ… Self-hosted - Full control, deployable via Docker
  • โœ… Open-source - Community-driven and actively maintained
  • โœ… 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, Oracle, Cloudflare D1

New in v1.14 & v1.15

  • Canvas Filtering Enhancements - Filter by area, show/hide faster
  • DBML Editor Upgrade - Edit diagrams directly from DBML
  • Areas 2.0 - Parent-child grouping + reorder with areas
  • View Support - Import and visualize database views
  • Auto-Increment Support - Handled per-dialect in export scripts
  • Custom Types - Highlight fields that use enums/composites
  • PostgreSQL Hash Indexes - Now supported and exportable
  • UI Fixes & Performance - 40+ improvements and bug fixes

Whatโ€™s Next

  • Version control for diagrams, linked to your database
  • Sticky notes - Add annotations directly on the canvas
  • Docker improvements - Support for sub-route deployments
  • Clone diagram - Safely duplicate your diagram

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

Would love to hear your feedback, requests, or how you're using it in your stack. Weโ€™re building this together - huge thanks to the community for all - the support!

 

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! ๐Ÿ™Œ

 

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!

 

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

A few months ago, I introduced ChartDB to this community and received an amazing response - tons of positive feedback and feature requests. Thank you for the incredible support!

Recap: 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 Databases - 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.7.0 (2025-02-03)

๐Ÿš€ New Features

  • CockroachDB Support - Now fully supports CockroachDB.
  • ClickHouse Enhancements - Improved ClickHouse integration.
  • DBML Editor - Added a built-in DBML editor in the side panel.
  • Import DBML - Now you can import DBML files directly into ChartDB.
  • Drag & Drop Table Ordering - Easily reorder tables in the side panel.
  • Mini Map Toggle - Added a toggle option for mini-map visibility.

๐Ÿ›  Bug Fixes & Improvements

  • Docker Build - OPENAI_API_KEY is now optional when using Docker.
  • Canvas Editing - You can now edit table names directly on the canvas.
  • Dark Mode Fixes - Improved UI for the empty state in dark mode.
  • Power User Shortcuts - Added new keyboard shortcuts and key bindings.
  • Performance Boost - Optimized bundle size for faster loading.

Whatโ€™s Next?

  • AI - Tables Relationships finder - AI-powered tool to detect table relationships.
  • CLI/API Diagram Updates - Option to update diagrams via CLI, API, or a JSON input file.
  • Git Integration for Versioning - Manage and track diagram changes with Git version control.
  • More database support & DBML improvements.
  • Enhanced collaboration & sharing features.
  • Additional performance optimizations.

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