Re: [sqlite] compressed sqlite3 database file?

On Thu, 11 Apr 2019 18:45:01 -0600 Warren Young wrote: > Sure, but what *is* on the disk after a crash is always consistent > with ZFS, so any decent database engine can recover. It's been some years, but I saw a presentation about running Postgres on ZFS. Every "victory" was a way to compensat

Re: [sqlite] Problem with SELECT by rowid after INSERT

On Fri, 12 Apr 2019 11:40:13 -0400 Jim Dossey wrote: > CREATE TABLE "sessiond" ( > "journal" VARCHAR(4) DEFAULT '' NOT NULL, > "session" VARCHAR(16) DEFAULT '' NOT NULL, > "pid" INTEGER DEFAULT 0 NOT NULL, > rowid INTEGER PRIMARY KEY > ); Although it has nothing to do with the problem you posed,

Re: [sqlite] Help with sqlite3_value_text

On Sat, Apr 13, 2019 at 12:04 PM x wrote: > This seems to work OK as a sqlite function. > > > > // assume values[0] & [1] are supplied and not null > > // find Count of values[1] in values[0] > > > > char *c = (char *)sqlite3_value_text(values[0]); > > char *Sep = (char *)sqlite3_value_text(value

Re: [sqlite] Help with sqlite3_value_text

This seems to work OK as a sqlite function. // assume values[0] & [1] are supplied and not null // find Count of values[1] in values[0] char *c = (char *)sqlite3_value_text(values[0]); char *Sep = (char *)sqlite3_value_text(values[1]); int Byte1, Count=0, NrBytes, NrSepBytes = strlen(Sep);

Re: [sqlite] Help with sqlite3_value_text

Thanks for all the help. Things are much clearer now. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.28.0 beta 1

I would really support this other approach. It seems more extensible and eventually would address on of my pain points in SQLite, not knowing what type of statement is being executed. -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users