Leo Hsu

Boston, Massachusetts

Areas of Expertise:

  • PostgreSQL
  • PostGIS
  • SQL Server
  • Economics
  • Database
  • consulting
  • speaking
  • programming
  • training
Leo Hsu is a co-principal of Paragon Corporation, a database consulting company based in Boston. He has over 15 years of professional experience developing and thinking about databases for organizations large and small. Leo holds an MS degree in engineering of economic systems from Stanford University and BS degrees in mechanical engineering and economics from the Massachusetts Institute of Technology. He co-authored PostGIS in Action and PostgreSQL: Up and Running.

PostgreSQL: Up and Running PostgreSQL: Up and Running
by Leo Hsu, Regina Obe
Second Edition May 2014

PostgreSQL: Up and Running PostgreSQL: Up and Running
by Regina Obe, Leo Hsu
July 2012
Print: $19.99
Ebook: $16.99

Leo blogs at:

psql watch for batch processing

May 31 2014

A while back, we discussed using pgAdmin pgScript as a quicky way for running a repetitive update script where you want each loop to commit right away. Since stored functions have to commit as a whole, you can't use stored functions alone for this kind of processing. Question: Can you do… read more

PostgreSQL 9.4beta1 and PostGIS 2.2.0 dev on Windows

May 20 2014

PostgreSQL 9.4beta1 was released last week and windows binaries for both 32-bit and 64-bit are already available to try it out from http://www.postgresql.org/download/windows. Since this is a beta release, there are no installers yet, just the zip binary archive. To make the pot a little sweeter, we've setup the PostGIS windows… read more