Hi,
Some of my single row inserts use parameterized queries today to make
encoding easier. For example having embedded single quotes in strings etc.
Now, I would like to take advantage of the multi row inserts as described in
Hi,
When I read this: http://sqlite.org/pragma.html#pragma_page_size it seems to
argue that I can never change the page_size on a non-empty db that is
running in WAL mode. Any tips how I can still do this?
Thanks
Andy
___
sqlite-users mailing
Hi,
I am using System.Data.SQLite, Version=1.0.92.0. I read that increasing the
page_size to 4k on modern OS is a good thing and should speed things up.
However, I have a particular query that takes substantially longer. I tried
to make sure that nothing else is changed, so I am a little
Hi,
I added a call to both:
ANALYZE
ANALYZE sqlite_master
To my app at timely intervals. We are also running in WAL mode. Do I need to
do a WAL checkpoint (pragma wal_checkpoint) before running the index recalc
or not?
Thanks
Andy
___
Hi,
I determined that I would like to upgrade my page_size from 1k to 4k during
start up time if it is not done yet. At the time I would like to do that, no
other db access is occurring yet. Still, I see failures that often the
page_size returned at the end in the verification step is still
Hi,
Using sqlite dbs for my program (official .NET sqlite.interop.dll, v.
1.0.92.0). Have not had any db integrity issues until today. One user send me a
db, I ran Sqlite Expert professionals's integrity checker and got this:
*** in database main ***
On tree page 2 cell 14: 2nd reference to
I have been reading there are a few issues with v 95, so I am waiting for
the next. Will there be a version that has only bug fixes or new features as
well? As many of you know, new features usually also create regressions.
Thanks
Andy
Hi,
I would like to write a script that checks whether certain records already
exist, and if not, insert them. If they do exist, it should be a no op.
I am trying this:
IF (SELECT COUNT(*) FROM [Antennas]) = 0
BEGIN
/* Table data [Antennas] Record count: 16 */
INSERT OR REPLACE INTO
Hi,
I use a simple ALTER TABLE ADD COLUMN statement. However, when I use the Sqlite
Expert, the DDL is not reflected. Even though the column is created. I read
somewhere that the DDL is really just a copy of the text when teh table was
created. Is there a way to refresh this?
Thanks,
Andy
Hello,
I'm looking for best practices on when and where to create/initialize your
tables when using SqlLite.Net as well as how to properly handle schema changes
from one version to another.
It seems I could roll my own using large SQL files or use some library that can
do the updates for me…
sqlite] SqlLite.Net: Tables creation and schema changes strategies
On 8 Feb 2020, at 3:10pm, Andy KU7T wrote:
> I'm looking for best practices on when and where to create/initialize your
> tables when using SqlLite.Net as well as how to properly handle schema
> changes from one version to a
ld use different parameter
type. I would use TEXT type.
Regards R.A.
On 14.02.2020 15:09, Andy KU7T wrote:
> Hi,
>
> I am having trouble searching for a Guid. I think some conversion is missing.
> I wonder if someone can point me to the error…
>
> Column:
> [ID] GUID(16)
>
Hi,
I am having trouble searching for a Guid. I think some conversion is missing.
I wonder if someone can point me to the error…
Column:
[ID] GUID(16)
Index:
CREATE UNIQUE INDEX [ID_INDEX] ON [DXLOG]([ID] COLLATE [BINARY] ASC);
Trigger:
CREATE TRIGGER [AUTOGENERATE_ID] AFTER INSERT ON [DXLOG]
Hi,
I added a randomblob(16) to each record of a Sqlite table via a trigger with
the goal of global uniqueness. Is that the correct approach or would it be
better to pass Guid from .Net? I am using System.Data.Sqlite. The following
article got me questioning the usage of randomblob:
I admit I do not fully understand all the arguments. I am running on Windows.
Are you saying the PRNG on Windows is not good enough to use randomblob(16) in
Sqlite? All I need is a reasonable assurance that is are unique...
Andy
Sent from my T-Mobile 4G LTE Device
Get Outlook for
15 matches
Mail list logo