Messages from Usenet group comp.lang.idl-pvwave, compiled by Paulo Penteado
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
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