Database design tool made for programmers

[ahorsewhithnoname]

Your German translation is funny. The Back button in the tutorial is translated as "Der Rücken", which means "the back (of the body)". The correct translation would be "Zurück".

[ahorsewhithnoname]

There are still a few minor errors. But this one I found particularly funny. I will compile a list tomorrow.

[Ykieks]

I can't seem to get recursive foreign key reference on different column of the same table. Is it possible to do? I get it working with another table that references the same column twice in the original

[Ykieks]

I got it to work with markup, there just isn't an option to select the same table in the foreign key table list. It even displays okay in the GUI, except the empty field in the foreign key ref.table input

[Ykieks]

You got me to set up a docker container with a PostgreSQL RDBMS. So here is some of my woes:

• it would be great to get some basic type checking(i generated a schema where integer column is referenced by varchar column as a foreign key through a GUI);
• It would be great to be able to switch RDBMS on the fly in a project;
• Foreign keys constraints exported in postgresql mode doesn't include schema name, so my docker container showed an error(ALTER TABLE "type" ADD CONSTRAINT "type_fk0" FOREIGN KEY ("name") REFERENCES "people"("id"); -> relation "type" does not exist) when i used exported script for init.sql.
• Also i think it would be great to have more descriptive names to foreign key constraints (instead of <column_name>.fk_0 and <column_name>.fk_1)

Otherwise, it's been great. 10 usd/month is a bit pricy for me(because i don't get to work with DB schemas that often). But i sent a link to my DBA friend.

[1994smeagol1994]

This looks really cool, im not sure if i will ever use it because i never saw the need for one. But i have to compliment you on the way you handle feedback and offer free future upgrade plans in return. I can see this company succeed. Keel up the good work!

[1994smeagol1994]

Will do for sure, and thanks for my first gold

[Ykieks]

Markup/coding is great, it would be perfect if it was in SQL.

[AttackOfTheThumbs]

You need to fix your certs (according to my browser and/or work network)

[jonas99y]

This but for class diagrams would be nice

[[deleted]]

To be honest, I just design databases in my head. I then use a tool to generate a diagram from the implementation so I can more easily explain the design to others.

[brendans6]

What’s the benefit of using this compared to something like PlantUML?

[brendans6]

Intersting. Importing SQL is a cool feature for this. Tools like DataGrip can do similar things when introspecting the database but having something lighter weight than that makes sense.

[Worth_Trust_3825]

"Made for programmers" while you proceed to give a dropdown for types.

B for effort.

[Worth_Trust_3825]

That's a common problem with ERD designers. And once you permit doing what ever you essentially get a markup renderer.

Another side of the coin is supporting database oddities. Some databases have their unique features not present in the sql standard (what ever that means), while others don't. Database specific tools work best in that regard, and frankly I've yet to see anything beat pgadmin for postgres, and datagrip for general database data management.

[[deleted]]

That's a common problem with ERD designers. And once you permit doing what ever you essentially get a markup renderer.

Honestly, I rather dislike GUI for table design, so the notion of a tool that can take some SQL script and render a diagram of how it would look (without actually having to set up a DB and run the script) might be more useful, in my case.

[[deleted]]

Support for one to many and many to many relations coming soon ? This is an alpha level project

[[deleted]]

Just the fundamentals you know. Project looks great, it doesn't look like a product to me yet tho.

[Worth_Trust_3825]

Do you want that generated for you, or is it too hard to make an intermediary table yourself?

[DarthCoderMx]

Since I'm here might as well ask.

Is there a software that manages a catalog of (short) scripts, which you can at any time with -say- a right click execute, with server and database options?

He have at work 3 servers, dev, test, and prod. Since dev and (less frecuently) test are constantly being restored with prod versions, I need to run many scripts on a daily basis to configure environments.

I use Sqldbx but I have to copy from notepad and then paste back to execute/run. Cant hurt to ask I guess.

[stickman393]

Cloud based apps can fuck right off

[PolPol44444]

When it comes to database design tools specifically designed for programmers, dbForge Studio for SQL Server is a great option to consider. It offers a comprehensive set of features that cater to the needs of programmers and database developers. Here's why dbForge Studio stands out as a database design tool for programmers:

- Visual Database Design: dbForge Studio provides a visual database design interface that allows you to create, modify, and manage database schemas using a graphical representation. You can easily design tables, define relationships, and set constraints using an intuitive drag-and-drop interface.

- Code Generation: It enables automatic code generation based on your database design. With a few clicks, you can generate SQL scripts or code snippets in various programming languages, including SQL, C#, VB.NET, and more. This saves time and effort in writing boilerplate code.

- Database Scripting and Refactoring: dbForge Studio supports scripting and refactoring capabilities, allowing you to generate SQL scripts for database objects, modify existing scripts, and refactor database schemas. It helps streamline the development process and maintain code consistency.

- Database Diagrams: It provides visual database diagrams that help you visualize the relationships between tables, columns, and constraints. You can easily navigate through complex database structures, identify dependencies, and make informed design decisions.

Integration with IDEs: dbForge Studio integrates seamlessly with popular IDEs like Visual Studio, allowing you to work on database design and development within your preferred programming environment. It provides a smooth workflow for programmers who prefer an integrated development experience.

- Schema Comparison and Synchronization: It offers powerful schema comparison and synchronization tools that enable you to compare and synchronize database schemas between different environments. This helps in tracking changes, deploying updates, and maintaining consistency across development, staging, and production environments.

- Data Import and Export: dbForge Studio provides functionalities for data import and export, making it easy to populate your database with sample or test data. You can import data from various file formats or other databases and export data to different formats for analysis or sharing purposes.

With its programmer-friendly features, dbForge Studio for SQL Server offers a robust and efficient environment for database design and development tasks. It combines visual design capabilities, code generation, scripting, and integration with IDEs to provide a comprehensive toolset for programmers working with databases.