Re[2]: [sqlite] SQLite - how to protect the data

>>That's all. >>> >>>Regards, >>> >>>Ulrich >>> >>>- >>>To unsubscribe, send email to [EMAIL PROTECTED] >>>- >>> >>> >>> >> >> JS> - JS> To unsubscribe, send email to [EMAIL PROTECTED] JS> - -- Best regards, Tegmailto:[EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re[2]: [sqlite] BLOB question

"Signature," "File" ") VALUES (?,?);"); BindBlob(1,pMD5,MD5_DIGEST_LENGTH); BindBlob(2,pszFile,static_cast(nLength)); uint32_t nResults; hr = Step(nResults); if( FAILED(hr))

Re[2]: [sqlite] Effect of blobs on performance

Hello drh, You tested under Windows with synchronous=OFF? I mean specifically that way. I've never seen Sqlite trash a DB when I had synchronous turned on even with app crashes. C Thursday, February 22, 2007, 9:56:57 AM, you wrote: dhc> Teg <[EMAIL PROTECTED]> wrote: >> >

Re[2]: [sqlite] Effect of blobs on performance

- dhc> To unsubscribe, send email to [EMAIL PROTECTED] dhc> - I'm pretty sure an application crash even without power failure can corrupt to. At least in my experience. I keep synchronous on and simply use "insert or

Re[2]: [sqlite] Effect of blobs on performance

Hello drh, Thursday, February 22, 2007, 7:54:58 AM, you wrote: dhc> A common use for SQLite is as an application file format. When you do File->>Open, instead of reading and parsing a bunch of dhc> information in a proprietary format, just call sqlite3_open() dhc> on the file instead.

Re[4]: [sqlite] how can i speed up inserts ?

a UPS, corruption wasn't an issue. C Wednesday, February 7, 2007, 12:36:10 PM, you wrote: D> On 2/7/07, Teg <[EMAIL PROTECTED]> wrote: >> >> Hello ohadp, >> >> Well, my experience is, particularly when it's users using it and not >> a personal project, th

Re[2]: [sqlite] how can i speed up inserts ?

gt; >> - >> To unsubscribe, send email to [EMAIL PROTECTED] >> - >> >> >> -- Best regards, Tegmailto:[EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Problems compiling in Windows-32

all people use MS VC++. AJM> A.J.Millan AJM> ZATOR Systems. AJM> - AJM> To unsubscribe, send email to [EMAIL PROTECTED] AJM> ---------

Re[2]: [sqlite] can i dynamically move backward and forward in a record-set ?

a file handles and the read API or by using a pointer. It have JS> not tried using a pointer to such a structure in a list control, but it JS> may be possible. JS> Avoiding using mallocs for dynamic memory allocation makes for less JS> possibility of checkerboarding in long running pr

Re[2]: [sqlite] can i dynamically move backward and forward in a record-set ?

the data. It's not always possible but, if the data sizes permit it, that's what I do. I don't shy away from using 100-200 megs of RAM if that's what the user's asking for. C Monday, January 1, 2007, 12:47:45 PM, you wrote: RB> -BEGIN PGP SIGNED MESSAGE- RB> Hash: SHA1 RB>

Re: [sqlite] can i dynamically move backward and forward in a record-set ?

at when user jumps with the scroll-bar to OEP> item 10,523 i tell the record-set to move to that location. OEP> my other option is to cache it myself, but i'll leave that as a last resort. -- Best regards, Teg

Re[4]: [sqlite] Re: Re: Handling null characters in blob data

nai" <[EMAIL PROTECTED]> SSTC> To: <sqlite-users@sqlite.org> SSTC> Sent: Wednesday, November 15, 2006 2:02 AM SSTC> Subject: RE: Re[2]: [sqlite] Re: Re: Handling null characters in blob data SSTC> Hi Teg, SSTC> Can u please send me the sample code SSTC> Thanks

Re[2]: [sqlite] Re: Re: Handling null characters in blob data

ues. You can't treat them like text though which is what it sounds like you're doing. You really have two choices, encode them as text using something like UU, Mime or Sqlite's built in encoding or used the advanced API calls to bind the binary data as blobs when inserting and retrieving

Re: [sqlite] so many warnings on vc6 with warning level 4

- GR> To unsubscribe, send email to [EMAIL PROTECTED] GR> --------- -- Best regards, Tegmailto:[EMAIL PROTECTED] --

Re: [sqlite] sqlite in MSVC 8

e errors here. I use SQLite 3 under VC6 and VS2005. You know what name mangling is? I might be looking in that direction if it's a linker error. I have a feeling you're going to have to recompile the library. -- Best regards, Teg

Re[2]: [sqlite] High Ascii in path causes database load failures

Hello G., The Dr has solved it. SQlite's looking for UTF8 which is the same as ASCII except in the presence of high order characters. Thanks. C Thursday, October 12, 2006, 9:52:08 AM, you wrote: GRS> On Thu, 2006-10-12 at 13:19 +, [EMAIL PROTECTED] wrote: >> Teg <[EMAIL PROTE

[sqlite] High Ascii in path causes database load failures

Hello sqlite-users, I'm on a US English version of windows XP, latest patches. From time to time my users report that they can't open a database that's clearly sitting there in the file system. I've tracked the problem down to high ascii in the path. For instance D:\DataBoy\GROUPS.DB3 works

Re[2]: [sqlite] filename limit in sqlite_open

you use the unicode versions of the CreateFile functions. The downside of doing that is standard windows tools like Explorer can't delete a file with a name longer than 255 bytes. -- Best regards, Tegmailto:[EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Deadlock with multiple threads

determining where in SQlite the freeze is happening. What happens if you use a global mutex/lock to prevent simultaneous calls to "open"? -- Best regards, Tegmailto:[EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re[2]: [sqlite] reg:blob data reading

Hello Dennis, Monday, September 18, 2006, 11:50:03 AM, you wrote: DJ> Jay Sprenkle wrote: >> On 9/18/06, Teg <[EMAIL PROTECTED]> wrote: >>> Hello Jay, DJ> Everyone has different needs. We like keeping all of the data (blobs DJ> included) in one data file. We als

Re[4]: [sqlite] reg:blob data reading

Hello Jay, Monday, September 18, 2006, 10:05:19 AM, you wrote: JS> On 9/18/06, Teg <[EMAIL PROTECTED]> wrote: >> Hello Jay, >> >> The whole reason I store files in the DB in the first place is to have >> a single "package" to move around and backup when

Re[2]: [sqlite] reg:blob data reading

ries of PNG and JPG files in the DB with meta data describing where the images came from. I like the concept of being able to set an upper limit on the number of retrieved bytes on a blob. I don't see any easy way to do it though. My images files tend to be from 50-500K so

Re[4]: [sqlite] A lillte help adding sqlite to a c program

^ LT> sql = "insert into call_data(direction, LT> call_time)values('details.inout','details.statime)" LT> Do you have any ideas? LT> Lloydie T LT> - Original Message - LT> From: "Teg" <[EMAIL PROTECTED]> LT> To: "Lloyd T

Re[2]: [sqlite] A lillte help adding sqlite to a c program

"; >> str += sqlite3_errmsg(db); >> throw str.c_str(); >> break; >> } >> >> // clean up when finished >> sqlite3_finalize( pStmt ); >> >> sqlite3_close( db ); >> >> >> >> -- >> SqliteImporter and SqliteReplicator: Command line utilities for Sqlite >> http://www.reddawn.net/~jsprenkl/Sqlite >> >> Cthulhu Bucks! >> http://www.cthulhubucks.com >> >> - >> To unsubscribe, send email to [EMAIL PROTECTED] >> - >> LT> - LT> To unsubscribe, send email to [EMAIL PROTECTED] LT> - -- Best regards, Tegmailto:[EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Handling files in sqlite db

> If possible,How it will stores files in tables?In which format? >> > > Please explain me how can i do it. >> > > >> > > Thank you >> > > Sandhya >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > Yes there is. >> > >> > I used Sqlite database browser to import from local file system. The >> > files I imported were of csv kind. >> -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] Avoiding Fragmentation of SQLite database file ???

Hello Jeff, Tuesday, June 13, 2006, 5:01:15 PM, you wrote: JM> On 6/13/06, Teg <[EMAIL PROTECTED]> wrote: JM> >> I'd think allocating the space for the file, then copying the SQLite >> DB to this new file, renaming the old and renaming the new would &g

Re: [sqlite] Avoiding Fragmentation of SQLite database file ???

d a 5G db from one filename to another and it changed from 6700 fragments to 1. -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] reasonable assumptions

lite.org >>>Subject: Re: [sqlite] reasonable assumptions >>> >>>Dave Dyer <[EMAIL PROTECTED]> wrote: >>> >>>>>I think this is a very reasonable assumption. >>>> >>>>It's a lot easier to drive if you assume you're the only &g

Re: [sqlite] First query on database takes forever...?

cally 50-80 MB in size. MG> Any light upon what goes wrong would be much appreciated. :) MG> regards, MG> Mats Gefvert MG> Visionutveckling AB -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] MMAP

nsfer. JS> The system I am replacing was put together on the basis that there were JS> plenty of resources to compensate for each added inefficiency, until one JS> day it did matter - the camel's back eventually broke. JS> JS -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] Inserting image files into a database table

:[EMAIL PROTECTED] >> Sent: Monday, March 27, 2006 2:15 PM >> To: sqlite-users@sqlite.org >> Subject: [sqlite] Inserting image files into a database table >> >> Hi, >> Could someone give me the procedure for inserting images into a database >> table? >> E.g., say I created a table thus: >> create table first_table( picture_name string, picture BLOB); >> >> How do I insert an image into the picture field? >> >> Thanks. >> Srikanth. >> >> >> -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] Performance & database design

. I'll have to do some testing. I thought vector was pretty speedy. JS> Thanks for posting your results! -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re: [sqlite] Open->executeSql->close

on the real table. Maybe write to a separate staging database then combine them every N seconds so, you have the reliability of having the data in the DB without locking the main DB all the time. If you have a crash, the data in the staging DB can still be sent to the main DB on restart. --

Re[2]: [sqlite] Vacuum slow

vacuum to be be slow also but, don't know how to quantify it. -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re: [sqlite] Problems with character '

> Hi Guys NB> I'm having some problems dealing with the character '. Sqlite thinks NB> fair enough that it should terminate the string, which I would like it NB> to avoid. Are there any solutions to my problems. NB> Thanks, Niels -- Best regards, Teg

[sqlite] 3.3.4 Build warnings using VC6

Dr H, Are you interested in all the build warnings I get when I build 3.3.4 under VC6? If so, I'll happily email them to you. A majority of them are size issues with assignment from __int64's to ints and __int64's to longs. C

Re[2]: [sqlite] Keeping prepared statements in the class?

is created. >> dhc> SQLite has no way of knowing that the table you created, modified, dhc> or dropped does not effect existing prepared statement - no way dhc> that is other than preparing them again and comparing the results. dhc> -- dhc> D. Richard Hipp <

Re[2]: [sqlite] sqlite3_exec vs. sqlite3_prepare / sqlite3_step

te Switching to prepare/step has HUGELY reduced the hassle of adding data to a DB. It's the only way I'll do it any more. The problems I was running into was the whole formatting of the data before insertion thing. I was constantly running into cases where what I wanted to insert required escaping so as to

[sqlite] Database is Full error

I have a 15 gig database that I'm trying to "vacuum", the table structure's butt simple but, after running most of the night it tells me "Database is Full". Not sure exactly what that means. I have 24 gigs of disk space free on the disk so, I don't think I ran out. SQlite3.exe is 3.2.2 The

Re[2]: [sqlite] R: [sqlite] Snapshot database creation performance

/decompression. C Tuesday, February 7, 2006, 10:26:02 AM, you wrote: AP> On Tue, Feb 07, 2006 at 08:51:43AM -0500, Teg wrote: >> My application uses compressed data (gzip) but, the tradeoff to small >> data files is exceptionally heavy CPU usage when the data is >> decompressed/compress

Re: [sqlite] R: [sqlite] Snapshot database creation performance

ke you don't necessarily need ALL the CM> facilities of a normal file-system, so you're wondering if perhaps you CM> could implement something more purpose-specific yourself rather than CM> using that ramdisk driver. CM> Interesting, but I don't know the answer. -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] ANN: SQLiteSpy 1.5.1 released

e risk for all the reason CJ> already mentioned. This is probably not the nicest solution, but my CJ> customers tend to be "zero-install" sort of people - ie copy the application CJ> to another machine and hope for the best, so I like an application that CJ> looks after itself.

Re[2]: [sqlite] FILE_FLAG_WRITE_THROUGH for windows in future releases?

it seems your patch dhc> is really just the equivalent of setting synchronous=OFF, dhc> at least on your brand new AMD64 with the SATA disk drives. dhc> -- dhc> D. Richard Hipp <[EMAIL PROTECTED]> -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] FILE_FLAG_WRITE_THROUGH for windows in future releases?

ROUGH flag is added to the code. NB> Otherwise, it seems that NB> FlushFileBuffers really hinders SLQite to a point it NB> becomes unusable. '7 NB> Inserts per seconds' on a brand new AMD64 3500+ with NB> SATA drives is extremely NB> low, and this could be fixed by using this option, NB> IMO. NB> Thanx. NB> __ NB> Do You Yahoo!? NB> Tired of spam? Yahoo! Mail has the best spam protection around NB> http://mail.yahoo.com -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] Save my harddrive!

n> things. n> At 12 rows per second (given a relatively small row), 24hrs of usage n> will n> still be less than the amount of harddrive churning involved in a single n> reboot of your machine. Consider that a fast app can insert about 1 n> million n> rows into a SQLite table in about 15 seconds. n> Robert -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] Slow query after reboot

gt; >> That's not so strange, really. When the app is installed (along with >> the database), the Windows disk cache probably has at least part of >> the database file cached -- afterall it just got finished writing it. >> >> Robert >> >> >> >> >> -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] Database design and SQLite

rent child hierarchy (It does sound like a sqliteized version of XML). C MF> Teg schrieb: >>Hello Marten, >> >>I wasn't suggesting one table for all object, I was suggesting a table >>for objects and a table for object properties. Using the object ID as a way >>

Re[2]: [sqlite] Database design and SQLite

, I'd even expect the performance to be reasonably good. C Monday, January 16, 2006, 5:52:34 AM, you wrote: MF> Just some additional comments: MF> The "vertical" approach (described by Teg) leads also to a very MF> untypical relational MF> database and if a p

Re: [sqlite] Database design and SQLite

. mm> I'm trying to see if I can do this some way I do not mm> currently know how, because the only thing I can think of is some mm> delimited BLOB and recalculate all the parent properties whenever mm> the parent is changed which I imagine may significent

Re: [sqlite] Windows threading help needed. Was: Thread handling in Windows

Hello drh, Your mail server was unhappy about the attachments. C Saturday, January 14, 2006, 9:51:46 AM, you wrote: dhc> Teg <[EMAIL PROTECTED]> wrote: >> >> To me the proper solution would be to avoid using TLS in the first >> place since, you (sqlite) neither cr

Re: [sqlite] Windows threading help needed. Was: Thread handling in Windows

January 14, 2006, 9:51:46 AM, you wrote: dhc> Teg <[EMAIL PROTECTED]> wrote: >> >> To me the proper solution would be to avoid using TLS in the first >> place since, you (sqlite) neither create nor destroy the thread. >> dhc> I'm trying to move in this

Re[2]: [sqlite] Thread handling in Windows

n. Fortunately for us, we DJ> create a fixed number of threads at startup and after that, do not DJ> create nor destroy any threads that use sqlite until shutdown. -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re: [sqlite] Thread handling in Windows

1601: http://www.sqlite.org/cvstrac/tktview?tn=1601 dhc> -- dhc> D. Richard Hipp <[EMAIL PROTECTED]> -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re: [sqlite] Which VC6 options to use for fastest sqlite3?

quot; /D MS> "_WINDOWS" /D "_MBCS" /D "_USRDLL" MS> Is there another C compiler that generates faster executables on MS> windows? MS> Michael -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re: [sqlite] Compiling with Visual Studio 2005

deployment. Easiest solution is to use static linking (/MT rather than TA> /MD); but dynamic linking is the default. Or use a different compiler. TA> I'm not sure that I've nailed every last nuance of this problem, so TA> comments welcome. TA> Tim -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] multiple Db's and journal file time hit?

dhc> some kind of virus scan the first time the journal file is dhc> created. dhc> -- dhc> D. Richard Hipp <[EMAIL PROTECTED]> -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] multiple Db's and journal file time hit?

filer. Then run it again in a debugger examine the regions of code stc> that the profiler flagged as "taking a long time". stc> Black box it: stc> Use "filemon" (win32/64, from www.sysinternals.com) or "strace" on Linux stc> or the equivilent on any other platform. They will timestamp and record stc> all disk access. Have your own program display the exact system stc> timestamps before and after the lengthy operation. Examine the logs to stc> see what is going on. -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] multiple Db's and journal file time hit?

stc> stopped after 12 hours because we completed our tests. stc> We want to buy it but are concerned about the 30-40 second hit. stc> Anyone got an idea what might be going on? stc> Thanks much, stc> Tom Nicholas stc> http://www.thntech.com -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] Threads and locking

t;> > a higher priority and not letting the low priority thread >> back in to >> > finish the transaction and release the lock. >> > >> > Does this sound reasonable and is there a good way of dealing with >> > this situation? Should I try to increase the priority of the >> > background thread when I get a lock? Or is there some way >> to make sure >> > that transactions in the low priority thread are executed >> all at once without interruption? >> > >> > Thanks for your time, >> > >> > -- >> > BP >> > << www.planet-hood.com >> Welcome to our world << >> > >> > >> >> >> -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] Problem with floating point fields, and a feature request

st where f=13.06; -- returns no data DD> Pardon me for throwing a bomb, but no good programmer DD> would ever use = to compare floating point numbers. DD> Choose a more appropriate representation for your data. -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re: [sqlite] Using time and date values

, you wrote: HF> Hi, HF> I am looking for a simple way of using date and time values with HF> sqlite3. I have some Ctime classes (VC++.net) which have to be stored in HF> the database and they should be compared. HF> Anyone has an idea? HF> Henning -- Best regards, Teg

Re: [sqlite] Usability problem with quoted names

double quoted string always mean "column name", AK> and single quoted string stand for 'literal value' AK> Best regards, AK> Alexander AK> mailto:[EMAIL PROTECTED] -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] Can't commit transaction - SQL statements in progress

y way to find out *what* transactions are >>> still operating at the time this error is issued? >>> >>> That would help my debugging efforts greatly. >>> >>> -Eric >>> >> -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re: [sqlite] Re: Probably not simple question

ing. C p> Teg wrote: >> Hello John, >> >> You guys are both going off in you own directions and arguing >> something that's really an unimportant implementation detail. >> Serialization's a wonderful thing, if you need it. It's nothing more >> than a pro

Re[2]: [sqlite] Re: Probably not simple question

a database unless JS> you have need for the facilities supplied by the database? Simple is JS> always better. The idea of storing simple non-variant computational JS> data structures in XML is bizarre. JS> Teg wrote: >> Hello John, >> >> You guys are both going

Re[2]: [sqlite] Re: Probably not simple question

> using this code, etc, etc and then wait for people telling you about >> segfaults). What about the case when stored_doublet will be changed? All >> the data that was prevoiusly stored in blobs will not be valid anymore? >> this case is also handled by boost::serialization >> >>> >>> In practical terms it would be best to choose the byte format used by >>> Intel processors since that would most likely minimize re-ordering. >>> >> >> and, yes, you may save binary data in byte-endianess independent format >> or in processor native format also - you may have this choice with >> boost::serialization >> -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re: [sqlite] Sqlite database to Palm

; I've tried exporting to List format with no luck and I know there are SP> db like MobileDB and PilotSQL. SP> Before diving myself into this challenge, does anyone have any clue SP> on how to start? SP> Thank you very much. -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re: AW: [sqlite] DELETE Statements

n and sqlite3_stmt to the step and the finalize function. The D> prepare function returns SQLITE_DONE and the prepare and finalize functions D> return SQLITE_OK. But the record stays in the Database. D> What do I do wrong? The database isn't opend in any other way during the D> query. D>

Re: [sqlite] Re: Probably not simple question

structure packing enforced). If you think about it, if structure packing isn't the same, you can't really use the "blob as struct" at all can you? C Friday, December 9, 2005, 6:04:35 AM, you wrote: p> Teg wrote: >> Hello Nathan, >> >> Depends on how you access

Re[2]: [sqlite] Speed of a count operation

Dec 08, 2005 at 12:26:44PM -0500, Teg wrote: >> I have a 6.5 gb database with 29,587 records in it. It takes about >> 30-40 seconds for a count to return the first time I specify one in >> "Sqlite3" (seeing this in my program as well). Subsequent "count" >>

[sqlite] Speed of a count operation

Using 3.2.7 I have a 6.5 gb database with 29,587 records in it. It takes about 30-40 seconds for a count to return the first time I specify one in "Sqlite3" (seeing this in my program as well). Subsequent "count" operations are nearly instantaneous even when I exit Sqlite3 and restart. I'm pretty

Re[2]: [sqlite] Probably not simple question

and then reconstituting NK> them. I was concerned about alignment at one point, but it seems to NK> be working without problems. Are there 'gotchas' that are likely to NK> 'get me' in the future? This is server-side, and only for temporary NK> data, so I'm not concerned about the end

Re[2]: [sqlite] how can I import CSV file into SQLite quickly

, >>"3","2","2","1", >>.. >> >>If I use .import,It seems I have to set the variable names manually . >>Is there any way to import the whole data file into SQLite quickly? >>Thank you! >> >>ronggui >> >> >> >> -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re: [sqlite] A newbie question

Tuesday, December 6, 2005, 7:15:25 PM, you wrote: eop> Hi all, eop> so I have a (not) simple question. eop> Is it possible to insert into blob field content of the file? How to = eop> manage it in C++? eop> Regards eop> WojciechW -- Best regards, Tegmailto:[EMAIL PROTECTED]

Re[2]: [sqlite] Database recovery best practice?

Hello drh, That works for me. Thank! C Saturday, December 3, 2005, 11:55:41 AM, you wrote: dhc> Teg <[EMAIL PROTECTED]> wrote: >> Version 3.2.7 >> >> I've got a 7gb damaged database. It's at least partially readable but, >> when I want to vacuum or drop a

[sqlite] Database recovery best practice?

Version 3.2.7 I've got a 7gb damaged database. It's at least partially readable but, when I want to vacuum or drop a table it gives me the "malformed disk image" error. What's the best practice for salvaging this database? ".dump" then import? Thanks --

<    1   2   3