Home

Essential PostgreSQL




Other Refcardz


thumb

Design Patterns

Features include class diagrams, explanation, usage information, and a real world example.


thumb

Core CSS: Part II

Features include Element Selectors, ID Selectors, Descendent Selectors, Attribute Selectors, Combining Selectors, Hot Tips and more.


thumb

Getting Started with Oracle Berkeley DB

Contents Include: Oracle Berkeley DB Family, Berkeley DB Java Edition Features, BDB JE Base API and Collections API, BDB JE DIrect Persistent layer, BDB JE Transaction Support and Performance Tuning, BDB JE Backup and Recovery, Hot Tips and more...


thumb

Seam UI

Contents Include: Simplifying JSF, Page Navigation, JSF Component Annotations, JSF Component Tags, Hot Tips, and More...




Click Here To
Download PDF


Overview

Targeted at novices and professionals alike, this Refcard will help you quickly navigate some of PostgreSQL’s most popular features as well as its hidden gems. It will cover topics such as configuration, administration, backup, language support, and advanced SQL features.


About the Author

The wife and husband team of Leo Hsu and Regina Obe founded Paragon Corporation in 1997 specializing in database technology.  Paragon Corporation works with numerous organizations to design, develop  and maintain database and web applications.  In 2002, Leo and Regina started to dabble in the growing field of spatial analysis  and have become active participants in the on-going development of PostGIS which is a spatial extension of PostgreSQL.  Regina is a member of the PostGIS core development team and Project Steering Committee.

Through Paragon Corporation, Leo and Regina have helped many clients using PostgreSQL, SQL Server and MySQL.  Paragon Corporation takes on database projects in a wide range of industries and advocates database-driven development.

Leo and Regina met at MIT and both graduated with engineering degrees.  Leo went on to obtain a master’s degree from Stanford University in Engineering of Economic Systems.

They maintain two sites:  http://www.postgresonline.com  -- provides tips and tricks for using PostgreSQL and http://www.bostongis.com - provides tips and tricks for using PostGIS, SQL Server 2008 Spatial and other open source and open GIS tools.

Email contact: lr@pcorp.us

URL: http://www.paragoncorporation.com