From: Dan Lyke <danlyke@flutterby.com>
To: pgsql-sql@postgresql.org
Subject: Using Random Sequence as Key
Date: Mon, 16 Apr 2001 13:16:29 -0700 (PDT)
Message-ID: <15067.21277.884548.721903@wynand.flutterby.com> (raw)
In-Reply-To: <9bdjag$faj$1@news.tht.net>
References: <9bdjag$faj$1@news.tht.net>
Bernardo de Barros Franco writes:
> Hello, I was wondering if noone can help me maybe someone could at least
> give me some directions where to look for info or where to ask:
> I wanted to index a table by a random key.
As others have pointed out, making a unique random primary key is
tough. What I do for my cookie on my web based login system is have
two fields in my database, one's the "id SERIAL", the other is a
"magiccookie CHAR(16)" which I populate with 16 random characters on
the initial insert.
My cookie is then of the format "id/magiccookie". In my login
verification code I split on the "/" character and query on "WHERE
id=$id AND magiccookie=$magiccooke". Even though the "id" field is
encoded in the cookie in plain text a cracker can't just guess at the
user id number because that 16 character magiccookie needs to match as
well.
This also lets me be pretty loose about the id information, I can use
it in other public places, because only the magiccookie needs to be
restricted to being known by the logged in user.
Dan
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: danlyke@flutterby.com
Subject: Re: Using Random Sequence as Key
In-Reply-To: <15067.21277.884548.721903@wynand.flutterby.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