[sqlite] FTS3 Unicode support

hi all: I'm working on full text search with sqlite-fts3 on chinese characters. I know that For those wishing to perform full-text searching for non-English text, there is some basic functionality provided via the ICU library. The ICU tokenizer will break words on boundaries as identified by

Re: [sqlite] Insert performance in 3.6.11 vs. 3.5.5

Larry, Thanks for replying. It may not apply to your situation, but I just read about a serious performance regression in certain kernel versions with SQLite inserts, and wondered if you had also done a kernel update as well which may be part of the problem. Check out the bottom graph:

Re: [sqlite] Insert performance in 3.6.11 vs. 3.5.5

Is the page_size the same in both cases? Does the page_size fit the I/O unity of the Compact Flash? (the default is not always optimal) I experimented with setting the page size to 4096 bytes, but apart from increased memory use I did not see any change in performance. For releasing cache

Re: [sqlite] Sqlite3 crashes when using the where command

I checked the two links that were mentioned and they seem to talk about the error- but not sure how they help me fix it. Forgive me- I am relatively new to the unix side of things. A few more pieces of information. Everything worked fine with 3.5.7- not built by me- but a precompiled package.

[sqlite] virtual file system

Dear all, I have a question regarding virtual file systems. I assume I can load my own virtual file system by calling the  c-function sqlite3_vfs_register(...). Am I right that I cannot load a virtual file system by a pragma command or a core function similar to load_extension? I would

Re: [sqlite] virtual file system

As far as I'm aware, sqlite3_vfs_register() is the only way to register your own VFS. Martin Pfeifle wrote: Dear all, I have a question regarding virtual file systems. I assume I can load my own virtual file system by calling the c-function sqlite3_vfs_register(...). Am I right that I

Re: [sqlite] virtual file system

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Martin Pfeifle wrote: I have a question regarding virtual file systems. I assume I can load my own virtual file system by calling the c-function sqlite3_vfs_register(...). That function passes the vfs name and a series of callbacks that implement

Re: [sqlite] virtual file system

Thanks. I appreciate very much, the way I can add my own loadable extension myExtension.dll by simply calling on SQL-level select load_extension(myExtension.dll) without changing anything in C. I wish that I could do this for vfs too. select load_vfs(myVFS.dll) without changing anything in C.

Re: [sqlite] virtual file system

Martin Pfeifle martinpfei...@yahoo.de wrote: Thanks. I appreciate very much, the way I can add my own loadable extension myExtension.dll by simply calling on SQL-level select load_extension(myExtension.dll) without changing anything in C. What do you mean, without changing anything in C?

Re: [sqlite] virtual file system

Maybe I am totally mistaken. Assume I always use the latest sqlite_shell.exe program. I do not want to change anything in this program, then I cannot connect to my virtual file system which is written in C and stored in myExtension.dll. In contrast loadable extensions can be used. For me

Re: [sqlite] virtual file system

Martin Pfeifle martinpfei...@yahoo.de wrote: Maybe I am totally mistaken. Assume I always use the latest sqlite_shell.exe program. I do not want to change anything in this program, then I cannot connect to my virtual file system which is written in C and stored in myExtension.dll. Why? Can't

Re: [sqlite] virtual file system

thank you. This helped me a lot. Best Martin Von: Igor Tandetnik itandet...@mvps.org An: sqlite-users@sqlite.org Gesendet: Donnerstag, den 26. März 2009, 20:55:18 Uhr Betreff: Re: [sqlite] virtual file system Martin Pfeifle martinpfei...@yahoo.de wrote:

[sqlite] Select table name and count(*) on same command

Hello, Exemple of 2 SQL command : sqlite select name from sqlite_master where type='table'; City Country CountryLanguage sqlite_stat1 sqlite select count(*) from country; 239 - Could anyone tell me what is the command to get the following result : Table names nb

Re: [sqlite] Select table name and count(*) on same command

REPKA_Maxime_NeufBox repka.max...@neuf.fr wrote: Exemple of 2 SQL command : sqlite select name from sqlite_master where type='table'; City Country CountryLanguage sqlite_stat1 sqlite select count(*) from country; 239 - Could anyone tell me what is the command to get the

Re: [sqlite] Step Query

On Wed, 25 Mar 2009 18:47:14 -0600, Dennis Cote r.dennis.c...@gmail.com wrote: Kees Nuyt wrote: This seems a very nice addition to the http://www.sqlite.org/cvstrac/wiki?p=SampleCode we already have. I feel tempted to put it in the wiki http://www.sqlite.org/cvstrac/wiki under the

Re: [sqlite] Select table name and count(*) on same command

On Thu, Mar 26, 2009 at 3:18 PM, REPKA_Maxime_NeufBox repka.max...@neuf.fr wrote: Hello, Exemple of 2 SQL command : sqlite select name from sqlite_master where type='table';    City    Country    CountryLanguage    sqlite_stat1 sqlite select count(*) from country;    239 - Could

Re: [sqlite] sql select of varchar text with special chars

anjela patnaik wrote: Hello all, I've a table in oracle that contains fields of type varchar2. In these fields are TCL scripts that contain backslash chars and brackets. Now, I've generated an SQL file from the Oracle table data that contains SQL insert statements. I then use sqlite