Re: General question about OS

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: General question about OS
Date: 2019-06-10 01:57:44
Message-ID: 0e32dce3-9cb2-c299-a63d-08d891eb65ba@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Drexl Spivey schrieb am 10.06.2019 um 04:45:
> It seems in my little database development experience that this is
> one area where windows might actually offer the best, most
> mature/developed choices. If this is the case, I should acclimate
> myself to it more.
>
> I have found many applications have been ported to other systems, but
> they don't seem as "good", and some programs like Power Designer are
> windows only.
>

As Windows is still dominant on the desktop market, most tool
vendors - especially commercial ones - will probably start with
Windows first as that is (theoretically) the bigger market (unless
they start directly with a cross-platform tool).

I guess it essentially boils down to on how old those tools are.
15 years ago cross-platform development wasn't that widespread and Windows
was even more dominant on the desktop than today.

Very old tools like PowerDesigner (or the TOAD family of products) have
been created ages ago with only Windows in mind. I guess their code base
can't easily be migrated to a capable cross-platform framework.

> Is database work heavily windows leaning??

Even though Windows is still very widespread, I wouldn't go that
far. There are many decent tools that are based on cross-platform
languages or frameworks.

Oracle for example uses Java exclusively for their client tools
(SQL Developer, SQL Data Modeler).

The suite of JetBrains tools (which I haven't used, but as far as
I can tell, are very good) are also all Java based and thus
cross-platform.

There are other very decent Java based tools out there, and with
.Net getting better and better for non-Windows systems, I wouldn't
be surprised if more tools show up based on .Net (or what the
correct name for the cross-platform version of it is).

As you have mentioned PowerDesigner: if you are looking for
cross-platform, cross-dbms modelling tool, you might want to
have a look at DbSchema. It's reasonably priced and I think
it's quite a good tool (I have no affiliation with them)

Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-06-10 04:14:26 Re: Inserting into the blob
Previous Message Tom Lane 2019-06-10 01:15:02 Re: General question about OS