PG-Trajectory is a PostgreSQL/PostGIS extension for spatiotemporal data. Thanks to trajectory data model and functions, it is possible to develop complicated spatiotemporal applications. PG-Trajectory is developed by DMLAB @ GSU.
PG-Trajectory is coded in PL/pgSQL and source code is open sourced.
See online docs or download the paper.