Changes

Jump to: navigation, search

SQLite Adapter Research

359 bytes added, 22:01, 22 September 2011
no edit summary
! Limit
|-
|Max Number of columnsColumns
|Default: 2000 Max: 32767
|-
|Number of rows
|2^64 (Max file size should be reached before this)
|-
|Page size
|512 - 65536
|-
|Database size
|2 ^ 31 - 2 * Page_Size - Max theoretical size is 14 Terabytes, Operating system file size limit could occur before that point
|-
|Max number of columnsUUID|UUID's implemented in randomblob(); + hex();
|-
|UUID & Auto Increment|AUTOINCREMENT keyword guarantees that automatically chosen ROWIDs will be increasing but not that they will be sequential
|-
|Joins
|SQLite supports JOINS and LEFT Joins, FULL JOIN and RIGHT JOIN are supported
|}

Navigation menu