https://www.gravatar.com/avatar/306d401b2a8c0efe0996fec60e0c90aa?s=240&d=mp

My coding journey

Hello!

My name is Kamila. Let me welcome you on my homepage kamilachyla.com


You will find here a handful of my notes.

I write mainly about programming (EN/PL) (Java, Python, Go, JavaScript), play with generative art using p5js and I'm an author and illustrator of my children's books.

Have fun!

Postgres - exercises

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…

Postgres - installation

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.