John Ashmead
Database Analyst at 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.
Upcoming presentations
No upcoming presentations...
Past presentations
- Table design
- Indexing
- PostgreSQL types
- Stored procedures -- when & how to use, when not
- Triggers
- How to work with a web framework (i.e. Ruby-on-Rails): what works belongs in t...
From Startup to Mature Company
PostgreSQL Tips and Techniques
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:
Apr 20 2018