Jeremy Smith

Software Engineer at The Cornell Lab of Ornithology

About

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.

Jeremy Smith has presented the following presentations

    Henrietta Dombrovskaya Alvaro Hernandez Alexander Ioffe dharshan rangegowda Boris Novikov Jeremy Smith Life without ORM: is it possible and how we can get there at Postgres Conference 2020

    presented by Henrietta Dombrovskaya, Alvaro Hernandez, Alexander Ioffe, dharshan rangegowda, Boris Novikov, and Jeremy Smith

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

    more

    Development
    Jeremy Smith Building JSON from Relational Data at Postgres Conference 2020
    Explore PostgreSQL's built-in tools for creating JSON documents

    presented by Jeremy Smith

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

    more

    Development