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

2014-02-05 Thread big stone
Hello, APSW looks indeed great for specialised installations. If we wish to have SQLite + Python combination to become "reference choice" in education, I would think that priority list should be : - fixing true problems among those listed in "http://bugs.python.org/; with search the keyword

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

2014-02-05 Thread E.Pasma
Op 1 feb 2014, om 08:29 heeft big stone het volgende geschreven: Maybe Chrismas will be in february this year : http://bugs.python.org/issue20465 Whatever will be the answer from the python team, THANKS a lot Mr Hipp, Mr Kennedy, and Mr Mistachkin for making it possible !

Re: [sqlite] Virtual Table xRowid

2014-02-05 Thread Kevin Martin
On 5 Feb 2014, at 18:40, Dan Kennedy wrote: > But is it the case that your virtual table doesn't handle > anything other than full scans of the entire table contents? If > so, it's probably not a problem if rowids are inconsistent. Thanks for the heads up on the 'or'

Re: [sqlite] Virtual Table xRowid

2014-02-05 Thread Dan Kennedy
On 02/06/2014 01:22 AM, Kevin Martin wrote: Hi, My questions are basically: 1) What causes sqlite3 to call xRowid 2) If I don't want to update my virtual table, or do a select ROWID, can I just use an incremental counter, increased on every call to xNext (bearing in mind the order of my data

[sqlite] Virtual Table xRowid

2014-02-05 Thread Kevin Martin
Hi, My questions are basically: 1) What causes sqlite3 to call xRowid 2) If I don't want to update my virtual table, or do a select ROWID, can I just use an incremental counter, increased on every call to xNext (bearing in mind the order of my data is not guaranteed, so this won't necessarily

Re: [sqlite] mj file loss consequences

2014-02-05 Thread Brett Mcdonald
Understood and most grateful for the quick response. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] mj file loss consequences

2014-02-05 Thread Richard Hipp
On Wed, Feb 5, 2014 at 9:03 AM, Brett Mcdonald wrote: > >The only consequence of losing -mj file is that in a multi-database > >transaction (which can only be in rollback mode, not in WAL mode) if you > >lose power and come back up without the -mj file,

Re: [sqlite] mj file loss consequences

2014-02-05 Thread Brett Mcdonald
>The only consequence of losing -mj file is that in a multi-database >transaction (which can only be in rollback mode, not in WAL mode) if you >lose power and come back up without the -mj file, then the transaction >might commit to some of the database files, but not to others. Are you

Re: [sqlite] mj file loss consequences

2014-02-05 Thread Richard Hipp
On Wed, Feb 5, 2014 at 7:50 AM, Brett Mcdonald wrote: > What are the recovery consequence(s) to a database (journal mode wal) > should a master-journal file be lost? > > Suppose a flash sensitive embedded product had to update its database every > second. To save

[sqlite] mj file loss consequences

2014-02-05 Thread Brett Mcdonald
What are the recovery consequence(s) to a database (journal mode wal) should a master-journal file be lost? Suppose a flash sensitive embedded product had to update its database every second. To save flash wear the database (journal mode delete) is created in ram (e.g. /tmp). Suppose every 8

Re: [sqlite] Database Grammar 101

2014-02-05 Thread Dominique Devienne
On Wed, Feb 5, 2014 at 1:27 PM, Simon Slavin wrote: > On 5 Feb 2014, at 12:08pm, Dominique Devienne wrote: > > Hundreds of new words in French dictionaries for 2014 > > Apologies. Technical distinction due to French being defined by > L'Académie

Re: [sqlite] Database Grammar 101

2014-02-05 Thread Simon Slavin
On 5 Feb 2014, at 12:08pm, Dominique Devienne wrote: > On Sat, Feb 1, 2014 at 3:09 PM, Simon Slavin wrote: > >> But over all, English is an acquisitive (unlike German) evolving (unlike >> French) language. > > Hundreds of new words in French

Re: [sqlite] Database Grammar 101

2014-02-05 Thread Mike King
I've followed this thread with some interest and I think you are all wrong... All discussion should be in English, that's UK English as spoken by us Brits not the bastardisation of our glorious language that is American English. I put it to the list that Colour should be spelt with a U, same for

Re: [sqlite] Database Grammar 101

2014-02-05 Thread Dominique Devienne
On Sat, Feb 1, 2014 at 3:09 PM, Simon Slavin wrote: > But over all, English is an acquisitive (unlike German) evolving (unlike > French) language. > Hundreds of new words in French dictionaries for 2014 (links to other recent years at the bottom):

Re: [sqlite] Database Grammar 101

2014-02-05 Thread Alaric Snell-Pym
On 01/02/14 14:09, Simon Slavin wrote: > > But over all, English is an acquisitive (unlike German) evolving (unlike > French) language. So how about we give it two hundred, two hundred and fifty > years, and see what happens ? > Nah, we should just hold all technical discussions in Lojban,

Re: [sqlite] Understanding transactions

2014-02-05 Thread Dan Kennedy
On 02/04/2014 10:12 PM, Igor Tandetnik wrote: On 2/4/2014 5:23 AM, Yuriy Kaminskiy wrote: How sqlite is supposed to behave when *) there are read-only transaction; *) there are update transaction on other connection; *) cache space is exhausted by update transaction; *) sqlite was not able to

[sqlite] [ANNOUNCEMENT] Updated: sqlite3-3.8.3-2 for Cygwin/Cygwin64

2014-02-05 Thread Jan Nijtmans
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine Changes since 3.8.2-3 = * Updated to upstream 3.8.3 release. Main feature: Added support for CTE (Common Table Expressions) and Recursive