Storing files in the database - and giving easy access to this?

From: Stefan Keller <sfkeller(at)gmail(dot)com>
To: pgsql-general List <pgsql-general(at)postgresql(dot)org>
Subject: Storing files in the database - and giving easy access to this?
Date: 2012-11-29 20:07:30
Message-ID: CAFcOn28sR5YwosyC0fX=9w+u1vDr5cZDL6kp17NzX_o0j50DXA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Tomas, hi all,

Nice blog, Thomas, about "storing files in the database" [1].

Now, I'd like to implement a single client script for using this
"remote file system".

The solution should implement (1) List (dir), (2) Copy (cp) and (3)
Remove (rm). It should be available for both Linux and Windows and use
the credentials of the database.

As a first approach it could use psql:
=> Does anybody have some tricks on how to insert an external file
into the tables Files and File_data using psql?

But ideally, there should be a web-based file manager. There are many
such projects around for PHP, but I'd prefer one in Python, like
Snakelets [2]
=> Any tipps?

Stefan

[1] http://www.fuzzy.cz/en/articles/storing-files-in-a-postgresql-database/
[2] http://pythonsource.com/open-source/web-servers/snakelets

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-11-29 20:16:59 Re: pg_listening_channels()
Previous Message Kevin Grittner 2012-11-29 19:55:17 Re: When does CLUSTER occur?