Re: [sqlite] compile problem with sqlite 3.7.6.3 on ubuntu

2014-02-27 Thread Nabeel Younus
Hi, I have been able to solve the problem. In shell.c file, I commented out the following part : */* Begin evanm patch. * * extern int sqlite_shell_init_icu();* * if( !sqlite_shell_init_icu() ){* *fprintf(stderr, "%s: warning: couldn't find icudt38.dll; "* *"queries

Re: [sqlite] compile problem with sqlite 3.7.6.3 on ubuntu

2014-02-27 Thread Nabeel Younus
HI, I am bit new to linux. Can u plz exactly specify the statement I need to call before calling make. So far, I first do ./configure (which works ok). Then I perform make (where it fails). Regards, Nabeel On Thu, Feb 27, 2014 at 12:08 PM, mm.w <0xcafef...@gmail.com> wrote: > Hello > > th

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread mm.w
Hello, my bad learning c# on the rock, I feel dirty. Best Regards. On Thu, Feb 27, 2014 at 1:17 PM, mm.w <0xcafef...@gmail.com> wrote: > Hello > > tell him to add a call named close() ... > > but anyway try that: > > var sqliteConnection = null; > using (sqliteConnection = new ... ) { ... } >

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread mm.w
Hello tell him to add a call named close() ... but anyway try that: var sqliteConnection = null; using (sqliteConnection = new ... ) { ... } sqliteConnection = null; // delete or var sqliteConnection = null; using (sqliteConnection = new ... ) { ... } sqliteConnection.Dispose(); sqliteConnect

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread Joe Strommen
The File.Delete call *is* outside the scope using block. Anyhow, I've added a comment to the ticket. It would be great if a dev working on SQLite-LINQ integration gave this a look. Thanks much! On Thu, Feb 27, 2014 at 2:55 PM, mm.w <0xcafef...@gmail.com> wrote: > Hello, > > so then move your

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread mm.w
Hello, so then move your code out of a scoped using block or force the gc at the end before deleting the file anyway what an ugly language! java almost died (google saved it, they should not have), and they did it again! calling that c#, by bad. Best Regards. On Thu, Feb 27, 2014 at 12:50 PM,

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread Joe Strommen
After looking into this further, I think this is the same problem described in ticket aba4549801, which was marked resolved in Sep 2013 ( https://system.data.sqlite.org/index.html/tktview?name=aba4549801) I will add a comment to the ticket to try to get it re-opened. Thanks Joe On Thu, Feb 27,

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread mm.w
Hello, is it the class you use? https://github.com/peterhuene/sqlite-net/blob/master/src/SQLite.cs then extend SQLiteConnection and overwrite public void Dispose () to trace what's happening Best Regards. On Thu, Feb 27, 2014 at 12:33 PM, mm.w <0xcafef...@gmail.com> wrote: > Hello, > > rea

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread mm.w
http://msdn.microsoft.com/en-us/library/system.data.entity.dbcontext(v=vs.113).aspx public class TestContext : DbContext ? On Thu, Feb 27, 2014 at 12:41 PM, Joe Strommen wrote: > To be more specific - the end of the "using (var sqliteConnection = new > SQLiteConnection("Data Source=" + path)

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread Joe Strommen
To be more specific - the end of the "using (var sqliteConnection = new SQLiteConnection("Data Source=" + path))" block will close the connection. I'm not relying on Entity Framework to close the connection for me. On Thu, Feb 27, 2014 at 2:33 PM, mm.w <0xcafef...@gmail.com> wrote: > Hello, >

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread mm.w
Hello, reading quickly the doc "Constructs a new context instance using the existing connection to connect to a database. The connection will not be disposed when the context is disposed ifcontextOwnsConnection is false." base(existingConnection, false) { } Best Regards. On Thu, Feb 27, 2014

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread Joe Strommen
The end of the using() block automatically closes the connection. If I remove the line with "efContext.TestEntities.Count()" then it works fine. On Thu, Feb 27, 2014 at 2:09 PM, mm.w <0xcafef...@gmail.com> wrote: > Hello, > > I don't know anything about c# and the Entity Framework, but somethi

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread mm.w
Hello, I don't know anything about c# and the Entity Framework, but something obvious where do you close your connection? Best Regards. On Wed, Feb 26, 2014 at 11:46 AM, Joe Strommen wrote: > Hi all, >I'm using SQLite with Entity Framework 6 and having a problem. I am > unable to delete

Re: [sqlite] compile problem with sqlite 3.7.6.3 on ubuntu

2014-02-27 Thread mm.w
Hello that's an undefined symbol of some lib/fork "sqlite_shell_init_icu", this is not part of sqlite standard amalgamation, I guess you need to add shell_icu_linux.c from the fork at compile time. Best Regards On Thu, Feb 27, 2014 at 11:35 AM, Nabeel Younus wrote: > HI, > >Thanks for you

Re: [sqlite] compile problem with sqlite 3.7.6.3 on ubuntu

2014-02-27 Thread Nabeel Younus
HI, Thanks for your reply. I have already installed ICU lib i.e. libicu-dev. Waiting for your reply. Regards, Nabeel On Fri, Feb 28, 2014 at 2:56 AM, Richard Hipp wrote: > Maybe you need to install the ICU library on your system. > > > On Wed, Feb 26, 2014 at 10:04 PM, Nabeel You

[sqlite] pragma database_list returns win32 paths on Cygwin

2014-02-27 Thread Jan Nijtmans
Compiling fossil trunk as-is on Cygwin gives: $ ./fossil status repository: /cygdrive/c/fossil/fossil.fossil local-root: /Localdata/workspace/fossil/ .. $ ./fossil sqlite3 SQLite version 3.8.3.1 2014-02-11 14:52:19 Enter ".help" for usage hints. sqlite> .dat

Re: [sqlite] compile problem with sqlite 3.7.6.3 on ubuntu

2014-02-27 Thread Richard Hipp
Maybe you need to install the ICU library on your system. On Wed, Feb 26, 2014 at 10:04 PM, Nabeel Younus wrote: > Hi everyone, > > I am having a problem with compiling sqlite 3.7.6.3 on Linux i686. I > have to use only this version because it has been provided by our clients. > > The *

Re: [sqlite] 'Select' queries via pdo_sqlite are slow

2014-02-27 Thread Simon Slavin
On 26 Feb 2014, at 9:09pm, pihu...@free.fr wrote: > Benchmark (bench.php) on the « $bdd->query(...); » instruction : > Query 2 : select DateMonteeAuPlan, Debut, Fin, Statut from ReportJobs where > NomJob = 'NSAVBASE' and NomChaine like 'DCLC257%' limit 20; > => 0.0002752075195 seconde(s) >

[sqlite] compile problem with sqlite 3.7.6.3 on ubuntu

2014-02-27 Thread Nabeel Younus
Hi everyone, I am having a problem with compiling sqlite 3.7.6.3 on Linux i686. I have to use only this version because it has been provided by our clients. The *sqlite3.7.6.3* folder contains *amalgamation folder, src folder and patches files. * I have changed my directory to *src*

[sqlite] 'Select' queries via pdo_sqlite are slow

2014-02-27 Thread pihug12
Hello! I found out that some 'SELECT' SQL queries are very slow with pdo_sqlite (PHP 5.3 or PHP 5.4). The same query entered in the sqlite3 binary is way faster. Here is my project : http://we.tl/59fGSVnAXh (password : "sqlite-php") - bench.php - chaines_centre.db - inc_func.php - info_job.php

[sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread Joe Strommen
Hi all, I'm using SQLite with Entity Framework 6 and having a problem. I am unable to delete the sqlite file, even though I'm disposing all my disposable objects. Below is a minimal code sample that demonstrates the issue. I'd appreciate any advice/workarounds you can provide. I'm happy to e