Re: [sqlite] DELETE only deletes some records, not others

000|12.0147 1294352264000|12.0148 1294352265000|12.0147 129435228|12.0135 1294352281000|12.0138 1294352282000|12.0133 1294352284000|12.0149 1294352292000|12.014 sqlite> Corey On Sun, Jul 8, 2012 at 12:15 AM, Corey Nelson wrote: > Some bad data found it's way into my database and I&#

Re: [sqlite] DELETE only deletes some records, not others

I tried CASTing price to REAL. Same result. Some get deleted, most don't. See below. Mini:01 corey$ sqlite3 02.fxdb SQLite version 3.7.7 2011-06-25 16:35:41 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> SELECT * FROM GBP_CHF_BID WHERE CAST (price AS REAL) >= 3;

Re: [sqlite] DELETE only deletes some records, not others

Thanks Igor. Yup, it's corrupt. I had already suspected as much so I started writing a little program to read everything and copy to a new database to save what I can. Is there a better way to try and repair? Corey On Sun, Jul 8, 2012 at 5:34 PM, Igor Tandetnik wrote: > Corey Nelso

[sqlite] DELETE only deletes some records, not others

Some bad data found it's way into my database and I'm trying to delete it. But my DELETE command is only deleting some of the records while leaving most as is. See below. The sqlite database file is here . Am I doing something wrong? Is

Re: [sqlite] database file size isn't really very small

TECTED]> wrote: > > On Fri, Jul 18, 2008 at 11:58:16AM -0700, Corey Nelson scratched on the > wall: > >> > sqlite3 Ticks.db ".dump" > >> BEGIN TRANSACTION; > >> CREATE TABLE StockName (date TEXT UNIQUE ON CONFLICT REPLACE, price > REAL); > >

[sqlite] database file size isn't really very small

I'm developing some software that helps with day trading. I need to store years worth of tick prices. At first I was going to write a library that would write and read this information to and from files. Then I thought "don't be silly", this is the sort of thing databases were made for. I have litt