I fear the OP is referring to DB Browser for SQLite. This recently
released v3.11.1.
@desarrollo - I would suggest contacting the DB Browser for SQLite
developers at this address:
https://github.com/sqlitebrowser/sqlitebrowser/issues
Thanks,
Chris
On Wed, Mar 6, 2019 at 3:47 PM Hick Gunter wr
On Tue, 05 Mar 2019 13:58:06 -0700
"Keith Medcalf" wrote:
> >The query requests no such thing. SQL makes no request or
> >suggestion for how to execute a query. It simply describes a result.
> >It's up to the implementation to determine how to produce that
> >result.
>
> You are, of course, co
The current version of SQLite itself is 3.27.2, Version 3.11.1 would be from
2016 and does not have window functions (introduced in Version 3.25)
Please check which sqlite binding product you are using and see if it has a
support page. If a query works from the sqlite shell but not from the prog
Good morning,
I have a project in c# which I integrate with SQLite and I have very good
performance at all, I've had no troubles, but yesterday I updated to last
version of SQLite 3.11.1 and began to use the ROW_NUMBER() function, and
running the query in the interface of DB Lite I had no troubles
This is another example of the problem described by ticket
https://www.sqlite.org/src/info/df46dfb631f75694 which is fixed in
version 3.27.2.
On 3/5/19, Peter Hardman wrote:
> If i run the following query from Python 3.7 using the sqlite3 DBAPI
> adapter or from sqlitebrowser I get a segmentation
On 3/6/19, Peter Hardman wrote:
>
> I've attached the database file (300K).
>
Attachments are stripped by the mailing list. Please send via private
email directly to me.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mai
OK. I've anonymised the database and cut it down so that only the records
extracted by the query are present. I have this feeling I've done something
stupid with the data - but all the other queries I run against this database
work fine.
It still gives a segfault when I run the query.
The SQL
On 6/3/62 16:37, Peter Hardman wrote:
So, I forgot I had emails from the list turned off
Integrity check shows no results.
The query fails from the CLI
The schema (of a very much cut down database) is attached.
Can you post the results of running the ".fullschema" command in the
shell
I was not able to reproduce it. I arrived at the following decoded schema and
query:
CREATE TABLE version (
major_version INTEGER NOT NULL PRIMARY KEY,
minor_version INTEGER NOT NULL,
paradox_upload TEXT,
converted TIMESTAMP NOT NULL,
created TIMESTAMP NOT NULL
);
CREATE TAB
> Multiple processes write to foo.db.
What method of journaling do you use? WAL?
> Multiple processes read foo.db (no writes at all).
Do they open a connection, read, then close the connection, or do you open
a connection, read, read, read, read, until the process is terminated, THEN
close the
Scenario 1:
Multiple processes write to foo.db.
I want to do some periodic snapshots.
What is the best way to do this without interrupting/blocking writers?
sqlite3 foo.db '.backup snapshot.db' ?
Scenario 2:
Multiple processes read foo.db (no writes at all).
I need to update foo.db without readers
On 3/6/19, Peter Hardman wrote:
>
> The schema (of a very much cut down database) is attached.
I translated the attached schema into SQL and appended the query. I
uploaded the result to https://sqlite.org/tmp/peter-hardman-001.txt
I have run the resulting script through every version of SQLite
So, I forgot I had emails from the list turned off
Integrity check shows no results.
The query fails from the CLI
The schema (of a very much cut down database) is attached.
And if it does still crash, please provide the database schema to help with
debugging.
-Original Message---
13 matches
Mail list logo