Jeremy Smith
Software Engineer at The Cornell Lab of Ornithology
I am an Applications Developer at the Macaulay Library, part of the Cornell Lab of Ornithology. This library houses the world’s premier scientific archive of natural history audio, video, and photographs. I work on databases and APIs for storing metadata about and searching through our collection. I have been an avid user of PostgreSQL for the past 12 years, attempting to straddle the line between database administrator and backend developer.
Upcoming presentations
No upcoming presentations...
Past presentations
There is no protection against bad queries. If a query is poorly written, it's execution can't be improved with any indexes, fast access path or other database advancements. What is the most common source of poorly written queries? Most of the time they do not come from humans; they are generated by applications that use ORMs to communicate with databases. What can we do to prevent it from happ...
Building JSON from Relational Data
Explore PostgreSQL's built-in tools for creating JSON documents
JSON is the de facto format for modern APIs and has been part of Postgres since version 9.2. The ability to store, parse, and index JSON documents alongside relational data was game-changing and continuous improvements since 9.2 such as JSONB, indexing support, and the brand new JSON path expressions have made this feature better than ever.
In addition to storing JSON, Postgres provides a n...