Re: [sqlite] Online/Hot backup of WAL journalling mode database

On 10 Dec 2014, at 07:35, Dan Kennedy wrote: > Strictly speaking the database file may not be well-formed even if there is > no ongoing checkpoint. If: > > a) process A opens a read transaction, > b) process B opens and commits a write transaction to the database, > c) process C checkpoints

Re: [sqlite] Online/Hot backup of WAL journalling mode database

On 10 Dec 2014, at 02:36, Simon Slavin wrote: > > On 10 Dec 2014, at 12:30am, Nick wrote: > >> That's interesting Simon I didn't expect the database not to be trustworthy. > > The database will be trustworthy at any instant. Your copy of it will be > corrupt because

Re: [sqlite] sqlar

On Wed, Dec 10, 2014 at 3:07 PM, Richard Hipp wrote: > On Wed, Dec 10, 2014 at 4:58 PM, Scott Robison > wrote: > > > In the function add_file it checks if a filename is a directory. If so, > it > > calls opendir, and if successful, loops on readdir. But

Re: [sqlite] sqlar

On Wed, Dec 10, 2014 at 4:58 PM, Scott Robison wrote: > I realize that sqlar is not intended as a production quality tool. That > being said, I was doing some experiments today and encountered a bug (at > least on FreeBSD, not sure if Linux is impacted). > > In the

[sqlite] sqlar

I realize that sqlar is not intended as a production quality tool. That being said, I was doing some experiments today and encountered a bug (at least on FreeBSD, not sure if Linux is impacted). In the function add_file it checks if a filename is a directory. If so, it calls opendir, and if

[sqlite] News typos

I just noticed that the version links for the last two releases at: http://sqlite.org/news.html seem to be cut/paste errors, 3.8.7.3 and 3.8.7.4 both have links to the 3.8.7.2 release. -- Kyle ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] replace many rows with one

On 2014/12/10 13:39, Simon Slavin wrote: Dear folks, A little SQL question for you. The database file concerned is purely for data manipulation at the moment. I can do anything I like to it, even at the schema level, without inconveniencing anyone. I have a TABLE with about 300 million

Re: [sqlite] replace many rows with one

Both, I guess Insert into ... select a,b,sum(theCount) group by a,b; -Ursprüngliche Nachricht- Von: Simon Slavin [mailto:slav...@bigfraud.org] Gesendet: Mittwoch, 10. Dezember 2014 12:39 An: General Discussion of SQLite Database Betreff: [sqlite] replace many rows with one Dear folks,

Re: [sqlite] replace many rows with one

Hi Simon, Am 10.12.2014 12:39, schrieb Simon Slavin: Dear folks, A little SQL question for you. The database file concerned is purely for data manipulation at the moment. I can do anything I like to it, even at the schema level, without inconveniencing anyone. I have a TABLE with about

[sqlite] replace many rows with one

Dear folks, A little SQL question for you. The database file concerned is purely for data manipulation at the moment. I can do anything I like to it, even at the schema level, without inconveniencing anyone. I have a TABLE with about 300 million (sic.) entries in it, as follows: CREATE

Re: [sqlite] Bugreport - slowdown in sqlite after the ANALYZE statement

Thank you very much for the explanation and tips, they are appreciated. Dne 9.12.2014 v 14:30 Richard Hipp napsal(a): > Answered by adding a comment at > https://bugzilla.redhat.com/show_bug.cgi?id=1161844 > > On Tue, Dec 9, 2014 at 6:06 AM, Jan Staněk wrote: > > Hi, > some

Re: [sqlite] seeking advice

Hello, Rene > Hi there, > > I have to store and retrieve up to 2000 parameters. > The parameters can have real and integer values. > The max. change rate is 100ms and the max. duration is up to some hours. > > The simple solution would be to use plain binary files. It's fast but not >