Changes

Jump to: navigation, search

SQLite Adapter Research

731 bytes added, 22:47, 26 January 2014
no edit summary
{{Admon/obsolete}}
 
[[category: NexJ Express SQLite]]
=Overview=
! Limit
|-
|Max Number of columnsColumns|Default: 2000 \n , 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|-|UUID 4|N-byte blob containing pseudo-random bytes, SQL Function hex(randomblob(16)) facilitates this
|-
|Max number of columnsAuto Increment|AUTOINCREMENT keyword guarantees that automatically chosen ROWIDs will be increasing but not that they will be sequential, added to Integer PK fields
|-
|UUID & Auto IncrementLast 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|-|JDBC Drivers|http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.7.2/ 
|}

Navigation menu