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
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
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/
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
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
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
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
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:
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
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
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
(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,
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
13 matches
Mail list logo