ype: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL:
<http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160226/234451af/attachment.pgp>
I am using System.Data.SQLite in .NET and encountering "database is locked"
with wal using multiple threads from the same process running simple select
statements with (separate) read-only connections. Please see the link below and
note the Visual Studio output window when it runs.
I'm using SQLite 3.8.10.2 and the following query illustrates the problem:
WITH
tA(id, name) AS
(
SELECT 1, "a" UNION ALL SELECT 2, "b"
),
tB(name) AS
(
SELECT "a" UNION ALL SELECT "b"
)
SELECT tB.id FROM tA INNER JOIN tB ON (tA.name = tB.name);
There is no _id_ column in the tB table,
On 26 Feb 2016, at 5:45pm, Christoforus Surjoputro
wrote:
> I've problem with sqlite choosing index that I think I have better index to
> use. I've ask here but still didn't get why this happen? Did sqlite choose
> the best index to use or choose the last entered index?
SQLite doesn't know
I've problem with sqlite choosing index that I think I have better index to
use. I've ask?here but still didn't get why this happen? Did sqlite choose the
best index to use or choose the last entered index?
| ? |
| ? | | ? | ? | ? | ? | ? |
| SQLite use autoindex instead my own indexI've
On 24 February 2016 at 23:46, Igor Tandetnik wrote:
> On 2/24/2016 10:08 AM, Stephen Chrzanowski wrote:
>
>> IMO, all that, plus the fact that you have an easy roll back mechanism.
>> Anything that needs to be put in the database is external to the pristine
>> database. Lock the database with a
On 24 February 2016 at 21:49, Richard Hipp wrote:
> On 2/24/16, Simon Slavin wrote:
> > Why can't the information which SQLite
> > stores in a journal file be put in the database file ?
>
> Doing so would double the size of the database file. Every database
> file would contain extra space
On Fri, 26 Feb 2016 at 16:42 Simon Slavin wrote:
>
> I thought I knew where it was documented but I can't find it at the
> moment. The idea is that if you have given the column an explicit name (in
> your case 'storeID') then you might be referring to it in your code, so
> SQLite shouldn't
Richard Hipp wrote:
> I suppose that Thunderbird was making use of the fts3_tokenizer()
> interface, which has be removed from standard builds due to security
> concerns, as of version 3.11.0. You can reenable that feature at
> compile-time by building with -DSQLITE_ENABLE_FTS3_TOKENIZER. See
On 26 Feb 2016, at 2:22pm, Tristan Seligmann wrote:
> PRAGMA writable_schema=on;
> UPDATE sqlite_master SET sql='CREATE TABLE some_table_name (..., storeID
> INTEGER PRIMARY KEY)' WHERE tbl_name='some_table_name';
I thought I knew where it was documented but I can't find it at the moment.
Hi,
To encrypt the SQLite database, I can only find the following extension:
https://www.sqlite.org/see/doc/trunk/www/readme.wiki
So I must recompile and enable the extension to encrypt the database, is
that correct?
Thanks
> -Original Message-
> From: sqlite-users-bounces at
Axiom is an ORM'ish layer on top of SQLite in Python. Due to unfortunate
historic reasons, Axiom relies on the implicit ROWID (actually "oid")
column present in every table in SQLite, without declaring an explicit
PRIMARY KEY; this, of course, means that VACUUMing an Axiom table will
corrupt it as
On Thu, 25 Feb 2016 14:01:31 +0800
wrote:
> Does SQLite provide a good way to encrypt the SQL query strings while
> does not affect the performance when executing the queries?
If you're worried about the user examining your program image
statically, you could encrypt your SQL by whatever means,
On 26 Feb 2016, at 9:23am, Steven Haigh wrote:
> Please CC me as I'm not subscribed to this list.
I sent this person the 'if you don't read a list don't post' message.
Simon.
On 2/26/2016 12:07 PM, Igor Korot wrote:
> Full code is in here:
> http://stackoverflow.com/questions/35345258/crash-when-disconnecting-from-sqlite-database
Off the top, the example never calls Connect, which leaves
SQLiteDatabase::m_db contain uninitialized garbage (you don't initialize
it in
Summary: Certain Unicode code points expand to more than two code points
when run through u_strToUpper().
SQLite's src/ext/icu/icu.c contains icuCaseFunc16() which implements custom
upper() and lower() functions. It allocates a buffer of twice the input
size because some code points take more
Hello, Teg,
On Fri, Feb 26, 2016 at 11:41 AM, Teg wrote:
> Hello Igor,
>
> I use Sqlite through a DLL interface. I mean I have another DLL that
> includes Sqlite static linked inside it. All opening, closing and
> access to Sqlite takes place inside the context of the DLL. The
> application
Hello Igor,
I use Sqlite through a DLL interface. I mean I have another DLL that
includes Sqlite static linked inside it. All opening, closing and
access to Sqlite takes place inside the context of the DLL. The
application never makes Sqlite calls directly. Instead it uses higher
level functions
On 2/25/16 10:31 AM, Igor Korot wrote:
> Hi,
> I'm trying to design/make a program where I will use SQLite from the DLL.
>
> What I mean is I will establish a connection inside a DLL but disconnect from
> the database in my main application.
>
> It turns out that doing so I am getting the crash
On 2/26/2016 4:01 AM, Rowan Worth wrote:
> On 24 February 2016 at 23:46, Igor Tandetnik wrote:
>
>> On 2/24/2016 10:08 AM, Stephen Chrzanowski wrote:
>>
>>> IMO, all that, plus the fact that you have an easy roll back mechanism.
>>> Anything that needs to be put in the database is external to the
On 2/26/16, Richard Hipp wrote:
>
> At this time, you basically have two options:
>
Beginning with version 3.12.0, there will be a third option. You can
use the sqlite3_db_config() interface with the new
SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER argument to enable the
two-argument version of
On 2/26/16, Tristan Seligmann wrote:
>
> PRAGMA writable_schema=on;
> UPDATE sqlite_master SET sql='CREATE TABLE some_table_name (..., storeID
> INTEGER PRIMARY KEY)' WHERE tbl_name='some_table_name';
>
I don't think that will work. I believe you are going to need to copy
the table content.
On Fri, 26 Feb 2016 14:39:50 +0800, wrote:
> To encrypt the SQLite database, I can only find the following extension:
>
> https://www.sqlite.org/see/doc/trunk/www/readme.wiki
>
> So I must recompile and enable the extension to encrypt
> the database, is that correct?
That's almost correct, you
WAL files can be many times bigger than a database - the default WAL
checkpoint size is when the WAL grows to > 1000 pages. You can get a
DB (for example) with 100 pages and a WAL of 1000 (with multiple
different copies of the same page).
Paul
www.sandersonforensics.com
skype: r3scue193
twitter:
I suppose that Thunderbird was making use of the fts3_tokenizer()
interface, which has be removed from standard builds due to security
concerns, as of version 3.11.0. You can reenable that feature at
compile-time by building with -DSQLITE_ENABLE_FTS3_TOKENIZER. See the
last bullet (the only
On 2/25/16, Luke Amery wrote:
> https://www.sqlite.org/c3ref/vfs.html
>
> New fields may be appended in figure versions
>
Thank you. Fixed at https://www.sqlite.org/src/info/ff3d7f845e1875d6
--
D. Richard Hipp
drh at sqlite.org
> Message: 31
> Date: Thu, 25 Feb 2016 07:53:06 -0500
> From: Richard Hipp
> To: SQLite mailing list
> Subject: Re: [sqlite] bubble-generator.tcl usage question
> Message-ID:
>
27 matches
Mail list logo
