Thanks Richard for the reply. Appreciated.
On Tue, Mar 12, 2019 at 2:49 AM Richard Hipp wrote:
> On 3/11/19, Chris Locke wrote:
> > Does SQLite keep a count of the number of current open connections to the
> > database?
>
> No.
>
> SQLite can find out if some other connection has the database
A clarification about sqlite3_exec please.
Surely that works the same way as sqlite3_step in respect to memory use
since it's using step internally and just forwards the results to the
callback function of exec.
Or did I miss something?
--
Sent from: http://sqlite.1065341.n5.nabble.com/
On 12 Mar 2019, at 6:38am, niklas wrote:
> Surely that works the same way as sqlite3_step in respect to memory use since
> it's using step internally and just forwards the results to the callback
> function of exec.
>
> Or did I miss something?
You missed nothing. _exec() returns only the
What is the journal mode?
On 3/12/2019 10:30 AM, Ted Goldblatt wrote:
On Tue, Mar 12, 2019 at 11:45 AM James K. Lowden
wrote:
On Tue, 12 Mar 2019 10:36:37 -0400
ted.goldbl...@gmail.com wrote:
The problem is basically that as part of a test, the customer wants
to power fail the device, and
On Tue, Mar 12, 2019 at 11:47 AM Hick Gunter wrote:
> Without gaining SQLite shell access to the actual file (e.g. copy from
> flash to PC/Linux/whatever) or some other possibility to run integrity
> checks, this is going to be hard.
>
I do have this - the firmware is able to upload a copy of
Info on the use of temp files can be found here
https://www.sqlite.org/tempfiles.html
Anything integral to integrity is always put on disk, so SQLITE_TEMP_STORE
shouldn't be affecting integrity.
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
On Tue, Mar 12, 2019 at 11:45 AM James K. Lowden
wrote:
> On Tue, 12 Mar 2019 10:36:37 -0400
> ted.goldbl...@gmail.com wrote:
>
> > The problem is basically that as part of a test, the customer wants
> > to power fail the device, and then to be able to recover (after the
> > device restarts)
Hello,
1st question : Is there a way to tell printf() to display the decimal separator
set in the OS ?
For example, the decimal separator in my OS is set to comma (,), I would like
printf() to display the comma as the decimal separator.
sqlite> select printf('%.2f %%', 25.365419);
25.37 %
Without gaining SQLite shell access to the actual file (e.g. copy from flash to
PC/Linux/whatever) or some other possibility to run integrity checks, this is
going to be hard.
With an embedded device, not upgrading SQLite is probably due to not wanting to
increase image size. Newer releases
Other posters have taken care of very important aspects of your circumstances,
but I wanted to mention one I didn't see anyone mention. Settings.
If you compile SQLite without changing compilation settings, and use it without
changing defaults, SQLite is extremely good at avoiding corruption,
On Tue, 12 Mar 2019 10:36:37 -0400
ted.goldbl...@gmail.com wrote:
> The problem is basically that as part of a test, the customer wants
> to power fail the device, and then to be able to recover (after the
> device restarts) data that was generated/stored as close to the power
> failure as
On Mon, 11 Mar 2019 10:39:06 +0100
Jean-Luc Hainaut wrote:
> Your implementation of trees is that of network databases at the
> pointer-based physical level but definitely not relational. Try this:
>
> create table TREE(
>ID integer not null primary key,
>Parent integer references
I may have missed this already being discussed.
Will you have access to a copy of the database as it was before corruption
testing ? Can you use SQLite to see whether it is already corrupt ? Or can
the test run on a brand new, freshly-created database ? If neither of those,
your test won't
I apologize in advance for the length of the following…
I have recently been handed a customer-reported problem against a legacy
embedded device (an industrial process monitor) that makes use of SQLite over
flash for storing the monitored info (it uses this internally to respond to
remote info
On Tue, 12 Mar 2019 16:08:24 +
Alexandre Billon wrote:
> 1st question : Is there a way to tell printf() to display the decimal
> separator set in the OS ?
>
> For example, the decimal separator in my OS is set to comma (,), I
> would like printf() to display the comma as the decimal
On 12 Mar 2019, at 9:41pm, Ted Goldblatt wrote:
> SQLITE_OMIT_xxx, SQLITE_DEFAULT_CACHE_SIZE,
> SQLITE_THREADSAFE
None of these are a problem, assuming your embedded app does not do
multi-threading.
> One of these is SQLITE_TEMP_STORE, which is set to
> "Always use memory" which strikes me a
On Tue, Mar 12, 2019 at 1:55 PM Jim Morris wrote:
> What is the journal mode?
>
> That is a very interesting question, as a journal file certainly seems
relevant to power fail issues. Unfortunately, you have exceeded the limits
of my knowledge of either SQLite or of the underlying software on
On Tue, Mar 12, 2019 at 12:29 PM Simon Slavin wrote:
> I may have missed this already being discussed.
>
> Will you have access to a copy of the database as it was before corruption
> testing ? Can you use SQLite to see whether it is already corrupt ? Or
> can the test run on a brand new,
> SQLite is built from (the combined) source as part of the project build.
> [...]
If you want extra safety, I would recommend you consider using
SQLITE_DEFAULT_SYNCHRONOUS=3 which is the equivalent to using PRAGMA
synchronous=EXTRA.
Quick references:
*
Hi
On Tue, Mar 12, 2019 at 5:03 PM Ted Goldblatt wrote:
>
> On Tue, Mar 12, 2019 at 12:29 PM Simon Slavin wrote:
>
> > I may have missed this already being discussed.
> >
> > Will you have access to a copy of the database as it was before corruption
> > testing ? Can you use SQLite to see
At https://www.sqlite.org/rescode.html#cantopen the text says ..."or on of
several"... which should probably be "or one of several".
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
Does SQLite keep a count of the number of current open connections to the
database?
On the DB4S mailing list, there is an enquiry (
https://github.com/sqlitebrowser/sqlitebrowser/issues/1798) about
encryption failing due to the database being open. Was wondering whether a
PRAGMA or function
My main goal - to avoid blocks and interruptions in this two scenarios.
Thanks for "vacuum into" - I will test that.
Is the "foo.db" in Scenario 1 the same "foo.db" in scenario 2 or do they just
have the same name by happenstance?
Or the same database of different machines or something?
On Mar 12, 2019, at 11:30 AM, Ted Goldblatt wrote:
>
> I have been writing software for too many decades to casually dismiss the
> possibilities of software bugs. If there couldn't be bugs in SQLite, there
> would have been no bug fixes since the version being used here, and having
> briefly
On Tue, Mar 12, 2019 at 12:17 PM Simon Slavin wrote:
> Other posters have taken care of very important aspects of your
> circumstances, but I wanted to mention one I didn't see anyone mention.
> Settings.
>
> If you compile SQLite without changing compilation settings, and use it
> without
25 matches
Mail list logo