PostgreSQL Showcase project – helping newcomers to get on track with Postgres

Here’s a short one. To prepare for the upcoming trainings season I thought I’ll get our little „Postgres Showcase“ (Github project) on track. The idea is that it’s just a collection of easy to follow SQL samples moving from basics to more advanced stuff, helping to exemplify how to use Postgres and to show off its features. Basically „critical Postgres knowledge in-a-box“, helping newcomers to grasp the core user side features in less than an hour, if going through all the samples.

PostgreSQL Showcase Project

The idea I had already some months ago as I found myself constantly explaining the same things all over again, in a non-practical (talking, showing documentation) way. But I guess nonbody really enjoys hearing about abstract things or reading a lot of documentation – sometimes going through some „near to real life“ code is much more benefical as it helps to get a feeling for „the gist of it“ faster.

Prerequisite for understanding the sample bits I guess would be some experince with SQL, some other RDBMS would be totally fine. Also there’s the simplest possible Python script provided to show how easy it is to work with data so basic Python knowledge wouldn’t hurt.

PostgreSQL Showcase – Project status

As we know Postgres functionality is HUGE and not everything is exemplified (maybe more advanced stuff even shoudn’t be), so here would be actually good to hear some feedback from actual Postgres beginners. As it’s getting pretty tough to put myself in the shoes of a beginner after years of daily Postgres 🙂

Also look at the structural side – would it be better off by using Markdown all the way instead of commented SQL scripts? Some better structuring?
In short – feedback on Github would be much appreciated! Thanks.

Visit the project on Github

Kaarel Moppel
I’ve been interested with databases for the last 10 years, working last 6 years exclusively with PostgreSQL. And still I’m constantly surprised by it’s powerful set of features and the fast pace of development by the globally friendly community. On my spare time I enjoy playing soccer and travelling.