Обсуждение: General question about OS
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.
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.
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 likePower 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 youget 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 likePower 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