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
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? |