3 ms·
I've used Oracle since 1998 and SQLServer since early 2000s. Oracle has great defaults now and the free version is very good. Licenses for MSSQL and Oracle can
by thorin 12y ago
I've used Oracle since 1998 and SQLServer since early 2000s. Oracle has great defaults now and the free version is very good. Licenses for MSSQL and Oracle can be competitive - obviously if you are a MS shop SQLServer will become cheap(er) in comparison. I prefer Oracle because I know it better and I sometimes work with *nix. PL/SQL packages are far better than the comparable stored procedures in MSSQL. APEX is pretty unique too.
If I was starting on an open source or startup project with a modern web framework I definitely be looking at using Postgres - it looks great.
- matwood 12y agoFair enough. It has been awhile since I used Oracle and we used to joke that the defaults were set such that you had to hire Oracle as a consultant to set up the db and tune it :) Clearly competition has helped there. If I was starting on an open source or startup project with a modern web framework I definitely be looking at using Postgres - it looks great. I'm in complete agreement, if I was starting a new project today pg would be the default to decide why not to use.
- thorin 12y agoActually if I was starting something from scratch AND I needed to get something done quick AND I had an Oracle licence/host I'd use Oracle APEX. http://www.oracle.com/technetwork/developer-tools/apex/overview/index-155186.html http://www.oracle.com/technetwork/developer-tools/apex/overv... Which as an oracle user and pl/sql programmer is a great way to build an app quickly. I guess if I was building something (quickly) from OS I'd use Django or Java Spring or Grails.