| Re: Postgresql driver DLM [message #65259 is a reply to message #65181] |
Wed, 18 February 2009 00:16  |
Michi
Messages: 9 Registered: December 2007
|
Junior Member |
|
|
That sounds rather interesting. ATM, we are using our own dataformat
for similar purposes, but a SQL backend would be really useful in the
long run.
I was thinking about using sqlite, but I couldn't find idl wrappers,
so I gave it up (temporarily)
What exactly does 'large object storage' mean? Is it on the scale of
MB, or even GB?
Regards,
Michi
On Feb 17, 12:39 am, Robbie <ret...@iinet.net.au> wrote:
> Hi
>
> I'm just wondering if there is demand for a postgresql driver DLM.
> I've written one and compiled it using CMake for Win32 as well as OSX.
> The most important feature is that it supports large object storage.
> This means that you can do random access reads and writes to binary
> objects in the database.
>
> A synopsis is below:
>
> PSQLCONNECT - Connect to the database
> PSQLDISCONNECT - Disconnect from the database
> PSQLADD - Add a new large object identifier
> PSQLDEL - Delete a large object identifier
> PSQLGET - Get a chunk of data from a large object
> PSQLPUT - Put a chunk of data into a large object
> PSQLQUERY - Do a SQL query
> PSQLESCAPE - Escape a string for putting into a SQL query
>
> I use it for curve, region and image storage. I imagine it could be
> used for all kinds of other interesting things.
>
> Robbie
|
|
|
|