Re: [sqlite] Calculating the size of a backup

2009-04-03 Thread D. Richard Hipp
On Apr 3, 2009, at 5:04 PM, Brown, Daniel wrote: > After a bit of digging I think (PRAGMA) page_count * (PRAGMA) > page_size is roughly the size of the database but is the actual > database file that size. Is there a header to take into account too? The header is included in the page_count.

Re: [sqlite] Calculating the size of a backup

2009-04-03 Thread Brown, Daniel
> boun...@sqlite.org] On Behalf Of Brown, Daniel > Sent: Friday, April 03, 2009 11:42 AM > To: General Discussion of SQLite Database > Subject: [sqlite] Calculating the size of a backup > > Good Morning List, > > Is there any way to calculate the size of a database backup be

[sqlite] Calculating the size of a backup

2009-04-03 Thread Brown, Daniel
Good Morning List, Is there any way to calculate the size of a database backup before doing a backup? I need to know how big the backup database is going to before I call the new backup API: as the backup database is using an in memory VFS. Cheers, Daniel Brown | Software Engineer "The best l