About

Leo Hsu is a master database architect with extensive experience building business intelligence and automation applications for flight management, labor unions, and economic optimization apps. He has over 20 years professional experience working for non-profits and Dot coms developing automated pricing and process applications and devising workflow strategies.

He is a PostgreSQL aficionado and author. He is a co-author with his wife, Regina Obe, on several PostgreSQL related books: PostGIS In Action (now in it's 2nd edition with 3rd edition in the works) (Manning Publications), PostgreSQL Up and Running (now in 3rd edition)(O'Reilly Media), pgRouting: A Practical Guide (Locate Press, 2nd edition in works), and upcoming big book of PostgreSQL in the works (No Starch Press).


Leo Hsu has presented the following presentations

    Leo Hsu Regina Obe Getting Stuff done with PostGIS and pgRouting at Postgres Conference 2020
    Answering WHERE and HOW with your data

    presented by Regina Obe and Leo Hsu

    This training will teach you how to use PostGIS related extensions to answer questions about WHERE and HOW TO GET THERE with data. The main focus will be on the postgis and pgrouting extensions as well as tools for loading spatial data. We will also cover techniques for getting the most performance out of your spatial and routing queries. Though most queries will also work on lower versions, w...

    more

    Data Science
    Leo Hsu Getting stuff done with PostGIS at Postgres Conference
    What PostGIS can do for me

    presented by Leo Hsu

    This training will teach you how to use PostGIS related extensions with main focus on the postgis, pgrouting and ogr_fdw spatial extensions. We will also cover techniques for getting the most performance out of your spatial queries. Though most queries will also work on lower versions, we will be using PostgreSQL 11+, PostGIS 2.5+ , and pgRouting 2.6+. We will highlight functions/spatial tricks...

    more

    Tue 19 2019 Development