About

Regina Obe is a world-renowned PostGIS spatial database expert and connoisseur of all things PostgreSQL. She has over 20 years professional experience in various programming languages and database systems. She is a member of the PostGIS project steering committee, the PostGIS core development team, pgRouting development team, and Geometry Open Source Library (GEOS) development and project steering committees.

She is a co-author of several PostgreSQL related books with her husband, Leo Hsu:

  • PostGIS in Action (2nd edition, 3rd edition in the works), published by Manning Publications,
  • PostgreSQL: Up and Running, (now in 3rd Edition), published by O'Reilly Media,
  • pgRouting: A Practical Guide (publisher, LocatePress).

She and Leo are currently working on an upcoming PostgreSQL book (publisher: No Starch Press).


Regina Obe 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
    Regina Obe Loading data into PostgreSQL at Postgres Conference
    Let me count the ways

    presented by Regina Obe

    PostgreSQL is one of the easiest databases to get data into and out of. In addition there are tons of free useful data sources to munch on.

    We'll cover various ways of loading various kinds of data into PostgreSQL. Data formats will include other postgres data, delimited, fixed width, spreadsheets, other relational databases, and other formats (including spatial formats) you may come across...

    more

    Tue 19 2019 Data