On 02/16/2020 10:47 PM, Bee.Lists wrote:> Sequel ORM > > >> On Feb 16, 2020, at 7:28 PM, H <agents at meddatainc.com> wrote: >> >> I am looking for an open-source SQL modeling tool to use with MySQL, MariaDB and PostgreSQL. Does anyone have a favorite? > > > Cheers, Bee > > > > > _______________________________________________ > CentOS mailing list > CentOS at centos.org > https://lists.centos.org/mailman/listinfo/centosI looked at Sequel ORM but it seems to be a Ruby database toolkit supporting various SQL databases? If so, this is not what I am looking for since I might as well be writing the SQL statements directly. I am hoping to use a graphical database manager where I can design a database, all the tables, relationships etc.
On 02/20/2020 04:36 PM, H wrote:> On 02/16/2020 10:47 PM, Bee.Lists wrote: >> Sequel ORM >> >> >>> On Feb 16, 2020, at 7:28 PM, H <agents at meddatainc.com> wrote: >>> >>> I am looking for an open-source SQL modeling tool to use with MySQL, MariaDB and PostgreSQL. Does anyone have a favorite? >> >> Cheers, Bee >> >> >> >> >> _______________________________________________ >> CentOS mailing list >> CentOS at centos.org >> https://lists.centos.org/mailman/listinfo/centos > I looked at Sequel ORM but it seems to be a Ruby database toolkit supporting various SQL databases? If so, this is not what I am looking for since I might as well be writing the SQL statements directly. > > I am hoping to use a graphical database manager where I can design a database, all the tables, relationships etc. >Here is a page with some suggested tools http://intellspot.com/open-source-data-modelling/. I would be interested in hearing if anyone is using any of these modeling tools.
On Thu, 20 Feb, 2020 at 16:36:51 -0500, H wrote:> On 02/16/2020 10:47 PM, Bee.Lists wrote: > > Sequel ORM > > > > > >> On Feb 16, 2020, at 7:28 PM, H <agents at meddatainc.com> wrote: > >> > >> I am looking for an open-source SQL modeling tool to use with MySQL, MariaDB and PostgreSQL. Does anyone have a favorite? > > > > > > Cheers, Bee > > > > > > > > > > I looked at Sequel ORM but it seems to be a Ruby database toolkit supporting various SQL databases? If so, this is not what I am looking for since I might as well be writing the SQL statements directly. > > I am hoping to use a graphical database manager where I can design a database, all the tables, relationships etc. >I use DBeaver, packaged as a Flatpak, when I want a graphical database tool. Quite versatile. https://flathub.org/apps/details/io.dbeaver.DBeaverCommunity
On 02/20/2020 05:18 PM, Liam O'Toole wrote:> On Thu, 20 Feb, 2020 at 16:36:51 -0500, H wrote: >> On 02/16/2020 10:47 PM, Bee.Lists wrote: >>> Sequel ORM >>> >>> >>>> On Feb 16, 2020, at 7:28 PM, H <agents at meddatainc.com> wrote: >>>> >>>> I am looking for an open-source SQL modeling tool to use with MySQL, MariaDB and PostgreSQL. Does anyone have a favorite? >>> >>> Cheers, Bee >>> >>> >>> >>> >> I looked at Sequel ORM but it seems to be a Ruby database toolkit supporting various SQL databases? If so, this is not what I am looking for since I might as well be writing the SQL statements directly. >> >> I am hoping to use a graphical database manager where I can design a database, all the tables, relationships etc. >> > I use DBeaver, packaged as a Flatpak, when I want a graphical database tool. Quite versatile. > > https://flathub.org/apps/details/io.dbeaver.DBeaverCommunity > _______________________________________________ > CentOS mailing list > CentOS at centos.org > https://lists.centos.org/mailman/listinfo/centosThank you for your suggestion. I will try a couple of the packages suggested on the link I shared and see if they meet my needs. I did receive an off-list message with suggestions which were not open-source. Are there list members who have used other SQL UML software packages perhaps?