Live data from Hacker News

Why I love databases

medium.com

171–172 of 172 posts

Re: Why I love databases

#171
post #121
post #68

Earlier quoted context omitted.

MSSQL can be a great value for the money if you need all of the additional tools (SSIS, MSAS), and you are already in a Windows environment. For a straight rdbms, pg is a great solution. Oracle is something you only use when you have reached some problem that only Oracle can solve. Even then, I would still try to work around Oracle. It is expensive and requires a large amount of tuning to make work well. Oh, and pret…

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 prett…

Fair 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.

Re: Why I love databases

#172
post #121

Earlier quoted context omitted.

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 prett…

Fair 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…

Actually 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/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.

Post reply on HN