Re: [sqlite] Seemingly random Access Violation errors

2012-10-05 Thread Matthew Dumbleton
Joe, I'm afraid this doesn't seem to fix the issue. Just out of interest are you able to run the code I sent on a real device or in an emulator? I'm testing on a Motorola ES400 and didn't initially think to try switching to the emulator which doesn't seem to throw the error (still testing

Re: [sqlite] Sqlite and SQL Server 2005

2012-10-05 Thread Jorge
Thanks I forgot to include coding language (vb) Do you know where can i find a sample code. Thanks Again Sent from my iPhone On Oct 4, 2012, at 4:47 PM, Bart Smissaert bart.smissa...@gmail.com wrote: What is your coding language? If VB then maybe via ODBC and ADO. RBS On Thu, Oct 4,

Re: [sqlite] Sqlite and SQL Server 2005

2012-10-05 Thread Bart Smissaert
To connect to SQLite I recommend the VB wrapper written by Olaf Schmidt: http://www.thecommon.net/ There are plenty of examples to connect to SQL Server with VB, ADO and ODBC. A simple Google search will find them. RBS On 10/5/12, Jorge cotrinago...@yahoo.com wrote: Thanks I forgot to include

Re: [sqlite] Size

2012-10-05 Thread Alami Omar
Thank you for your answer Mr.Simon Davies, but it seems that in a sqlite format 3 file (that i have), the offset 28 value is not valid(not equal to the file size) and surely not equal to offset 92 (00 00 00 00), what i am trying to do, is extract an SQLite Format 3 file from the hex code of

[sqlite] [PATCH] cache the column names in SQLiteDataReader for System.Data.SQLite

2012-10-05 Thread Ashish Kulkarni
Hello, I've attached a patch which caches the column names in SQLiteDataReader. During profiling a scenario where more than 100-200 records are read and columns are accessed by name and not by index -- well over 50% of the time was spent in System.Data.SQLite.SQLite3.ColumnIndex(). The attached

[sqlite] Database Memory Stream

2012-10-05 Thread Chris Sonon
Hello, I am currently developing a program that will use an sqlite database and I would like to know if it is possible to load a database from a memory stream in c#? I would like to house my database in a ZIP file and extract the database to a memory stream and then open it directly from the

Re: [sqlite] [PATCH] cache the column names in SQLiteDataReader for System.Data.SQLite

2012-10-05 Thread Ashish Kulkarni
Don't know why the patch didn't get through, sending again... === diff -ur a\System.Data.SQLite\SQLiteDataReader.cs b\System.Data.SQLite\SQLiteDataReader.cs --- a\System.Data.SQLite\SQLiteDataReader.csSat Aug 11 16:40:46 2012 +++ b\System.Data.SQLite\SQLiteDataReader.csFri Oct 05

Re: [sqlite] Seemingly random Access Violation errors

2012-10-05 Thread Black, Michael (IS)
It would seem to me that if GC.Collect fixes the problem than all you've done is move the problem to someplace else that isn't fatal (at the moment) and could rear its ugly head at most any time. The reason your emulator doesn't throw the error would be for the same reason...different memory

Re: [sqlite] Seemingly random Access Violation errors

2012-10-05 Thread Matthew Dumbleton
Michael, Completely agree with your conclusion the GC.Collect is pretty much a plaster over a severed limb, it's just hiding the problem rather than solving it. Just mentioned it in case that gave Joe any ideas. My code is all c# and the link privided I believe is a c++ only feature. I

Re: [sqlite] interesting deadlock.

2012-10-05 Thread Dan Kennedy
On 10/05/2012 04:29 AM, Jonathan Engle wrote: Ok, so here's a question (trying an experiment to see if this will work, but throwing it out here as well). What if the source db handle for the backup is opened to use private cache? Will this have any effect at all or is it the cache mode of db2

[sqlite] diagrams a la sql server management studio

2012-10-05 Thread Bill Swartz
Hi,   I am looking for a diagramming tool for a sqlite database. I want functionality similar to the diagrammer in sql server management studio. Any suggestions?   Bill ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] [PATCH] cache the column names in SQLiteDataReader for System.Data.SQLite

2012-10-05 Thread Joe Mistachkin
Ashish Kulkarni wrote: Hello, I've attached a patch which caches the column names in SQLiteDataReader. During profiling a scenario where more than 100-200 records are read and columns are accessed by name and not by index -- well over 50% of the time was spent in

Re: [sqlite] Seemingly random Access Violation errors

2012-10-05 Thread Joe Mistachkin
Matthew Dumbleton wrote: I'm afraid this doesn't seem to fix the issue. Odd, it seemed like a disposal race condition. I thought the additional locking semantics would fix it. On the desktop versions of the .NET Framework, there is an actual CriticalHandle class and the necessary

Re: [sqlite] [PATCH] cache the column names in SQLiteDataReader for System.Data.SQLite

2012-10-05 Thread Joe Mistachkin
Joe Mistachkin wrote: Good idea; however, I'm going to implement the column index caching using a Dictionary, which will result in slightly more efficient operation. The changes can be seen here: http://system.data.sqlite.org/index.html/ci/bdd8e44fd0 I'm curious what performance

Re: [sqlite] Database Memory Stream

2012-10-05 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/10/12 05:47, Chris Sonon wrote: I would like to house my database in a ZIP file and extract the database to a memory stream and then open it directly from the memory stream? Is this possible? If so, how? You can get a zipvfs from the SQLite