Database consulting and application development...

...because your data is your business

 
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 Accidental DBA

So, you’ve inherited a PostgreSQL server. Congratulations? Thanks to Postgres’ popularity as the database for new applications, both open source and commercial, thousands of developers, system administrators and devops are finding themselves in charge of PostgreSQL servers with no idea what to do next. This tutorial will cover the essential care and feeding of a Postgres elephant so that you can get back to your real job. The tutorial will include the following core topics: Installation Updates and upgrades Backup System information Configuration Basic query troubleshooting Connection management Monitoring Replication basics Where to go for further help.


More Presentations by Josh Berkus
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
Nov. 3, 2015

Explain Explained

In depth discussion on the explain process in PostgreSQL.


More Presentations by Josh Berkus
Sept. 18, 2015

Postgres Performance in 15 Minutes

In 15 minutes, plus Q&A time, Postgres expert Josh Berkus will explain the essentials of making your database performance "good enough" that you can ignore it and move on to other things. This will include: Why database configuration is less than 20% of performance The 14 settings most people need Why connection pooling is essential Avoiding bad hardware DB performance for the public cloud Stupid things your app does which kills performance Enjoy this fast-paced roundup of PostgreSQL performance essentials.


More Presentations by Josh Berkus
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
June 18, 2015

PostgresSQL 9.4: FlexScalePerfSQL

Whatever you use PostgreSQL for, version 9.4, released December 18th, has a lot to offer. Whether you're migrating your NoSQL application to PostgreSQL by using the new JSONB or scaling up using higher performance, scaling out using the new replication API, or doing analytics using new analytic functions. version 9.4 has something for you. Come learn all about it, with demos.


More Presentations by Josh Berkus
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
Feb. 26, 2015

Shootout at the AWS Corral

This talk is about running PostgreSQL in the cloup


More Presentations by Josh Berkus
Feb. 5, 2015

Demonstrating pg_shard

Josh Berkus demonstrates pg_shard.


More Presentations by Josh Berkus
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

Full Throttle Database PostgreSQL 9.2

Gentlemen, start your database engines! PostgreSQL 9.2 beta is here, and it's faster and more exciting than ever before. Come down to the track and join us for a high-speed tour of a database which is faster than ever before! Starting at pole position, we will whip around the features of version 9.2, speeding through one demo after another, including: cascading replication enhanced vertical scalability improved performance index-only access range types JSON support better live DDL deployments new administrative views It's the fastest PostgreSQL yet, and you have a shotgun seat!


More Presentations by Josh Berkus
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
Aug. 24, 2013

Super Jumbo Delux

Before you resort to expensive proprietary database systems or time-consuming map-reduce frameworks, PostgreSQL should be your first tool for handling Big Data.


More Presentations by Josh Berkus
Aug. 8, 2013

Data Warehousing 101

This talk is everything you never wanted to know about big databases but were forced to find out anyway.


More Presentations by Josh Berkus
July 24, 2013

Seven Deadly Sins of Software Deployment 2013

A quick poetic talk comparing the seven deadly sins to software development and deployment.


More Presentations by Josh Berkus
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
July 12, 2012

Firehouse Engineering:Designing high-volume data collection systems

How to best design a system which allows for large amounts of incoming data and a large amount of processing of this data. This talk goes over the 4 biggest issues which must be dealt with: Volume, constant flow, database size and component failure. The talk continues by discussing the ways to solve these problems.


More Presentations by Josh Berkus
June 30, 2012

Optimizing Queries with Postgres Explain

This talk reviews how to use the explain feature is postgreSQL. It also talks about optimizing queries using the results from the explain command.


More Presentations by Josh Berkus
May 23, 2012

Stupid Solaris tricks

This talk goes over some solaris tip and tricks.


More Presentations by Josh Berkus
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 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 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
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 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 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 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 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 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
Oct. 22, 2011

PostgreSQL 9.1 Grand Tour

This talk shares in-depth information on the new features of postgreSQL 9.1


More Presentations by Josh Berkus
April 14, 2011

Scale Fail

In this tongue and cheek talk, Josh talks about how to best make your application impossible to scale.


More Presentations by Josh Berkus

Our Presentations