Re: creating a custom server

From: Keary Suska <hierophant(at)pcisys(dot)net>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: creating a custom server
Date: 2001-10-18 18:01:04
Message-ID: B7F47500.4D3D%hierophant@pcisys.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Off the top of my head, I don't recall any specific 'middleware'
implementations that do this exactly, but it wouldn't be entirely difficult
to make one of your own. If you are familiar with Perl or Python, making a
parallel processing network server is not rocket science, and you have
complete control over the desired protocol.

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"

> From: Victor Ivanov <v0rbiz(at)icon(dot)bg>
> Date: Thu, 18 Oct 2001 12:17:00 +0300
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] creating a custom server
>
> Hi!
>
> First, sorry if this is off topic. Second, WARNING: broken english
> ahead :)
>
> Is it possible to create a 'custom' server which can accept normal
> connections from normal clients, but use different language (or just
> 'proxy' the queries to the real server)? A friend of mine told me this
> is a feature of some commercial sql server. What I acutaly want to do
> is to add another layer between the client and the server.
>
> For example, a client connects and issues a query like 'show sessions'.
> My server checks if the client has permission (according to a table in
> postgres) and then 'translates' the query to 'select * from sessions' or
> something else. The result is then sent back to the client (possibly
> modified).
>
> Another way to do this is to get the communication library and use
> it in my application...
>
> Any ideas/hints/etc will be appreciated.
>
> --
> Players win and winners play
> Have a lucky day
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-10-18 18:01:44 Re: Getting OID after Insert
Previous Message Joel Burton 2001-10-18 17:53:24 Re: Backup Postgre Windows to Linux