[sqlite] :memory: + attach WAL?

2017-01-21 Thread Tim Uy
Hi, I currently start a :memory: database and then attach a physical database and then set wal mode by using PRAGMA mydb.journal_mode=WAL 1. Is this safe? (I noticed default is 'delete') 2. Can I do it automatically with the ATTACH? So I don't have to wait 150 ms for the WAL PRAGMA statement? ___

[sqlite] System.Data.SQLite version 1.0.100.0 released

2016-04-15 Thread Tim Uy
that is a lot of 1s and 0s. On Fri, Apr 15, 2016 at 10:42 AM, Joe Mistachkin wrote: > > System.Data.SQLite version 1.0.100.0 (with SQLite 3.12.1) is now available > on the System.Data.SQLite website: > > https://system.data.sqlite.org/ > > Further information about this release can be seen

[sqlite] compiling 3.11.1

2016-03-10 Thread Tim Uy
found it - old copy of cerod slipped into my sqlite3.c! On Wed, Mar 9, 2016 at 10:44 PM, Tim Uy wrote: > yup must be just me, it works fine on a clean fossil clone > > On Wed, Mar 9, 2016 at 10:15 PM, Tim Uy wrote: > >> It is probably just something I mangled - but oddly my

[sqlite] compiling 3.11.1

2016-03-09 Thread Tim Uy
yup must be just me, it works fine on a clean fossil clone On Wed, Mar 9, 2016 at 10:15 PM, Tim Uy wrote: > It is probably just something I mangled - but oddly my tsrc/fts5.c has no > trace of sqlite3PagerGet and no more than 2 or so lines. > > On Wed, Mar 9, 2016 at 10:07 PM, T

[sqlite] compiling 3.11.1

2016-03-09 Thread Tim Uy
It is probably just something I mangled - but oddly my tsrc/fts5.c has no trace of sqlite3PagerGet and no more than 2 or so lines. On Wed, Mar 9, 2016 at 10:07 PM, Tim Uy wrote: > I'm getting > > tsrc/fts5.c(23549): error C2198: 'sqlite3PagerGet': too few arguments

[sqlite] compiling 3.11.1

2016-03-09 Thread Tim Uy
I'm getting tsrc/fts5.c(23549): error C2198: 'sqlite3PagerGet': too few arguments for call tsrc/fts5.c(23568): error C2198: 'sqlite3PagerGet': too few arguments for call What am I missing? :P

[sqlite] <> in Makefile.msc

2016-03-09 Thread Tim Uy
What does <> <> mean in Makefile.msc? Just noticed it.

[sqlite] ICU and FTS5

2016-03-09 Thread Tim Uy
Will the ICU tokenizer work with FTS5, or does some work need to be done to port it over (slight pun intended).

[sqlite] attach db limit

2016-03-04 Thread Tim Uy
lite.org/c3ref/limit.html>(db, SQLITE_LIMIT_ATTACHED <https://www.sqlite.org/c3ref/c_limit_attached.html#sqlitelimitattached>,size) interface." On Fri, Mar 4, 2016 at 8:11 AM, Tim Uy wrote: > Well, probably only like a dozen, no worries. > > On Fri, Mar 4, 2016 at 8:07 AM,

[sqlite] attach db limit

2016-03-04 Thread Tim Uy
Well, probably only like a dozen, no worries. On Fri, Mar 4, 2016 at 8:07 AM, Simon Slavin wrote: > > On 4 Mar 2016, at 4:02pm, Tim Uy wrote: > > > So Richard, theoretically, if you use negative numbers, you can get > another > > x2? > > Tim, > > are you ac

[sqlite] attach db limit

2016-03-04 Thread Tim Uy
(or use unsigned) On Fri, Mar 4, 2016 at 8:02 AM, Tim Uy wrote: > So Richard, theoretically, if you use negative numbers, you can get > another x2? > > On Thu, Mar 3, 2016 at 2:07 PM, Tim Uy wrote: > >> (Thanks Richard for the explanation of "main" and "te

[sqlite] attach db limit

2016-03-04 Thread Tim Uy
So Richard, theoretically, if you use negative numbers, you can get another x2? On Thu, Mar 3, 2016 at 2:07 PM, Tim Uy wrote: > (Thanks Richard for the explanation of "main" and "temp".) > > On Thu, Mar 3, 2016 at 2:02 PM, Tim Uy wrote: > >> So comme

[sqlite] attach db limit

2016-03-03 Thread Tim Uy
(Thanks Richard for the explanation of "main" and "temp".) On Thu, Mar 3, 2016 at 2:02 PM, Tim Uy wrote: > So comment in sqliteLimit just needs an update? > > On Thu, Mar 3, 2016 at 1:20 PM, Richard Hipp wrote: > >> On 3/3/16, John McKown wrote:

[sqlite] attach db limit

2016-03-03 Thread Tim Uy
So comment in sqliteLimit just needs an update? On Thu, Mar 3, 2016 at 1:20 PM, Richard Hipp wrote: > On 3/3/16, John McKown wrote: > > Why 125 would be a good question. > > The maximum value of an signed 8-bit integer is 127. Take away two > for the "main" and "temp" databases. > > -- > D. R

[sqlite] attach db limit

2016-03-03 Thread Tim Uy
Hi, I see that there is a default limit of 10 attached databases. And from the docs, 125 is limit. However, in the file sqliteLimit.h it says /* ** The maximum number of attached databases. This must be between 0 ** and 62. The upper bound on 62 is because a 64-bit integer bitmap ** is used inte

[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Tim Uy
Exactly. How does this happen? On Tue, Nov 10, 2015 at 3:31 PM, Jay Kreibich wrote: > > > On Nov 10, 2015, at 2:45 PM, Warren Young wrote: > > > >> On Nov 10, 2015, at 1:29 PM, Rousselot, Richard A < > Richard.A.Rousselot at centurylink.com> wrote: > >> > >> What no love for their own Access DB