-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 way
В сообщении от 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 not any
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
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
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 to
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 interpret C as any
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 the object.
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
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.
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, hunspell
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
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
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'm know
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
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 {
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;y1000;++y){
if (sqlite3_prepare_v2(db, sqltwo, -1, init_statement, NULL) !=
SQLITE_OK) {
}
sqlite3_finalize(init_statement);
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 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 steps.
My understanding is that's
the same as if I finalized it and setup a new
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
19 matches
Mail list logo