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 sq

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

On Thu, Mar 26, 2009 at 3:18 PM, REPKA_Maxime_NeufBox 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 anyone te

Re: [sqlite] Step Query

On Wed, 25 Mar 2009 18:47:14 -0600, Dennis Cote 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 'Hints For U

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

REPKA_Maxime_NeufBox 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 followi

[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

Re: [sqlite] virtual file system

thank you. This helped me a lot. Best Martin Von: Igor Tandetnik An: sqlite-users@sqlite.org Gesendet: Donnerstag, den 26. März 2009, 20:55:18 Uhr Betreff: Re: [sqlite] virtual file system Martin Pfeifle wrote: > Maybe I am totally mistaken. > Assume I alway

Re: [sqlite] virtual file system

Martin Pfeifle 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 you do "select

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 loada

Re: [sqlite] virtual file system

Martin Pfeifle 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? What is myExtensio

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

-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 impleme

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 th

[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 apprecia

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.

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 ca

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 gra

[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 th