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 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 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
- Standard FDO expressions and filters
- Parameter binding for all commands (at the API level)
Restrictions of SQLite Schemas
When you create or modify a SQLite schema, the following restrictions apply:
- SQLite native data supports only the following base property types: int64, double, string and Geometry.
- If there is data in the class, you cannot modify the primary key or constraints.
- Persistent locking and long transactions are not supported.
- You cannot change the schema name for a SQLite data store. The schema name must be “Default.”
- You cannot add comments in the Schema or Feature Class fields.
Working with SQLite Data