Do you need to know what RDBMS Server version you're on, and you only have SQL at your disposal? No problem. Most RDBMS provide you with that information in some form of meta data table. Here's how: -- CockroachDB select version(); -- Db2 select service_level from table (sysproc.env_get_inst_info()) t -- Derby select getdatabaseproductversion() from (values … Continue reading How to Get an RDBMS Server Version with SQL
Best Practices and Lessons Learned from Writing Awesome Java and SQL Code. Get some hands-on insight on what's behind developing jOOQ.