In this post I’m reading official PostgreSQL documentation related to date and time types, and taking notes. In case you know this stuff: nothing fancy here. However, if you need a refresher - then: go ahead and read, you’re welcome!

Notes about Gradle

What should I know about Gradle? How to create a project with submodules? Or maybe: how to create simple project? Or how to use Gradle with Kotlin?

I became curious about json and jsonb types in postgres, so today I want to check what they are and how to use them.

SQL Exercises

As part of my SQL training and in order to know postres better I am (slowly) doing exercises from pgexercises.com page.

I like that page very much:

• it does not want my email address
• it does not require me being logged in
• it remembers my progress
• ine can solve many SQL-related mini-tasks in different categories (from simple selects to joins, data modifications, to aggregate functions)

Although database schema for those exercises is very simple, I’m struggling a bit when things get complicated…

I’ve just started reading: Anthony De Barros “Practical SQL: A Beginner Guide to Storytelling with Data”. All examples in the book are using Postgresql db system. Therefore I decided it’s time to instal postgres on my machine.

I want to take a closer look to postgresql itself, and during reading I want to play a bit with with different data sets. I need to recall how to use SQL. So this is my plan for October.

This is my first blog post in English. I’ve finally made a decision to start blogging in English.