Oracle database coding evil, PostgreSQL business logic useful

Every time you mention doing data centric business logic in an Oracle database using pl/sql, the first reaction you’ll get from java/jee developers is that it’s evil. Code and business logic should be placed in the java based middleware.

PostgreSQL 9.2 was just released, and one of the new features is json and javascript support in the database. And somehow, developers find this an interesting feature:

Combined with the new PL/V8 Javascript and PL/Coffee database programming extensions, and the optional HStore key-value store, users can now utilize PostgreSQL like a “NoSQL” document database.

I agree that it’s interesting, and potentially useful, but why is this any different than doing business logic in an Oracle RDBMS?

blog comments powered by Disqus