Re: [sqlite] Recursive query?

On Jan 12, 2014, at 11:02 AM, Darren Duncan dar...@darrenduncan.net wrote: I would expect so; you can't have WITH RECURSIVE without WITH. It’s taking shape: http://www.sqlite.org/src/timeline?r=common-table-exprnd Oh, so, exciting! :) ___

[sqlite] Load spatialite-extension through System.Data.SQLite

Hello System.Data.SQLite-Users, I am trying to use SQLite/Spatialite from a .Net-4.0-Application. To get easy access to SQLite I am using System.Data.SQLite. I try to load version 4.1.1 of Spatialite via the command-text **SELECT load_extension(libspatialite-4.dll) which leads to an Access

[sqlite] [System.Data.SQLite] Load spatialite-extension through System.Data.SQLite

** Sorry, i forgot to add the appropriate tags to the subject ** Hello System.Data.SQLite-Users, I am trying to use SQLite/Spatialite from a .Net-4.0-Application. To get easy access to SQLite I am using System.Data.SQLite. I try to load version 4.1.1 of Spatialite via the command-text

[sqlite] WAL/TCL Question

All, I have a database that I am using with a couple processes that will modify the database at near the same time. So I thought this would be the ideal time to investigate the WAL mode. How do I enable this on the database, and what do I need to watch for when talking to this db after WAL

Re: [sqlite] WAL/TCL Question

On Tue, Jan 14, 2014 at 5:15 PM, Tilsley, Jerry M. jerry.tils...@st-claire.org wrote: All, I have a database that I am using with a couple processes that will modify the database at near the same time. So I thought this would be the ideal time to investigate the WAL mode. How do I enable

Re: [sqlite] WAL/TCL Question

On 1/14/14, Tilsley, Jerry M. jerry.tils...@st-claire.org wrote: I have a database that I am using with a couple processes that will modify the database at near the same time. So I thought this would be the ideal time to investigate the WAL mode. How do I enable this on the database, and

Re: [sqlite] Insert multiple values as an economy of coding time and quicker upload process ?

INSERT INTO t1 SELECT 1 UNION SELECT 2 UNION (...) SELECT ; It works out of the box on any DBMS you care to name, and of course in SQLite, too. It is ever so slightly verbose, but better than the alternative of executing INSERT INTO t1 VALUES(###); Cheers, -Tiago On Mon,

Re: [sqlite] [System.Data.SQLite] Load spatialite-extension throughSystem.Data.SQLite

Markus Dibo wrote: Other users seem to have the same problem: https://groups.google.com/forum/#!topic/spatialite-users/fOb_J8djVP4 It appears that the issue also appears in a completely different ADO.NET provider for SQLite. Also, people report that it does not appear with the previous

[sqlite] SqlAlchemy 0.9 release note complaint

Hello, Reading SQLAlchemy release note, I see a functionality complaint on SQLite. see :http://docs.sqlalchemy.org/en/rel_0_9/changelog/migration_09.html In its last release Note, SQLAlchemy complains that SQLite doesn't allow this : SELECT a.*, b.*, c.* FROM a LEFT OUTER JOIN (b JOIN c ON