Re: [sqlite] Multi thread access for encrypted database bug

2013-11-04 Thread Fabrizio Steiner
If you are using System.Data.SQLite with the provided Encryption you may run into the same problem as I had. http://www.mail-archive.com/sqlite-users%40sqlite.org/msg66194.html As Richard already clarified, this encryption is not officially supported by the SQLite team and is only there for

Re: [sqlite] SQLite reading old data

2012-05-24 Thread Fabrizio Steiner
m Auftrag von Fabrizio Steiner > Gesendet: Freitag, 16. Dezember 2011 15:49 > An: General Discussion of SQLite Database > Betreff: Re: [sqlite] SQLite reading old data > > Yeah, I see the same two solutions. The first solution would also ensure > currently encrypted databases wil

Re: [sqlite] SQLite reading old data

2011-12-16 Thread Fabrizio Steiner
ens. > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Fabrizio Steiner > Sent: Thursday, December 15, 2011 3:00 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQLite readi

Re: [sqlite] SQLite reading old data

2011-12-15 Thread Fabrizio Steiner
of > minutes and thought I'd throw it out there... > > ~Mike > > -Original Message- > From: sqlite-users-boun...@sqlite.org<mailto:sqlite-users-boun...@sqlite.org> > [mailto:sqlite-users-boun...@sqlite.org]<mailto:[mailto:sqlite-users-boun...@sqlite.org]&

Re: [sqlite] SQLite reading old data

2011-12-15 Thread Fabrizio Steiner
sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] Im Auftrag von Igor Tandetnik > Gesendet: Donnerstag, 15. Dezember 2011 14:26 > An: sqlite-users@sqlite.org > Betreff: Re: [sqlite] SQLite reading old data > > Fabrizio Steiner <f...@bbtsoftware.ch> w

[sqlite] SQLite reading old data

2011-12-15 Thread Fabrizio Steiner
Hello I'm currently facing a problem with the System.Data.SQLite ADO.NET Provider. I'm using stamps (simple integer column) on the rows in order to detect if another user has altered the same datarow during the time the first user started the edit and when he invoked the save. Every update

Re: [sqlite] Unable to retrieve columns with table accessor on nested joins.

2011-12-09 Thread Fabrizio Steiner
o retrieve columns with table accessor on nested > joins. > > On Fri, Dec 09, 2011 at 01:12:26PM +, Fabrizio Steiner scratched on the > wall: > > SELECT t1_title, t2.t2_title, t3.t3_title FROM t1 LEFT JOIN ( t2 INNER > > JOIN t3 ON t2_id = t3_id) ON t1_id = t2.t2_id; > >

Re: [sqlite] Unable to retrieve columns with table accessor on nested joins.

2011-12-09 Thread Fabrizio Steiner
Seems like the patch didn't get through, let's try again. Regards Fabrizio -Ursprüngliche Nachricht- Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] Im Auftrag von Fabrizio Steiner Gesendet: Freitag, 9. Dezember 2011 14:12 An: 'sqlite-users@sqlite.org

[sqlite] Unable to retrieve columns with table accessor on nested joins.

2011-12-09 Thread Fabrizio Steiner
Hello I'm currently facing a problem with nested right hand joins. I've also reported this to the mailing list over one month ago, but haven't received any reply. In the meantime I've investigated the problem in the SQLite source and sorted some things out. Let's first start with an example

[sqlite] Problems with nested Joins

2011-10-20 Thread Fabrizio Steiner
Hello I'm currently evaluating SQLite for replacing a Microsoft Access (Jet) Database in one of our projects. We use a data layer abstraction which allows us to quickly implement other database. Therefore we allow the user of the data acces layer to make arbitrary nested joins. Currently I

[sqlite] Problems with nested Joins

2011-10-19 Thread Fabrizio Steiner
Hello I'm currently evaluating SQLite for replacing a Microsoft Access (Jet) Database in one of our projects. We use a data layer abstraction which allows us to quickly implement other database. Therefore we allow the user of the data acces layer to make arbitrary nested joins. Currently I