General question about OS

On 6/9/19 4:45 PM, Drexl Spivey wrote:

Hello all,

Don't want to start one of those endless internet tug of wars without end threads, but would like some other people's opinions.

First off, I use all Operating systems without problems, personally defaulting to linux at home, but mostly mac at work. I use windows, when necessary, not my favorite.

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.

Is database work heavily windows leaning??
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.

I use 100% linux. vim, vim-dbext, subversion to exit/exec/store .sql files. psql for db administration.
Same tools can be used as easy on a close database as one thats very far away.

Some at my company prefer pgAdmin. It works for them. I use psql, it works for me. Best thing is: they both work, so you get the choice.

-Andy

Drexl Spivey <drexl@little-beak.com> writes:

Hello all,

Don't want to start one of those endless internet tug of wars without end threads, but would like some other people's opinions.

First off, I use all Operating systems without problems, personally defaulting to linux at home, but mostly mac at work. I use windows, when necessary, not my favorite.

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.

Is database work heavily windows leaning??

Not my experience. Much of my work has been with Oracle and Postgres and
all of it has been on Linux (well, Unix originally Tru64, Solaris). In
medium to larger enterprises, it was often Linux based database backend and
Windows client frontend or Linux backend and 'client' delivered via web
based frontend, typically served from Linux Tomcat,Apache,*ngnix
etc. Smaller organisations tended to have more Windows servers with more
instances of MS SQL Server.

In recent years, I have seen a growth in MS SQL Server, especially with
growth in things like Sharepoint, Skype, MIM/MDM and the push towards
Azure. At the same time, we also see MS embracing Linux more with bash
and linux subsystem, availability of linux VMs in Azure etc.

For your larger databases, I see more Linux than MS. This could be
related to storage and file systems more than anything else.

--
Tim Cross

On 10/06/2019 09:45, Drexl Spivey wrote:

Hello all,

Don't want to start one of those endless internet tug of wars without
end threads, but would like some other people's opinions.

First off, I use all Operating systems without problems, personally
defaulting to linux at home, but mostly mac at work. I use windows,
when necessary, not my favorite.

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.

Is database work heavily windows leaning??
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.

I got into the game before Microsoft ever existed.  I find Linux far
easier to use, for both general things and development.

Can't say I'm familiar with what Microsoft offers now, but it still
seems to be a security nightmare and very restrictive.

Cheers,
Gavin

On 6/9/19 2:45 PM, Drexl Spivey wrote:

Hello all,

Don't want to start one of those endless internet tug of wars without
end threads, but would like some other people's opinions.

First off, I use all Operating systems without problems, personally
defaulting to linux at home, but mostly mac at work. I use windows, when
necessary, not my favorite.

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.

If it for your use then use what you understand. If it is not then you
will be using what has already been decided on.

Is database work heavily windows leaning??

I think not and personally I hope not.

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.

--
Adrian Klaver
adrian.klaver@aklaver.com

Drexl Spivey <drexl@little-beak.com> writes:

Is database work heavily windows leaning??

FWIW, I don't know of *any* mainstream database server, other than
Microsoft's own SQL Server, that considers Windows to be a preferred
platform. It's definitely the last choice so far as Postgres is
concerned; maybe you'd get more support for your thesis somewhere
other than here.

On the client side, certainly there are specific applications that
are Windows-centric.

regards, tom lane

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