On 21.02.2020 15:03 Richard Hipp wrote:
> On 2/21/20, Wout Mertens wrote:
>> The idea is that upon storing the JSON
>> data, the JSON1 extension parses it, extracts the layouts recursively,
>> stores them when they are not known yet, and then only stores the
>> values in the binary format with the
On 06.10.2019 22:02 Keith Medcalf wrote:
> On Sunday, 6 October, 2019 13:03, Kadirk wrote:
>
>> We already have an application specific WAL file, sqlite updates +
>> application data is in this WAL file. We are taking snapshot of sqlite +
>> application data to the disk to truncate WAL file, then
On 12.12.2017 19:47 Simon Slavin wrote:
> On 12 Dec 2017, at 6:27pm, Jens Alfke wrote:
>
>> On Dec 12, 2017, at 5:46 AM, Simon Slavin wrote:
>>> Before you answer that question, you should know that both Windows and
>>> macOS have been proved to have serious bugs in their memory mapping code.
>>
On 21.11.2017 17:30 John McKown wrote:
> On Tue, Nov 21, 2017 at 10:27 AM, Drago, William @ CSG - NARDA-MITEQ <
> william.dr...@l3t.com> wrote:
>
>>> I really need to come up with an alternative to the mailing list.
>>> Perhaps some kind of forum system. Suggestions are welcomed.
>>> --
>>> D. Ric
Hi,
with 3.15:
sqlite> PRAGMA quick_check;
integrity_check
ok
with 3.16:
sqlite> PRAGMA quick_check;
quick_check
ok
The second one is more intuitive, but existing applications may use the
first column name.
Regards,
Martin Raiber
___
sqlite
On 16.09.2016 00:53 Simon Slavin wrote:
> On 15 Sep 2016, at 11:38pm, Martin Raiber wrote:
>
>> There are two instances in the program where the sqlite database file is
>> opened
>> and closed outside of sqlite3 (to backup the database file and to sync
>> it before
.
Solution seems to be to not close the database file after opening it and
to reuse
the file handle (on Linux).
On 14.09.2016 13:05 Martin Raiber wrote:
> Hi,
>
> there have been three reports by users using my software of SQLite
> 3.12.0 returning SQLITE_IOERR a
On 14.09.2016 13:26 Simon Slavin wrote:
> Check the hard disk format for format errors (fsck).
>
> Run "PRAGMA integrity_check" on the database file.
>
> Is the database file on a disk inside the computer running the SQLite calls,
> or is it accessed across a network ?
>
> Do you use any PRAGMAs i
On 14.09.2016 13:31 Dan Kennedy wrote:
> On 09/14/2016 06:05 PM, Martin Raiber wrote:
>> there have been three reports by users using my software of SQLite
>> 3.12.0 returning SQLITE_IOERR and logging a SQLITE_IOERR_SHORT_READ
>> (522). Specifically:
>>
>> 201
Hi,
there have been three reports by users using my software of SQLite
3.12.0 returning SQLITE_IOERR and logging a SQLITE_IOERR_SHORT_READ
(522). Specifically:
2016-09-12 04:37:04: WARNING: SQLite: disk I/O error errorcode: 522
2016-09-12 04:37:04: ERROR: Error preparing Query [PRAGMA cache_size
Hi,
I have used sqlite3VarintLen outside of SQLite and noticed that the
assertion in this function is hit if the highest bit is set (and it
returns 10 when it should return 9). E.g. with
sqlite3VarintLen(0xF000);
It could be that this is not relevant to SQLite as it is guaranteed tha
11 matches
Mail list logo