Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

I have always wondered why people will insist on using human readable column names (with embedded spaces and special characters) in the implementation layer (SQL code) instead of the presentation layer (user interface). The clutter introduced into queries by having to quote the column names by

Re: [sqlite] Shell tool question

Yes. I'm using several layers of .read files to load the appropriate subset of extensions for each class of process (OLTP, user query, subsystem, specific tools,...) -Ursprüngliche Nachricht- Von: Simon Slavin [mailto:slav...@bigfraud.org] Gesendet: Mittwoch, 21. Jänner 2015 17:35 An:

[sqlite] regarding sqlite3_prepare_v2() func

I have one doubt regarding sqlite code. I have 2 programs-one with sqlite3_exec() included in the code and in other it is not included.I included those files which are zmain.c and zmain1.c respectively. First i created a database and added a table "em" and added some contents to it,then i executed

Re: [sqlite] regarding sqlite3_prepare_v2() func

On 01/22/2015 11:53 AM, Sairam Gaddam wrote: I have one doubt regarding sqlite code. I have 2 programs-one with sqlite3_exec() included in the code and in other it is not included.I included those files which are zmain.c and zmain1.c respectively. First i created a database and added a table

[sqlite] regarding sqlite3_prepare_v2() func

I have one doubt regarding sqlite code. I have 2 programs-one with sqlite3_exec() included in the code and in other it is not included.I included those files which are zmain.c and zmain1.c respectively. First i created a database and added a table "em" and added some contents to it,then i executed

Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

Figured this one out. DeclareTable doesn't like any 'quoting' around the column names in the sql. It works fine with just straight column names. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Mike Nicolino Sent:

Re: [sqlite] excel vba use sqlite

On 22 Jan 2015, at 1:04am, YAN HONG YE wrote: > I don't know how to use sqlite in EXCEL vba? Need I install sqlite connect > driver? Simon. ___ sqlite-users mailing list

[sqlite] excel vba use sqlite

I don't know how to use sqlite in EXCEL vba? Need I install sqlite connect driver? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Shell tool question

On 21 Jan 2015, at 5:15pm, Richard Hipp wrote: > It appears to be, after a quick glance at the code. It uses a new > stack frame for each level of recursion. So if you create a recursion > loop, you'll overflow the stack and segfault. That's great. Thanks for the fast

Re: [sqlite] Shell tool question

On 1/21/15, Simon Slavin wrote: > Quickie: > > In the Shell Tool, is '.read' recursive ? In other words, if I use .read to > read a script and I have .read in a script, will the shell tool finish both > scripts correctly ? It appears to be, after a quick glance at the

[sqlite] Shell tool question

Quickie: In the Shell Tool, is '.read' recursive ? In other words, if I use .read to read a script and I have .read in a script, will the shell tool finish both scripts correctly ? I ran a quick test and I know what I got, but I wanted to be reassured I wasn't just lucky. Simon.

Re: [sqlite] Huge WAL log

Here is my final report. The problem was definitely in indexes. Simply the larger is the index table as compared to the page cache size, the faster growths the WAL log. My solution (all these measures were important): - Drop the index before the bulk insert, create it at the end. - Intermediate

Re: [sqlite] Update Statements using Sub query

thanks Simon -- View this message in context: http://sqlite.1065341.n5.nabble.com/Update-Statements-using-Sub-query-tp80175p80181.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Whish List for 2015

On Mon, Jan 19, 2015 at 2:01 AM, Stefan Keller wrote: > Adding JSON to SQLite (like in PostgreSQL) ultimately needs a > JavaScript parser - and that seems to be against the goal of SQLite > being slim. > It needs a JSON parser, not a JavaScript parser. That's much smaller.