"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
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
"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 sql
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 PR
"Ben Smith" <[EMAIL PROTECTED]> wrote in
message
news:[EMAIL PROTECTED]
> if (sqlite3_prepare_v2(db, sql, -1, &init_statement, NULL) !=
> SQLITE_OK) {
>
> int y = 0;
> for(y=0;y<1000;++y){
>
> if (sqlite3_prepare_v2(db, sqltwo, -1, &init_statement, NULL) !=
> SQLITE_OK) {
> }
>
> sqlite3_finalize(i
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 {
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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-us
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.
>
> I
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
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 ins
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, hunspel
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.
por
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
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
>> close
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 interp
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 t
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 statements
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
В сообщении от 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 but
19 matches
Mail list logo
