BLOBs in SQL
Posted: Sun May 05, 2013 4:56 pm
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.
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.