sharp knives: A Postgres

Work better with PostgreSQL. Understand and master the various tools you have at your disposal when working with a database. Level up your database skills.

First workshop to be held in Bangalore on March 2nd and 3rd. Register here SOLD OUT!

No spam, only infrequent updates.

What's on the table?

Grok SQL: Understand how queries are constructed, composed, how joins work, and never again get stuck writing complex queries.

Datatypes: Built-ins and beyond, learn how to construct and use your own types, functions, and when and why to use them.

Constraints: Validate your data, and preserve integrity using constraints. Learn about different kinds of constraints, and the how, when, and why of using them.

Indexes: Write queries that perform better. Choose right indexes, learn how to reason about query performance, and also when not to use indexes.

Schema Design: Tried and tested design patters, and when to use them. e.g. de-normalisation, using triggers, event sourcing.

Data manipulation: Split a large table, join multiple tables, bulk import millions of flat rows into normalised tables etc

Views: Regular and materialized views and their various usages in caching, reporting, query re-use, segmentation of data etc.

Locks, transactions: ACID in action, working with transactional data, concurrent requests, row & table locks, implications.

The dev environment: Give yourself a dev setup that gets out of your way and makes you productive. What tools to use? What to keep in your dot-files? etc.

Go Meta: Peek under the hood. Answer questions like: What queries are currently running? How many tables are referenced by this table?

Β© 2018 Swanand Pagnis. Icon made by Pixel Buddha from Flaticon

Thank you!

We're working on logistics, dates, and program structure. You will hear from us when we have more details.


You would've received an email from the ticket provider. Retain it, but no need to print it out.

What happens now?

1. You will get installation and setup instructions. πŸ“”
2. You will get some more communication about logistics. πŸ—ΊοΈ
3. That's it; you show up at the workshop, have fun, and learn. πŸ’»