pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: rdeleonp@gmail.com, rdeleonp@yahoo.com, pgsql-admin@postgresql.org, "Jonah H. Harris" <jonah.harris@gmail.com>
Cc: Aaron Bono <postgresql@aranya.com>
Subject: Re: Wrap (obfuscate) code
Date: Tue, 4 Jul 2006 18:56:51 -0700
Message-ID: <200607041856.52276.jd@commandprompt.com> (raw)
In-Reply-To: <28774.1152064303@sss.pgh.pa.us>
References: <a55915760607041053q12a77e64je19340c0fb9e554b@mail.gmail.com>
	<a55915760607041838y5edabeb9hed6783bdcc22f01e@mail.gmail.com>
	<28774.1152064303@sss.pgh.pa.us>

On Tuesday 04 July 2006 18:51, Tom Lane wrote:
> "Rodrigo De Leon" <rdeleonp@gmail.com> writes:
> > I would be quite a bonus to have equivalent functionality in PG.
>
> Write your functions in C and give them precompiled libraries.
> Yes, also theoretically decompilable, but plenty hard ... plus
> they have to come back to you for an update on every major PG
> revision ;-)

On that note, would it be possible to write a language handler in 
C that would wrap plPgsql? E.g;

Write function in plpgsql, but call plpgsql_o

plpgsql_o takes the plpgsql code and turns it into some kind of bytecode.

When executed via postgresql, the handler defanges the bytecode and
hands it off to plpgsql for proper processing?

Just a thought.

Joshua D. Drake

>
> 			regards, tom lane



view thread (14+ messages)  latest in thread

Message-ID: <200607041856.52276.jd@commandprompt.com>
Permalink:  ../200607041856.52276.jd@commandprompt.com/
Also on:    postgresql.org/message-id/200607041856.52276.jd@commandprompt.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jd@commandprompt.com, tgl@sss.pgh.pa.us, jonah.harris@gmail.com, postgresql@aranya.com
  Subject: Re: Wrap (obfuscate) code
  In-Reply-To: <200607041856.52276.jd@commandprompt.com>
  References: <a55915760607041053q12a77e64je19340c0fb9e554b@mail.gmail.com> <a55915760607041838y5edabeb9hed6783bdcc22f01e@mail.gmail.com> <28774.1152064303@sss.pgh.pa.us> <200607041856.52276.jd@commandprompt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox