Re: [sqlite] Why latest places.sqlite from firefox can't be opened by some older versions of sqlite

2013-08-31 Thread Max Vlasov 
On Sat, Aug 31, 2013 at 10:14 PM, Richard Hipp  wrote:
> On Sat, Aug 31, 2013 at 2:03 PM, Max Vlasov  wrote:
>
>> Hi,
>>
>> I noticed that opening places.sqlite of my installation of Firefox
>> can't be made for example with sqlite 3.6.10, it says that file either
>> encrypted or invalid
>
> Recent versions of Firefox use WAL mode (http://www.sqlite.org/wal.html)
> which is supported by SQLite version 3.7.0 and later.
>

Thanks, Richard, that's it. A small suggestion, if it's possible, the
doc mentioned by Slavin could contain additional section after the
main table with conditional format incompatibilities. WAL and latest
partial index support can be mentioned there.

Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Why latest places.sqlite from firefox can't be opened by some older versions of sqlite

2013-08-31 Thread Richard Hipp 
On Sat, Aug 31, 2013 at 2:03 PM, Max Vlasov  wrote:

> Hi,
>
> I noticed that opening places.sqlite of my installation of Firefox
> can't be made for example with sqlite 3.6.10, it says that file either
> encrypted or invalid (everything ok for example with 3.7.15.2 and sure
> firefox itself, it works :)).
>

Recent versions of Firefox use WAL mode (http://www.sqlite.org/wal.html)
which is supported by SQLite version 3.7.0 and later.



>
> This might be a failure of my particular installation so maybe after
> several years of upgrading firefox made my particular db semi-valid or
> something. It's not big deal, just curious, probably ff uses some
> features making sqlite 3 format incompatible with 3.6.* versions
>
> Max
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Why latest places.sqlite from firefox can't be opened by some older versions of sqlite

2013-08-31 Thread Max Vlasov 
Hi,

I noticed that opening places.sqlite of my installation of Firefox
can't be made for example with sqlite 3.6.10, it says that file either
encrypted or invalid (everything ok for example with 3.7.15.2 and sure
firefox itself, it works :)).

This might be a failure of my particular installation so maybe after
several years of upgrading firefox made my particular db semi-valid or
something. It's not big deal, just curious, probably ff uses some
features making sqlite 3 format incompatible with 3.6.* versions

Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users