Help : Microsoft SQL Server equivalents in PostGreSQL

Hello,
my customer, ntl:Telewest is using an open source 'file upload progress
bar' called NeatUpload to help users to upload video files to a MS SQL
database. They want to replace the MS SQL database with
Solaris/PostgreSQL and ZFS.

There is an extension to NeatUpload that enables this to work with MS
SQL Server. I emailed the author of this extension to ask how easy it
would be to replace MS SQL Server with PostgreSQL. His reply (below)
suggests that I need to use a postgreSQL equivalent for "Updatetext" and
"ReadText" in MS SQL Server. Any pointers on what the PostgreSQL
equivalent is?

Many thanks.

------------------------------- forwarded email
------------------------------------------------
Hi Benedict,
Re: NeatUpload SqlServerInputFile Extension with PostGres in Solaris 10.

In my implementation of SqlServerInputFile I use the commands
"updatetext" and "readtext", which are as far as I know Microsoft SQL
Server specific. If there is an equivalent in postgresql you could use
that instead.

If there is no equivalent commands, it is possible to use "standard" SQL
to do the same task (i.e. writing chunks of a file to a database) but
there is no such code in my code at this point.

If you indend to rewrite the code so that it works, look at the
SqlServerBlobStream class, and the functions GenerateReadCommand and
GenerateWriteCommand. They aer the ones responsible, and has to be
rewritten using neutral SQL language. To make the file upload work you
really only need to fix "GenerateWriteCommand".

If you manage to make it work I'd love to take a look at it! I've never
used postGreSQL, although I've read quite a lot about it. I think I even
have some 6 months old installation files here somewhere I never had
time to use... ;)
Any further questions, please ask.
Best regards / med vänlig hälsning
Joakim Wennergren, Hitone Nordic AB
Tel: +46 8 556 18 754, Fax: +46 8 556 18 755, Mobile: +46 70 191 42 59


On 1/17/07, *Benedict Faria* <Benedict.Faria@sun.com
<mailto:Benedict.Faria@sun.com>> wrote:

    Joakim,
    I have a requirement to upload content to a PostGres database on Solaris
    10 instead of a Microsoft SQL database. PostGres is an open source SQL
    database. See  http://www.postgresql.org/ <http://www.postgresql.org/>

     From the documentation at
    http://www.brettle.com/NeatUpload-1.2/docs/Manual.html#SqlServerInputFile
    I don't envisage any issues with doing this, but I though I'd email you
    to confirm. Could you help?
    Many thanks.
    Benedict.

    ---------------------------------------------------------------------
    Benedict Faria
    Engagement Architect, Client Solutions - Comms & Media
    ---------------------------------------------------------------------
    Sun Microsystems Computers,  Tel  : +44 (0)207-256-3200 (Switchboard)
    Regis House,                      : +44 (0)207-469-9725 (Direct line)
    55 King William Street,      Fax  : +44 (0)207-469-9910
    London,                      Mob  : +44 (0)7711-053-822
    EC4R 9AD.                    Email: Benedict.Faria@sun.com
    <mailto:Benedict.Faria@sun.com>
    --------------------------------------------------------------------
    Network with peers, keep pace with technology :
    Technical community: http://www.sun.com/boardroom
    Executive community: http://www.sun.com/innercircle
    "The box said 'Windows Server 2003 or better', so I installed Solaris10"