[sqlite] ADO.NET Provider, targeting any cpu

ntime ? I did something like this some time ago : 2 classes, one for x86 dll, one for x64 dll, implementing same interface. And at runtime, a function to get the right "native methods class", by trying to load one, and catch "BadImageFormatException", t

Re: [sqlite] ADO.NET Provider, targeting any cpu

2012/5/23 Joe Mistachkin <sql...@mistachkin.com> > > Damien wrote: > > > > Is there a way to have an assembly targeting "any cpu", that chooses by > > itself the right dll to use at runtime ? > > > > The System.Data.SQLite managed-only

Re: [sqlite] ADO.NET Provider, targeting any cpu

Hi, It is working for a classic application. But for a website (or a web application), the directories x86 and x64 should be in the "~/Bin" directory or in "~/" ? Thanks. Damien 2012/5/23 Joe Mistachkin <sql...@mistachkin.com> > > Rob Richardson wrote: > &

[sqlite] System.Data.SQLite and Custom UDF

, unregister it when connections are in a pool, when connection is returned to the pool... Do you think it is possible ? Who should I ask ? Thanks :) Damien ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] SQLite on .NET Standard

Hi, For DotNet core, there is an implementation of sqlite for entity framework. maybe you can dig the dependencies to find the sqlite packages. I remember to have done this some time ago, worked well, but some features missing. Damien Le 23 mai 2017 21:04, "Mark Raymond" <mar

[sqlite] problems with shared cache?

, it's not an issue for us anymore. But I thought it's worth reporting. Have there been any other instances of problems with the shared cache mode? Cheers, Damien ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] problems with shared cache?

ite> select id, count(id) from cards group by id having count(id) > 1; sqlite> Any ideas? On Fri, Mar 20, 2009 at 10:00 AM, Damien Elmes <reso...@ichi2.net> wrote: > Hi all, > > Some of my users have been reporting strange database problems > recently, which seem to have g

Re: [sqlite] problems with shared cache?

Yep - but only the three listed on this page: http://www.sqlite.org/cvstrac/wiki?p=UndoRedo So they shouldn't be modifying anything in the main DB, only the temporary DB. On Fri, Mar 20, 2009 at 3:13 PM, Dan <danielk1...@gmail.com> wrote: > > On Mar 20, 2009, at 8:10 AM, Damien

Re: [sqlite] problems with shared cache?

Well, those 3 x the number of tables in the Db. On Fri, Mar 20, 2009 at 3:17 PM, Damien Elmes <reso...@ichi2.net> wrote: > Yep - but only the three listed on this page: > > http://www.sqlite.org/cvstrac/wiki?p=UndoRedo > > So they shouldn't be modifying anything in the main D

Re: [sqlite] problems with shared cache?

)s .. etc On Fri, Mar 20, 2009 at 8:16 PM, Dan <danielk1...@gmail.com> wrote: > > Does the "undolog" table, or whatever you're using in its place, have > a primary key? > > On Mar 20, 2009, at 1:20 PM, Damien Elmes wrote: > >> Well, those 3 x the number of

Re: [sqlite] problems with shared cache?

Sorry, my application's files are called decks, and I unwittingly used the wrong terminology. Any ideas about the problem? On Sat, Mar 21, 2009 at 2:27 AM, Griggs, Donald wrote: > >> However, when I ask the user to send me their deck, I find that: >>

Re: [sqlite] problems with shared cache?

;>>>> integrity_check >>>>>>>> --- >>>>>>>> ok >>>>>>>> sqlite> select id, count(id) from cards group by id having >>>>>>>> count(id) >>>>>>>>> 1; >>>

Re: [sqlite] problems with shared cache?

allows using multiple nulls for the primary key, but > according to their docs, it is non-standard and it says something > about "this may change in the future".  Maybe you are getting caught > in the middle of a change that is going to occur across multiple > revisions of SQLite. >

[sqlite] Subselects negating benefit of index?

to handle this situation any better than it does at the moment? Cheers, Damien ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Subselects negating benefit of index?

a,b,c, x IIRC firebird is able to use multiple indices on the one table. Is there a reason that sqlite doesn't? Is it too complicated? Don't get me wrong - I find sqlite extremely useful, and I'm just curious as to the reasons why it uses the current design. Cheers, Damien _

Re: [sqlite] Can the page size cause bugs? (was Re: problems with shared cache?)

, and occasionally a once-a-minute timer was firing in that repaint call, which selected from the database. It would be nice if sqlite noticed a query was being run in the progress handler and pointed out the operator error. Cheers, Damien On Fri, Apr 3, 2009 at 8:21 AM, Damien Elmes <reso...@ichi2.

[sqlite] add column creating null columns even with default?

sed older versions of sqlite - is this a known issue that has been fixed in a more recent release? Cheers, Damien ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] add column creating null columns even with default?

a numeric type. Oh, and just to clarify - in the second alter table statement, it should have said: default '' - an error with my copying Cheers, Damien On Fri, May 29, 2009 at 8:40 AM, John Machin <sjmac...@lexicon.net> wrote: > On 29/05/2009 2:53 AM, Simon Slavin wrote: >> On 28

Re: [sqlite] Move to Github!!?

revolution with Fossil! Ironically when I first came across a site called FossHub I actually thought that was an attempt to make a Fossil-based GitHub. Seems that isn't the case after all. Cheers. Damien. -Original Message- From: Richard Hipp Sent: Tuesday, December 26, 2017 1:10 PM

Re: [sqlite] Resources for learning SQLite

from the usage notes and my limited knowledge of MySQL. Cheers. Damien. -Original Message- From: Mike Clark Sent: Thursday, March 29, 2018 6:06 PM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Resources for learning SQLite I suspect there are already threads on this, so

Re: [sqlite] Protecting databases

, there is the possibility that anyone sharing the computer or network may peruse the database when you don't want them to. Kind regards, Damien. -Original Message- From: Darren Duncan Sent: Saturday, October 08, 2016 6:54 AM To: SQLite mailing list Subject: Re: [sqlite] Protecting

[sqlite] Protecting databases

Hi there, My name is Damien Lindley, and I am, among other things, an independent, hobbiest programmer. I have been blind since birth and thus all my computer work relies on screenreader software and keyboard. I have only just come through the brink of scripting into compiled programming and so

Re: [sqlite] Protecting databases

in C. On the other hand, searching is a necessity so it appears that encrypting the data from the application itself is also not an option. So I think at this point I am stuck Cheers. Damien. -Original Message- From: R Smith Sent: Saturday, October 08, 2016 10:02 AM To: sqlite-users

Re: [sqlite] Article about using sqlite3 in Python

a lot of time. Cheers. Damien. -Original Message- From: David Raymond Sent: Monday, October 23, 2017 3:36 PM To: SQLite mailing list Subject: Re: [sqlite] Article about using sqlite3 in Python Basic but good. execute will prepare the statement each time through, whereas executemany