#typescript #database #db #db_migration #editor #erd #mariadb #mssql #mysql #postgresql #react #react_flow #schema_migrations #sql #sqlite #typescript #visualization #xyflow

ChartDB is a powerful tool that helps you visualize and manage your database schema easily. It allows you to import your database structure with just one query and view it as a diagram. You can edit this diagram interactively, which makes it easier to understand and work with complex databases. ChartDB also uses AI to help you export your database schema to different systems, like from MySQL to PostgreSQL, making migrations simpler. This tool is open-source and available online or for local use, making it very useful for developers to design and collaborate on databases more efficiently.

https://github.com/chartdb/chartdb

#typescript #bigquery #cassandra #cockroachdb #database #electron #firebird #linux_app #mac_app #mariadb #mssql #mysql #postgresql #sql #sql_server #sqlite #windows_app

Beekeeper Studio is a free, open-source SQL editor and database manager that works on Windows, Mac, and Linux. It supports many databases like MySQL, PostgreSQL, and SQLite. The app offers features like auto-complete SQL queries, syntax highlighting, and a tabbed interface for multitasking. You can sort and filter data, save queries, and even export data in formats like CSV or JSON. It's designed to be easy to use and enjoyable, making database management simpler for everyone. You can download it for free and upgrade to premium features if needed.

https://github.com/beekeeper-studio/beekeeper-studio

#typescript #data_layer #local_first #signals #sqlite #state_management #sync_engine

LiveStore is a powerful data layer for apps that uses a reactive SQLite database to manage and sync data instantly across devices, even offline. It replaces traditional state management tools like Redux by allowing you to query and update data reactively with real-time syncing via event-sourcing. It supports many platforms and UI frameworks, offers flexible data modeling, and handles merge conflicts automatically. This means your app can work smoothly offline, sync changes seamlessly, and stay fast and reliable. LiveStore helps you build high-performance, offline-first apps with easy debugging and evolution.

https://github.com/livestorejs/livestore