Re: [sqlite] if possible point another table

2014-04-04 Thread Simon Slavin
On 4 Apr 2014, at 7:55am, Darren Duncan dar...@darrenduncan.net wrote: Putting that aside, for any SQL DBMS that supports the PREPARE and EXECUTE keywords, you can have a SQL string value that contains a SQL statement and execute it, and you can build that string in other SQL from your

[sqlite] Can sqlite access storage system directly?

2014-04-04 Thread 김병준
After spend quite long time search for regarding to use file I/O in SQLite, I've found that through the VFS layer is the only way go into the kernel. However I am wandering about if there is other method to detour filesystem, so that SQLite is directly interface with device driver

Re: [sqlite] Can sqlite access storage system directly?

2014-04-04 Thread Stephan Beal
On Fri, Apr 4, 2014 at 10:52 AM, 김병준 bjkm1...@naver.com wrote: filesystem help, but there will be performance gain. ( e.g. From not using Journaling See: http://www.sqlite.org/pragma.html#pragma_journal_mode -- - stephan beal http://wanderinghorse.net/home/stephan/

Re: [sqlite] Can sqlite access storage system directly?

2014-04-04 Thread Richard Hipp
On Fri, Apr 4, 2014 at 4:52 AM, 김병준 bjkm1...@naver.com wrote: After spend quite long time search for regarding to use file I/O in SQLite, I've found that through the VFS layer is the only way go into the kernel. However I am wandering about if there is other method to detour

[sqlite] Database to SQLite Population

2014-04-04 Thread danap
Hello, On working with the MyJSQLView database GUI access tool it has been determined that a local file/memory database would be valuable to perform recurring analysis on datasets from the connected datasource. Sqlite is being considered as the local database. All the underlining code has been

Re: [sqlite] comma-separated string data

2014-04-04 Thread Robert Hairgrove
You need to normalize the database design. -- On Fri, 2014-04-04 at 14:20 -0400, peter korinis wrote: A data column in a link table contains comma-separated string data, where each value represents a value to link to another table. (many-to-many relationship) How do you 'parse' a

[sqlite] comma-separated string data

2014-04-04 Thread peter korinis
A data column in a link table contains comma-separated string data, where each value represents a value to link to another table. (many-to-many relationship) How do you 'parse' a table entry like: 4,66,51,3009,2,678, . to extract these values and use them in an SQL statement, perhaps a WHERE

Re: [sqlite] comma-separated string data

2014-04-04 Thread Clemens Ladisch
peter korinis wrote: A data column in a link table contains comma-separated string data, where each value represents a value to link to another table. (many-to-many relationship) Every time you use non-normalized data ... God kills a kitten. How do you 'parse' a table entry like:

Re: [sqlite] Problem using ICU

2014-04-04 Thread Stadin, Benjamin
Answering to my own question. After some lengthy debugging session I finally figured that it’s a problem with the ICU library which I build with SQLite for iOS. The problem was related to ICU’s obscure loading mechanism. Ben Am 03.04.14 19:37 schrieb Stadin, Benjamin unter

[sqlite] sqlite3 shell man page not installed

2014-04-04 Thread Andy Goth
make install in the SQLite source tree (obtained via Fossil) does not install the sqlite3 shell man page, sqlite3.1. -- Andy Goth | andrew.m.goth/at/gmail/dot/com ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Bug with FTS3 parenthesis and ICU

2014-04-04 Thread Stadin, Benjamin
It seems like that creating a virtual FTS3 table with ICU tokenizer breaks FTS3 parenthesis. Example: SQLITE_ENABLE_FTS3_PARENTHESIS SQLite is of course built with SQLITE_ENABLE_FTS3_PARENTHESIS, ICU, etc. I compile SQLite with ICU for the iPhone with the following flags: . Though I think it

[sqlite] Bug with FTS3 parenthesis and ICU (2)

2014-04-04 Thread Stadin, Benjamin
(Please disregard my first email. I hit the wrong button and sent the email to early.) It seems that creating a virtual FTS3 table with ICU tokenizer breaks FTS3 parenthesis. Example: — Create test table participant CREATE VIRTUAL TABLE 'participant' USING fts4 (tokenize=icu de_DE, firstName,

Re: [sqlite] comma-separated string data

2014-04-04 Thread James K. Lowden
On Fri, 4 Apr 2014 14:20:57 -0400 peter korinis kori...@earthlink.net wrote: How do you 'parse' a table entry like: 4,66,51,3009,2,678, . to extract these values and use them in an SQL statement, perhaps a WHERE id='66'? http://www.schemamania.org/sql/#lists HTH, really. --jkl