Hi,
I have tried PRAGMA key command but it didn't work.
PRAGMA key=
Is there anything else we can try to open the encrypted database?
Thanks,
Navyatha
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of sqlite-users-requ...@sqlite.org
Sent: Monday, October 07, 2013 9:30 PM
To: sqlite-users@sqlite.org
Subject: sqlite-users Digest, Vol 70, Issue 7
Send sqlite-users mailing list submissions to
sqlite-users@sqlite.org
To subscribe or unsubscribe via the World Wide Web, visit
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
or, via email, send a message with subject or body 'help' to
sqlite-users-requ...@sqlite.org
You can reach the person managing the list at
sqlite-users-ow...@sqlite.org
When replying, please edit your Subject line so it is more specific than "Re:
Contents of sqlite-users digest..."
Today's Topics:
1. Re: SQLite4 release date and how to compile on windows
platform (Gabriel Corneanu)
2. Re: Tool for extracting deleted data from unvacuumed SQLite
files (James K. Lowden)
3. Re: Tool for extracting deleted data from unvacuumed SQLite
files (Paul L Daniels)
4. How to run sqlite just in memory - pragma cache_size issue
(Kf Lee)
5. Execute scripts on SQLITE password protected database
(Navyatha Ummineni)
6. Re: Execute scripts on SQLITE password protected database
(Simon Slavin)
7. updating using a value from another table (dean gwilliam)
8. Re: updating using a value from another table (Rob Richardson)
9. Re: updating using a value from another table (Simon Slavin)
10. Re: updating using a value from another table (dean gwilliam)
11. Re: updating using a value from another table (Rob Richardson)
12. Re: updating using a value from another table (Simon Slavin)
13. Re: updating using a value from another table (dean gwilliam)
14. Re: updating using a value from another table (dean gwilliam)
--
Message: 1
Date: Sun, 06 Oct 2013 18:34:18 +0200
From: Gabriel Corneanu
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] SQLite4 release date and how to compile on
windows platform
Message-ID: <5251910a.8020...@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Simon,
I have asked several times similar questions, and got similar replies.
This answer is simply NOT correct.
While I understand nobody wants to commit to a release/stable version, I really
wanted to evaluate how it fits my needs.
Therefore I took some time to understand how could I compile it.
I found the unpleasant truth: at this time (ok, a few weeks ago) Windows is not
supported at all.
The file lsm_unix.c is not ported to Windows (contains low level file access,
shared memory, memory mapped files, etc).
Regards,
Gabriel
--
Message: 2
Date: Sun, 6 Oct 2013 17:31:54 -0400
From: "James K. Lowden"
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Tool for extracting deleted data from unvacuumed
SQLite files
Message-ID: <20131006173154.139cf171.jklow...@schemamania.org>
Content-Type: text/plain; charset=US-ASCII
On Sun, 6 Oct 2013 22:58:28 +1000
Paul L Daniels wrote:
> "Undark" is only at v0.2 at this time, it's still quite coarse
> around some corners and it does not differentiate between
> deleted and undeleted rows. It also has a limitation of only
> decoding what it finds within the SQLite page (ie, 4K in most
> cases), if the row extends beyond the page the data won't be
> retrieved ( I am working on this for v0.3 ), finally, it
> doesn't decode or dump BLOB data yet, simply not sure how to
> represent that sanely on a CSV dump.
If Undark decodes the metadata, it might be more useful to create a new
database instead of a CSV file. The new database would be a mirror of the
input, except that its tables would hold deleted rows (or both deleted and
extant, with a column signifying which).
That way no information is lost, re-insertion is simple, and representation
questions are mooted.
--jkl
--
Message: 3
Date: Mon, 7 Oct 2013 10:11:47 +1000
From: Paul L Daniels
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Tool for extracting deleted data from unvacuumed
SQLite files
Message-ID: <20131007101147.4310b...@pldaniels.com>
Content-Type: text/plain; charset=US-ASCII
> If Undark decodes the metadata, it might be more useful to create a
> new database instead of a CSV file. The new database would be a
> mirror of the input, except that its tables would hold deleted rows
> (or both deleted and extant, with a column signifying which).
I may look in to adding such a featu