SQL is standardised by ISO / IEC. We have wonderful standards, such as SQL-92, SQL:1999, SQL:2003, SQL:2008. Right? In theory. In practice, many things do not have an equivalence between the actual SQL implementations. This is very true for common function support - most of which are not part of any standard. Here's an interesting … Continue reading Crazy Translations of Simple SQL Expressions to Various SQL Dialects
Month: September 2013
PostgreSQL 9.3 Released!
A great database has just gotten better. PostgreSQL 9.3 has been released today. While improved reliability and availability is certainly quite a thrilling addition, from the jOOQ perspective, the most interesting features are new SQL syntax elements. These include: Better support for JSON LATERAL JOIN (or as SQL:1999 calls it: lateral derived table) Materialised views … Continue reading PostgreSQL 9.3 Released!
jOOQ Newsletter September 2013
Subscribe to this newsletter here SQL Popularity and Controversy In the last newsletter, SQL popularity was well addressed by the tremendous feedback our articles received: 10 Common Mistakes Java Developers Make When Writing SQL 10 More Common Mistakes Java Developers Make When Writing SQL Together, the above articles have have reached out to more than … Continue reading jOOQ Newsletter September 2013