Changes

Jump to: navigation, search

SQLite Adapter Research

209 bytes added, 11:59, 23 September 2011
Limits
|2 ^ 31 - 2 * Page_Size, Max theoretical size is 14 Terabytes, Operating system file size limit could occur before that point
|-
|UUID4|N-byte blob containing pseudo-random bytes, SQL Function hex(randomblob(16)) facilitates this
|-
|Auto Increment
|AUTOINCREMENT keyword guarantees that automatically chosen ROWIDs will be increasing but not that they will be sequential, added to Integer PK fields|-|Last Insert Row|Non thread safe SQL Function last_insert_rowid() facilitates last row access
|-
|Joins
|SQLite supports JOINS and LEFT Joins, FULL JOIN and RIGHT JOIN are supported, maximum of 64 tables per join
|}

Navigation menu