On 15/7/19 11:25 PM, Nelson, Erik - 2 wrote:
> Dominique Devienne wrote on Monday, July 15, 2019 2:41 AM
>
>> That's when you reach for virtual tables (and their "virtual indices").
>> I.e. you keep your data in native data-structures (Boost.MultiIndex in my
>> case),
>> and just provide a SQLite
>-Original Message-
>From: Keith Medcalf [mailto:kmedc...@dessus.com]
>Sent: Monday, 15 July, 2019 19:13
>To: 'SQLite mailing list'
>Subject: RE: [sqlite] [EXTERNAL] Re: how to delete BLOB object from
>the data base
>
>
>Use one connection. Use one thread. As follows:
>
>sqlite *db;
>sqli
Use one connection. Use one thread. As follows:
sqlite *db;
sqlite_stmt *beginstatement;
sqlite_stmt *commitstatement;
sqlite_stmt *insertstatement;
sqlite_stmt *deletestatement;
int i = 0;
sqlite_open_v2('database.db', &db, ...);
sqlite_prepare_v2(db, "begin immediate", &beginstatement, ...);
On 15 Jul 2019, at 8:38pm, Zhu, Liang [AUTOSOL/ASSY/US]
wrote:
> I am getting the SQLite_locked error on delete, and my data from the select
> statement are junk.
I think you are saying that you get the result SQLITE_LOCKED. To do this you
must be
A) Using one database connection for two o
We do the increment of 1000, when the record reaches number which dividable by
1000, we delete the record.
-Original Message-
From: sqlite-users On Behalf Of
Robert Hairgrove
Sent: Monday, July 15, 2019 4:00 PM
To: sqlite-users@mailinglists.sqlite.org
Subject: [EXTERNAL] Re: [sqlite] h
The questions coming to mind at the moment:
What is the schema of the table holding the BLOBs?
What is the normal size for the blobs?
How are you doing the inserts and deletes?
What journal mode are you using?
I would think normal way to delete a record is the simple
delete from blob_table where
On 15.07.19 21:38, Zhu, Liang [AUTOSOL/ASSY/US] wrote:
... I am inserting to the BLOB data into the table at every 250ms, I
delete the oldest row at every 600ms, also I am reading the data from
the database at every 10ms...
How do you determine the "oldest" row? I believe the timestamps
gener
Sqlite Experts,
I have a table contains the BLOB object, I am inserting to the BLOB data into
the table at every 250ms, I delete the oldest row at every 600ms, also I am
reading the data from the database at every 10ms. After almost of 100,000
insert, delete and select operations, I am g
Issue is RESOLVED.
After more experimentation, I realized that I was causing the Read() operations
in the first resultset by doing this after the ExecuteReader() call:
PS D:\temp> $dataReader
FieldCount
--
2
2
2
It would seem that asking PowerShell to 'output'
> On Jul 15, 2019, at 3:57 AM, Richard Hipp wrote:
>
> Yeah there is. SQLite has a high-level query language (SQL) that can
> radically simplify application development.
I guess it depends on your programming style. Most apps whose architecture I’m
aware of* either wrap something like an ORM
On Mon, Jul 15, 2019 at 12:57 PM Richard Hipp wrote:
>
> On 7/15/19, Jens Alfke wrote:
> >
> > If you’re going to keep your data in memory, there’s no good reason to use
> > SQLite at all.
>
> Yeah there is. SQLite has a high-level query language (SQL) that can
> radically simplify application d
New SQLite user... trying to understand the following issue.
(Spent several hours on Google, Stack Overflow, SQLite mailing list archive...
found nothing satisfactory.)
[ISSUE]
As far as I can tell, after calling ExecuteReader(), I cannot Read() any rows
in the *first* result set because the ret
Dominique Devienne wrote on Monday, July 15, 2019 2:41 AM
>That's when you reach for virtual tables (and their "virtual indices").
>I.e. you keep your data in native data-structures (Boost.MultiIndex in my
>case),
>and just provide a SQLite view of it. Much faster than "pure-in-Memory" with
> SQ
On 14/7/62 17:18, Chaoji Li wrote:
This problem is only present for 3.28+. A sample test case is attached.
Thanks for reporting this. We think it's fixed here:
https://sqlite.org/src/info/52f463d29407fad6
The mailing list stripped off your test case, so if you could either run
it with the
Dan Kennedy explained why this limitation exists:
>On 27/2/62 05:47, Jake Thaw wrote:
>>This may not strictly be a bug, but currently (3.27.2) a vtab cannot overload
>>scalar functions in aggregate queries.
>>
>>Adding a check for TK_AGG_COLUMN in sqlite3VtabOverloadFunction makes my use
>>case
On 7/15/19, Jens Alfke wrote:
>
> If you’re going to keep your data in memory, there’s no good reason to use
> SQLite at all.
Yeah there is. SQLite has a high-level query language (SQL) that can
radically simplify application development.
--
D. Richard Hipp
d...@sqlite.org
_
On 15/7/62 00:05, ardi wrote:
Hi!
I'm going to use sqlite as means of the file format I/O for
applications. One of the critical points in file I/O is saving the
file in a safe way, so that data loss cannot happen (or at least the
risk of happening is minimized as much as possible). Traditionall
On 14/7/62 15:59, Orgad Shaneh wrote:
Hi,
In reply to
https://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/msg113512.html.
Can you please accept this patch?
The patch doesn't seem all that intrusive, but is there a reason you
can't build from canonical sources instead of sqlit
18 matches
Mail list logo
