A Couple of Reasons Why You Should Use PostgreSQL

Here's a nice article showing a couple of good reasons why you should consider using PostgreSQL in many of your future projects: http://www.cubrid.org/blog/dev-platform/postgresql-at-a-glance From the jOOQ perspective - which is a perspective focussed on SQL feature scope rather than storage and maintenance - Postgres is one of the most outstanding databases out there, and it's completely … Continue reading A Couple of Reasons Why You Should Use PostgreSQL

jOOQ as a “PL/Java” language

Some people who get in touch with PL/SQL, PL/pgSQL, T-SQL, or any other proprietary procedural language for SQL interaction are probably missing out on a couple of language integration features in the Java world. Most Java APIs see SQL as an external domain-specific language that is "best" dealt with using string concatenation. Such APIs include: … Continue reading jOOQ as a “PL/Java” language

A success story of SQL scaling horizontally

One of the biggest killer-arguments in favour of NoSQL databases is that they are supposed to natively scale horizontally, unlike traditional relational databases. Personally, I believe that you still have to be an excellent architect, in order to actually take advantage of this "native feature" of some NoSQL databases. You can still design a system … Continue reading A success story of SQL scaling horizontally