| Postgresql driver DLM [message #65181] |
Mon, 16 February 2009 15:39  |
Robbie
Messages: 165
Registered: February 2006
|
Senior Member |
|
|
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
|
|
|
|
| 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
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
