Re: [sqlite] minor nit pick of "When To Use"

On November 11, 2018 8:04:51 AM EST, Dennis Clarke wrote: > >this : https://www.sqlite.org/whentouse.html > >I know this is really a nit pick but I see that the OpenGroup folks >have >published a new shiney UNIX standard called SUSv4 or Single UNIX >Specification version 4 or even ye "The Open

Re: [sqlite] minor nit pick of "When To Use"

On 11/11/18 8:38 AM, Dennis Clarke wrote: On 11/11/18 8:25 AM, J. King wrote: On November 11, 2018 8:04:51 AM EST, Dennis Clarke wrote: this : https://www.sqlite.org/whentouse.html he.net is Hurricane Electric, an Internet backbone. An IX ? https://www.peeringdb.com/asn/6939 in a big

[sqlite] minor nit pick of "When To Use"

this : https://www.sqlite.org/whentouse.html I know this is really a nit pick but I see that the OpenGroup folks have published a new shiney UNIX standard called SUSv4 or Single UNIX Specification version 4 or even ye "The Open Group Base Specifications Issue 7, 2018 edition IEEE Std

Re: [sqlite] minor nit pick of "When To Use"

On 11/11/18 8:25 AM, J. King wrote: On November 11, 2018 8:04:51 AM EST, Dennis Clarke wrote: this : https://www.sqlite.org/whentouse.html he.net is Hurricane Electric, an Internet backbone. An IX ? Ah yes .. those guys ... been around forever. I should just "know that" but forgot.

Re: [sqlite] Broken Foreign key

parent keys MUST have unique indexes. Add the missing indexes. child keys SHOULD be indexed: UNIQUE indexes for 1:1 relationships, non-unique indexes for 1:N relationships put unique indexes on your parents and all will work just fine. --- The fact that there's a Highway to Hell but only a

[sqlite] Broken Foreign key

https://d3x0r.org:444/temporary/broken_fk.tgz (30k) this has a .option.db in it and a test.sh. It turns on foreign_keys, selects from the name_id that it says is a forieng key violation, and inserts into option4_map. option4_map has option_id(PK),parent_id(FK option_id),name_id(FK) option4_name

Re: [sqlite] Out of bounds memory reads triggered by sqlite tests (testfixture/fuzzcheck)

It seems the mailing list strips out the attachments. Pasting the content of the ASAN errors in here: --- ==9547==ERROR: AddressSanitizer: global-buffer-overflow on address 0x007fe73e at pc 0x4ecfea bp 0x7ffc7f568090 sp 0x7ffc7f568080 READ of size 2

[sqlite] Out of bounds memory reads triggered by sqlite tests (testfixture/fuzzcheck)

Hi, When compiling sqlite with address sanitizer (-fsanitize=address in CFLAGS/LDFLAGS) and running the tests I get two memory safety violations. I've attached the ASAN error messages / stack traces. Both are out of bounds memory reads, in testfixture and fuzzcheck. I strongly recommend that

Re: [sqlite] HELP!

> On Nov 11, 2018, at 1:24 AM, Clemens Ladisch wrote: > > It's not; SQLite is file based. The only way to share this would be to > make a file share in the company-wide network, i.e., to make the file > \\COMPANYSERVER\SomeShare\MyLittleDB.sqlite directly accessible from > everywhere. (This

Re: [sqlite] minor nit pick of "When To Use"

> On Nov 11, 2018, at 7:38 AM, Dennis Clarke wrote: > > On 11/11/18 8:25 AM, J. King wrote: >> On November 11, 2018 8:04:51 AM EST, Dennis Clarke >> wrote: >>> >>> this : https://www.sqlite.org/whentouse.html > >> he.net is Hurricane Electric, an Internet backbone. > > An IX ? HE is not