Re: [sqlite] Supporting databases larger than 2GB on FAT filesystems?

2007-04-14 Thread Ludvig Strigeus
Alright thanks! I will look into that. /Ludvig On 4/14/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Ludvig Strigeus" <[EMAIL PROTECTED]> wrote: > Does Sqlite support databases larger than 2GB on FAT filesystems? SQLite supports large databases just fine. It is FAT that does not

Re: [sqlite] Supporting databases larger than 2GB on FAT filesystems?

2007-04-14 Thread drh
"Ludvig Strigeus" <[EMAIL PROTECTED]> wrote: > Does Sqlite support databases larger than 2GB on FAT filesystems? SQLite supports large databases just fine. It is FAT that does not support large files. > > If not, how hard would it be to add so it uses additional files for the > pages that

Re: [sqlite] Supporting databases larger than 2GB on FAT filesystems?

2007-04-13 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ludvig Strigeus wrote: > I would like to have a single table larger than 2GB...though. FAT16 has a maximum file size of 2GB. FAT32 (the most common one in use today) has a maximum file size of 4GB. It is impossible to have single files larger than

Re: [sqlite] Supporting databases larger than 2GB on FAT filesystems?

2007-04-13 Thread John Stanton
Use a file system with 64 bit addressing. Ludvig Strigeus wrote: I would like to have a single table larger than 2GB...though. /Ludvig On 4/13/07, John Stanton <[EMAIL PROTECTED]> wrote: It is limited by the maximum file size on your OS. You can make a multiple file database by ATTACHing

Re: [sqlite] Supporting databases larger than 2GB on FAT filesystems?

2007-04-13 Thread Ludvig Strigeus
I would like to have a single table larger than 2GB...though. /Ludvig On 4/13/07, John Stanton <[EMAIL PROTECTED]> wrote: It is limited by the maximum file size on your OS. You can make a multiple file database by ATTACHing more than one database. Ludvig Strigeus wrote: > Does Sqlite

Re: [sqlite] Supporting databases larger than 2GB on FAT filesystems?

2007-04-13 Thread John Stanton
It is limited by the maximum file size on your OS. You can make a multiple file database by ATTACHing more than one database. Ludvig Strigeus wrote: Does Sqlite support databases larger than 2GB on FAT filesystems? If not, how hard would it be to add so it uses additional files for the pages

RE: [sqlite] Supporting databases larger than 2GB on FAT filesystems?

2007-04-13 Thread Samuel R. Neff
building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: Ludvig Strigeus [mailto:[EMAIL PROTECTED] Sent: Friday, April 13, 2007 2:32 PM To: [EMAIL PROTECTED] Subject: [sqlite] Supporting databases larger than 2GB on FAT

[sqlite] Supporting databases larger than 2GB on FAT filesystems?

2007-04-13 Thread Ludvig Strigeus
Does Sqlite support databases larger than 2GB on FAT filesystems? If not, how hard would it be to add so it uses additional files for the pages that don't fit in the first file? Thanks Ludvig