Presented by:

John ashmead cheerful

John Ashmead

Nistica, Inc.

John Ashmead has been working with relational databases since the 1980's, building & repairing databases in Informix, Mistress, Oracle, 4th Dimension, Omnis, and Ingres (a predecessor to PostgreSQL).

For most of his career he has been a consultant, but for the last four years he has been the DBA & database developer at Nistica, a leading manufacturer of Optical Switches. John is in charge of the care & feeding of Nistica's manufacturing database Zeppelin. Zeppelin is written in PostgreSQL. The front end is written (mostly) in Ruby-on-Rails with bits in Java, bash, ruby, awk, .... Zeppelin is distributed across a number of Linux servers, some in Vietnam, some in Japan, and some in New Jersey.

His talk will be about what he & Nistica have learned about how to make this work reasonably well and what not to do.

No video of the event yet, sorry!
Download the Slides

This talk is for people relatively new to PostgreSQL who are wondering:

How do I get going with PostgreSQL -- in a way that won’t create problems later on!

We’ll go over best practice in:

  1. Table design
  2. Indexing
  3. PostgreSQL types
  4. Stored procedures -- when & how to use, when not
  5. Triggers
  6. How to work with a web framework (i.e. Ruby-on-Rails): what works belongs in the framework, what should be done in the database
  7. Error & exception management
  8. Doing the right amount of planning
  9. Why you might want to build the help system first, and use it to help build the rest.

Nistica has its ownership in Japan, engineering in New Jersey, & manufacturing in Vietnam so we’ll take a special look at:

  1. Handling different languages & character sets
  2. Timestamps & time zones
  3. How to sync data from one part of the world to another without letting data fall on the floor or creating infinite loopiness.

Nistica has gone from startup to world player in the manufacture of optical switches. It has run its manufacturing on PostgreSQL from the start, using PostgreSQL to drive every step from assembly to quality assurance & tracking all part data in the database.

Going from the ad hoc procedures appropriate for a startup to the disciplined approaches required by the world market has taught us a lot about how to get the best out of PostgreSQL.

We’ve learned a lot from the PostgreSQL community; now we’d like to share some of what we’ve learned from our experience.

2018 April 20 09:50 EDT
50 min
PostgresConf US 2018
Use Cases