SQLite Quick Facts
Format Type Identifier |
SQLITE3 |
Reader/Writer |
Both |
Licensing Level |
Base |
Dependencies |
None |
Dataset Type |
File |
Feature Type |
Table name |
Typical File Extensions |
.sqlite, .sqlite3, .db, .sl3 Note that .db and .sl3 are equivalent; however, the .db filename extension is more commonly used. These filename extensions are not exclusive to the SQLite 3 format. |
Automated Translation Support |
Yes |
User-Defined Attributes |
Yes |
Coordinate System Support |
No |
Generic Color Support |
No |
Spatial Index |
Never |
Schema Required |
Yes |
Transaction Support |
Yes |
Encoding Support |
Yes |
Geometry Type |
db_none |
SQLite Geometry Support
Geometry |
Supported? |
aggregate |
no |
circles |
no |
circular arc |
no |
donut polygon |
no |
elliptical arc |
no |
ellipses |
no |
line |
no |
none |
yes |
point |
no |
polygon |
no |
raster |
no |
solid |
no |
surface |
no |
text |
no |
z values |
n/a |