SQL has evolved. Beyond the relational model. Discover it now. | Continue reading
Making decision despite missing SQL data (NULL): How to avoid OR…IS NULL in the WHERE clause. | Continue reading
Modern SQL has nice features that are not available through JPA. Blaze-Persistence provides mappings for them. | Continue reading
How JPA and SQL together achieve something that one alone could not. | Continue reading
Oracle DB 19c has closed some major gaps in its SQL/JSON path implementation, and they have also introduced a few JSON extensions. | Continue reading
Window functions, filter clause, upsert, and more. SQLite got some cool new features in 2018! | Continue reading
Oracle Database 18c is actually just a patch. A few interesting changes are worth mentioning nevertheless: JSON, Polymorphic Table Functions, Grouping and LISTAGG. | Continue reading
Error 404: Page not found | Continue reading
MariaDB 10.3 has improved in terms of no less than seven modern SQL features. Time traveling, percentiles, sequences, and self-referencing UPDATE and DELETE are just the tip of the iceberg. | Continue reading
PostgreSQL is very close to the SQL standard, yet there are some omissions. Here are the gaps that I presented at PGCon.org in Ottawa last week. | Continue reading