[sqlite] Database is locked (wal) - purely from read-only connections/queries

2016-02-29 Thread Jim Callahan
Are you using any SQL VIEWs? "You cannot DELETE, INSERT, or UPDATE a view. Views are read-only in SQLite." http://sqlite.org/lang_createview.html Jim On Mon, Feb 29, 2016 at 10:31 PM, Vince Scafaria wrote: > Richard, I can confirm that having a writable connection open first, prior > to trying

[sqlite] Page_size

2016-02-29 Thread Olivier Mascia
GMail URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160229/058ee774/attachment.pgp>

[sqlite] Using My Own Encryption Possible ?

2016-02-29 Thread Ulrich Telle
Am 29.02.2016 um 16:44 schrieb a a: > Thank you for your responces, > > I am looking for a non commercial way to make my own encrypted database file > if it can be done and if it can be easy by using any kind of encryption i > prefer with my own script > I want to be able to enrypt and manage

[sqlite] Page_size

2016-02-29 Thread Jim Wang
hi,all Could different page_size do impact on the speed of retrieving record? Is page_size 8192 faster than page_size 1024 or page_szie 4096? or The pagesize has nothing to do with the retrieving speed. Best reagard! Jim Wang.

[sqlite] ASK SQLite algoritm to chose Index

2016-02-29 Thread Christoforus Surjoputro
Hi Keith, Thanks for reply. You explain it very well. But, I've try make an unique index, but sqlite still use their autoindex, which mean their index still better than mine. Maybe, it's because UNIQUE constrain on email will only return one value as you say. Thanks. On Monday, February

[sqlite] Using My Own Encryption Possible ?

2016-02-29 Thread Simon Slavin
On 29 Feb 2016, at 3:44pm, a a wrote: > I want to be able to enrypt and manage the database encrypted with my own > encryption like SEE commercial use .. thats what i am asking if it is possible There are a few free encryption systems available. Try googling 'sqlite encryption' and seeing

[sqlite] Using My Own Encryption Possible ?

2016-02-29 Thread R Smith
On 2016/02/29 3:28 PM, Dominique Devienne wrote: > On Mon, Feb 29, 2016 at 2:18 PM, Simon Slavin wrote: > >> Another way would be to write your own authorizer which, among other >> things, did some encryption of the data involved. >> > > It's

[sqlite] Using My Own Encryption Possible ?

2016-02-29 Thread a a
Thank you for your responces, I am looking for a non commercial way to make my own encrypted database file if it can be done and if it can be easy by using any kind of encryption i prefer with my own script I want to be able to enrypt and manage the database encrypted with my own encryption

[sqlite] Using My Own Encryption Possible ?

2016-02-29 Thread Dominique Devienne
On Mon, Feb 29, 2016 at 2:18 PM, Simon Slavin wrote: > Another way would be to write your own authorizer which, among other > things, did some encryption of the data involved. > It's the first time I read someone proposing using an authorizer

[sqlite] Using My Own Encryption Possible ?

2016-02-29 Thread Simon Slavin
On 29 Feb 2016, at 1:28pm, Dominique Devienne wrote: > Can an authorizer really be "abused" that way? You're quite right. It's not useful for this. Thanks for the heads-up. Sorry. Simon.

[sqlite] Using My Own Encryption Possible ?

2016-02-29 Thread Simon Slavin
On 29 Feb 2016, at 12:51pm, a a wrote: > Is there a possibility to use my own Encryption for enctrypting the database > file or i can use it only for my data being stored ? > > I am wondering if there is way to get the full database encrypted (database > schema) and not only my entered

[sqlite] Possible bug in the SQL parser

2016-02-29 Thread R Smith
On 2016/02/29 12:49 PM, Jo?o Ramos wrote: > Maybe this has been fixed then? This is what I'm getting: > > select sqlite_version(); -- 3.8.10 > > select sqlite_source_id(); -- 2015-05-04 19:13:25 > 850c11866686a7b39d7b163fb60898c11283688e > > > WITH > > tA(id, name) AS > > ( > > SELECT 1, "a"

[sqlite] Why is a separate journal file needed ?

2016-02-29 Thread Rowan Worth
On 29 February 2016 at 12:13, Igor Tandetnik wrote: > On 2/28/2016 9:19 PM, Rowan Worth wrote: > >> On 27 February 2016 at 00:02, Igor Tandetnik wrote: > > > > I simplified to make the main point stand out: it is not true that the >> >>> database file remains "pristine" while the transaction is

[sqlite] Fwd: Sqlite is secure with MD5?

2016-02-29 Thread veer verma
Hi Keith, I have not compiled sqlite3.c with any option such as -DTCLSH=1 or -DSQLITE_TCLMD5 or -DSQLITE_TEST. I am just running configure and make to build sqlite3 ( Not changing anything in the Makefile that comes default with tarball). >From the first few lines from tclsqlite.c files, i

[sqlite] Using My Own Encryption Possible ?

2016-02-29 Thread a a
Hello, Is there a possibility to use my own Encryption for enctrypting the database file or i can use it only for my data being stored ? I am wondering if there is way to get the full database encrypted (database schema) and not only my entered values. If it needs to go through a perpetual

[sqlite] Page_size

2016-02-29 Thread Simon Slavin
On 29 Feb 2016, at 9:14am, Olivier Mascia wrote: > we have found the sweet spot (for us, and for now) to be 4K page sizes, which > just happen to be the virtual memory page size of Windows system Yes. That's the idea. Match the page size of the database to the size of the chunks your

[sqlite] Fwd: Sqlite is secure with MD5?

2016-02-29 Thread veer verma
Hi, Can i get some help on this please? Thanks Sameer Hello, I am using sqlite3-3.11.0, i See sqlite is using MD5 hash algorithm to generate MD5 checksums for TCL interface. Since MD5 is broken for purposes of security, How can i replace MD5 with any other hash algorithm (sha-2) to keep it

[sqlite] Possible bug in the SQL parser

2016-02-29 Thread João Ramos
Maybe this has been fixed then? This is what I'm getting: select sqlite_version(); -- 3.8.10 select sqlite_source_id(); -- 2015-05-04 19:13:25 850c11866686a7b39d7b163fb60898c11283688e WITH tA(id, name) AS ( SELECT 1, "a" UNION ALL SELECT 2, "b" ), tB(name) AS ( SELECT "a" UNION ALL

[sqlite] Why is a separate journal file needed ?

2016-02-29 Thread Rowan Worth
On 27 February 2016 at 00:02, Igor Tandetnik wrote: > On 2/26/2016 4:01 AM, Rowan Worth wrote: > >> In principle this is correct, but actually the database *file* is not >> immediately modified in rollback mode. Instead when a page is modified the >> original contents are saved to the rollback

[sqlite] Page_size

2016-02-29 Thread Olivier Mascia
Type: application/pgp-signature Size: 842 bytes Desc: Message signed with OpenPGP using GPGMail URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160229/9a014bad/attachment.pgp>

[sqlite] Fwd: Re: SQLite and Thunderbird

2016-02-29 Thread Rowan Worth
On 26 February 2016 at 22:42, Howard Chu wrote: > Thunderbird has *always* used its own statically built sqlite, just like > all other Mozilla software. > > In fact, it has more than one copy: > https://hg.mozilla.org/mozilla-central/file/918df3a0bc1c/db/sqlite3/src > > >

[sqlite] Page_size

2016-02-29 Thread Keith Medcalf
The NTFS cluster size is usually 4K, unless you have changed it (you can use fsutil or chkdsk to see what the cluster size is). Windows does I/O in units of a cluster. Therefore the smallest (and largest) I/O which Windows will do is 1 Cluster, or 4K. While you may set the page size larger

[sqlite] Page_size

2016-02-29 Thread Scott Hess
Also note that almost all current storage you can purchase uses 4k basic blocks. So it's not just some weird Windows thing. In addition to performance advantages of getting the block size right, there is also the advantage that most storage systems strive hard to make sure block operations are

[sqlite] Sqlite is secure with MD5?

2016-02-29 Thread Richard Hipp
On 2/24/16, veer verma wrote: > > I am using sqlite3-3.11.0, i See sqlite is using MD5 hash algorithm to > generate MD5 checksums for TCL interface. Since MD5 is broken for purposes > of security, Some of the TCL tests for SQLite uses MD5 has a hash function. This has nothing to do with

[sqlite] Possible bug in the SQL parser

2016-02-29 Thread Richard Hipp
On 2/29/16, Jo?o Ramos wrote: > Maybe this has been fixed then? This is what I'm getting: > > select sqlite_version(); -- 3.8.10 > > select sqlite_source_id(); -- 2015-05-04 19:13:25 > 850c11866686a7b39d7b163fb60898c11283688e Compiling with that exact same version of the source code, it works

[sqlite] SQLite and Thunderbird

2016-02-29 Thread Simon Slavin
On 29 Feb 2016, at 2:02am, Rowan Worth wrote: > Hm, the "how to corrupt your database" page explicitly recommends against > this practice (multiple copies of sqlite linked to the same application). > See https://www.sqlite.org/howtocorrupt.html section 2.2.1. > > I suppose it is safe enough if