Re: [sqlite] SQLite3 on iPhone - Memory Issue

2008-07-26 Thread Igor Tandetnik
"Igor Tandetnik" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Ben Smith" <[EMAIL PROTECTED]> wrote in > message > news:[EMAIL PROTECTED] >> I'm using sqlite_reset at end of each loop. > > sqlite3_reset doesn't destroy a statement handle. It just prepares it > for another round of

Re: [sqlite] sqlite + .net cf

2008-07-26 Thread Enrique Ramirez
Have you looked into the ADO.NET provider from http://sqlite.phxsoftware.com/? It also works on the .Net Compact Framework. On Sat, Jul 26, 2008 at 6:09 AM, Tom Lancaster <[EMAIL PROTECTED]> wrote: > Hi, > > i'm considering using sqlite as a replacement for sql server ce in a > mobile device that

Re: [sqlite] SQLite3 on iPhone - Memory Issue

2008-07-26 Thread Igor Tandetnik
"Ben Smith" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm using sqlite_reset at end of each loop. sqlite3_reset doesn't destroy a statement handle. It just prepares it for another round of steps. > My understanding is that's > the same as if I finalized it and setup a new

Re: [sqlite] SQLite3 on iPhone - Memory Issue

2008-07-26 Thread Ben Smith
I'm using sqlite_reset at end of each loop. My understanding is that's the same as if I finalized it and setup a new sqlite3_stmt. Is that not the case? On Sat, Jul 26, 2008 at 1:46 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > "Ben Smith" <[EMAIL PROTECTED]> wrote in > message > news:[EMAIL

Re: [sqlite] SQLite3 on iPhone - Memory Issue

2008-07-26 Thread Igor Tandetnik
"Ben Smith" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > if (sqlite3_prepare_v2(db, sql, -1, _statement, NULL) != > SQLITE_OK) { > > int y = 0; > for(y=0;y<1000;++y){ > > if (sqlite3_prepare_v2(db, sqltwo, -1, _statement, NULL) != > SQLITE_OK) { > } > >

Re: [sqlite] SQLite3 on iPhone - Memory Issue

2008-07-26 Thread Ben Smith
Hi Richard - Here's my proof of concept, if you will. Open xCode, choose new project, choose Window-based application (the most basic) under the iPhone. In your application delegate class replace this method: [code] - (void)applicationDidFinishLaunching:(UIApplication *)application {

Re: [sqlite] FTS statistics and stemming

2008-07-26 Thread Alexey Pechnikov
Hello! Thanks! I think the workaround can be helpful for me. There is a few documents about SQLite FTS extension :-( Best regards, Alexey. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] FTS statistics and stemming

2008-07-26 Thread Stephen Woodbridge
Alexey Pechnikov wrote: > Hello! > > В сообщении от Saturday 26 July 2008 21:37:19 Stephen Woodbridge написал(а): >> I have thought a lot about these issues and would appreciate any >> thoughts or ideas on how to implement any of these concepts or others >> for fuzzy searching and matching. > >

Re: [sqlite] SQLite3 on iPhone - Memory Issue

2008-07-26 Thread D. Richard Hipp
On Jul 26, 2008, at 2:12 PM, Ben Smith wrote: > Hi Folks - > > I have an issue (that others are reporting as well at Apple > discussions); when using the built in SQLite3 library it seems that > finalize and close doesn't actually release all of the memory of a > particular connection. It isn't

[sqlite] SQLite3 on iPhone - Memory Issue

2008-07-26 Thread Ben Smith
Hi Folks - I have an issue (that others are reporting as well at Apple discussions); when using the built in SQLite3 library it seems that finalize and close doesn't actually release all of the memory of a particular connection. It isn't reported as a leak or anything. But if you use

Re: [sqlite] FTS statistics and stemming

2008-07-26 Thread Alexey Pechnikov
Hello! В сообщении от Saturday 26 July 2008 21:37:19 Stephen Woodbridge написал(а): > I have thought a lot about these issues and would appreciate any > thoughts or ideas on how to implement any of these concepts or others > for fuzzy searching and matching. I'm know that ispell, myspell,

Re: [sqlite] FTS statistics and stemming

2008-07-26 Thread Stephen Woodbridge
Alexey Pechnikov wrote: > Hello! > > And how about stemming? Can I'm using ispell, myspell, hunspell? And trigrams? Hello Alexey, There are currently two stemmers available: simple - which just breaks the input into tokens based on spaces and punctuation that is first converted to spaces.

Re: [sqlite] FTS statistics and stemming

2008-07-26 Thread Alexey Pechnikov
Hello! And how about stemming? Can I'm using ispell, myspell, hunspell? And trigrams? Best regards, Alexey. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Severe documentation bug in sqlite3_close leading to crash

2008-07-26 Thread Hartwig Wiesmann
Am 26.07.2008 um 17:21 schrieb Stephen Woodbridge: > Hartwig Wiesmann wrote: >> The latest sqlite3_close(sqlite3*) documentation states: >> >> Applications should finalize all prepared statements and close all >> BLOB handles associated with the sqlite3 object prior to attempting >> to >>

Re: [sqlite] sqite wildcard search with indexing

2008-07-26 Thread CAVALO SCHMIDT
CAVALO SCHMIDT <[EMAIL PROTECTED]> writes: > > Salutations, > > Is it possible to do a simple wildcard/regexp-type search in sqlite > databases, but with indexing? For example, if I want to search for the > string "aCa", we would do only one SELECT * FROM a WHERE a = "aCa", > and it would

Re: [sqlite] Severe documentation bug in sqlite3_close leading to crash

2008-07-26 Thread Stephen Woodbridge
Hartwig Wiesmann wrote: > The latest sqlite3_close(sqlite3*) documentation states: > > Applications should finalize all prepared statements and close all > BLOB handles associated with the sqlite3 object prior to attempting to > close the object. The sqlite3_next_stmt() interface can be used

[sqlite] Severe documentation bug in sqlite3_close leading to crash

2008-07-26 Thread Hartwig Wiesmann
The latest sqlite3_close(sqlite3*) documentation states: Applications should finalize all prepared statements and close all BLOB handles associated with the sqlite3 object prior to attempting to close the object. The sqlite3_next_stmt() interface can be used to locate all prepared

[sqlite] sqlite + .net cf

2008-07-26 Thread Tom Lancaster
Hi, i'm considering using sqlite as a replacement for sql server ce in a mobile device that periodically syncs with a web server. I wish to use sqlite because I will be able to assemble the whole new database for the mobile device on the web server and send it back in its entirety. What I would

Re: [sqlite] Corrupted database repairing

2008-07-26 Thread Alexey Pechnikov
В сообщении от Saturday 26 July 2008 10:23:57 Roger Binns написал(а): > Alexey Pechnikov wrote: > >> Maybe sqlite3_trace() or sqlite3_profile() can help with what you're > >> looking for here. > > Unfortunately sqlite3_trace isn't that useful as it only tells you the > text of the sql statement

Re: [sqlite] Corrupted database repairing

2008-07-26 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alexey Pechnikov wrote: >> Maybe sqlite3_trace() or sqlite3_profile() can help with what you're >> looking for here. Unfortunately sqlite3_trace isn't that useful as it only tells you the text of the sql statement but not any bound parameters. The