Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

Duncan Hall wrote: > > The db was created by Spatialite and has a fairly lengthy schema. I'm not > sure if I should leave anything out so I'll attach a text file. > Thanks. I've run the schema and query here with the desktop version of SpatiaLite and it does not crash. I suspect the

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

Joe Mistachkin-3 wrote > Are you able to share the schema for your database? It may be helpful. The db was created by Spatialite and has a fairly lengthy schema. I'm not sure if I should leave anything out so I'll attach a text file. schema.txt

Re: [sqlite] Repost: Having problems with Entity Framework code first db creation

Walter Williams wrote: > > I noticed in the configuration of App.config after the packages > are installed, the defaultConnectionFactory refers to > System.Data.Entity.Infrastructure.SqlConnectionFactory, and there is a > provider System.Data.Entity.SqlServer.SqlProviderServices in addition to

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

Duncan Hall wrote: > > 'cmd.CommandText = "SELECT name FROM sqlite_master WHERE type='table'" > cmd.CommandText = "SELECT * FROM idx_Locale_Geometry " > Are you able to share the schema for your database? It may be helpful. -- Joe Mistachkin ___

Re: [sqlite] Possible to get table size (in bytes)?

Thanks to the reference to the sqlite_analyzer. That is very interesting. (And the manual counting of bytes would also help me for my question..) The main question I have is how expensive will adding an fts4aux table be? I noticed the report for a FTS table e.g. NOTES_FTS only shows results

Re: [sqlite] Repost: Having problems with Entity Framework code first db creation

I tried it again with the 1.0.95 NuGet packages (even with a new project), and I get the exact same error. You said EF looks like it is trying to use SQL Server. I noticed in the configuration of App.config after the packages are installed, the defaultConnectionFactory refers to

Re: [sqlite] why does the recursive example sort alphabetically

On 2015/02/04 15:45, Mark Summerfield wrote: Hi, In the documentation on page http://www.sqlite.org/lang_with.html there is an example of a recursive query if you scroll down to the heading "Controlling Depth-First Versus Breadth-First Search Of a Tree Using ORDER BY". The second example

Re: [sqlite] why does the recursive example sort alphabetically

On 2/4/15, Mark Summerfield wrote: > Hi, > > In the documentation on page http://www.sqlite.org/lang_with.html > there is an example of a recursive query if you scroll down to the heading > "Controlling Depth-First Versus Breadth-First Search Of a Tree Using ORDER

[sqlite] why does the recursive example sort alphabetically

Hi, In the documentation on page http://www.sqlite.org/lang_with.html there is an example of a recursive query if you scroll down to the heading "Controlling Depth-First Versus Breadth-First Search Of a Tree Using ORDER BY". The second example under that heading shows how to get a depth-first

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

Thanks for the response I'm developing for a Mobile 5 or 6 device in Visual Studio 2008. I'm porting a project that works fine on the desktop in VS 2012. I have tried the most recent release 1.094 and also 1.095 pre release. I also tried with an old version 1.082 which is working in another app,

[sqlite] [ANN] schemadoc 1.0 - auto-generate your SQLite database schema docu for tables, columns, etc.; incl. themes

Hello, I've put together a command line tool, that is, schemadoc [1] that lets you auto-generate your SQLite database schema docu for tables, columns, etc. The schemadoc tool connects to your SQLite database and writes out the schema info in database.json and also builds an a-z symbol index