| 32 | The proposed SQLite provider will have the following features: |
| 33 | |
| 34 | * Data stored and consumed in native SQLite format, and therefore accessible to other SQLite-based applications; |
| 35 | * Geometry will be serialized as BLOBs in FDO geometry format (FGF). Other ways that may be considered are storing points as X,Y columns and also geometry as WKB format; |
| 36 | * A non-persistent, spatial index usable for BBOX queries built on the fly and valid for the duration of the FDO connection; |
| 37 | * Execution of arbitrary SQL commands; |
| 38 | * A metadata table where the geometry coordinate system is stored in WKT or EPSG form. In addition, PRJ files will be supported as alternative means of specifying a coordinate system when a metadata table is undesirable; |
| 39 | * A tentative list of supported FDO commands : DescribeSchema, Select, SelectAggregates, Insert, Update, Delete, GetSpatialContexts, arbitrary SQL, ApplySchema, CreateDataStore; |
| 40 | |
| 41 | FDO features the provider will likely *not* support: |
| 42 | |
| 43 | * Feature class inheritance; |
| 44 | * Geometry filters other than BBOX; |
| 45 | * FDO Transactions -- but you can still manually execute BEGIN/COMMIT around other FDO commands; |
| 46 | * Any other exotic feature you can think of. |