Re: [sqlite] Solving the Sudoku with SQlite 3.8.3 trunk

Hello The SQLite version is 3.8.4 by now and this is stil about the sudoku solving. I studied Norvigs algorithm (Python) http://norvig.com/sudoku.html . It is possible to achieve this method in SQL. A very important difference between Norvigs programme and the SQLite example is however

Re: [sqlite] System.Data.SQLite Deployment Mystery

I have an identical problem. I cannot deploy an app which uses either Net 4.5 or 4.5.1 with the appropriate sqlite dll. It can be fixed by installing the sqlite package on the target computer. -- View this message in context:

Re: [sqlite] Solving the Sudoku with SQlite 3.8.3 trunk

Hi Edzard, I just reproduced your test. Indeed : - you probably blew-up everything running SQL sudoku on this planet : . 'hardest1' in under 2 seconds on my machine, . 'eastermonster1' in 43ms. - with Norvig's method and available SQLite syntax. Each of these feats is jaw-dropping.

Re: [sqlite] Solving the Sudoku with SQlite 3.8.3 trunk

Op 16 mrt 2014, om 16:45 heeft big stone het volgende geschreven: Hi Edzard, I just reproduced your test. Indeed : - you probably blew-up everything running SQL sudoku on this planet : . 'hardest1' in under 2 seconds on my machine, . 'eastermonster1' in 43ms. - with Norvig's method and

[sqlite] Execute Error Notification

I use quite a few script-type sql lists to achieve some functions in some systems, by which I basically mean I make up a list of SQL statements and then just send them to the very convenient sqlite3_exec() function when I'm pretty sure I cannot do it any faster by individual steps or speed is

Re: [sqlite] Solving the Sudoku with SQlite 3.8.3 trunk

Hi again, I confess I have difficulties to diggest your code. >From your experience to reach this success, would you have some hints for SQLite team that would allow the code to become more easy to read and stay performant ? Example : - a non-performant implementation of 'this' required 'that'

Re: [sqlite] Execute Error Notification

On 16 Mar 2014, at 7:16pm, RSmith wrote: > My question is though, is there a way to learn somehow whether a rollback or > constraint violation happened during the whole execute process which caused a > rollback? > > Kind of like saying: "Yes I know the script executed

Re: [sqlite] System.Data.SQLite Deployment Mystery

dpybus wrote: > > I have an identical problem. I cannot deploy an app which uses either Net 4.5 > or 4.5.1 with the appropriate sqlite dll. It can be fixed by installing the > sqlite package on the target computer. > Generally, there are three types of issues with System.Data.SQLite

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

Stefano Ravagni wrote: > > In addiction..what change in backward compatybilities ? I think nothing... > Who use datareader with "while .read do " continue to use in same > waybut many others developer, who use HasRows for check if > datareader has or had records will be gratified to