No upcoming presentations...

    In responding to an RFP to optimize and improve street sweeping routes for a small city in California, we developed a solver based on Google's Operations Research Tools. While the guts of the solver uses OR-Tools, virtually everything else about the project is made possible by PostgreSQL, PostGIS, and pgRouting.

    In this presentation, I talk about the various ways PostgreSQL and friends made ...

    @ Postgres Webinar Series

    Oct 21 2020

    Case Study

    Using PostgreSQL, PostGIS, and pgRouting for street sweeping

    Load, clean, store, and animate OpenStreetMap data for a street sweeping route-optimizer project

    In responding to an RFP to optimize and improve street sweeping routes for a small city in California, we developed a solver based on Google's Operations Research Tools. While the guts of the solver uses OR-Tools, virtually everything else about the project is made possible by PostgreSQL, PostGIS, and pgRouting.

    In this presentation, I talk about the various ways PostgreSQL and friends ...

    @ Postgres Conference 2020
    Case Studies

    My standard development technique with PostgreSQL is to hack away in Emacs, try things out on live data, and eventually build up working queries and functions. This "test as you go" approach works well for small projects, but for really hard problems the result is usually hundreds of lines of SQL that looks a lot like an object lesson in unmaintainable code. Old hackers can learn new tricks, an...

    @ PGConf US 2016 [PgConf.US]
    Development