/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of ext/rtree/geopoly.c

2019-04-13
04:38
Use the 64-bit memory allocator interfaces in extensions, whenever possible. file: [c5911641] check-in: [07ee06fd] user: drh branch: trunk, size: 52226
2019-01-18
19:33
Typecasts added to the GeoPoly extension to avoid harmless UBSAN warnings. file: [061432bd] check-in: [a1f6a093] user: drh branch: trunk, size: 52175
2019-01-03
00:44
Fix the geopoly_svg() function so that it returns NULL when given zero arguments. file: [603ec9b7] check-in: [120cb176] user: drh branch: trunk, size: 51808
2018-11-29
12:00
Fix the name of the trig function approximation in geopoly. No functional changes to the code. file: [d56ff997] check-in: [33576b12] user: drh branch: trunk, size: 51780
2018-11-24
20:44
Fix a bug in the geopoly_ccw() function. Test cases in TH3. file: [6683c994] check-in: [773c5c1d] user: drh branch: trunk, size: 51790
2018-11-05
23:01
Initial code to make shadow tables read-only to ordinary SQL. The now xShadowName method is added to the sqlite3_module object and is used to identify potential shadow tables. The SQLITE_PREPARE_SHADOW argument to sqlite3_prepare_v3() is defined. It is designed to permit writing to shadow tables, but is currently an unused placeholder. file: [38ad90ca] check-in: [31942b3d] user: drh branch: read-only-shadow, size: 51790
2018-10-10
01:01
Fix the build for Macs. file: [08910e5c] check-in: [6a1d937d] user: drh branch: apple-osx, size: 52535
2018-10-08
18:55
Replace the new geopoly_reverse() function with geopoly_ccw(). The geopoly_ccw() function only reverses the vertex order if doing so is necessary to get the correct right-hand winding rule on the polygon. file: [2464b332] check-in: [07506694] user: drh branch: trunk, size: 51742
12:58
Add the geopoly_reverse() function to the GeoPoly extension. file: [9d8411b2] check-in: [690dd18a] user: drh branch: trunk, size: 51165
2018-10-05
15:10
Changes to geopoly to silience false-positive warnings coming out of clang. file: [04db01e2] check-in: [11d9015f] user: drh branch: trunk, size: 50300
2018-09-28
14:01
Add the geopoly_regular(X,Y,R,N) function to the geopoly extension. file: [cdf79727] check-in: [4505bbae] user: drh branch: trunk, size: 49916
13:18
Make most geopoly functions pure. file: [c92eb2c5] check-in: [944e167a] user: drh branch: trunk, size: 48373
00:16
Rig geopoly to use sqlite3AtoF() if it is available, as that routine is much faster than atof(). file: [d8eb3351] check-in: [470c6c07] user: drh branch: trunk, size: 48239
2018-09-27
23:57
Small performance optimization in the JSON parser of Geopoly. file: [596a1eb5] check-in: [fb520e71] user: drh branch: trunk, size: 47999
20:37
Enhance the GeoPOLY extension so that it always stores its polygons in the binary format, which is faster and more compact. file: [470c928b] check-in: [dc35f7b1] user: drh branch: trunk, size: 48010
2018-09-12
01:05
Fix some harmless compiler warnings seen with MSVC. file: [415a8ca5] check-in: [78862252] user: mistachkin branch: trunk, size: 47726
2018-09-06
16:47
Fix harmless compiler warning. file: [447df739] check-in: [88b39c46] user: mistachkin branch: trunk, size: 47664
11:14
Fix excess memory usage in the JSON parser of GEOPOLY. file: [6a5e6879] check-in: [9057e27e] user: drh branch: trunk, size: 47650
02:40
Fix a problem with geopoly trying to update both the _shape and an auxiliary column in the same UPDATE statement. file: [d4cd5840] check-in: [14c95515] user: drh branch: trunk, size: 47650
2018-08-29
20:52
Fixes to the UPDATE logic in Geopoly. file: [8ed95c32] check-in: [7c3cee0a] user: drh branch: trunk, size: 47639
15:50
Add the geopoly_group_bbox() aggregate function to the Geopoly module. file: [0f1fda44] check-in: [2d4debcc] user: drh branch: trunk, size: 47335
2018-08-28
19:23
Stricter enforcement of the JSON and GeoJSON standards in the Geopoly extension. file: [3b27e2e4] check-in: [c0bf3ff3] user: drh branch: trunk, size: 45250
15:51
Fix new issues in the geopoly module discovered by TH3. file: [00e0cc34] check-in: [22fff9af] user: drh branch: trunk, size: 45171
2018-08-27
15:55
Split the three-argument version of geopoly_within() off into a separate function named geopoly_contains_point(). file: [01343c63] check-in: [5a0e1541] user: drh branch: rtree-geopoly, size: 44949
2018-08-25
23:03
Enhance the geopoly virtual table so that it does a better job of optimizing geopoly_within() queries. file: [a265dcbd] check-in: [1f717385] user: drh branch: rtree-geopoly, size: 44840
19:51
Provide the two-argument geopoly_within(P1,P2) routine that determines if polygon P2 is contained within polygon P1. Make this function available to the query planner for optimized rtree lookups. Update the visual01.txt script to verify that the new functionality actually works. file: [b4957182] check-in: [6eb5d09b] user: drh branch: rtree-geopoly, size: 43831
18:57
Fix a harmless compiler warning. file: [9d4f90cd] check-in: [d49be983] user: drh branch: rtree-geopoly, size: 42852
2018-05-29
17:17
Fix a problem in the geopoly json parser associated with spaces before a coordinate number. file: [524f336f] check-in: [9d8d3af8] user: drh branch: rtree-geopoly, size: 42842
2018-05-28
23:59
The geopoly virtual table seems to be working. But only thinly tested so far. file: [95626633] check-in: [4288f1ad] user: drh branch: rtree-geopoly, size: 42842
13:23
Untested incremental check-in. Add the geopoly_xform() function. Complete basic logic for the geopoly virtual table. file: [8c175a1c] check-in: [ed06cc32] user: drh branch: rtree-geopoly, size: 42728
2018-05-26
12:21
Minor correction. file: [66b0192b] check-in: [f20d9a99] user: drh branch: rtree-geopoly, size: 39112
2018-05-25
22:39
Untested incremental check-in. Basic infrastructure for geopoly in place, except for the MATCH operator. file: [e1b19244] check-in: [b2745191] user: drh branch: rtree-geopoly, size: 39112
20:53
Incremental check-in: Progress toward implementing the geopoly vtab. file: [bf7a5fc7] check-in: [9b7d6f98] user: drh branch: rtree-geopoly, size: 39021
19:22
Forward port the geopoly extension functions into the r-tree extension, with the idea of creating a new spatial index based on simply polygons. file: [bde931e2] check-in: [0593aac8] user: drh branch: rtree-geopoly, size: 23673 Added