2011

Working with SQLite Data
The OSGeo FDO provider for SQLite is an open-source, file-based provider
developed by Autodesk. This read/write provider supports one update user at
a time with any number of read users.
You can do the following in AutoCAD Map 3D:
■ Create a SQLite data store
■ Connect to a SQLite data store
■ Import from SQLite
■ Export to SQLite
■ Save a Display Manager layer to SQLite
Each SQLite data store can contain one schema and a single spatial context.
The name of the schema must be "Default.”
What SQLite Schemas Support
A SQLite
schema (page 2073) can support the following:
■ All FDO property types except raster, object, association, and LOB properties
■ Auto-generated properties for int32 and int64 properties
■ All FDO geometry and geometry component types, including arc segments
■ 2D, 3D, and measure (M)
■ Single and composite primary keys
■ Null value constraints
■ Unique value constraints
■ Range and list constraints
■ Default values
■ Select, Select Aggregate, Insert, Update, and Delete commands
■ SQL commands
■ Transactions with commit and rollback
■ All FDO spatial operators except distance
Working with SQLite Data | 565