this post was submitted on 27 Oct 2025
143 points (98.6% liked)

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

  1. Be civil.

  2. No spam.

  3. Posts are to be related to self-hosting.

  4. Don't duplicate the full text of your blog or readme if you're providing a link.

  5. Submission headline should match the article title.

  6. No trolling.

  7. 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.

  8. 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:

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

Questions? DM the mods!

founded 3 years ago
MODERATORS
 

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

you are viewing a single comment's thread
view the rest of the comments
[โ€“] QueenMidna@lemmy.ca 5 points 8 months ago* (last edited 8 months ago) (2 children)

Support for Big Data types (maps, hash sets ,structs) would be wonderful

[โ€“] johnnyfish@lemmy.world 4 points 8 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?

[โ€“] QueenMidna@lemmy.ca 1 points 8 months ago

Hadoop and other big data sources such as Spark