Hello.
I would like to use some database for caching preprocessed data for a website. Even though the data will seldom be larger than a few megabytes, I do not feel good about having to load them into memory on the whole instead of serving them. I can (and will) of course use plain files if necessary, but having a database taking care of the dirty stuff (transactions, locks, integrity, etc.) is probably more convenient. Postgres has a blob-api - http://www.postgresql.org/docs/current/ ... faces.html - but it seems that Postmodern does not have such a thing. Maybe it is possible to use libpg via FFI, and postmodern, simultaneously? Or maybe there is another Database (MySQL, SQLite, tokyocab, etc.) that can do exactly this?
Best regards.
BLOBs in SQL
-
- Posts: 99
- Joined: Sat Jul 26, 2008 2:30 pm
- Location: Germany
- Contact:
BLOBs in SQL
Sorry for my bad english.
Visit my blog http://blog.uxul.de/
Visit my blog http://blog.uxul.de/
-
- Posts: 166
- Joined: Sun Nov 28, 2010 4:21 pm
Re: BLOBs in SQL
http://common-lisp.net/project/cl-sqlite/ does blobs when provided with byte vectors.
-
- Posts: 99
- Joined: Sat Jul 26, 2008 2:30 pm
- Location: Germany
- Contact:
Re: BLOBs in SQL
But that does not prevent me from having to load the whole data into RAM first, which I want to avoid.pjstirling wrote:http://common-lisp.net/project/cl-sqlite/ does blobs when provided with byte vectors.
I am currently considering using postgres byte-arrays and substr.
Sorry for my bad english.
Visit my blog http://blog.uxul.de/
Visit my blog http://blog.uxul.de/