In-Memory DB size limits

[Yahia]

Hi,

I am planning to work with SQLite "in-memory" DBs in one application (x64)...
Some users might have a lot of data exceeding 2-4 GB.

Is it possible to have in-memory SQLite DBs bigger than 4 GB?

Thanks in advance.

Best Regards
Yahia El-Qasem

[Shalex]

dotConnect for SQLite doesn't put any size limitation on the SQLite database. Please contact the SQLite support team to find out the in-memory DB size limit.

[Yahia]

I suspect there is a misunderstanding... pure native SQLite can do this.

BUT I read that dotconnect is 100% managed and works with "native preloaded DLL" it might introduce additonal limits - for .NET does not allow for a single object > 2 GB (even in x64) and thus I am asking here...

[Shalex]

We do not create explicitly any object in our code which size would be equal to the size of the database file. You may encounter the "single object size" limitation only if you create this object in your code.