Awesome SQL Trick: Constraints on Views

CHECK constraints are already pretty great when you want to sanitize your data. But there are some limitations to CHECK constraints, including the fact that they are applied to the table itself, when sometimes, you want to specify constraints that only apply in certain situations. This can be done with the SQL standard WITH CHECK … Continue reading Awesome SQL Trick: Constraints on Views

jOOQ Newsletter: September 02, 2014 – Do You Really Need Support?

Do you really need support? Our apologies. We hadn't realised that we didn't advertise the support-free jOOQ licenses, which we had been offering for quite a while now well enough on our website. So we have fixed that now. We think that jOOQ is such a high quality, intuitive piece of software with a vibrant … Continue reading jOOQ Newsletter: September 02, 2014 – Do You Really Need Support?