Documentation Source Text

File History
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of pages/vtab.in

2018-11-16
14:33
More fixes to the virtual table documentation. file: [5afca8d8fd] check-in: [70c4eaad4d] user: drh branch: trunk, size: 67631
14:30
Explain the use of SQLITE_CONSTRAINT as a return value from xBestIndex. file: [633dd921e1] check-in: [52c277f049] user: drh branch: trunk, size: 67428
2018-11-12
15:24
Enhancements to the documentation regarding security and shadow tables. file: [f8600c18f3] check-in: [7b6b7a791b] user: drh branch: trunk, size: 65051
2018-09-25
16:26
Improvements to the legacy_alter_table pragma documentation. Typo fix in the change log. file: [40a259a11f] check-in: [db3facf719] user: drh branch: branch-3.25, size: 62122
15:02
Preliminary changes for version 3.25.2. file: [c0ba86d3c7] check-in: [e00e728eae] user: drh branch: branch-3.25, size: 62127
2018-08-27
20:52
Enhancements to the virtual table documentation to describe the operation of SQLITE_INDEX_CONSTRAINT_FUNCTION. file: [6f33d266c4] check-in: [f3d8866e42] user: drh branch: trunk, size: 61557
2018-06-15
19:12
Fix missing "const" in the documentation of the argv parameters to the xCreate and xConnect methods in the sqlite3_module object. file: [a9369ba6bb] check-in: [2ee890a53a] user: drh branch: branch-3.24, size: 59519
2018-06-08
13:21
Use https for all internal hyperlinks. file: [c031632705] check-in: [59e5f9e3da] user: drh branch: branch-3.24-https, size: 59501
2018-05-25
17:50
Add the vtablist.html page. file: [8a0e009314] check-in: [3d073f02d7] user: drh branch: trunk, size: 59499
12:54
Clarification of xUpdate behavior in the virtual table documentation. file: [8ea396006e] check-in: [36334d1830] user: drh branch: trunk, size: 59398
2018-04-30
22:27
Update the change log. Fix typo in virtual table documentation. file: [f89efbdb0b] check-in: [32c5dad1b2] user: drh branch: trunk, size: 59333
2018-02-07
20:35
Fix typo in the vtab.html document. file: [16d989be23] check-in: [ec9c8be989] user: drh branch: branch-3.22, size: 59332
2018-01-22
18:05
Fix a typo in the vtab document. file: [1180bd8e8c] check-in: [2105719672] user: drh branch: trunk, size: 59320
2018-01-13
00:03
Clarification and typo fixes in the sqlite3_value_nochange() description within the xUpdate documentation. file: [a9c09dd79f] check-in: [92b3735966] user: drh branch: trunk, size: 59319
2018-01-12
23:52
Update documentation for the sqlite3_value_nochange() interface. file: [685f08e741] check-in: [8d811e938b] user: drh branch: trunk, size: 59223
2017-09-12
00:44
Update the virtual table documentation with information about the new operators passed into xBestIndex. file: [33d26508d8] check-in: [bd399e9806] user: drh branch: trunk, size: 58265
2017-08-11
01:21
Update the virtual table documentation to describe writable WITHOUT ROWID virtual tables. Also update the change log. file: [da69470a70] check-in: [af4e59995a] user: drh branch: trunk, size: 57890
2017-08-09
20:03
Clarification on the operation of the xUpdate method in the virtual table interface. file: [4ccdc8bf50] check-in: [ecec1e668b] user: drh branch: trunk, size: 57360
2016-09-14
21:12
Fix unescaped > characters in vtab.in. file: [60bb0e494a] check-in: [aa59a746e9] user: drh branch: trunk, size: 57337
18:40
Add and use the "[dateof:3.X.Y]" hyperlink target for automatically inserting release dates into the text. file: [daba002df9] check-in: [858d993381] user: drh branch: trunk, size: 57328
2016-09-12
21:06
Fix formatting problems in vtab.html associated with <yyterm> marks. file: [77a77ba503] check-in: [2262f22f31] user: drh branch: trunk, size: 57212
21:01
Fix a typo in vtab.in. file: [15c8b6489f] check-in: [4df3244e10] user: dan branch: trunk, size: 57719
2016-08-09
00:13
Properly escape "<" and ">" characters in the vtab.html document. file: [62b599d019] check-in: [03ec352945] user: drh branch: trunk, size: 57720
2016-06-23
16:59
Enhancements to the WITHOUT ROWID virtual table documentation. file: [8f4fe32040] check-in: [ad981b591f] user: drh branch: trunk, size: 57705
2016-06-03
22:40
Documentation on WITHOUT ROWID virtual tables and the LIKE OR EQUAL optimization for virtual tables. file: [41e584b735] check-in: [01b8f2aa54] user: drh branch: trunk, size: 57740
2016-02-02
02:05
Enhance the comment on the sqlite3_index_constraint.iColumn field to help bring attention to the fact that it can be negative for a rowid column. file: [05e1679d19] check-in: [be35c1ae8e] user: drh branch: trunk, size: 56388
2015-11-30
19:36
Add information about the sqlite3_index_info.colUsed field. file: [bf36b063cb] check-in: [43d4cb5785] user: drh branch: trunk, size: 56393
2015-11-25
18:42
Update the documentation for the LIKE/GLOB/REGEXP enhancement to virtual tables. file: [2557617a3d] check-in: [6b8138c898] user: drh branch: trunk, size: 55497
2015-11-11
20:52
Fix a typo in the virtual table documentation. file: [384ed86023] check-in: [04edad8b2f] user: drh branch: trunk, size: 55258
2015-10-12
18:04
Fix typos. file: [33d41c85c4] check-in: [63898e2980] user: drh branch: trunk, size: 55258
05:51
More documentation updates for 3.9.0. file: [9df3fb379f] check-in: [1c92bfea70] user: drh branch: trunk, size: 55259
2015-10-07
22:42
Fix a couple typos in the new docs. file: [7c82a6653b] check-in: [255ed0fac7] user: mistachkin branch: trunk, size: 54705
2015-09-11
17:17
Improvements and fixes to the eponymous virtual table documentation. file: [fe1e3f8f23] check-in: [a8cbed7cc9] user: drh branch: trunk, size: 54708
16:14
Minor updates to json1 and table-valued function documentation. file: [e4342f884a] check-in: [af1be7762c] user: drh branch: trunk, size: 54373
2015-09-08
21:33
Improved documentation for table-valued functions and eponymous virtual tables. file: [e6182d8b67] check-in: [9b1f04e2d1] user: drh branch: trunk, size: 54255
18:41
Updates to the change log for 3.8.12. Add documentation for eponymous virtual tables, for table-valued functions, and other new capabilities. file: [464f298fa9] check-in: [456508e2ed] user: drh branch: trunk, size: 53024
16:25
Update language documentation to begin describing new features: (1) indexes on expressions (2) table-valued functions (3) column names on VIEWs. file: [4cd63307ed] check-in: [d9a422f858] user: drh branch: trunk, size: 49930
2015-08-19
13:55
Fix the argvIndex description in the virtual table documentation. file: [bc6a8ec068] check-in: [26089f7cd9] user: drh branch: trunk, size: 49439
2014-10-25
13:09
Fix a paragraph number in the vtab.html document. file: [e47080223b] check-in: [66c36ec0c8] user: drh branch: trunk, size: 49438
2014-07-24
14:39
Add documentation for sqlite3_index_info.estimatedRows, part of the virtual table interface. file: [f035907454] check-in: [77f80a4186] user: dan branch: trunk, size: 49438
2014-07-03
11:15
Fix a typo in vtab.html. file: [937faaebdf] check-in: [34e181958c] user: dan branch: trunk, size: 48580
2013-06-21
08:00
Fix another minor typo in the vtable docs. file: [7f5e298342] check-in: [a93d66e412] user: mistachkin branch: trunk, size: 48585
2013-05-29
06:57
Fix minor typo in the virtual table documentation for xCreate and xConnect. file: [e1514410e4] check-in: [44d1e198ca] user: mistachkin branch: trunk, size: 48584
2013-03-09
15:12
Fix various documentation typos. file: [ca8fded095] check-in: [8a8b9f4250] user: drh branch: trunk, size: 48578
2012-10-29
19:14
Fix typos in the documentation of xDisconnect and xDestroy methods of virtual tables. file: [20cebe70db] check-in: [1974081af3] user: drh branch: trunk, size: 48584
2011-06-20
21:48
Documentation typos. file: [b88b3a0851] check-in: [b503d1f516] user: drh branch: trunk, size: 48584
2011-05-24
00:52
Added preliminary documentation for the SAVEPOINT methods in virtual tables. file: [a4515675af] check-in: [3dded2adf9] user: drh branch: trunk, size: 48583
2010-11-26
21:06
Updates to the FTS3 documentation to include additional discussion and links to FTS4 concepts. file: [f9833014be] check-in: [b8865a0011] user: drh branch: trunk, size: 46974
2010-09-02
04:20
More typo fixes. file: [a45745629e] check-in: [db66d3a1d4] user: shaneh branch: trunk, size: 46600
2010-09-01
11:49
New hyperlinks to FTS and RTree. New requirement that automatically generated rowids must be positive. file: [4b3954d964] check-in: [ddcf89bab0] user: drh branch: trunk, size: 46601
2010-08-28
05:48
Fix documentation typos. file: [f3723de64e] check-in: [78fe166463] user: shaneh branch: trunk, size: 46597
2010-08-13
17:44
Enhancements to the description of how the COLLATE operator works. file: [3f2067feb7] check-in: [17093bc7d6] user: drh branch: trunk, size: 46596
2010-08-09
15:45
Fix a bunch of documentation typos reported on the mailing list. file: [86c15ceff2] check-in: [d9e242f92a] user: drh branch: trunk, size: 46594
2009-08-06
17:47
Change docs to talk about the fact that virtual tables and shared cache can be used together beginning with version 3.6.17. file: [0208341f4b] check-in: [68debd1491] user: drh branch: trunk, size: 46595
2009-07-30
10:51
Update documentation to talk about 100% test coverage in SQLite. file: [39187f02fc] check-in: [f7aa8bfebf] user: drh branch: trunk, size: 46591
2009-07-29
23:07
Merge lang.html and vtab.html corrections that got marooned on a branch into the main line. file: [c906dae116] check-in: [ab7c4f5247] user: drh branch: trunk, size: 47234
2009-04-15
12:56
Fix typos in the vtab.html document. file: [79514e25ae] check-in: [e9e994caf8] user: drh branch: trunk, size: 46731
2009-04-14
18:20
More virtual table documentation tweaks. file: [f56b52a2e0] check-in: [0d0a959a73] user: drh branch: trunk, size: 46670
18:15
Update to the virtual table documentation - in particular the documentation on the xUpdate method. file: [b3b857dfdc] check-in: [feccb40483] user: drh branch: trunk, size: 46462
11:45
Additional virtual table documentation improvements. Fix the "when-to-use" document to omit discussion of the obsolete bitmap size limits. file: [dcc0f7756a] check-in: [9ef2178fee] user: drh branch: trunk, size: 45907
2009-04-13
18:04
Fix a requirement number conflict in fileformat.in. Enhanced and expanded vtab.in. file: [562ed5eb22] check-in: [9acad193dd] user: drh branch: trunk, size: 45551
14:43
Further enhancements to the virtual table documentation. file: [db095cd2aa] check-in: [ebd923dab6] user: drh branch: trunk, size: 36532
12:58
Initial check-in of documentation on the virtual table interface. file: [7bfdd6afc6] check-in: [0776bf4007] user: drh branch: trunk, size: 34909 Added