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 execu
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 mean, for every write oper
-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 impleme
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
>
_
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
http://sqlite.org:8080/cgi-bin/mailman/listinf
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,
they'll use that.
If they hav
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 cannot simulate these issues on my
> > machine.
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
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, write one and market
it.
Pe
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 database in your own applicati
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 (or rather, to force) cor
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, 2012 at 4:27 PM, Simon Sl
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 anything that's free.
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 your text
> is already in Unicode.
>
> >>> you
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 or sqlite version)
Th
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:
>
> > I have 10 databases. One database got disk io
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 one. If they have already
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. It's fully corrupted.
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 above.
Thanks f
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 anyway since they don't
20 matches
Mail list logo