John Ashmead

Database Analyst at Nistica, Inc.

About

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.

John Ashmead has presented the following presentations

    John Ashmead From Startup to Mature Company at PostgresConf US 2018
    PostgreSQL Tips and Techniques

    presented by John Ashmead

    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 t...
    more

    Fri 20 2018 Use Cases