Database consulting and application development...

...because your data is your business

 
Sept. 27, 2017

Human Beings Do Not Have A Primary Key

... or, Data Modeling in the Age of Social Networks.

We're now building systems that collect data on every aspect of someone's life: Not just their name and address, but their gender(s), family, relationships, movements, preferences...

And all of the assumptions we make about people in these models are probably wrong. What's a "name"? What's a "family"? What's a "relationship"? How do we model the vast complex reality of human life in a data system... and do so ethically, legally, and with an eye to the realities of how people live?

We'll talk about the range of issues this brings up, from basic low-level schema issues through user experience concerns, as well as touching on ethical, legal, and regulatory compliance issues in collecting this sort of data.


More Presentations by Christophe Pettus
May 25, 2017

Corruption War Stories PGCon 2017

Every instance of database corruption is unique. In this talk, we'll talk about some specific, real-world examples of PostgreSQL database corruption, and how they were repaired. We'll step through each one with how we detected it, how we isolated the issue, and what we did to patch it... and what did and didn't work.


More Presentations by Christophe Pettus
March 30, 2017

Corruption War Stories

Every instance of database corruption is unique. In this talk, we'll talk about some specific, real-world examples of PostgreSQL database corruption, and how they were repaired. We'll step through each one with how we detected it, how we isolated the issue, and what we did to patch it... and what did and didn't work.


More Presentations by Christophe Pettus
Nov. 16, 2016

Securing PostgreSQL - PGConf SV

There are many ways database servers can be vulnerable to attacks. This talk delves into many of the ways a PostgeSQL database server can be secured.


More Presentations by Christophe Pettus
Aug. 10, 2016

Django 1.8/1.9 and PostgreSQL: An Ever-Closer Union - DjangoCon US 2016

Django 1.8/1.9 adds a whole bunch of cool new features that are specifically designed for PostgreSQL. We'll take a quick tour through them, and show when and how you can use them in real-world applications. We'll also talk about how to get the best performance out of PostgreSQL when using the Django ORM.


More Presentations by Christophe Pettus
May 31, 2016

Django 1.8/1.9 and PostgreSQL: An Ever-Closer Union - PyCon 2016

Django 1.8/1.9 adds a whole bunch of cool new features that are specifically designed for PostgreSQL. We'll take a quick tour through them, and show when and how you can use them in real-world applications. We'll also talk about how to get the best performance out of PostgreSQL when using the Django ORM.


More Presentations by Christophe Pettus
Jan. 18, 2016

Life with Object-Relational Mappers part 09

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.


More Presentations by Christophe Pettus
Nov. 25, 2015

The PCI-Compliant Database

If you handle credit card numbers, your application and database are probably not PCI (Payment Card Information) compliant. Yes, this means you. We'll talk about what is required and forbidden when dealing with payment card information at the database layer. We'll talk about policies and procedures, security best practices, encryption, and things you must never, ever do.


More Presentations by Christophe Pettus
Aug. 18, 2015

PostgreSQL in Django 1.8 DjangoCon 2015

Among the topics are: A survey of the new Django 1.8 PostgreSQL features. Using migrations with PostgreSQL in interesting ways. Real-life applications of the new field types. Basic model design for good performance on PostgreSQL.


More Presentations by Christophe Pettus
Aug. 3, 2015

PostgreSQL in Django 1.8 2015

Django 1.8 adds a whole bunch of cool new features that are specifically designed for PostgreSQL. We'll take a quick tour through them, and show when and how you can use them in real-world applications. We'll also talk about how to get the best performance out of PostgreSQL when using the Django ORM.


More Presentations by Christophe Pettus
April 11, 2015

PostgreSQL Proficiency for Python People - PyCon 2015

PostgreSQL has become the default database for most green-field development projects, and is the data storage architecture behind many major Python-based success stories, such as Instagram. Despite a reputation as being complex and fiddly, Postgres is easy to install, administer, maintain, and use... with just a little bit of orientation. This is that orientation.


More Presentations by Christophe Pettus
Aug. 8, 2014

Django Transactions: Past, Present, and Future

PyCon Australia is the national conference for users of the Python Programming Language. In August 2014, we're heading to Brisbane to bring together students, enthusiasts, and professionals with a love of Python from around Australia, and all around the World.


More Presentations by Christophe Pettus
June 2, 2014

The Worst Day of Your Life

Recovering from PostgreSQL Crises and Disasters


More Presentations by Christophe Pettus
May 23, 2014

Really, Really Fast Django 2014

Tips and tricks on how ensure django runs fast.


More Presentations by Christophe Pettus
April 12, 2014

PostgreSQL Proficiency for Python People 2014

"PostgreSQL has become the default database for most green-field development projects, and is the data storage architecture behind many major Python-based success stories, such as Instagram. Despite a reputation as being complex and fiddly, Postgres is easy to install, administer, maintain, and use... with just a little bit of orientation.This is that orientation."


More Presentations by Christophe Pettus
Dec. 30, 2013

Unstructured Data in PostgreSQL

With the new JSON features in 9.2, PostgreSQL has more options for handling unstructured data than ever before, while retaining the full typing system, relational integrity, and data safety features of a full RDBMS. We'll go over the various schema-less data storage options in PostgreSQL, with a focus on the new JSON features. We'll talk about indexing, using JSON and other unstructured types in functions within PostgreSQL, and performance considerations.


More Presentations by Christophe Pettus
Aug. 24, 2013

PostgreSQL when it's not your job 2013

In this DevOps world, developers are increasingly being asked to manage the database as well. In a few brisk minutes, we will talk about (nearly) everything you need to know to bring up, tune, and keep a PostgreSQL database health. We'll go over installation, basic tuning, backups, disaster recovery, and helpful tools and techniques. It's a very rare startup these days that has a full-time DBA on staff; mostly, the developers are pressed into service to handle the database as well. In this talk, we'll present the survival skills required to manage your PostgreSQL database while trying to push the product out the door. We'll cover: Installation. Basic tuning (it's easier than you think). Performance, including things you must not do. Backups and disaster recovery. Helpful tools, tips and tricks.


More Presentations by Christophe Pettus
July 5, 2013

Extending Python into PostgreSQL

This talk goes into depth in writing and using custom types in PostgreSQL using Python and everything that can go wrong.


More Presentations by Christophe Pettus
June 4, 2013

Advanced PostgreSQL in Django

Using the postgreSQL specific features in database agnostic Django.


More Presentations by Christophe Pettus
Dec. 28, 2012

PostgreSQL when it's not your job PyConAr 2012

In this DevOps world, Django programmers are increasingly being asked to manage the database as well. In 45 brisk minutes, we will talk about (nearly) everything you need to know to bring up, tune, and keep a PostgreSQL database health. We'll go over installation, basic tuning, backups, disaster recovery, and helpful tools and techniques.


More Presentations by Christophe Pettus
Dec. 9, 2012

Django under massive loads 2012

The Python web framework Django can handle extremely high levels of traffic... with appropriate design and support. We'll go over techniques to keep your Django site from being crushed under high load. Topics include: Schema/model design; Caching; Efficient view function design; Caching; Template design for high performance; Caching; Database tuning and sharding; Caching We'll also discuss caching.


More Presentations by Christophe Pettus
Dec. 8, 2012

PostgreSQL Unboxing - PgDayAr2012

In this one intense tutorial, we'll go from a bare machine with just a PostgreSQL source tarball or RPM in hand to a fully-functional, replicated, backed-up, tuned database installation. We'll cover: Installing the base PostgreSQL package and important additional modules; How to lay out the installation and the various components of PostgreSQL in the right places in the file system; Basic PostgreSQL tuning and optimization for particular hardware.; Getting PostgreSQL streaming replication/hot standby set up.; Doing backups; Monitoring and performance checking once your database is in production; Disaster planning and recovery. Only basic system administration experience is required; if you can type commands into bash, you're qualified.


More Presentations by Christophe Pettus
Oct. 6, 2012

PostgreSQL when it's not your job 2012

A guide to the basics of PostgreSQL for non-DBAs managing their system.


More Presentations by Christophe Pettus
Jan. 18, 2012

Life with Object-Relational Mappers part 06

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.


More Presentations by Christophe Pettus
Jan. 18, 2012

Life with Object-Relational Mappers part 05

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.


More Presentations by Christophe Pettus
Jan. 18, 2012

Life with Object-Relational Mappers part 04

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.


More Presentations by Christophe Pettus
Jan. 18, 2012

Life with Object-Relational Mappers part 02

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.


More Presentations by Christophe Pettus
Jan. 18, 2012

Life with Object-Relational Mappers part 07

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.


More Presentations by Christophe Pettus
Jan. 18, 2012

Life with Object-Relational Mappers part 08

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.


More Presentations by Christophe Pettus
Jan. 18, 2012

Life with Object-Relational Mappers part 01

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.


More Presentations by Christophe Pettus
Jan. 18, 2012

Life with Object-Relational Mappers part 11

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.


More Presentations by Christophe Pettus
Jan. 18, 2012

Life with Object-Relational Mappers part 10

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.


More Presentations by Christophe Pettus
Jan. 18, 2012

Life with Object-Relational Mappers part 03

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.


More Presentations by Christophe Pettus

Our Presentations