this post was submitted on 05 Feb 2025
32 points (94.4% liked)

Selfhosted

41787 readers
749 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

  1. Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.

  2. No spam posting.

  3. Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.

  4. Don't duplicate the full text of your blog or github here. Just post the link for folks to click.

  5. Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).

  6. No trolling.

Resources:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 2 years ago
MODERATORS
 

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! ❤️

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 2 points 6 hours ago* (last edited 6 hours ago) (2 children)

Tried it out on https://app.chartdb.io/

Tried the generic and v5.4 scripts for MySQL to generate the schema information.

Both returned [NULL]

MySQL is running on Docker and I use DBeaver to access it. MySQL is version 8.4.0.
I stopped trying to use the app after that tbh

[–] Luckyfriend222 1 points 3 hours ago (1 children)

When last did you try? A few of us had MariaDB issues, but it started working like a month ago. There is a github issue about it too.

[–] [email protected] 1 points 3 hours ago

I tried today, about 4 hours ago I guess? And this is about MySQL but perhaps the MariaDB issues are related? Anyway, I know it works for some (most?), just not for me and my attention span has only so much to spend on a graphing tool for db's so I'm good. I was just curious, tried it out and failed. That's all there is to it tbh. And as it was the very 1st step, I was immediately done as I have no clue what else will not work for me and I have only so much time and energy for project like this.