dbSpy 3.0

Hello Product Hunt community! I'm Adrian, co-contributor to dbSpy 3.0, along with @kris_magat, @santiago_gil, @kwang929, and @anthonyAlRifai. Welcome to dbSpy3.0! dbSpy is an open-source data modeling and visualization tool that facilitates relational database development! With dbSpy 3.0, you can create entities, add attributes and datatypes, establish relationships between them, and watch your entity-relationship diagram update with your new columns and connections. Whether you’re importing an existing database or building one from scratch, dbSpy 3.0 allows you to build and manipulate representations of data to assist with their creation and modification. It has the ability to connect to local and hosted PostgreSQL and MySQL databases, as well as support for direct upload of .sql files should one already have local schema copies on their machine. After connecting or uploading a file, you are then able to interact with and change the rendered schema of your database. Any changes made to the model will then be processed by dbSpy 3.0, and once you’re satisfied with your changes, you can execute those changes on your actual database! Features -Database file upload: Upload a database’s SQL file directly from your machine -Schema modification: Modify a database’s tables, a table’s columns, their relationships, and more. -Database Integrity: Checks are performed as a client edits the database to ensure its continued integrity *NEW AND IMPROVED IN 3.0* -SQL database support: dbSpy supports PostgreSQL databases -New: Full compatibility with mySQL databases added -ER Diagrams: Visualize and lay out the entity-relationship diagram of a database -New: Reimplemented canvas, powered by React Flow -Database connection: Connect to a hosted database-as-a-service or a live local database. -New: Have your full URL for a PostgreSQL database? Now you can simply copy and paste it without needing to fill out multiple fields. -Canvas Focus: Have many entities in your diagram? Zoom out to view all of them on the canvas with one button click -Screenshot: Take a screenshot of the canvas with all your tables laid out exactly as you want them -Dark mode: Fully styled visual setting for reduced eye strain and a more comfortable experience in low-light environments while maintaining visual clarity -Labeled arrows: Foreign key relationships are now easily identifiable by labeled arrow connections dbSpy 3.0 was created to provide a free, open-source solution for those looking to model and modify relational databases. It was originally envisioned as an alternative to paid database visualization tools, and had a robust feature set constrained by technical debt. In accordance with our goal to build a new foundation for dbSpy’s future, we revitalized user and developer experiences with React Flow, Zustand, and Tailwind to provide a smoother, more stable tool with visual clarity and rich features. Now, not only is it free of charge like previous iterations, but it is also much easier and more enjoyable to use, and hopefully to develop for as well. Our main goal was to make further development simpler and new features much easier to implement, and we hope that the changes made encourage more developers to work on future features and iterations of dbSpy. As open-source developers, we understand the impact the community can have and are always looking for new ideas and talented individuals to collaborate with. We’ve only scratched the surface of what can be done with dbSpy, and welcome any and all suggestions and contributions to make dbSpy even more useful! If you’d like, take a look at our GitHub page and try out dbSpy for yourself! Happy modeling! https://github.com/open-source-l... Contributors to dbSpy 3.0 Kris Magat -https://www.linkedin.com/in/kmag/ -https://github.com/KrisMagat Adrian Reczek -https://www.linkedin.com/in/adri... -https://github.com/adziu1234 Anthony Al-Rifai -https://www.linkedin.com/in/anth... -https://github.com/AnthonyAl-Rifai Santiago Gil Maya -https://www.linkedin.com/in/sant... -https://github.com/santiago-gil Kevin Wang -https://www.linkedin.com/in/kevi... -https://github.com/kwang929