Re: [sqlite] table backup

You could write a virtual table extension that performs pre-image (in the xUpdate method) or after-image (in the xCommit method) logging of write transactions to a CSV file or even an SQL Logfile. The biggest challenge would be writing the xBestIndex function to properly return an optimal

Re: [sqlite] table backup

Sometimes, sqlite databse corrupts. So, I want to take online backup of specific table. Not entire database. Any best solution? On Sun, Dec 9, 2012 at 11:29 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 09/12/12 10:35, dd wrote: > > i

Re: [sqlite] table backup

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/12/12 10:35, dd wrote: > i mean, for every write operation in a table. You should specify some of your other constraints and exactly what it is you are trying to achieve (*not* how you are trying to achieve it). The solutions range from

Re: [sqlite] table backup

i mean, for every write operation in a table. On Sun, Dec 9, 2012 at 11:55 PM, dd wrote: > Hi All, > > What is the best way to do online backup for a particular table for > every write operation in a sqlite db. Not entire database. > > Best Regards, > d >

[sqlite] table backup

Hi All, What is the best way to do online backup for a particular table for every write operation in a sqlite db. Not entire database. Best Regards, d ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

Le 9/12/2012 13:40, Gilles Ganault a écrit : On Sun, 9 Dec 2012 11:40:15 +, Simon Slavin wrote: If you think you can make money by providing a basic app, write one and market it. People don't want one. If they have already paid for and learned to use Excel,

Re: [sqlite] disk image malformed

I do Integrity check every often. On Sun, Dec 9, 2012 at 5:07 PM, Simon Slavin wrote: > > On 9 Dec 2012, at 12:44pm, dd wrote: > > > Can I read the database when sqlite throws disk io or image malformed or > > other critical errors first time. I

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

You're finding out that "simple" and "complete" are frequently mutually exclusiveespecially when defined by you. Chances are that if what you want doesn't exist there's a good reason for it.either not practical or not useful or doable by other means already. To make a powerful, idiot proof

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

Am 09.12.2012 12:40, schrieb Simon Slavin: On 9 Dec 2012, at 11:13am, Gilles Ganault wrote: OTOH, whoever writes that application could always provide two version: Basic (datagrid) and Pro (spreadsheet). If you think you can make money by providing a basic app,

Re: [sqlite] disk image malformed

On 9 Dec 2012, at 12:44pm, dd wrote: > Can I read the database when sqlite throws disk io or image malformed or > other critical errors first time. I cannot simulate these issues on my > machine. So, I need your suggestion. You should not continue to work with the

Re: [sqlite] disk image malformed

On Sun, 9 Dec 2012 16:44:13 +0400, dd wrote: > Can I read the database when sqlite throws disk io or image malformed or > other critical errors first time. I cannot simulate these issues on my > machine. So, I need your suggestion. Here are a few suggestions to simulate

Re: [sqlite] disk image malformed

Can I read the database when sqlite throws disk io or image malformed or other critical errors first time. I cannot simulate these issues on my machine. So, I need your suggestion. On Sun, Dec 9, 2012 at 4:40 PM, dd wrote: > Thank you Simon Slavin. > > > On Sun, Dec 9,

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

On Sun, 9 Dec 2012 11:40:15 +, Simon Slavin wrote: >If you think you can make money by providing a basic app, write one and market >it. > >People don't want one. If they have already paid for and learned to use >Excel, they'll use that. > If they haven't, they'll use

Re: [sqlite] disk image malformed

Thank you Simon Slavin. On Sun, Dec 9, 2012 at 4:27 PM, Simon Slavin wrote: > > On 9 Dec 2012, at 12:10pm, dd wrote: > > > I have code in C++. Right now, I got this issue on Mac. > > Oh. Then you don't have to worry about Windows codepages. All

Re: [sqlite] disk image malformed

On 9 Dec 2012, at 12:10pm, dd wrote: > I have code in C++. Right now, I got this issue on Mac. Oh. Then you don't have to worry about Windows codepages. All your text is already in Unicode. >>> you still have faulty hardware or software > > faulty software means? (OS

Re: [sqlite] disk image malformed

I have code in C++. Right now, I got this issue on Mac. >>you still have faulty hardware or software faulty software means? (OS or sqlite version) On Sun, Dec 9, 2012 at 3:37 PM, Simon Slavin wrote: > > On 9 Dec 2012, at 7:34am, dd wrote: > > >

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

On 9 Dec 2012, at 11:13am, Gilles Ganault wrote: > OTOH, whoever writes that application could always provide two > version: Basic (datagrid) and Pro (spreadsheet). If you think you can make money by providing a basic app, write one and market it. People don't want

Re: [sqlite] disk image malformed

On 9 Dec 2012, at 7:34am, dd wrote: > I have 10 databases. One database got disk io error, later it's used by > application without proper handling, so it's corrupted. > > After some days, one more database also corrupted without io error. Sqlite > returned error code 11.

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

On Sun, 09 Dec 2012 00:04:40 +0100, Olaf Schmidt wrote: >If no such special Formatting is needed, then the >term "DataGrid" is the more common one, since >"real SpreadSheet functionality" is usually associated >with the extended requirements (at individual cell-level) >I've listed

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

On Sun, 09 Dec 2012 00:49:03 +0100, Jean-Christophe Deschamps wrote: >What are those $20 suppose to pay for? Licenses by users interested in buying that utility optimized to build lists and sort data much better than in Excel (which isn't meant for that, but people use it