pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedTwo way encryption in PG???
5+ messages / 4 participants
[nested] [flat]
* Two way encryption in PG???
@ 2001-03-04 17:09 Boulat Khakimov <boulat@inet-interactif.com>
0 siblings, 1 reply; 5+ messages in thread
From: Boulat Khakimov @ 2001-03-04 17:09 UTC (permalink / raw)
To: pgsql-sql
Hi,
Im porting my software from mySQL to PG.
I need to encypt a field in a table using two way encription. In mySQL
for those purposes I was
using build-in functions ENCODE/DECODE, is there such an equivalent in
PG?
How do I encrypt/decrypt something in PG?
Regards,
Boulat
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Two way encryption in PG???
@ 2001-03-05 02:04 David Olbersen <dave@slickness.org>
parent: Boulat Khakimov <boulat@inet-interactif.com>
0 siblings, 1 reply; 5+ messages in thread
From: David Olbersen @ 2001-03-05 02:04 UTC (permalink / raw)
To: Boulat Khakimov <boulat@inet-interactif.com>; +Cc: pgsql-sql
On Sun, 4 Mar 2001, Boulat Khakimov wrote:
->How do I encrypt/decrypt something in PG?
Perhaps it'd be better to one-way encrypt something? Granted I don't know the
details of your project, but allowing a way to "decrypt" something is rather
insecure.
-- Dave
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Two way encryption in PG???
@ 2001-03-05 14:11 Boulat Khakimov <boulat@inet-interactif.com>
parent: David Olbersen <dave@slickness.org>
0 siblings, 1 reply; 5+ messages in thread
From: Boulat Khakimov @ 2001-03-05 14:11 UTC (permalink / raw)
To: pgsql-sql
David Olbersen wrote:
>
> On Sun, 4 Mar 2001, Boulat Khakimov wrote:
>
> ->How do I encrypt/decrypt something in PG?
>
> Perhaps it'd be better to one-way encrypt something? Granted I don't know the
> details of your project, but allowing a way to "decrypt" something is rather
> insecure.
>
> -- Dave
Now, one way CC encryption doesnt really make any sense, does it :)
Two-way encryption algorithms like blowfish are very hard to break, too
bad they are
not build in to PG.
--
Nothing Like the Sun
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Two way encryption in PG???
@ 2001-03-05 16:40 clayton cottingham <drfrog@smartt.com>
parent: Boulat Khakimov <boulat@inet-interactif.com>
0 siblings, 1 reply; 5+ messages in thread
From: clayton cottingham @ 2001-03-05 16:40 UTC (permalink / raw)
To: Boulat Khakimov <boulat@inet-interactif.com>; +Cc: pgsql-sql
Boulat Khakimov wrote:
>
> David Olbersen wrote:
> >
> > On Sun, 4 Mar 2001, Boulat Khakimov wrote:
> >
> > ->How do I encrypt/decrypt something in PG?
> >
> > Perhaps it'd be better to one-way encrypt something? Granted I don't know the
> > details of your project, but allowing a way to "decrypt" something is rather
> > insecure.
> >
> > -- Dave
>
> Now, one way CC encryption doesnt really make any sense, does it :)
>
> Two-way encryption algorithms like blowfish are very hard to break, too
> bad they are
> not build in to PG.
>
this could be easily done with
PL/perl couldnt it?
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Two way encryption in PG???
@ 2001-03-05 23:06 Mathijs Brands <mathijs@ilse.nl>
parent: clayton cottingham <drfrog@smartt.com>
0 siblings, 0 replies; 5+ messages in thread
From: Mathijs Brands @ 2001-03-05 23:06 UTC (permalink / raw)
To: clayton cottingham <drfrog@smartt.com>; +Cc: Boulat Khakimov <boulat@inet-interactif.com>; pgsql-sql
On Mon, Mar 05, 2001 at 08:40:53AM -0800, clayton cottingham allegedly wrote:
> Boulat Khakimov wrote:
> >
> > David Olbersen wrote:
> > >
> > > On Sun, 4 Mar 2001, Boulat Khakimov wrote:
> > >
> > > ->How do I encrypt/decrypt something in PG?
> > >
> > > Perhaps it'd be better to one-way encrypt something? Granted I don't know the
> > > details of your project, but allowing a way to "decrypt" something is rather
> > > insecure.
> > >
> > > -- Dave
> >
> > Now, one way CC encryption doesnt really make any sense, does it :)
> >
> > Two-way encryption algorithms like blowfish are very hard to break, too
> > bad they are
> > not build in to PG.
> >
>
> this could be easily done with
> PL/perl couldnt it?
It's still not clear to me why someone would want to. Having the database
server do two-way encryption doesn't really provide you with any extra
protection. Also, it puts extra strain on the database server.
If you want to store encrypted data on the server, have the application do
the encryption. That also would provide for a much more scaleable solution,
since it doesn't put any extra load on the database server. Doing the
encryption on the application end should be pretty easy.
I know there are some database(like) systems that can do this kind of stuff,
but the only advantage I can see at the moment is that when someone
physically steals your database server (or the disks), they can't read your
data. This only works when the key is NOT, again, NOT stored on disk in any
form; query the sysadmin (or someone similar) when starting the db server
instead.
Btw. don't even think about asymmetric (public key) cyphers, such as RSA.
They are MUCH too slow, both in setup and processing (throughput) time.
Cheers,
Mathijs
--
It's not that perl programmers are idiots, it's that the language
rewards idiotic behavior in a way that no other language or tool has
ever done.
Erik Naggum
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-03-05 23:06 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-04 17:09 Two way encryption in PG??? Boulat Khakimov <boulat@inet-interactif.com>
2001-03-05 02:04 ` David Olbersen <dave@slickness.org>
2001-03-05 14:11 ` Boulat Khakimov <boulat@inet-interactif.com>
2001-03-05 16:40 ` clayton cottingham <drfrog@smartt.com>
2001-03-05 23:06 ` Mathijs Brands <mathijs@ilse.nl>
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