[sqlite] Changing WAL mode for a transaction

Hello, My application runs the following right after opening the connection to the database. pragma journal_mode=wal; pragma page_size=4096 When the application wants to perform a bulk data load (loading around 21Gb of data), it runs the following before starting the transaction.

[sqlite] Changing WAL mode for a transaction

Hi Dan, > On 27-Apr-2015, at 10:52 am, Dan Kennedy wrote: > > On 04/26/2015 07:01 PM, Navaneeth K N wrote: >> Hello, >> >> My application runs the following right after opening the connection to the >> database. >> >> pragma journal_mode

[sqlite] Changing WAL mode for a transaction

Hi Dan, > On 27-Apr-2015, at 11:34 am, Dan Kennedy wrote: > > On 04/27/2015 12:55 PM, Navaneeth K N wrote: >> Hi Dan, >> >> >>> On 27-Apr-2015, at 10:52 am, Dan Kennedy wrote: >>> >>> On 04/26/2015 07:01 PM, Navaneeth K N wrote: &g

[sqlite] Date function accepts only DD for date string

Hello, select date('2013-11-04') -> Works well select date('2013-11-4') -> Not working Is there a way to make the second form working? Currently, I handle this at the application side. If month/day is less than 10, then prefix it with 0. But I'm wondering is there a better way to do this

Re: [sqlite] Using SQLite by Jay Kreibich (2010 paperback edition)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 Hello, On 12/31/13 8:18 AM, Bob Cochran wrote: > I'm working on a tough project that requires me to use Node.js and > SQLite. I'm building a database with SQLite version 3.8.2. > > My question is, would purchasing the book "Using Sqlite" by Jay

[sqlite] Behavior change in group by in 3.8.2 when compared with 3.7.7

-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 Hello, I am seeing a change in the results returned for a query in SQLIte 3.8.2 version. The query used to return expected results with 3.7.7 and when I updated to 3.8.2, it changed the results. Here is a test case: CREATE TABLE test(name