Much of the ORM criticism of the last decade missed the point, being inaccurate. By the end of this article, we will conclude with the following: There is no significant difference between the relational (data) model and object oriented models How to come to this conclusion? Read on! How we came to believe in this … Continue reading There is no Such Thing as Object-Relational Impedance Mismatch
Tag: CUBRID
CUBRID: A Lesser-Known Korean OSS Database Gem
While RedHat and Google have been dumping MySQL for MariaDB, there's actually a third, much lesser-known option for MySQL-oriented database folks in the RDBMS market: CUBRID. One of CUBRID's main goals is also to lure MySQL users away from Oracle by offering many equivalent syntax elements that are available in either the MySQL or Oracle … Continue reading CUBRID: A Lesser-Known Korean OSS Database Gem
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
How to simulate MySQL’s INSERT statement extensions
I have previously posted about the SQL MERGE statement, and how powerful it is here: https://blog.jooq.org/arcane-magic-with-the-sql2003-merge-statement/ Unfortunately, not all databases support this statement. Also, very often it is quite a bit of overkill, when what you want to do is to simply INSERT or UPDATE a single record, depending on whether it already exists. MySQL's … Continue reading How to simulate MySQL’s INSERT statement extensions