Documentation Source Text

File History
Login

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

History of pages/fts3.in

2018-11-12
15:24
Enhancements to the documentation regarding security and shadow tables. file: [1ea1c5a6fd] check-in: [7b6b7a791b] user: drh branch: trunk, size: 142042
2018-07-02
08:00
Add a sentence to the FTS3/4 documentation to make it clear that only columns that are part of the FTS3/4 table declaration exist, even if an external content table with more columns is in use. file: [134696837f] check-in: [ea0f0b4c4a] user: dan branch: trunk, size: 142058
2018-06-08
13:21
Use https for all internal hyperlinks. file: [af9deacb24] check-in: [59e5f9e3da] user: drh branch: branch-3.24-https, size: 141864
2017-10-06
20:00
Fix minor problems in fts3.html. file: [683671c28e] check-in: [47132abeb4] user: dan branch: trunk, size: 141863
17:54
Improve the error handling in the example rank function in fts3.html. file: [e896a4a28d] check-in: [a95efd5bb8] user: dan branch: trunk, size: 141858
2017-01-29
11:39
Fix an obsolete example in the FTS3 documentation. file: [a07dda6ac8] check-in: [c90c7a1015] user: drh branch: trunk, size: 141063
2016-11-25
21:47
Fix typo in the FTS3/4 documentation. file: [39c12f03b9] check-in: [71a72a66ff] user: drh branch: trunk, size: 141062
2016-09-14
18:40
Add and use the "[dateof:3.X.Y]" hyperlink target for automatically inserting release dates into the text. file: [d50f8075aa] check-in: [858d993381] user: drh branch: trunk, size: 141063
2016-08-25
17:29
Change the way sub-sections are selected by the search script. file: [b049283d13] check-in: [c7628dcb37] user: dan branch: experimental, size: 140939
2016-08-10
12:01
Fix typo in FTS3 docs. file: [87c7c3578d] check-in: [58a14bf9e1] user: drh branch: trunk, size: 140927
2016-07-28
16:04
Fix a typo in a snippet() example in the FTS3 documentation. file: [1ad61aa51b] check-in: [d2cba16a38] user: drh branch: trunk, size: 140921
2016-03-22
17:23
Merge fixes off of the 3.11 branch. file: [d57f469894] check-in: [ad0172e592] user: drh branch: trunk, size: 140919
2016-03-21
20:02
Fix the description of the case folding performed by the unicode61 tokenizer in FTS3. file: [0fc647fcec] check-in: [37a01760c6] user: drh branch: branch-3.11, size: 140815
2016-02-26
15:54
Updated documentation related to fts3_tokenizer() and the new SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER. file: [7186df65e8] check-in: [1483127f32] user: drh branch: trunk, size: 140917
2016-02-09
14:43
Update the 3.11.0 change log. file: [cda72d764e] check-in: [0dc9452382] user: drh branch: trunk, size: 140813
2016-02-08
19:55
Update fts3 documentation to mention that fts3_tokenzer(x,y) is only available if SQLITE_ENABLE_FTS3_TOKENIZER is defined at compile time. file: [864d859077] check-in: [27ee6d0233] user: dan branch: trunk, size: 140558
2015-12-30
15:10
Fix a problem in an SQL example in fts3.html. file: [b16ddadefa] check-in: [4648330f75] user: dan branch: trunk, size: 140115
2015-10-10
09:36
Add a new example for external-content tables to fts3.html. file: [d33f12d854] check-in: [e68ac068e8] user: dan branch: trunk, size: 140118
2015-09-02
11:30
Add missing parenthesis to an expression in fts3.html. file: [bb9df9f0b1] check-in: [d366268bab] user: dan branch: trunk, size: 139062
2015-08-01
18:13
Update rbu.in with more details on using RBU with FTS tables and the sqldiff tool. file: [2175e32626] check-in: [95c97dad08] user: dan branch: trunk, size: 139058
2015-06-17
16:05
Further tweaks to the matchinfo() documentation. file: [2c09533166] check-in: [d0b390051e] user: drh branch: trunk, size: 138986
15:59
Update the change log. Better fragments for matchinfo() flags. file: [91658c267b] check-in: [dcccfa67e1] user: drh branch: trunk, size: 139019
2015-05-11
19:12
Update fts3.html with a description of the matchinfo 'b' option. file: [1198f0846e] check-in: [2dad241898] user: dan branch: trunk, size: 138889
2015-05-07
11:32
Fix typos. file: [acafd318ea] check-in: [73e4989d49] user: drh branch: trunk, size: 137317
2015-05-05
19:59
Fix a typo in the documentation for fts3 matchinfo option 'y'. file: [2ead832db1] check-in: [9dff844fd9] user: dan branch: trunk, size: 137318
2015-05-04
12:16
Add the matchinfo(..,'y') option addition to the change log. file: [e36f15af26] check-in: [0cd02758ec] user: drh branch: trunk, size: 137328
2015-05-02
09:40
Update fts3 documentation with docs for the matchinfo 'y' flag. file: [fee1d3a662] check-in: [e6b9763fab] user: dan branch: trunk, size: 137296
2014-08-14
13:06
Fix typos. file: [e9b4598acd] check-in: [09088d9a21] user: drh branch: trunk, size: 135544
2014-07-07
13:13
Clarification of the automerge documentation in FTS3. file: [f73deeab4c] check-in: [a8e5cf50a0] user: drh branch: trunk, size: 135544
10:39
Add documentation for the "^" qualifier to fts3.html. file: [c1cf272ffb] check-in: [6a74a13c86] user: dan branch: trunk, size: 135505
2014-06-27
20:49
Clarifications to the FTS4 languageid documentation. file: [7e18b7b3d9] check-in: [0a22af73df] user: drh branch: trunk, size: 134898
2014-05-27
10:31
Fix documentation typos reported on the mailing list. file: [d032299aab] check-in: [84efe9e646] user: drh branch: trunk, size: 134747
2014-05-16
11:28
Update fts3.html for recent changes to FTS. file: [3ea2465811] check-in: [ae994ce63a] user: dan branch: trunk, size: 134819
2014-01-29
17:47
Update News and the change log. Bring the release date forward to 2014-02-03. Fix typos. Move older news entries out to oldnews.in. file: [4749bd347b] check-in: [ea6e1d11de] user: drh branch: trunk, size: 132998
2013-10-16
23:58
Fix typos in documentation. file: [813afa7279] check-in: [df95e4e1ec] user: drh branch: trunk, size: 132997
2013-10-15
19:08
Added the fts4aux languageid column. Fix typos in famous.html file: [020c503ea4] check-in: [cd0e9d17ed] user: drh branch: trunk, size: 132998
2013-09-18
11:31
Add examples of creating fts3tokenize tables that use tokenizers declared with multiple arguments to fts3.in. file: [9b29c9d8f3] check-in: [23c364befb] user: dan branch: trunk, size: 132443
2013-09-13
14:52
Add documentation for the fts4 unicode61 "tokenchars" and "separators" options. file: [f4ff1b8046] check-in: [00c7833d65] user: dan branch: trunk, size: 131803
2013-08-31
14:32
Add documentation for the fts4 unicode61 tokenizer option "remove_diacritics=0". file: [8ea77ec102] check-in: [f5d1d7106f] user: dan branch: trunk, size: 129566
2013-07-12
20:03
Add the isolation.in document. Other changes for 3.8.0. file: [98ece71c67] check-in: [2eb277d7fc] user: drh branch: trunk, size: 128866
2013-07-01
20:52
Fix a typo in an example in the fts4aux virtual table documentation. file: [b29c59fd19] check-in: [6743aed594] user: drh branch: trunk, size: 128776
2013-06-21
19:06
Add documentation for the fts4 notindexed option. file: [bc69ab5c71] check-in: [968222aa1c] user: dan branch: trunk, size: 128776
2013-04-26
14:47
Fix typos and add clarification in the fts3tokenize documentation. file: [dea32d4de1] check-in: [aee1b746ba] user: drh branch: trunk, size: 127439
14:38
Add documentation for the fts3tokenize table. file: [5a73a5fe9f] check-in: [a6e655aa62] user: drh branch: trunk, size: 127142
2013-04-25
11:35
Update the FTS3 documentation to make it clearer that external content tables must be in the same database as the FTS virtual table. file: [a7303adeea] check-in: [35441559aa] user: drh branch: trunk, size: 125268
2013-04-19
14:32
Replace some instances of < and > in the text of fts3.html with < and >. file: [fa44cc6375] check-in: [2966921d57] user: dan branch: trunk, size: 124934
2013-04-15
13:16
Update the FTS4 document to describe the two-argument form of fts4aux. file: [e8d00a624a] check-in: [ba14e1152f] user: drh branch: trunk, size: 124910
2012-12-11
19:11
Documentation typos fixed. file: [4866c4cc62] check-in: [5d8312cd94] user: drh branch: trunk, size: 124288
2012-08-22
22:50
Improved names for triggers in the FTS documentation. file: [b730c5466d] check-in: [851c7d53b7] user: drh branch: trunk, size: 124293
2012-05-28
17:05
Documentation on the unicode61 tokenizer and the ability to use shared-cache with in-memory databases. file: [40b26c21ab] check-in: [2ed85cc08c] user: drh branch: trunk, size: 124293
2012-05-15
16:46
Fix typos in FTS3 documentation. file: [d83a4496da] check-in: [89c68b1e44] user: drh branch: trunk, size: 123788
2012-04-02
15:00
Enforce the 80-character line limit on the new documentation source text for FTS4 commands. file: [459c44e7d6] check-in: [f1d54965d0] user: drh branch: trunk, size: 123781
14:47
Updates to the FTS4 document to describe recent merge=X,Y, automerge=B, and integrity-check commands. Updates to the change log for the same and for other recent changes. file: [de91dc8c9b] check-in: [2c33993bdc] user: drh branch: trunk, size: 123568
2012-03-06
13:11
Tweaks to the FTS4 documentation. Add Bentley to the sponsor list on the front page. file: [852a60ee89] check-in: [39b1d19256] user: drh branch: trunk, size: 116308
2012-03-05
19:40
Fix typos in the FTS4 languageid option documentation. Add entries to the 3.7.11 change log. file: [45d5d7f32b] check-in: [eb26f05574] user: drh branch: trunk, size: 116305
19:14
Documentation for the content= and langaugeid= options for FTS4. file: [39c29217ac] check-in: [16b58c9eb4] user: drh branch: trunk, size: 116305
2012-02-27
07:06
Fix a bug in the description of the 'simple' FTS tokenizer. Underscores (codepoint 95) are divider characters not token characters. file: [cfce6d2753] check-in: [73a0dac584] user: dan branch: trunk, size: 105211
2012-02-05
05:19
Fix an error in the FTS matchinfo documentation. file: [32b3945f78] check-in: [4a7f0dacc7] user: dan branch: trunk, size: 105231
2012-01-09
13:40
Add a note about data types and the compress/uncompress functions to the FTS documentation. file: [e9b18521b8] check-in: [8fadbd41ce] user: dan branch: trunk, size: 105231
2011-06-20
21:48
Documentation typos. file: [785c26b723] check-in: [b503d1f516] user: drh branch: trunk, size: 104656
19:49
Updates in preparation for the 3.7.7 release. file: [a89233647d] check-in: [be9ae0b604] user: drh branch: trunk, size: 104663
2011-06-14
19:38
Update fts3.html with the new "order" and "prefix" options. file: [005ee39344] check-in: [074255f9eb] user: dan branch: trunk, size: 104496
2011-04-13
18:37
Update documentation for the 3.7.6.1 patch release. Fix a typos in the FTS4 documentation. file: [7efc438f82] check-in: [0a742ee49a] user: drh branch: trunk, size: 101687
2011-04-05
14:31
Updates to the ANALYZE and FTS4 documentation to describe the latest changes. Updates to the changes.html file as we move closer to the 3.7.6 release. Added amalgamation32k to the download.html page. file: [dcf3469244] check-in: [4fb953fec0] user: drh branch: trunk, size: 101699
2011-03-16
07:03
Fix a typo in fts3.in. file: [6feb93a720] check-in: [c605c75c11] user: dan branch: trunk, size: 101633
2011-03-07
13:40
Fix typos in Appendix A of fts3.html. file: [07d09c0293] check-in: [b3c69199b5] user: dan branch: trunk, size: 101632
2011-02-05
17:00
Update the description of fts4aux in fts3.in to account for recent changes. file: [a06879118c] check-in: [8e18201f14] user: dan branch: trunk, size: 101628
2011-02-03
19:06
Update fts3.html to describe the fts4aux module and the fts4 compress/uncompress options. file: [b640978beb] check-in: [ead2cc60ef] user: dan branch: trunk, size: 100058
2010-12-29
04:52
Fix the order of the LIMIT and OFFSET clauses in some examples on fts3.html (LIMIT comes before OFFSET). file: [1f7f5abd31] check-in: [d3fc079ba8] user: dan branch: trunk, size: 93984
2010-11-27
15:55
Add some extra details to fts3.in. file: [da39893139] check-in: [5ab479563e] user: dan branch: trunk, size: 93984
11:46
Fix typos in fts3.in. file: [4802103463] check-in: [bead827e51] user: dan branch: trunk, size: 89934
2010-11-26
21:06
Updates to the FTS3 documentation to include additional discussion and links to FTS4 concepts. file: [c9e02e71a0] check-in: [b8865a0011] user: drh branch: trunk, size: 90006
18:23
Update documentation for fts3 matchinfo function. file: [dd27e3373b] check-in: [4deb70dd76] user: dan branch: trunk, size: 87694
2010-11-15
13:15
Fix a typo from the fts3.html document. file: [8e57b2c8ae] check-in: [c547f4b6c1] user: drh branch: trunk, size: 84562
2010-09-02
04:20
More typo fixes. file: [ec341b6af8] check-in: [db66d3a1d4] user: shaneh branch: trunk, size: 84566
2010-09-01
11:49
New hyperlinks to FTS and RTree. New requirement that automatically generated rowids must be positive. file: [c6c2750001] check-in: [ddcf89bab0] user: drh branch: trunk, size: 84573
2010-08-31
16:49
Fix typo in fts3.html pointed out on the mailing list. file: [e695cdc553] check-in: [8873618014] user: dan branch: trunk, size: 84554
2010-08-30
15:10
More typo and spelling fixes. file: [4d1039a7fc] check-in: [d7a2085524] user: shaneh branch: trunk, size: 84554
2010-08-09
15:45
Fix a bunch of documentation typos reported on the mailing list. file: [b6b3c02cbf] check-in: [d9e242f92a] user: drh branch: trunk, size: 84550
2010-06-08
14:21
Fix problem in fts3.html - snippet() takes between 1 and 6 arguments, not between 1 and 4. file: [731ffcfa2b] check-in: [1bbbb8afd0] user: dan branch: trunk, size: 84542
2010-02-09
23:25
Add an evidence mark to a statement in fts3.in. Add an evidence mark to a statement in fts3.in. file: [4a5960d3e9] check-in: [58746651dd] user: dan branch: trunk, size: 84543
2010-02-01
16:18
Fix a typo in the FTS3 documentation. file: [d62dad43b5] check-in: [f0a07e571f] user: drh branch: trunk, size: 84542
2010-01-20
18:32
Change the way the fts3.html document is generated to be more similar to most of the other documents. file: [8e3e263fba] check-in: [e3ae335670] user: dan branch: trunk, size: 84541
05:52
Fix typo in fts3.html. file: [fd6dbd5656] check-in: [897b36953b] user: dan branch: trunk, size: 83771
2010-01-18
14:12
Add a section to fts3.in to explain how to use the matchinfo() function efficiently. file: [818449fad3] check-in: [0917dec067] user: dan branch: trunk, size: 83771
2010-01-14
11:43
Fix an error in the matchinfo example in fts3.html. file: [8a53f90dce] check-in: [ceff4c1d37] user: dan branch: trunk, size: 71100
2010-01-13
18:09
Add a description of matchinfo() and update the description of snippet() in fts3.html. file: [29e8c621cc] check-in: [c31f4ab8b8] user: dan branch: trunk, size: 71100
2010-01-09
07:34
Fix a couple of snippet related examples in fts3.html. file: [27d0a9625b] check-in: [d8f53c98a9] user: dan branch: trunk, size: 62960
2009-12-11
14:46
Change fts3.html to present the new INSERT syntax used to optimize the full-text index. file: [a562892db5] check-in: [f6c99b3cc3] user: dan branch: trunk, size: 62933
2009-12-05
19:07
Fix a minor typo in fts3.html. file: [24ae2a096b] check-in: [a92e1357cb] user: dan branch: trunk, size: 62981
2009-12-04
07:50
Clarify that the values stored in the rowid of an FTS3 table do not change when the database is VACUUMed. file: [371ef6a555] check-in: [39d5f660c5] user: dan branch: trunk, size: 62981
2009-12-03
18:14
Change 3.6.21 release date. Fix typos reported by internet reviewers. file: [43c7713f72] check-in: [c922c8ef50] user: drh branch: trunk, size: 62871
2009-12-01
15:30
Fix two more typos in examples in fts3.in. file: [0068b01b80] check-in: [d075300786] user: dan branch: trunk, size: 62893
14:27
Fix a couple of bugs in the examples in fts3.in. file: [bc9cbe4ede] check-in: [9bd28d637b] user: dan branch: trunk, size: 62894
2009-11-30
15:37
Clarify authorship of the original FTS3 code in fts3.html. file: [bc1b874775] check-in: [daf96c0053] user: dan branch: trunk, size: 62911
15:27
Update indicative performance numbers for populating a large database in fts3.html. file: [251ff90f94] check-in: [54090fd49f] user: dan branch: trunk, size: 62890
11:52
Fix some problems with fts3.html. file: [af9e9dfd21] check-in: [0b949f6763] user: dan branch: trunk, size: 62975
08:41
Add text to fts3.html describing the snippet and offsets functions. file: [2ed30110a1] check-in: [d91a4c7249] user: dan branch: trunk, size: 60222
2009-11-28
19:17
Add a description of tokenizers to fts3.in. file: [ed32c844d9] check-in: [f1940858bf] user: dan branch: trunk, size: 52518
2009-11-27
17:03
Change things so that fts3.html and foreignkeys.html do not use an external stylesheet. file: [7c99a73275] check-in: [6a28d79533] user: dan branch: trunk, size: 44252
2009-11-26
18:43
Expand on the description of fts3 query syntax in fts3.in. file: [1999c8ed8a] check-in: [3031615e43] user: dan branch: trunk, size: 44112
2009-11-25
18:44
Describe fts3 query syntax. file: [a1304595ea] check-in: [6f60a71678] user: dan branch: trunk, size: 37231
2009-11-24
18:45
Add some text to fts3.html. file: [e42ea2fb49] check-in: [8d529e9fc1] user: dan branch: trunk, size: 30799
2009-11-23
13:57
Begin making changes in preparation for 3.6.21. file: [4bda585fb7] check-in: [442afaf708] user: drh branch: trunk, size: 16318
03:59
Add instructions for building an FTS3-enabled SQLite to fts3.html. file: [dec0ccb040] check-in: [cf42334a68] user: dan branch: trunk, size: 16314
2009-11-17
19:06
Improvements to the description of data structures in fts3.html. file: [d0c4a758d5] check-in: [146d003fc9] user: dan branch: trunk, size: 14921
2009-11-15
03:59
Add start of html fts3 documentation. This is very much a work in progress. file: [22d0d0d323] check-in: [8c18d00b27] user: dan branch: trunk, size: 9377 Added