Selfhosted

60526 readers

1163 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:

Detailed Rules Post

Be civil.
No spam.
Posts are to be related to self-hosting.
Don't duplicate the full text of your blog or readme if you're providing a link.
Submission headline should match the article title.
No trolling.
Promotion posts require active participation, with an account that is at least 30 days old. F/LOSS without a paywall has exceptions, with requirements. See the rules link for details.
AI-related discussions and AI-involved promotional posts have additional requirements for tagging, as noted in Rule 7 and the AI & Promotional Post Expanded Rules post.

Resources:

selfh.st Newsletter and index of selfhosted software and apps
awesome-selfhosted software
awesome-sysadmin resources
Self-Hosted Podcast from Jupiter Broadcasting

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

Questions? DM the mods!

founded 3 years ago

MODERATORS

curbstickle@anarchist.nexus

curbstickle_lw@lemmy.world

ChartDB (v1.7.0) - open-source database diagram visualization tool (lemmy.world)

submitted 1 year ago by johnnyfish@lemmy.world to c/selfhosted@lemmy.world

15 comments fedilink hide all child comments

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

[–] thejevans@lemmy.ml 2 points 1 year ago (1 children)

Yay for DBML! I'm so excited to stop using dbdiagram haha

[–] johnnyfish@lemmy.world 2 points 1 year ago

Give ours a try! I’d love to hear your feedback - hopefully, it’ll be an even better experience lol