Documentation Source Text

All files named "pages/rtree.in"
Login

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

History for pages/rtree.in

2023-02-20
00:00
[703d907909] part of check-in [691c346bb0] Merge branch-3.40 changes into trunk. (check-in: [691c346bb0] user: drh branch: trunk, size: 34468)
2023-02-19
23:57
[603d613dd7] part of check-in [58bfae254b] Updates to the text describing when RTree and Geopoly are available in amalgamation builds. (check-in: [58bfae254b] user: drh branch: branch-3.40, size: 34455)
2023-01-01
02:41
[574412a4c0] part of check-in [d18aaf5bcc] Fix several broken links, tag a few as "Obsolete URL", and make urlcheck do a GET if server dislikes HEAD requests. (check-in: [d18aaf5bcc] user: larrybr branch: docgen_tweaks, size: 34340)
2021-09-29
16:36
[10065d07f5] part of check-in [44188b09f0] Minor update to documentation of the custom rtree query API. (check-in: [44188b09f0] user: dan branch: trunk, size: 34328)
2021-09-16
18:05
[ccd25eae59] part of check-in [70af09cf7e] Correct a single requirement in the RTREE documentation. (check-in: [70af09cf7e] user: drh branch: trunk, size: 34261)
2021-09-14
19:55
[eedd725b64] part of check-in [13e88e4693] Typo fix in rtree documentation. (check-in: [13e88e4693] user: drh branch: trunk, size: 34282)
18:27
[46b615f391] part of check-in [c2fe6c397b] RTree documentation fixes. (check-in: [c2fe6c397b] user: drh branch: trunk, size: 34279)
2021-09-13
23:15
[a90b22f825] part of check-in [50c0dfb34c] New requirements marks in rtree. (check-in: [50c0dfb34c] user: drh branch: trunk, size: 34609)
23:06
[cec1f9f0fb] part of check-in [b253cfff16] Continuing improvement to the rtree documentation. (check-in: [b253cfff16] user: drh branch: trunk, size: 34606)
19:22
[39b82561de] part of check-in [8b0f880b08] New sample data for illustrating RTREE concepts. (check-in: [8b0f880b08] user: drh branch: trunk, size: 34634)
14:45
[51a53cc0c8] part of check-in [39d61b00a3] Minor fixes to the rtree documentation. (check-in: [39d61b00a3] user: drh branch: trunk, size: 34063)
2021-09-10
20:38
[fb2ead7b24] part of check-in [9f2bb99cd2] Documentation tweaks for RTREE and STRICT tables. Add many requirements marks to RTREE. (check-in: [9f2bb99cd2] user: drh branch: trunk, size: 33982)
2020-05-18
14:36
[27cee224a2] part of check-in [da19a96616] Fix a minor typo in the rtree documentation. (check-in: [da19a96616] user: drh branch: trunk, size: 33617)
2019-12-24
02:33
[fc90b39294] part of check-in [a8afb2f905] Document the fact that the R-Tree extension is not capable of doing simultaneous reads and writes. (check-in: [a8afb2f905] user: drh branch: trunk, size: 33617)
2019-12-07
12:14
[8e61867635] part of check-in [6958f518ec] Update the rtree documentation to report that type affinity is ignored for auxiliary columns. (check-in: [6958f518ec] user: drh branch: trunk, size: 31167)
2019-12-06
13:08
[2430121dc1] part of check-in [8199b59a39] Enhance the rtree documentation with more detail about the rules for column names and the affinity of columns in the rtree virtual table. (check-in: [8199b59a39] user: drh branch: trunk, size: 31398)
02:35
[792f307dd7] part of check-in [c3ab325994] Enhance the rtree auxiliary column documentation to point out that constraints such as NOT NULL on auxiliary columns are silently ignored. SQLite ticket https://www.sqlite.org/src/info/8bf76328ac940d52 (check-in: [c3ab325994] user: drh branch: trunk, size: 30239)
2018-11-12
15:24
[46fbd3de0c] part of check-in [7b6b7a791b] Enhancements to the documentation regarding security and shadow tables. (check-in: [7b6b7a791b] user: drh branch: trunk, size: 29896)
2018-09-26
19:52
[8c196b482b] part of check-in [3b812913fe] Fix a formatting error in the rtree.html document. (check-in: [3b812913fe] user: drh branch: branch-3.25, size: 29841)
2018-08-27
17:15
[e75c132836] part of check-in [a007133016] First cut at documentation for the Geopoly module. (check-in: [a007133016] user: drh branch: trunk, size: 29848)
2018-05-26
01:59
[aee2c2acd6] part of check-in [b5582fa868] Show the apSqlParam field that was added to the sqlite3_rtree_query_info object in version 3.8.11. (check-in: [b5582fa868] user: drh branch: trunk, size: 30084)
2018-05-25
22:50
[53c482a171] part of check-in [fe9ab1ba5b] Fix a typo in the rtree documentation. (check-in: [fe9ab1ba5b] user: drh branch: trunk, size: 29940)
2018-05-18
18:02
[d40af4bd5d] part of check-in [daa211f9cd] Update docs for the r-tree auxiliary columns. (check-in: [daa211f9cd] user: drh branch: trunk, size: 29939)
2018-01-09
19:47
[34816d2e98] part of check-in [6a23f5f429] More typo fixes. (check-in: [6a23f5f429] user: drh branch: trunk, size: 28349)
19:15
[c44f0d6850] part of check-in [68f1e1944c] Fix typo in the rtreecheck() documentation. (check-in: [68f1e1944c] user: drh branch: trunk, size: 28346)
2018-01-04
19:10
[620f3c026c] part of check-in [2ccafeedbe] Flesh out the description of shadow tables and the rtreecheck() function in the R*Tree documentation. (check-in: [2ccafeedbe] user: drh branch: trunk, size: 28347)
03:33
[bfc7b1c578] part of check-in [a897222d15] Update the change log for the 3.22.0 release. (check-in: [a897222d15] user: drh branch: trunk, size: 25959)
2017-10-24
12:47
[a42391b1e2] part of check-in [c0722042ac] Deprecate the SQLITE_RTREE_INT_ONLY compile-time option. (check-in: [c0722042ac] user: drh branch: trunk, size: 25370)
2017-02-08
18:10
[ff883cf2ea] part of check-in [96728cbc13] Clarification of a sentence in the R-Tree documentation. (check-in: [96728cbc13] user: drh branch: trunk, size: 25759)
2016-09-14
18:40
[9227631dc0] part of check-in [858d993381] Add and use the "[dateof:3.X.Y]" hyperlink target for automatically inserting release dates into the text. (check-in: [858d993381] user: drh branch: trunk, size: 25793)
2016-08-27
23:54
[a9971f1837] part of check-in [a55027b452] Use &lt; instead of < in the r-tree documentation. (check-in: [a55027b452] user: drh branch: trunk, size: 25776)
2016-07-13
14:17
[2cf2af03ba] part of check-in [cb9d13f931] Convert the RTree documentation to fancy-format. (check-in: [cb9d13f931] user: drh branch: trunk, size: 25734)
2015-10-03
12:21
[8ac9416192] part of check-in [56eab0136c] Update rtree documentation to describe the way attempts to insert non-integer primary key values or non-numeric dimensions into an rtree table are handled. (check-in: [56eab0136c] user: dan branch: trunk, size: 25815)
2014-05-27
10:31
[1b8fcf3a9f] part of check-in [84efe9e646] Fix documentation typos reported on the mailing list. (check-in: [84efe9e646] user: drh branch: trunk, size: 25460)
2014-05-01
14:44
[4e0ac82010] part of check-in [bd0fe1c3e1] Updates to the R*Tree documentation. (check-in: [bd0fe1c3e1] user: drh branch: trunk, size: 25456)
2014-04-29
15:08
[07e99fd274] part of check-in [89557fb903] Added documentation for the sqlite3_rtree_query_callback() enhancement. (check-in: [89557fb903] user: drh branch: trunk, size: 24563)
2013-10-16
23:58
[c3230e0acf] part of check-in [df95e4e1ec] Fix typos in documentation. (check-in: [df95e4e1ec] user: drh branch: trunk, size: 19614)
2013-08-19
14:26
[0a23dc8322] part of check-in [9ceaba9f7f] Fix a typo in the RTREE documentation. (check-in: [9ceaba9f7f] user: drh branch: trunk, size: 19615)
2013-04-17
13:35
[4c61a9022e] part of check-in [600d427573] Fix a coordinate error in the RTree documentation. (check-in: [600d427573] user: drh branch: trunk, size: 19615)
2012-12-12
14:45
[8029b9e6d4] part of check-in [3af544a1b7] Fix mistaken latitude values in the examples in the RTree documentation. (check-in: [3af544a1b7] user: drh branch: trunk, size: 19527)
2012-05-29
01:06
[6a00184ecd] part of check-in [1f473ab6ac] Add a brief note to the R-Tree documentation to encourage applications to round contained-within query boxes outward slightly to account for round-off error in 64-to-32-bit floating point conversions. (check-in: [1f473ab6ac] user: drh branch: trunk, size: 19488)
2012-04-03
02:04
[221f6b9d05] part of check-in [7404688990] Documentation on how to configure R*Tree for integer-only operation. (check-in: [7404688990] user: drh branch: trunk, size: 18215)
2011-06-20
23:51
[1b83041ce5] part of check-in [8f9d1225b6] More typo fixes. (check-in: [8f9d1225b6] user: drh branch: trunk, size: 17213)
2010-09-01
11:49
[5fae6efc6f] part of check-in [ddcf89bab0] New hyperlinks to FTS and RTree. New requirement that automatically generated rowids must be positive. (check-in: [ddcf89bab0] user: drh branch: trunk, size: 17216)
2010-08-31
16:14
[0cb71a012c] part of check-in [c96a663926] Add a fragment for the custom r-tree query section of the r-tree docs. Add the addition of custom r-tree query to the "changes" page. (check-in: [c96a663926] user: drh branch: trunk, size: 17206)
15:03
[0937ec0035] part of check-in [ed402895f8] Add a link to example geometry callback code to rtree.in. (check-in: [ed402895f8] user: dan branch: trunk, size: 17147)
11:01
[0d422ed004] part of check-in [7e421e2c51] Add documentation for custom r-tree geometry callbacks to rtree.in (check-in: [7e421e2c51] user: dan branch: trunk, size: 16974)
2010-08-30
00:13
[9fba6fcc13] part of check-in [33d6d684cb] Updates to the queryplanner.html document. (check-in: [33d6d684cb] user: drh branch: trunk, size: 10908)
2009-11-02
15:50
[f561a2db9f] part of check-in [ec4a51db99] Added the website keyword index. (check-in: [ec4a51db99] user: drh branch: trunk, size: 10837)
2009-10-26
14:52
[94744e35c8] part of check-in [4fb1b232ad] Add a "&#x27FE" mark after all hyperlinks to external websites. (check-in: [4fb1b232ad] user: drh branch: trunk, size: 10816)
2009-03-17
11:07
[bb79252789] part of check-in [61871a4c17] Fix typo in the rtree.html webpage. CVSTrac ticket #3730. (check-in: [61871a4c17] user: drh branch: trunk, size: 10836)
2008-10-09
00:41
[1c069dd50d] part of check-in [9bf9094c62] Fix a typo in the rtree documentation. (check-in: [9bf9094c62] user: drh branch: trunk, size: 10837)
2008-07-16
18:46
[8ff4d88c3c] part of check-in [161e589f81] Minor spelling corrections, changed i tags to em and b tags to strong, added missing 35to36 link to docindex, moved migration doc together (check-in: [161e589f81] user: mihailim branch: trunk, size: 10837)
2008-07-13
03:44
[0e8a00e4b4] part of check-in [9ab3251ed2] Fix typos in new documents. (check-in: [9ab3251ed2] user: drh branch: trunk, size: 10780)
2008-06-27
18:56
[0a5c5c2432] part of check-in [010e1a52d7] Additional work on the R-Tree documentation. (check-in: [010e1a52d7] user: drh branch: trunk, size: 10772)
17:20
Added: [ed20fd8ad4] part of check-in [a7b39daebb] Initial check-in of the rtree documentation. Very incomplete. (check-in: [a7b39daebb] user: drh branch: trunk, size: 6791)