Databases
-
Software Development
An argument against defaulting to auto-increment primary keys
The de-facto “easy” primary key for ages has been the auto-incrementing integer. Upon insertion of a new record, the database…
Read More » -
Software Development
10 Common Mistakes Java Developers Make when Writing SQL
Java developers mix object-oriented thinking with imperative thinking, depending on their levels of: Skill (anyone can code imperatively) Dogma (some…
Read More » -
Software Development
Source control your database with Liquibase
I recently started to use Liquibase on a project to keep track of the database changes in our Java Enterprise…
Read More » -
Software Development
Easy Mocking of Your Database
Test-driven development is something wonderful! Once you’ve established it in your organisation, you will start to: Greatly improve your quality…
Read More » -
Software Development
Caveats With MySQL Pagination
We’ve all done pagination – it’s sensible for both lists in the UI and for processing data in batches. “SELECT…
Read More » -
Enterprise Java
MySql connections autodrop after a certain hours
MySql is configured to drop any connection which has been Idle for more than 8 hours. What is the implication…
Read More » -
Software Development
Data Warehouse Design Approaches
In our previous posts we have got to learn about Data Warehousing Objects, different kinds of Data Warehouse schemas and…
Read More » -
Software Development
Recycle Bin in Database
Oracle introduced in database 10g new feature called ‘Recycle Bin’ to store the dropped database objects. If any table is…
Read More » -
Software Development
Debugging SQL query in MySQL
Recently I started writing SQL query for analyzing and debugging the production code. But I was surprised to see that…
Read More »
