Status: New
Owner: ----
Labels: Type-Defect Priority-Medium

New issue 778 by ggrigorenko: If there a way to create in-memory SQLITE database with Gears?
http://code.google.com/p/gears/issues/detail?id=778

This fails:

db.open(':memory:')

And since ATTACH is disabled, I guess there's no other way to use SQLITE
in-memory database (no files on disk).

That would be very useful, because sometimes I don't want to store offline
data on client computer but to use SQLITE database as temporary storage for
my data and in-memory databases are much faster.

This can also be solved very simple - just execute inside Gears

"ATTACH ':memory:' AS mem"

on every database after open() and users gets an opportunity to create in-
memory table (CREATE TABLE mem.FOO), index and use it besides on-disk
tables.

Thanks.





--
You received this message because you are listed in the owner
or CC fields of this issue, or because you starred this issue.
You may adjust your issue notification preferences at:
http://code.google.com/hosting/settings

Reply via email to