BaseTen, a new Mac framework for PostgreSQL databases

Posted on 2007-01-02

BaseTen is a new, open source Cocoa database framework for working with PostgreSQL databases. BaseTen has been designed with familiar, Core Data -like semantics and APIs.

The initial Developer Preview 1 release is intended for evaluation purposes only, but new versions should follow shortly. The feature highlights include:

  • BaseTen Assistant imports Core Data / Xcode data models
  • Discovers the database schema automatically at runtime, including 1-1, 1-many and many-many relationships
  • Database changes are propagated to clients automatically, without polling
  • In-memory database objects are uniqued, and objects fetched via relationships are faults by default
  • Support for RDBMS features like database-driven data validation, multi-column primary keys and updateable views
  • Autocommit and manual save/rollback modes, both with NSUndoManager integration
  • A BaseTen-aware NSArrayController subclass automates locking and change propagation
  • Fetches are specified with NSPredicates (the relevant portions of which are evaluated on the database)

Requirements

  • Foundation, Mac OS X 10.4-era and later; PostgreSQL 8.2 and later
  • AppKit for the optional BXSynchronizedArrayController

This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.