Month: March 2016

Get current timestamp with PostgreSQL

I’m pretty sure that almost everyone that have used PostgreSQL knows the now() function. Its purpose is mostly obvious: return the current timestamp or at least its name indicates that….

Best practices storing time data on the database

There is my personal list of best practices handling with time related data and its persistence. I assume they are for PostgreSQL in first time but that recommendations…

Implementing OCC (optimistic concurrency control) on the database

This is a simple tip for implement OCC directly on the database and so avoiding additional overhead that this can imply doing that at the application level. The OCC mechanism mainly consists…