> I have a concern, because this turns automatic checkpointing into a
mortal danger for all snapshots.
This sentence may be false. Automatic snapshots are PASSIVE, and I'm not
sure passive checkpoints invalidate snapshots returned by
sqlite3_snapshot_get().
But i'm not sure, and I would
On Thu, 26 Sep 2019 at 13:01, Jens Alfke wrote:
>
> > On Sep 24, 2019, at 3:48 PM, Keith Medcalf wrote:
> >
> > There are not, to my knowledge, any client/server database systems that
> will work properly if the database resides on a network filesystem (meaning
> remote multi-access). The
Hello,
I have noticed that security CVE
(https://nvd.nist.gov/vuln/detail/CVE-2019-16168) has been submitted on SQLite.
As far as I can see the patch was submitted to the trunk.
Will CVE patch be included in the 3.30.0?
Regards,
Alex
-Original Message-
From: sqlite-users On Behalf Of
On 26/9/19 11:51 PM, Keith Medcalf wrote:
> So, when you ask for time(current_time, 'localtime') you are saying to
> get the current utc datetime, discard the date part, then assume that
> the date part is 2000-01-01 with that time, then compute the
> "localtime" for that UTC time, and then
"Still says" due to 3_30_0.html is in a draft, I would assume.
On Thu, Sep 26, 2019 at 3:31 PM Olivier Mascia wrote:
> > Le 26 sept. 2019 à 20:26, Richard Hipp a écrit :
> >
> > Our plan is to release SQLite version 3.30.0 in about two weeks - on
> > or about 2019-10-10. Please review the
> Le 26 sept. 2019 à 20:26, Richard Hipp a écrit :
>
> Our plan is to release SQLite version 3.30.0 in about two weeks - on
> or about 2019-10-10. Please review the change log
>
>https://www.sqlite.org/draft/releaselog/3_30_0.html
>
> And perhaps download, build, and test the latest
Looks good.
One request that popped to mind while looking at this: Would you expand the
documentation on the index_info and index_xinfo pragmas to include what they
return when run on an expression index?
-Original Message-
From: sqlite-users On Behalf Of
Richard Hipp
Sent:
Our plan is to release SQLite version 3.30.0 in about two weeks - on
or about 2019-10-10. Please review the change log
https://www.sqlite.org/draft/releaselog/3_30_0.html
And perhaps download, build, and test the latest snapshot. Please let
us know if you encounter any problems or
Hello,
The documentation for sqlite3_snapshot_open() [1] says:
> A call to sqlite3_snapshot_open() will fail to open if the specified
snapshot has been overwritten by a checkpoint.
And indeed I am able to create a snapshot with sqlite3_snapshot_get() [2],
then run checkpoints with
On Thursday, 26 September, 2019 05:33, PALAMARA Alain
wrote:
>I'm quite new to sqlite and I'm surprised about the result I got from
>executing time(current_time, 'localtime') function.
>I use the sqlite3 command line (version 3.29.0) on Windows 7 and I tried
>to get my local time using this
You can't have a variable inside a pattern. Use like '%' || ? || '%'
-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von Daniel Odom
Gesendet: Donnerstag, 26. September 2019 15:26
An: sqlite-users@mailinglists.sqlite.org
I am just now getting around to learning Swift and XCode. I am having a
problem with 'LIKE'. When I do this:
let queryString = "select name, phone, street, city, state from phone
where name like '%?%'"
And then this: if sqlite3_bind_text(stmt, 1, name, -1, SQLITE_TRANSIENT)
!= SQLITE_OK {do
Hello,
I'm quite new to sqlite and I'm surprised about the result I got from executing
time(current_time, 'localtime') function.
I use the sqlite3 command line (version 3.29.0) on Windows 7 and I tried to get
my local time using this simple
statement:
select time(current_time,
Hi,
I have a crash at sqlite (encryption extension). Here is code:
sequence_t SQLiteDataFile::lastSequence(const string& keyStoreName)
const {
sequence_t seq = 0;
compile(_getLastSeqStmt, "SELECT lastSeq FROM kvmeta WHERE name=?");
UsingStatement u(_getLastSeqStmt);
14 matches
Mail list logo