No upcoming presentations...

    It's unlikely that you will need to implement the Postgres wire protocol yourself, but understanding it will give you insight into how Postgres operates you'll not get otherwise. And as far as binary protocols go, this one is surprisingly not awful! In this talk we'll cover - motivations for using the raw protocol vs linking libpq - (and some protocol features not available in libpq!) - authent...

    @ PGConf US 2017 [PgConf.US]
    Internals

    Of all my regrets while building database-backed applications, not fully embracing database constraints sooner is one of the bigger ones. For far too long, I treated the db as a little more than a dumb key-value store with joins.

    Strong constraints turn your database into the last line of defense against bad data. Applications change several orders of magnitude more often than db schemas, a...

    @ PostgresConf US 2018

    Apr 18 2018

    Development