Re: Dumping all the sql statements as backup

2012-08-30 Thread Robert Miles
On 7/25/2012 8:56 AM, andrea crotti wrote: I have some long running processes that do very long simulations which at the end need to write things on a database. At the moment sometimes there are network problems and we end up with half the data on the database. The half-data problem is

Re: Dumping all the sql statements as backup

2012-08-30 Thread Jason Friedman
I have some long running processes that do very long simulations which at the end need to write things on a database. At the moment sometimes there are network problems and we end up with half the data on the database. The half-data problem is probably solved easily with sessions and

Dumping all the sql statements as backup

2012-07-25 Thread andrea crotti
I have some long running processes that do very long simulations which at the end need to write things on a database. At the moment sometimes there are network problems and we end up with half the data on the database. The half-data problem is probably solved easily with sessions and sqlalchemy

Re: Dumping all the sql statements as backup

2012-07-25 Thread Jack
On 07/25/2012 09:56 AM, andrea crotti wrote: I have some long running processes that do very long simulations which at the end need to write things on a database. At the moment sometimes there are network problems and we end up with half the data on the database. The half-data problem is

Re: Dumping all the sql statements as backup

2012-07-25 Thread andrea crotti
2012/7/25 Jack tdl...@gmail.com Since you know the content of what the sql code is, why not just build the sql file(s) needed and store them so that in case of a burp you can just execute the code file. If you don't know the exact sql code, dump it to a file as the statements are