Databases
-
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 »
