Databases
-
Enterprise Java
The JDBC Boolean Compatibility List
Interestingly, boolean types have been introduced only late in the SQL standard, namely in SQL:1999. Even today, not all databases…
Read More » -
Software Development
You’re Very Likely to Have Gotten SQL Date Time Arithmetic Wrong!
You’re very likely to have gotten SQL date time arithmetic wrong. And why is that? Google it! You’ll quickly find…
Read More » -
Software Development
A Beginner’s guide to ACID and database transactions
Transactions are omnipresent in today’s enterprise systems, providing data integrity even in highly concurrent environments. So let’s get started by…
Read More » -
Software Development
The SQL Language’s Most Missing Feature
SQL is also awesome in many ways. We can write out the most complex truths and facts and have the…
Read More » -
Software Development
Lesser-Known SQL Features: DEFAULT VALUES
A lesser-known SQL feature is the DEFAULT keyword, which can be used in INSERT and UPDATE statements. Consider the following…
Read More » -
Software Development
MongoDB “Lightning Fast Aggregation” Challenged with Oracle
What does “Scale” even mean in the context of databases? When talking about scaling, people have jumped to the vendor-induced…
Read More » -
Software Development
Counting Distinct Records in SQL
The SQL language and its depths… Some of you readers might be aware of MySQL’s capability of counting distinct records…
Read More » -
Software Development
Add LATERAL Joins or CROSS APPLY to Your SQL Tool Chain
The T-SQL dialect has known the powerful CROSS APPLY and OUTER APPLY JOIN syntaxes for ages. The SQL:1999 standard had…
Read More » -
Software Development
Using SQL Injection Vulnerabilities to Dump Your Database
The threat caused by SQL injection is heavily underestimated even by many senior developers and software architects. Most people are…
Read More »
