I am looking for an open-source database modeling tool, ideally to run under both CentOS and Windows. I have not used any such tool before so I would like to solicit suggestions.
Thank you.
5 thoughts on - Database Modeling Tools
BeaverDB might be a good fit if you don’t mind that it’s written in Java.
I actually find myself using Valentina Studio these days. It’s not open source, but it is free, and it’s written in Qt, and is multi-platform.
Jason
I am looking for an open-source database modeling tool, ideally to run under both CentOS and Windows. I have not used any such tool before so I would like to solicit suggestions.
Thank you.
I don’t know what the difference is between database modelling and an actual database, but sqlite is available on just about every platform imaginable and works amazingly well. It comes with a command line to test and query databases as well as being a library that you can call from every language from C on up.
they are completely different things. Modeling is a database design tool, typically letting you design your table relations via a GUI tool, generating an entity-relation-diagram (ERD). The Modeling tool would then create the actual SQL database in the database engine of your choice (PostgreSQL, MySQL, SQLlite, Oracle, etcetcetc).
Gosh, I never knew such things existed. I guess I’ve never done anything sufficiently complex that I would need a tool like that.
Cool! Today I have learned something. Thank you sir!
5 thoughts on - Database Modeling Tools
BeaverDB might be a good fit if you don’t mind that it’s written in Java.
I actually find myself using Valentina Studio these days. It’s not open source, but it is free, and it’s written in Qt, and is multi-platform.
Jason
I am looking for an open-source database modeling tool, ideally to run under both CentOS and Windows. I have not used any such tool before so I would like to solicit suggestions.
Thank you.
I don’t know what the difference is between database modelling and an actual database, but sqlite is available on just about every platform imaginable and works amazingly well. It comes with a command line to test and query databases as well as being a library that you can call from every language from C on up.
they are completely different things. Modeling is a database design tool, typically letting you design your table relations via a GUI tool, generating an entity-relation-diagram (ERD). The Modeling tool would then create the actual SQL database in the database engine of your choice (PostgreSQL, MySQL, SQLlite, Oracle, etcetcetc).
Gosh, I never knew such things existed. I guess I’ve never done anything sufficiently complex that I would need a tool like that.
Cool! Today I have learned something. Thank you sir!
Thank you, I will look at both.
Does anyone have additional suggestions?