Databases
-
Enterprise Java
Postgres and Oracle compatibility with Hibernate
There are situations your JEE application needs to support Postgres and Oracle as a Database. Hibernate should do the job…
Read More » -
Software Development
Please, Run That Calculation in Your RDBMS
There’s one thing that you can do terribly wrong when working with RDBMS. And that thing is not running your…
Read More » -
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 »
