[sqlite] VFS Layer for to split database into several files?

2010-07-19 Thread James Croall
Hello All, I'm stuck with an environment with a 2GB file size limit. I have seen several posts over the last few years about working with these limits, and several proposals discussed. Some involve creating a VFS layer that splits the database file into chunks, and some discuss using a

Re: [sqlite] VFS Layer for to split database into several files?

2010-07-19 Thread Pavel Ivanov
I'm stuck with an environment with a 2GB file size limit. What the exact problem do you see and how do you compile SQLite? All modern compilers have macros _LARGEFILE_SOURCE or _FILE_OFFSET_BITS=64 defined by default and with that SQLite works perfectly with any files with more than 2GB in size.

Re: [sqlite] VFS Layer for to split database into several files?

2010-07-19 Thread Black, Michael (IS)
From: sqlite-users-boun...@sqlite.org on behalf of James Croall Sent: Mon 7/19/2010 12:26 PM To: sqlite-users@sqlite.org Subject: EXTERNAL:[sqlite] VFS Layer for to split database into several files? Hello All, I'm stuck with an environment with a 2GB file size limit

Re: [sqlite] VFS Layer for to split database into several files?

2010-07-19 Thread James Croall
, July 19, 2010 10:51 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] VFS Layer for to split database into several files? Also...would you care to elucidate what environment you're in that limits you to 2GB? I've heard numerous people before who think they're limited

Re: [sqlite] VFS Layer for to split database into several files?

2010-07-19 Thread Black, Michael (IS)
What modern system doesn't support NFSV3? They might have that turned on by default for their file export to legacy systems perhaps. The two systems should default to the highest version supported by both so who's holding the show? Are you running your application on another Linux box?