[sqlite] Did A Recent Windows & Update Affect SQLite???

[Alex Mandel]

On 03/31/2015 05:17 PM, Mark Romero wrote:
> Hey Everyone:
> 
> Was there a recent Windows 7 64-bit update that affected SQLite?
> 
> A few months ago one of the programs that I use (Lightroom) started to have
> long periods where it would stop responding. It wouldn't crash, but it
> would just keep my CPU pegged at 100% and the program would stop
> responding. This would happen at random times.
> 
> It never acted like this before, and I think it started acting funny just
> right after a win 7 64-bit automatic update.
> 
> The SLQlite "server" is built into Lightroom, so I have no access to the
> code.
> 
> One thing that is strange is that Adobe has another program (Adobe Camera
> Raw) which is nearly identical to lightroom except that Lightroom uses
> SQLite to store data while Adobe Camera Raw writes information into a
> separate file (an XMP Side Cart file). ACR runs fine, while Lightroom has
> problems.
> 
> So if you know of a recent windows 7 update that may affect SQLite, please
> let me know. maybe there are drivers I can download somewhere to fix the
> problem.
> 
> Thanks in advance.
> 

Do you have trouble using SQlite outside of Lightroom?
If not, then you should pursue this issue with the makers of Lightroom.
SQlite is not a server, nor is it likely to even be in the registry of
windows unless you have the sqlite command line application.

This doesn't rule out that a Windows update caused the issue (it's well
known that such updates can cause issues), however the right place to
start asking questions is the exact software in use.

Thanks,
Alex

Re: [sqlite] Direct PostgreSQL to SQLite connection?

[Alex Mandel]

http://www.gaia-gis.it/OpenLite/
ogr2ogr from gdal.org can probably do it on the command line
Spatialite I think has a Virtual Postgres table tool too.
(You can probably ignore that these are mostly for spatial data, should
work fine on regular tables)

Honestly a small python script to read from sqlite and insert to
Postgres is quite simple, especially if the schema in Postgres already
matches.

Open Sqlite connection
Open Postgres connection
Query Sqlite table
Prepare statement insert to postgres
Close Connections

I would encourage you to keep your working copy in Postgres and use your
SQLite files as archives.

Enjoy,
Alex


On 09/25/2013 11:44 PM, Vivien Malerba wrote:
> Hi!
> 
> Using Libgda (http://www.gnome-db.org) you can create virtual connections
> which "aggregate" several other connections (meaning all the tables from
> all the connections can be used in single SQL queries and you could copy
> data using an "INSERT INTO XXX SELECT ... FROM YYY" query), in your case
> you could aggregate a PostgreSQL and a SQLite connection.
> 
> Hope it helps,
> Regards
> Vivien
> 
> 
> On 25 September 2013 18:45, joe.fis...@tanguaylab.com <
> joe.fis...@tanguaylab.com> wrote:
> 
>> Looking for a solution to connect directly from a PostgreSQL database to a
>> SQLite database. We need PostgreSQL for it's Window/Analytic functions and
>> other features that SQLite doesn't have. Yet, SQLite is great for
>> collecting data.
>>
>> Every one of our experiments adds 300MB to the SQLite database. Rather
>> than exporting to CSV and then importing to PostgreSQL, we'd like to
>> directly access SQLite from PostgreSQL.
>>
>> Does anyone have good experience using 'Foreign Data Wrapper for sqlite'
>> or another method?
>> https://github.com/gleu/**sqlite_fdw 
>>
>>
>> Joe Fisher
>> Oregon State University
>>
>> __**_
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users
>>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 

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

Re: [sqlite] SQlite vs. SQlite3 - a beginners question

[Alex Mandel]

Richard Cooke wrote:
> I'm trying to teach myself PHP and SQLite and I've tried to understand 
> whether SQLite and SQLite3 are the same animal or are they completely 
> different.  I am using WAMP on a PC and the PHP version is 5.31.  If I 
> use sqlite_libversion(); I get a result of 2.8.17.  If I use 
> SQLite3::version() I get 3.6.15.  Does this make sense?
> 
> If they are completely different animals how do you decide on which one 
> to use?
> 
> Thanks,
> 
> RC

Use SQLite3 via PDO. sqlite 2.x is actually quite old at this point and
really shouldn't be used for new development, it there more for
backwards compatibility and maintainability of older apps.

Alex

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

Re: [sqlite] Converting .dbf to SQLite

[Alex Mandel]

Using R might actually be a convenient way to do it all in essentially
one step, and technically batch scriptable.

You'd need the RSQlite add on package, I think dbf reading is built in.

Alex

dave lilley wrote:
> 2009/11/12 Rich Shepard 
> 
>> On Thu, 12 Nov 2009, dave lilley wrote:
>>
>>> Not trying to be silly here but why not write a wee program that reads in
>>> the dbf file and for each row read in write the data into an sql file?
>>   Because I'd have to research the format of the .dbf file and I'd probably
>> be re-inventing the wheel.
>>
> 
> No I mean you use a programming language to read the DBF datafile and write
> out to your new database.
> 
> And as someone else has suggested you use OOo spreadsheet to connect to the
> DBF file and then write it out to a CVS file so you can import into your new
> DB.
> 
> if your not confidant with programming then i strongly suggest you take this
> option as you then only have to import the CVS data into SQLlite.
> 
> Rich
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SUM(tripSeconds) and format output as days.hours:minutes:seconds.hundredths?

[Alex Mandel]

DaleEMoore wrote:
> I'd like to SUM(tripSeconds) and format output as
> days.hours:minutes:seconds.hundredths, but have not been able to figure out
> how to do that with sqlite. This didn't seem to come close:
> 
> SELECT 
> STRFTIME('%d', SUM(tripSeconds)) + '.' +
> STRFTIME('%H', SUM(tripSeconds)) + ':' +
> STRFTIME('%M', SUM(tripSeconds)) + ':' +
> STRFTIME('%f', SUM(tripSeconds)) AS Duration, 
> SUM(tripSeconds)
> 
> Any ideas are appreciated,
> Dale E. Moore

What about something like
SELECT SUM(STRFTIME('%s', tripSeconds)) AS Duration
from table
GROUP BY trip

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

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

[Alex Mandel]

Gilles Ganault wrote:
> On Fri, 23 Oct 2009 12:00:47 +0200, Thibaut Gheysen
>  wrote:
>> You can use sqlite-manager (http://code.google.com/p/sqlite-manager/). 
> 
> Thanks for the tip, but I'd rather a stand-alone rather than a Firefox
> plug-in.
> 

If you have the XUL libraries installed it will run standalone I
believe. Just to check when you are testing these tools, are you also
looking at "Save to CSV" which would be just as good as a copy paste?

There's a reason why a lot of them don't display more than 100-1000
records per view.

You could also try http://www.gaia-gis.it/spatialite/

Alex

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

Re: [sqlite] GUI design & managment tool?

[Alex Mandel]

Allen Fowler wrote:
> Hello,
> 
> Can anyone recommend a Free, or reasonably priced Non-Free, GUI tool for 
> creating and maintaining an SQlite databases that can run on both Windows and 
> Linux?
> 
> (Support for visual relation design would be great, too.)
> 
> I found a list at:
> http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
> 
> But, I was wondering if anyone has personal experience to share...
> 
> Thanks,
> :)
> 

I usually use a UML diagram tool to draw the database to begin with and
run some scripts to convert it to SQL.
I've done it with Dia in the past which has a Dia2Code plugin but have
also heard good things about ArgoUml.

For ongoing management I use Firefox SQLite Manager plugin, and
spatialite-gui.

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

Re: [sqlite] How to install the latest version of sqlite3 on Ubuntu?

[Alex Mandel]

Robert,

1. When you build you want to make sure to override the default
directory settings. ./configure --builddir=/usr/
Check the directions and configure script for options
(make sure to run make clean before you attempt to run make again.)

2. Use Checkinstall, it will build a deb file specific to your system
and install it. Instead of make install

Maybe that will help, FYI I forced the Jaunty deb into Hardy with no
issues, since the dependencies haven't changed.

Alex

Robert Villanoa wrote:
> Thank you very much Dan, because this is exactly the problem.
> I used ldd to check shared library dependencies of the executable file 
> sqlite3 and the result was:
> linux-gate.so.1 =>  (0xb7fc3000)
> libsqlite3.so.0 => /usr/lib/libsqlite3.so.0 (0xb7f4e000)
> libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0xb7f4a000)
> libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0xb7f31000)
> libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0xb7de2000)
> /lib/ld-linux.so.2 (0xb7fc4000)
> However, the file libsqlite3.so.0 from the sqlite3 3.6.14 package is 
> installed to the /usr/local/lib/ folder. I then deleted libsqlite3.so.0 in 
> /user/lib/ and then copied the one from /usr/local/lib/ to /usr/lib/ and I 
> got the correct version of sqlite3.
> Now I wonder is that enough? I mean whether simply copying libsqlite3.so.0 to 
> /usr/lib/ will let me use the new version completely? Or is there any further 
> modifications I must do for me to use sqlite3 3.6.14 'properly'?
> Thank you so much for your help!
> 
> 
> 
> 
> 
> From: Dan 
> To: General Discussion of SQLite Database 
> Sent: Monday, May 18, 2009 4:43:53 PM
> Subject: Re: [sqlite] How to install the latest version of sqlite3 on Ubuntu?
> 
> 
> On May 18, 2009, at 3:33 PM, Robert Villanoa wrote:
> 
>> Thank you for your answer, Jean-Denis.
>> When I type 'which sqlite3', I get the following location:
>> /usr/local/bin/sqlite3
>> And the value of my PATH variable is:
>> /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/ 
>> games
>> So I think the executable file sqlite3 is seen by PATH.
>> Could you please tell me any more suggestions?
> 
> $ ldd /usr/local/bin/sqlite3
> 
> Check it's linking to the correct libsqlite3.so.
> 
> Dan.
> 
> 
>>
>>
>>
>>
>>
>> 
>> From: Jean-Denis Muys 
>> To: General Discussion of SQLite Database 
>> Sent: Monday, May 18, 2009 2:50:38 PM
>> Subject: Re: [sqlite] How to install the latest version of sqlite3  
>> on Ubuntu?
>>
>>
>> On 5/18/09 9:19 AM, "Robert Villanoa"   
>> wrote:
>>
>>> Hi everyone,
>>>
>>> I am new to sqlite3. My OS is Ubuntu 8.04 and it has sqlite3 3.4.2.  
>>> Now I want
>>> to upgrade it to the latest version, 3.6.14, but I don't know how  
>>> to do that.
>>>
>>> Here are the steps I have done (after reading another thread about  
>>> this
>>> issue):
>>> 1. Remove the default version using 'sudo apt-get remove sqlite3'.
>>> 2. Download sqlite-amalgamation-3.6.14.tar.gz, extract the package,  
>>> go to the
>>> sqlite3 directory and run:
>>> - ./configure
>>> - make
>>> - sudo make install
>>> Although I did not encounter any error after executing these above  
>>> commands,
>>> it seemed that I did not install sqlite3 3.6.14 successfully.  
>>> Whenever I type
>>> 'sqlite3' into the GNOME terminal, it shows that the version is  
>>> 3.4.2.
>>> What's wrong with me? Please help! Thanks in advanced!
>> PATH problem? When you type "which sqlite3" in the terminal, what is  
>> the
>> result? Does it match your install location?
>>
>> JD


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

[sqlite] [Fwd: [SpatiaLite-Users] spatialite-2.3.0 has been released]

[Alex Mandel]

 Original Message 
Subject: [SpatiaLite-Users] spatialite-2.3.0 has been released
Date: Tue, 07 Apr 2009 20:27:51 +0200
From: Alessandro Furieri 
Reply-To: spatialite-us...@googlegroups.com
To: spatialite-us...@googlegroups.com


Hi list,

I've just released SpatiaLite v.2.3.0 [stable version]

http://www.gaia-gis.it/spatialite-2.3.0

=

- supporting Routing [VirtualNetwork]

- supporting EXIF GPS pictures

- compatibility support for FDO/OGR RFC16 [VirtualFDO]

- intensive and generalize debugging

- AMALGAMATION: all the stuff put in a single source, as
  SQLite already does
  a complete SpatialDBMS engine in just 2 (two) C sources

- clear separation between the LIB and the TOOLs

- libspatialite-2.3.0 now includes libsqlite; linking
  a single library allow to support a full SpatialDBMS
  engine [some 800KB required]

- now builds on M$ Visual Studio .NET as well



enhanced GUI-tool:

- color SQL syntax
- full DB self-initialization during creation
  [using init_spatialite.sql is no longer required]
- introducing MEMORY-DB ... try and see ...
  ... never seen before something comparable ...


bye, Sandro

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups "SpatiaLite Users" group.
To post to this group, send email to spatialite-us...@googlegroups.com
To unsubscribe from this group, send email to
spatialite-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/spatialite-users?hl=en
-~--~~~~--~~--~--~---

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

Re: [sqlite] designing a db to hold repeating data

[Alex Mandel]

You should talk with Alessandro Furieri a.furi...@lqt.it who is
currently working on adding Raster support to spatialite.
http://www.gaia-gis.it/spatialite/

It may be more efficient to store the data separately in well used
raster formats and attach them to the database as needed for queries.

Alex

P Kishor wrote:
> I have a grid of 1000 x 1000 cells with their own data as well as 20
> years of daily weather data (20 * 365 = 7300 rows) for each contiguous
> group of 50 x 50 cell.
> 
> CREATE TABLE cells (
>   cell_id INTEGER PRIMARY KEY,
>   other cell attributes,
>   lat,
>   lon,
>   met_grid_id INTEGER
> );
> 
> cell_id met_grid_id
> --- 
> 0   0
> 1   0
> ..
> 24990
> 25001
> 25011
> ..
> 49991
> 
> CREATE TABLE met (
>   met_id INTEGER PRIMARY KEY,
>   other met attributes,
>   met_grid_id INTEGER
> );
> 
> met_id met_grid_id
> -- ---
> 0  0
> 1  0
> ..
> 7299   0
> 7300   1
> 7301   1
> ..
> 
> CREATE VIRTUAL TABLE cell_index USING rtree (
>   cell_id INTEGER,
>   minx REAL,
>   maxx REAL,
>   miny REAL,
>   maxy REAL
> )
> 
> The db is about 350 MB with the cell table with 1000,000 rows and the
> met table with 2,920,000 rows and the R*Tree index.
> 
> Is there any other better way that jumps out at any of you?
> 
> 

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

Re: [sqlite] Best GUI?

[Alex Mandel]

Nuno Magalhães wrote:
>> Do you want this for data entry, or developing and managing the database
>> via SQL. I have yet to see a really good front end for data entry
>> although Dabo shows promise as a tool to make good data entry tools.
> 
> Thanks, i'll look into it. I want it as a means to create the inicial
> schema and change it if necessary. Setting up constraints, data types,
> that sort of thing... For random queries i'd probably use the cli and
> for data entry i'll use php.
> 
> Nuno Magalhães
> LU#484677
> ___

Oh that's a different ballpark. I actually use Dia to draw my database
and then use dia2code to generate sql that can be run.
I've seen other variations of the same idea, UML diagram to SQL to code
is the basic idea. Of course most of them have no idea about the data
types for sqlite so you still end up typing out most of it.

Not really sure what you need a GUI for at that stage unless you want it
to baby step you with check boxes about your options. If that's what
you're looking for the firefox plugin is the closest thing I've seen to
that.

FYI- did you consider asking the plugin developer to add tools you think
are useful?

Alex

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

Re: [sqlite] Best GUI?

[Alex Mandel]

Nuno Magalhães wrote:
>> Here lots of  SQLite management tools
>>
>> http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
> 
> Keyword being "lots". I've been to that site, which was what prompted
> me to write in the first place. I'm looking for either web-based or
> *nix. I know there are lots, i just want to know which one(s) you
> recomend and why. I've been using a firefox plugin called SQLite
> Manager but am not happy with it, i'd like more options, something
> similar to Oracle's SQLDeveloper (pref without the Java™) or even
> Access.
> 
> Btw, vi and sh do not qualify as GUI, i have my own tools for that, thanks.
> 
> Nuno Magalhães
> LU#484677

Do you want this for data entry, or developing and managing the database
via SQL. I have yet to see a really good front end for data entry
although Dabo shows promise as a tool to make good data entry tools.

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

Re: [sqlite] Any concept of row number in SQLite?

[Alex Mandel]

P Kishor wrote:
> On Thu, Feb 19, 2009 at 6:54 PM, His Nerdship
>  wrote:
>> Hi,
>> I am converting a program from Paradox (stop laughing, please) to SQLite.
>> Paradox has a useful feature where you can specify the actual index of a row
>> in the table.  This is handy when the table is displayed in a grid and you
>> want the record corresponding to a row in that grid - you can just specify
>> the index, say 28, of that grid row and it will get the record no 28 from
>> the table.  It spares the need for a SELECT statement, and is a lot more
>> efficient.
>> As a SQLite newbie, the only way I can see to do this is to read the whole
>> table with sqlite3_get_table() and then get the required row from the
>> returned array.  This seems overkill when I just want a single record.
> 
> There is the rowid, but I am not sure what you want to do... are you
> expecting a database table to be a linear list of entries? Generally
> one uses a spreadsheet for that kind of stuff. A SQL database doesn't
> have an internal concept of order. You specify a criteria and the db
> returns a SET of rows or records. You can constrain the SET by
> specifying criteria (the WHERE clause), and you can impose an order on
> the returned rows by specifying an ORDER clause.
> 
> If you want just one specific row, just do a
> 
> SELECT cols FROM table WHERE some_primary_key = ?
> 
> If you don't want to specify and control your own primary key, you can
> use the rowid which is something the db uses internally for its own
> shenanigans.
> 
> 
>> Is there a more compact way of doing this?
>> Thanks in advance etc.
>> Sholto
> 
> 
> 

The behavior you want sounds to me like a table is treated as an object,
and the object has a cursor or specific property for each record. It
would make sense if you want to reference a record in this way that you
would need to load the whole table into some type of array or list and
cursor your way to that object.

My guess is the application you used before abstracted the table to an
object in the way that SQL Alchemy turns tables into objects for python.
This is the object oriented programming approach to the issue, the most
efficient sql way would be to do a SELECT statement which for some
reason you don't want to do.

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

Re: [sqlite] SQLite utilty to import XML

[Alex Mandel]

Salles, Joaquim Campos wrote:
> Hello,
> 
> I'm looking for an SQLite utility (Windows / Linux) to import XML files
> into an SQLite Database (free/open source), so I can use it in a shell
> script to periodicly search a directory and import the XML files.
> 
> I tried to find one in:
> 
> http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
> 
> 
> But I didn't find anything I can use.
> 
> Does anyone have any suggestions?
> 
> Thanks for the help,
> 
>  
> 
>  
> 
> Joaquim Salles
> 

I think the firefox SQLite Manager plugin can do XML.
http://code.google.com/p/sqlite-manager/

Alex

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

Re: [sqlite] Recover deleted records

[Alex Mandel]

John Machin wrote:
> On 21/01/2009 7:03 AM, Alex Mandel wrote:
>> Griggs, Donald wrote:
>>> Hi Alex
>>>
>>> I can't answer your specific questions, but I presume you've already
>>> studied the file format document (most recently mentioned by Roger
>>> Binn's recent post):
>>>
>>> http://www.sqlite.org/fileformat.html
>> Yes I did read through that, but I didn't see what I was looking for.
> 
> Have a look at section 3.3.2
> (http://www.sqlite.org/fileformat.html#record_format) and when you get
> to mentions of "variable length integer" and start to wonder what that
> is, read section 3.3.1.
> 
> 
>> Is there a list of binary codes or other delimiters likely to be
>> encountered between records or rows, or is the magic of length of a
>> given record only stored in some coded journal section or index.
>>
>> So far things are looking good using the unix tr command and trying out
>> various filters to remove unneeded characters. I also vacuumed a copy of
>> the database and did a diff against the tr results from that to narrow
>> down where my missing data is in the file.
>>
>> Now I'm just trying to figure out how to slice it into records, which
>> may dependant on me knowing the data really well, the problem I'm
>> running into is that there's no consistent character between two integer
>> fields so it's hard to split them apart.
> 
> Two levels of problem:
> (1) Finding where each record starts
> (2) Unpacking the record into columns
> You would certainly need to write code to do the record unpacking, and
> probably for the record finding as well.
> 
> HTH,
> John

Well I've gotten closer.
I think I have handle on (2) using the struct library in python I can
easily unpack values given a format specified by the first byte of the
record. What I'm still unsure of is how to isolate 1 record in a free
page or how to even find where in the header the free page is.

Any ideas,
Alex
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Recover deleted records

[Alex Mandel]

Griggs, Donald wrote:
> Hi Alex
> 
> I can't answer your specific questions, but I presume you've already
> studied the file format document (most recently mentioned by Roger
> Binn's recent post):
> 
> http://www.sqlite.org/fileformat.html 
> 
Yes I did read through that, but I didn't see what I was looking for.
Is there a list of binary codes or other delimiters likely to be
encountered between records or rows, or is the magic of length of a
given record only stored in some coded journal section or index.

So far things are looking good using the unix tr command and trying out
various filters to remove unneeded characters. I also vacuumed a copy of
the database and did a diff against the tr results from that to narrow
down where my missing data is in the file.

Now I'm just trying to figure out how to slice it into records, which
may dependant on me knowing the data really well, the problem I'm
running into is that there's no consistent character between two integer
fields so it's hard to split them apart.

Thanks,
Alex

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

[sqlite] Recover deleted records

[Alex Mandel]

I was looking through old posts and this one seemed quite similar to my
situation with one exception. I have full knowledge of what data I'm
trying to recover.
http://thread.gmane.org/gmane.comp.db.sqlite.general/35764

The basics, data was deleted from 4 tables via an ODBC connection. No
Vacuum has been done and looking at a copy of the database in a text
editor(Scite) I can see a lot of the data completely intact.

What I don't know is,
1.for the non-ascii characters in the file, what are they and how can I
translate the ones that might have say numeric data in them.(Text
appears to be just text)
2.is there a pattern of line starts/ends or other indicators that would
be useful for me to look for if I'm writing a script to parse the file
back into at least an unformatted text dump?

Is the "deleted" data in the "Free Pages" and is there anything in the
API to interact with data in this area so I could loop over it and
extract pieces one by one?

Any other leads I should be following?

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