Re: [sqlite] Support EXTRACT SQL standard function

Roger Andersson wrote: > On 02/12/12 20:34, Yuriy Kaminskiy wrote: >> I wonder, how it will be handled if you issue such request at >> month/year/... >> change (23:59.59.999 GMT -> 00:00:00.000 GMT)? >> Is timestamp for current_date/current_time generated once and cached >> at start of >> SELECT

Re: [sqlite] Support EXTRACT SQL standard function

On 02/12/12 20:34, Yuriy Kaminskiy wrote: I wonder, how it will be handled if you issue such request at month/year/... change (23:59.59.999 GMT -> 00:00:00.000 GMT)? Is timestamp for current_date/current_time generated once and cached at start of SELECT evaluation? It is certainly *not* cached

Re: [sqlite] Commit method not available

Thanks! - Original Message - From: "Joe Mistachkin" To: "'General Discussion of SQLite Database'" Sent: Sunday, February 12, 2012 1:40 PM Subject: Re: [sqlite] Commit method not available Kyle Cashion wrote: What am I missing?

Re: [sqlite] freelist_count - can it shrink back?

On 11 Feb 2012, at 10:06pm, Orit Alul wrote: > When deleting from sqlite, the freed space is added to the free_list count. > My question is, when I insert new data, is the needed space allocated out of > the free_list or do the db file grows larger and the free space stays till > vacuum

Re: [sqlite] Commit method not available

Kyle Cashion wrote: > > What am I missing? > You'll want to capture the return value of the SQLiteConnection.BeginTransaction method (which is the actual transaction) and then use the Commit and/or Rollback methods of that [SQLiteTransaction] object. -- Joe Mistachkin

Re: [sqlite] Support EXTRACT SQL standard function

Roger Andersson wrote: > On 02/11/12 15:22, Kit wrote: >> 2012/2/10 Willian Gustavo >> Veiga: >>> SQLite is a great database to unit test (TDD) applications. You can >>> run it >>> in memory with your tests ... >>> >>> I've found a problem when I was unit testing my application.

Re: [sqlite] SQLite extensions repository

Developers support a private repositories usually. As example: http://sqlite.mobigroup.ru/wiki?name=extensions http://sqlite.mobigroup.ru/wiki?name=utils 2012/2/12 Marco Bambini : > Hello, > I am wondering if there is there a place that collect all available sqlite >

[sqlite] Commit method not available

I'm using the drivers from sqlite-netFx40-setup-bundle-x86-2010-1.0.79.0.exe in VS2010, .NET 4. Connection.BeginTransaction is available as a method, but Connection.Commit is not, nor is Connection.Rollback. What am I missing? ___ sqlite-users

Re: [sqlite] opening places.sqlite from Firefox (10.0.1) profile qAdmin Cannot perform on closed dataset

Am 11.02.2012 13:47, schrieb Richard Hipp: On Sat, Feb 11, 2012 at 4:56 AM, Christoph Kukulieswrote: I'm trying to open some Firefox files that are located in the profiles directory using Sqlite admin (http://sqliteadmin.orbmu2k.**de/). I'm

Re: [sqlite] SQLite extensions repository

On 12-02-2012 19:48, Marco Bambini wrote: > Hello, > I am wondering if there is there a place that collect all available sqlite > extensions. > > Please let me know. > Thanks. http://www.sqlite.org/contrib looks like a good place for it ;) ___

Re: [sqlite] Usage of sqlite3_db_release_memory

On Sat, Feb 11, 2012 at 11:50 AM, Rittick Gupta wrote: > What memory does the sqlite3_db_release_memory call release from the heap. > Cache memory, holding disk content that might possibly be reused in the future but that is not currently in use. > Is it required that this

[sqlite] SQLite extensions repository

Hello, I am wondering if there is there a place that collect all available sqlite extensions. Please let me know. Thanks. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] freelist_count - can it shrink back?

Hi, Continuing the following thread, I'd like to explain my question better: http://www.mail-archive.com/sqlite-users@sqlite.org/msg67668.html When deleting from sqlite, the freed space is added to the free_list count. My question is, when I insert new data, is the needed space allocated out of

[sqlite] Usage of sqlite3_db_release_memory

What memory does the sqlite3_db_release_memory call release from the heap. Is it required that this call be made frequently to free up space which is no longer used ? Is it applicable in a shared cache environment ? Will appreciate a response. ___

Re: [sqlite] SQLite libraries

On 12-02-2012 19:15, Steinar Midtskogen wrote: > Hello > > Has anyone collected a library of extensions to SQLite, such as useful > aggregate functions, modules, etc? > > There is http://www.sqlite.org/contrib and extension-functions.c, but > is there more out there? > You can Google for:

[sqlite] SQLite libraries

Hello Has anyone collected a library of extensions to SQLite, such as useful aggregate functions, modules, etc? There is http://www.sqlite.org/contrib and extension-functions.c, but is there more out there? -- Steinar ___ sqlite-users mailing list

[sqlite] Tiny correction

Hello, It seems that the icuFunctionError can be simplified: char zBuf[128]; sqlite3_snprintf(128, zBuf, "ICU error: %s(): %s", zName, u_errorName(e)); zBuf[127] = '\0'; // <- useless In the documentation: "As long as the buffer size is greater than zero, sqlite3_snprintf() guarantees that

Re: [sqlite] Support EXTRACT SQL standard function

On 02/11/12 15:22, Kit wrote: 2012/2/10 Willian Gustavo Veiga: SQLite is a great database to unit test (TDD) applications. You can run it in memory with your tests ... I've found a problem when I was unit testing my application. MySQL (production database) supports EXTRACT