[CentOS] SQL modeling tool for CentOS 7

Wed Mar 4 15:17:14 UTC 2020
H <agents at meddatainc.com>

On 02/23/2020 06:29 PM, H wrote:
> 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/centos
> Thank 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?
>
I just found pgmodeler which can be used with postgreSQL - it looks quite capable! See https://pgmodeler.io/. I am just starting to review it but would also like to find something similar that would work with MySQL/MariaDB, even sqllite for that matter.