Fwd: [sqlite] Expect service interruptions Re: SQLite website hacked

2004-06-25 Thread David Costa
Very sad to hear that. If I can help anyway or if in the future you are looking for a full mirror, I would be glad to help. Cheers David Costa On Fri, 25 Jun 2004 15:43:44 -0400, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > Michael Roth wrote: > > D. Richard Hipp wrote: &

[sqlite] default cache size optimal value

2004-06-25 Thread David Costa
Hello everyone, I am still working on my PHP extension, quick question on the pragma default_cache_size: >From your experience what would be an advisable value for a powerfull hardware e.g. 1 gb ram, dual Xeon etc. is there any limit on the max size (e.g. 10,000 or 20,000) ? Thanks Da

Re: [sqlite] Questions on Database corruption and logo

2004-06-23 Thread David Costa
the examples and documentation. That means that the database is too sick to even read the SQLITE_MASTER table. Thanks a lot for your answer, Regards David Costa Regards, David Costa PEAR- PHP Extensions and Application Repository Developer http://pear.php.net/u

[sqlite] Questions on Database corruption and logo

2004-06-23 Thread David Costa
we don't even reach the pragma error message "database disk image is malformed" on connection. Thanks in advance for your time and patience, Regards, David Costa, managing partner at Dotgeek.org PEAR- PHP Extensions and Application Repository Developer http://pea

Re: [sqlite] Sqlite Secure backup

2004-06-03 Thread David Costa
On Jun 3, 2004, at 2:17 AM, Darren Duncan wrote: At 2:04 AM +0200 6/3/04, David Costa wrote: so in this case you just check if a file .journal exist and if it does you keep that file right ? Yes. But check the sqlite.org website documentation to make sure that is the correct file name. from

Re: [sqlite] Sqlite Secure backup

2004-06-02 Thread David Costa
On Jun 3, 2004, at 1:38 AM, Darren Duncan wrote: At 1:26 AM +0200 6/3/04, David Costa wrote: I am in the process of writing a PEAR package to handle Sqlite backups (both local backups and remote backups) and I am looking for some suggestions. Is the right way to proceed the db dump ? I assume

[sqlite] Sqlite Secure backup

2004-06-02 Thread David Costa
in advance for your time and attention I remain, Very much obliged, Regards, David Costa PEAR- PHP Extensions and Application Repository Developer http://pear.php.net/user/gurugeek - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional