Postgres as a Graph Database
Greg has been using PostgreSQL for over 20 years and can date himself to the days of Ingres. He has held positions at small and large companies including sysadmin, DBA, engineer to architect. As a recent addition to Pivotal, he serves as an Account Data Engineer for California and Western U.S.
Tom works as a Senior Software Engineer for the Howard Hughes Medical Institute at the Janelia Research Campus. As the main developer of the open source neuron reconstruction and analysis platform CATMAID he tries to provide tools to advance the field of neuroscience in collaboration with many labs. This results in large data sets that represent the physical layout and connectivity of many or all neurons in model organisms like the fruit fly. All data created in this context is held and maintained by PostgreSQL, which has been in use for this project for almost ten years.
Graph databases can be an incredible tool for discovering relationships buried within the data but are they always the right choice? As technical people, we are inclined to learning something new. Graph database solutions are no exception and to many of us they appear as shiny things that must be explored and applied. They are not always the right fit and we forget the R in RDBMS. PostgreSQL has many uses as a graph database and provides for many of the use cases as well as ancillary cases the graph database falls short.
Presentation covers use cases where PostgreSQL is a strong candidate and considerations for implementation.
Talk assumes knowledge of PostgreSQL query fundamentals and programming concepts.
- 50 min
- Postgres Conference 2020
- Data Science