[sqlite] BUG: Tcl sqlite3 command line options (-vfs option)

Hi, I just noticed by code review small and easy to fix bug in -vfs option handling code. sqlite3 Tcl command line syntax is following: sqlite3 HANDLE ?FILENAME ?-vfs VFSNAME? ?-readonly BOOLEAN? ?-create BOOLEAN? ?-nomutex BOOLEAN? ?-fullmutex BOOLEAN? But if -vfs option is in the middle, the

[sqlite] double calculation in SELECT

Hello, I have following SELECT statement in my program (Delphi+sqlite3): _ select id,power, (select sum ((strftime("%s",table2.endtime)-strftime("%s",table2.begintime))*table2.power) from table2 where

Re: [sqlite] How to get started SQLite Encryption Extensions(SEE) in SQLite

On Sun, 4 Oct 2009 12:11:52 +0700, Andi Suhandi wrote: >Hi George, > > >Thanks for the link >(http://www.codeproject.com/KB/database/CppSQLite.aspx) that you gave >me, it really help me to start progamming in C++. > >Ok, read the code in

Re: [sqlite] Phoronix SQLite benchmark Improvements - [was Re: SQLite behaviour on FreeBSD and KVM]

Thanks Roger. I understand aspects of your position. First up, as you imply, there are many cases where people call out that the sqlite tests are invalid. I would like to shore up against that by increasing the number of tests and increasing the system dimension that is tested. The current

Re: [sqlite] How to get started SQLite Encryption Extensions(SEE) in SQLite

Hi Kees, Thanks for your advice, I am understand now. Andi On 10/4/09, Kees Nuyt wrote: > On Sun, 4 Oct 2009 12:11:52 +0700, Andi Suhandi > wrote: > >>Hi George, >> >> >>Thanks for the link >>(http://www.codeproject.com/KB/database/CppSQLite.aspx) that

Re: [sqlite] SQLite performance with lots of data

On Fri, Oct 2, 2009 at 12:34 PM, Cory Nelson wrote: > On Fri, Oct 2, 2009 at 9:45 AM, Francisc Romano wrote: >> Wow. I did not expect such a quick answer... >> Is there somewhere I can read exactly how fast and how big databases SQLite >> can take, please? >

Re: [sqlite] Phoronix SQLite benchmark Improvements - [was Re: SQLite behaviour on FreeBSD and KVM]

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Matthew Tippett wrote: > 'How do I determine what impact the host os/environment has on sqlite'. The very first test should be a sanity check where you do a bunch of inserts each as their own transaction. Each transaction should require calling

Re: [sqlite] Phoronix SQLite benchmark Improvements - [was Re: SQLite behaviour on FreeBSD and KVM]

On 4 Oct 2009, at 7:08pm, Roger Binns wrote: > SQLite is used in Firefox for history and benchmarks. Why not > extrapolate > from the queries in the Firefox source code? Also relevant: HTML5 gives Web JavaScript the ability to do SQL. If I recall correctly both FireFox and WebKit (i.e.

Re: [sqlite] SQLite performance with lots of data

On 4 Oct 2009, at 6:11pm, Cory Nelson wrote: > On Fri, Oct 2, 2009 at 12:34 PM, Cory Nelson > wrote: >> On Fri, Oct 2, 2009 at 9:45 AM, Francisc Romano >> wrote: >>> Wow. I did not expect such a quick answer... >>> Is there somewhere I can read exactly

Re: [sqlite] double calculation in SELECT

--- proxi...@land.ru wrote: From: Michael To: sqlite-users@sqlite.org Subject: [sqlite] double calculation in SELECT Date: Sun, 04 Oct 2009 15:31:47 +0700 Hello, I have following SELECT statement in my program (Delphi+sqlite3):