3

I have a model whose instances don't need to be written to database, ever. They are generated on the fly, very cheaply, and almost never change.

I wish to query these instances via the ORM and also browse them in django-admin (read-only + mass_actions, no need for CRUD).

From what I gathered, SQLite uses in-memory database when running tests. I think I want to use this feature, just not limited to tests.

Another option might be a pure in-memory model backend, but I'm not finding one. Actually I did find this project: https://github.com/felipecruz/dmqs It looks a bit dated though.

Or maybe there is a caching backend that can do this?

frnhr
  • 12,354
  • 9
  • 63
  • 90

1 Answers1

5

You have to use the special file name :memory: to instruct sqlite to use an in memory database. 

DATABASES = {
  'default': {
    'ENGINE': 'django.db.backends.sqlite3',
    'NAME': ':memory:',
  }
}

should do the trick.

Chamindu
  • 716
  • 1
  • 5
  • 13