[Solar-talk] Handles or IDs?

[Antti Holvikari]

On 11/29/06, Paul M Jones <pmjones at ciaweb.net> wrote:
> On Nov 28, 2006, at 4:17 PM, Antti Holvikari wrote:
>
> > I'm thinking of migrating to using user ids instead of user handles,
> > but all Solar classes use handles (strings). Is everyone using just
> > handles or is someone using IDs? What do you think, should we keep the
> > all the adapters handle based and deal with the problem somehow or try
> > to change to using IDs only?
>
> I'm using handles everywhere all the time.
>
> Rodrigo mad e arequest a while back that I implemented: the Auth
> adapters allow you to retrieve a "uid" (if the adapter supports it,
> same thing with "email", "moniker", and "uri").  The "uid" value is a
> "user ID" or "unique ID" depending on how you look at it, but the
> idea is the same: a numeric ID that maps to the handle.  Your various
> table classes can then use a "uid" value instead of a "handle"
> value.  Solar_Auth_Adapter_Sql has an example of this, iirc.
>
> Does that help at all?

Yep, I'm using the uid var, the problems are with all the adapters.
And it seems it would be really hard to use only ids (write id support
for all the adapters). I'm basicly only worried about the speed of my
queries. The thing is, using only handles would be so easy. Please
convince me to use only handles :-) All the SQL gurus say we'd have to
use ids but then we say KISS and use handles... :-(


-- 
Antti Holvikari <http://phphalo.com>