It's very dificult decision. I'm prefer to use some callback function
for logging all queries. But I don't know how to realise this callback
- trace and profile callbacks can't show query string with variables
values.
2008/8/11, Dennis Cote <[EMAIL PROTECTED]>:
> Alexey Pechnikov wrote:
>>
>> Can
Alexey Pechnikov wrote:
>
> Can I get full log of sql statements for to sent it other network or store to
> outher device?
>
Alexey,
You may want to read http://www.sqlite.org/cvstrac/wiki?p=UndoRedo for
an example of using triggers to generate SQL to modify a database. This
example is
В сообщении от Saturday 26 July 2008 10:23:57 Roger Binns написал(а):
> Alexey Pechnikov wrote:
> >> Maybe sqlite3_trace() or sqlite3_profile() can help with what you're
> >> looking for here.
>
> Unfortunately sqlite3_trace isn't that useful as it only tells you the
> text of the sql statement
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alexey Pechnikov wrote:
>> Maybe sqlite3_trace() or sqlite3_profile() can help with what you're
>> looking for here.
Unfortunately sqlite3_trace isn't that useful as it only tells you the
text of the sql statement but not any bound parameters. The
В сообщении от Friday 25 July 2008 16:32:26 Derrell Lipman написал(а):
> > Can I get full log of sql statements for to sent it other network or
> > store to
> > outher device?
>
> Maybe sqlite3_trace() or sqlite3_profile() can help with what you're
> looking for here.
Thanks!
On Fri, Jul 25, 2008 at 5:23 AM, Alexey Pechnikov <[EMAIL PROTECTED]>
wrote:
> > > Database servers such as Oracle or PostgreSQL have transactions log and
> > > restore log.
> >
> > Those logs are effectively duplicates of the data or ways of
> > reconstructing the data. SQLite has a transaction
В сообщении от Friday 25 July 2008 12:16:39 Roger Binns написал(а):
> Alexey Pechnikov wrote:
> > May be on FS layer?
>
> I specifically said VFS which is SQLite functionality - see
> http://www.sqlite.org/c3ref/vfs.html and
> http://www.sqlite.org/c3ref/io_methods.html
Thanks, last link may be
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alexey Pechnikov wrote:
> May be on FS layer?
I specifically said VFS which is SQLite functionality - see
http://www.sqlite.org/c3ref/vfs.html and
http://www.sqlite.org/c3ref/io_methods.html
> Which FS can help me for this? I'm using ext3 FS now on
В сообщении от Friday 25 July 2008 03:40:22 Roger Binns написал(а):
> Alexey Pechnikov wrote:
> > Is any way to repair corrupted database?
>
> From a theoretical point of view the only way to repair a corrupted
> database is if there are multiple redundant copies of data or of
> generating that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alexey Pechnikov wrote:
> Is any way to repair corrupted database?
- From a theoretical point of view the only way to repair a corrupted
database is if there are multiple redundant copies of data or of
generating that data. Since SQLite doesn't do
В сообщении от Thursday 24 July 2008 20:48:08 Alexey Pechnikov написал(а):
> Hello!
>
> Is any way to repair corrupted database? May be I have archive copy of
> database and corrupted this pages - can I get correct pages and merge their
> with archive database?
>
> P.S. I have no corrupted
Hello!
Is any way to repair corrupted database? May be I have archive copy of
database and corrupted this pages - can I get correct pages and merge their
with archive database?
P.S. I have no corrupted database now but this question is important for me.
Best regards, Alexey.
12 matches
Mail list logo
