Re: [sqlite] Working with a new DB every 5 minutes

2009-06-09 Thread Mohit Sindhwani
John Elrick wrote: > Simon Slavin wrote: > >> On 8 Jun 2009, at 8:07pm, Mohit Sindhwani wrote: >> >> >> >>> I'm having a problem that I'm trying to find an elegant solution >>> to. I >>> have a database that stores real-time information - this information >>> is >>> replaced by new

Re: [sqlite] Working with a new DB every 5 minutes

2009-06-09 Thread John Elrick
Simon Slavin wrote: > On 8 Jun 2009, at 8:07pm, Mohit Sindhwani wrote: > > >> I'm having a problem that I'm trying to find an elegant solution >> to. I >> have a database that stores real-time information - this information >> is >> replaced by new values every 5 minutes and has about 30,00

Re: [sqlite] Working with a new DB every 5 minutes

2009-06-08 Thread Simon Slavin
On 8 Jun 2009, at 8:07pm, Mohit Sindhwani wrote: > I'm having a problem that I'm trying to find an elegant solution > to. I > have a database that stores real-time information - this information > is > replaced by new values every 5 minutes and has about 30,000 entries. > Once a new database

Re: [sqlite] Working with a new DB every 5 minutes

2009-06-08 Thread John Elrick
Mohit Sindhwani wrote: > Hi Everyone, > > I'm having a problem that I'm trying to find an elegant solution to. I > have a database that stores real-time information - this information is > replaced by new values every 5 minutes and has about 30,000 entries. > Once a new database is made availa

Re: [sqlite] Working with a new DB every 5 minutes

2009-06-08 Thread Mohit Sindhwani
Pavel Ivanov wrote: >> * Getting rid of the old files - I'm on Windows and would need to see >> the equivalent way of your Unix suggestion. >> > > I don't think you have good options here. One option is to make > continuous retries while remove() returns error. Another option I > believe would

Re: [sqlite] Working with a new DB every 5 minutes

2009-06-08 Thread Pavel Ivanov
> * Getting rid of the old files - I'm on Windows and would need to see > the equivalent way of your Unix suggestion. I don't think you have good options here. One option is to make continuous retries while remove() returns error. Another option I believe would be to change SQLite code to open dat

Re: [sqlite] Working with a new DB every 5 minutes

2009-06-08 Thread Mohit Sindhwani
Pavel Ivanov wrote: > I'd create another special file (maybe even database) that will keep > information about current file that your program should be working > with. So separate process will create new database and then update > this file. And program will just read this file and then work with >

Re: [sqlite] Working with a new DB every 5 minutes

2009-06-08 Thread Pavel Ivanov
I'd create another special file (maybe even database) that will keep information about current file that your program should be working with. So separate process will create new database and then update this file. And program will just read this file and then work with database mentioned in the fil

[sqlite] Working with a new DB every 5 minutes

2009-06-08 Thread Mohit Sindhwani
Hi Everyone, I'm having a problem that I'm trying to find an elegant solution to. I have a database that stores real-time information - this information is replaced by new values every 5 minutes and has about 30,000 entries. Once a new database is made available, I should start using that one