Re: [sqlite] Basic SQLite/EF6 question

I've no experience of SQLite with .NET/EF6 but... “Could not load file or assembly ‘System.Data.SQLite, Version=1.0.93.0,  Culture=neutral, PublicKey Token=db937bc2d44ff139’ or one of its  dependencies. An attempt was made to load a program with the incorrect  format.” in my experience indicates

Re: [sqlite] Basic SQLite/EF6 question

Joe Mistachkin writes: > > > Steven Davisworth wrote: > > > > I've just upgraded PC to 64bit (new PC) and installed VS2013. I've > followed > > standard install instructions as outlined in web posts I've come across > for > > EF6. I've used Syatem.Data.SQLite.EF6 1.0.93.0 Windows (.NET Fr

Re: [sqlite] Brief intro to SQLite in Python

>A Python programmer was doing a lot of data processing in Python and >wondered whether SQLite could speed it up: > > > >The article and the database needs of the programmer are rather simple, >and the results are unremarkable (fast DBMS

Re: [sqlite] Selecting from view gives bad column information when view name is used in quotes in select statement

On 13 Jul 2014, at 9:45pm, Clemens Ladisch wrote: > But these particular column names do not look as if they were anything > but as bug: > > sqlite> select "TestView"."id", "TestView"."data2" from TestView; > TestViewTestView > -- -- > 1 Miranda I understand your

Re: [sqlite] Selecting from view gives bad column information when view name is used in quotes in select statement

On 2014/07/13 22:45, Clemens Ladisch wrote: RSmith wrote: On 2014/07/11 17:26, Bruce Cowan wrote: When you select columns from a view, the (ADO.NET) DbDataReader that is returned from the execute call does not contain sensible column names There is no contract of which column names should be

[sqlite] Brief intro to SQLite in Python

A Python programmer was doing a lot of data processing in Python and wondered whether SQLite could speed it up: The article and the database needs of the programmer are rather simple, and the results are unremarkable (fast DBMS is fas

Re: [sqlite] Selecting from view gives bad column information when view name is used in quotes in select statement

RSmith wrote: > On 2014/07/11 17:26, Bruce Cowan wrote: >> When you select columns from a view, the (ADO.NET) DbDataReader that is >> returned from the execute call does not contain sensible column names > > There is no contract of which column names should be returned, no > "incorrect" headers and

Re: [sqlite] capturing and testing a hot journal

On 12 Jul 2014, at 9:37am, Charles Parnot wrote: > - the journal file is actually not “hot” and I misunderstood the conditions > that make it hot That one. The files on disk aren't 'hot' (as I think you mean it) while you're in a transaction. Your file system is not pushing journal changes

Re: [sqlite] Selecting from view gives bad column information when view name is used in quotes in select statement

On 13 Jul 2014, at 2:34pm, RSmith wrote: > If you need the returned names to be exactly something specific, then you > need to use the "AS" directive. You can even put the 'AS' into the VIEW: sqlite> .headers ON sqlite> .mode columns sqlite> CREATE TABLE TestA (one TEXT, two TEXT); sqlite> IN

Re: [sqlite] Selecting from view gives bad column information when view name is used in quotes in select statement

On 2014/07/11 17:26, Bruce Cowan wrote: When you select columns from a view, the (ADO.NET) DbDataReader that is returned from the execute call does not contain sensible column names// ...//This problem makes SQLite views completely unusable with ServiceStack.OrmLite version 4.0.23 or newe

Re: [sqlite] sqlite3_open() returns SQLITE_FULL

Probably because the UAC is not allowing changes to files in the folder you are using. Maybe a protected folder, such as a sub-folder of \Program Files\ or \System\? Place the file in a My Documents\ or some other place where access is unrestricted. If this works you know what the problem is, if

Re: [sqlite] Hello, I would like to know the difference between sqlite2 and sqlite3!

Oops, I should have linked to the official site, not my local copy. Corrected below. === > Hello, I would like to know the difference > between sqlite2 and sqlite3!? sqlite2 is deprecated since 2004, not maintained since 2005 and should only be used to convert legacy sqlite2 databases to sqlite

Re: [sqlite] Hello, I would like to know the difference between sqlite2 and sqlite3!

On Sun, 13 Jul 2014 07:23:08 +0800, "ddy is super man" wrote: > Hello, I would like to know the difference > between sqlite2 and sqlite3!? sqlite2 is deprecated since 2004, not maintained since 2005 and should only be used to convert legacy sqlite2 databases to sqlite3. sqlite3 is current and a

Re: [sqlite] capturing and testing a hot journal

On Sat, Jul 12, 2014 at 4:37 AM, Charles Parnot wrote: > Hi all, > > For testing purposes of our application (a Mac app), I am generating what > I thought would be a database with a “hot” journal using this approach (on > an existing database): > > - open the database (and PRAGMA journal_mode = T

[sqlite] capturing and testing a hot journal

Hi all, For testing purposes of our application (a Mac app), I am generating what I thought would be a database with a “hot” journal using this approach (on an existing database): - open the database (and PRAGMA journal_mode = TRUNCATE;) - open a transaction: BEGIN IMMEDIATE TRANSACTION; - add

[sqlite] Selecting from view gives bad column information when view name is used in quotes in select statement

When you select columns from a view, the (ADO.NET) DbDataReader that is returned from the execute call does not contain sensible column names when the select statement specifies "view-name"."column-name" or [view-name].[column-name]. Instead of column names, it just contains the view name for e

Re: [sqlite] trying to get things to work from the command line on windows 7 x64

Jan,  Yes, thank you I see.  the download of the x64 mingw is failing behind my proxy here.  the installer wants to phone home for some repository tool.  is there anyway around that?           OR can I use the 32-bit sqlite?    On Thursday, July 10, 2014 7:47 PM, Jonathan Leslie wro

[sqlite] Hello, I would like to know the difference between sqlite2 and sqlite3!

Hello, I would like to know the difference between sqlite2 and sqlite3!‍ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3_open() returns SQLITE_FULL

OS: Windows XP Disk not full. When logged in as Administrator, sqlite3_open() succeeds. When logged in as another account, sqlite3_open() failed with error SQLITE_FULL. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bi

Re: [sqlite] trying to get things to work from the command line on windows 7 x64

Jan,  Yes, thank you I see.  the download of the x64 mingw is failing behind my proxy here.  the installer wants to phone home for some repository tool.  is there anyway around that?           OR can I use the 32-bit sqlite?    On Thursday, July 10, 2014 5:14 PM, Jan Nijtmans wrote: