Date/Time Processing and Querying

Once the application’s data, or rather the user data, is properly stored as a timestamp with time zone, PostgreSQL allows us to implement all the processing we need to.

Using git repository

As an example dataset, we’re playing with git history this time. The PostgreSQL and the pgloader project history have been loaded into the commitlog table thanks to the git log command, with a custom format and some post-processing—properly splitting up the commit’s subjects and escaping its content. Here’s, for example, the most recent commit registered in our local commitlog table: