Re: [sqlite] geopoly - rules re data entry

Thanks for the clarification and news of the up-coming additions. This issue will not impede me for the moment. Oh, and by the way - the pragma compile_options sql command is still not including geopoly in the return list. (using 3.25.3) Graham On 18-11-2018 3:57 pm, Richard Hipp wrote: On

Re: [sqlite] Library Files on my Computer

Giovanni Giusti wrote: > they are offsite What do you mean with that? Do you get an error message when you try to access them? > and end in .sqlite-wal If there is no corresponding .sqlite file (without the "-wal"), then those files are not actual SQLite database files. Regards, Clemens

[sqlite] UUID extension

Hi folks, I've written an extension for generating RFC 4122 UUIDs: https://github.com/benwebber/sqlite3-uuid The API is inspired by PostgreSQL's uuid-ossp extension and Python's uuid module. It generates TEXT UUIDs by default, but there's a helper function to convert them to BLOBs for more

Re: [sqlite] DELETE does not accept AS alias despite documentation

Ah yes, you're right, it works in later versions. I was on 3.12.1 and then found stackoverflow posts saying it didn't work. Sorry and please disregard. -Jake Date: Thu, 15 Nov 2018 20:15:11 -0800 From: Shawn Wagner To: SQLite mailing list Subject: Re: [sqlite] DELETE does not accept AS alias

[sqlite] Library Files on my Computer

Hello, My name is Gio and someone has made themselves quite at home inside my computer. They've made changes to files and documents that I didn't even know you can change. I've dug fairly deep and found that some really important library files are being saved in files that cannot be opened due

[sqlite] geopoly - rules re data entry

Hi, The documentation for the geopoly module states that the vertices must be defined in a counter-clockwise order so that the interior of the polygon is on the left of the element as it is drawn. However, I have discovered that a polygon transformed with geopoly_xform can result in a polygon

Re: [sqlite] geopoly - rules re data entry

On 11/17/18 8:37 PM, Graham Hardman wrote: > Hi, > > The documentation for the geopoly module states that the vertices must > be defined in a counter-clockwise order so that the interior of the > polygon is on the left of the element as it is drawn. > > However, I have discovered that a polygon

Re: [sqlite] geopoly - rules re data entry

On 11/17/18, Richard Damon wrote: > On 11/17/18 8:37 PM, Graham Hardman wrote: >> >> My question then is, is it really necessary to ensure a counterclockwise >> order when a polygon shape is entered for the first time in the table. >> > My guess would be that SOME operations will need the