[Opensim-dev] User vs Avatar [WAS: Proposed additional db fields]

Tue Nov 4 09:58:12 UTC 2008

I'd love to have a DB pattern which better supported metadata myself.

There's been several occasions right now where it would have been handy to attach extra fields of data in (even if they cant be searched on easily).

Adam

From: opensim-dev-bounces at lists.berlios.de [mailto:opensim-dev-bounces at lists.berlios.de] On Behalf Of Michael Wright
Sent: Tuesday, 4 November 2008 1:38 AM
To: opensim-dev at lists.berlios.de
Subject: Re: [Opensim-dev] User vs Avatar [WAS: Proposed additional db fields]

I agree with Stefan, we have too much data mixed together in the dbs. Avatar appearance for instance. I don't believe that should be part of user data. We should either have it as part of the Inventory/Asset data or a separate Avatar  data set.

Mixing all the data together like we do, really makes it hand to make changes to the backends. And to make custom applications that function in a different manor to the standard opensim setup.

I'm also unsure we really need a email field as part of the opensim db. I would think that should be part of the website account data. Which I believe most likely should be separate from opensim data.

The more data we have mixed together in the db's. The hander/ more work it becomes to maintain a opensim installation; to update it when changes are made to the database structures.

For 0.6, lets think about some new layouts, to make things easier to customize and maintain?

Stefan Andersson <stefan at tribalmedia.se> wrote:
It is my firm belief, based on numerous integrations with custom backends, that we should separate the 'user' concept from the 'avatar' concept. On all Tribal Medias productions, the user logs on with a user id, not avatar first/last. In the real world (aka non-sl-grid world) it makes sense to separate them in the db.

Maybe the cross-section would be the 'agent' - and in the simplest of instances, agentId == userId == avatarId.

What I mean is that an asset was uploaded and accessed by an 'agent', not a 'user' or an 'avatar'. This should be reflected in the tables as well.

Best regards,
Stefan Andersson
Tribal Media AB

Join the 3d web revolution : http://tribalnet.se/

________________________________

To: opensim-dev at lists.berlios.de
From: alan_webb at us.ibm.com
Date: Mon, 3 Nov 2008 17:03:43 -0500
Subject: Re: [Opensim-dev] Proposed additional db fields

As you say, e-mail in user information should be non-controversial, but it does highlight the difference between users and avatars. Does the OpenSim database actually reflect users? Or avatars? I thought the latter. What purpose will the e-mail address serve? I think there maybe more reluctance to provide this information than you might think. I'm prsonally nearly as opressed by providing my e-mail as I am my telephone number.

Create time, given its one-to-one correspondence with an asset seems OK to me, but I think there is probably room for lots of discussion on ways to determine currency.

Best regards
Alan
-------------------
T.J. Watson Research Center, Hawthorne, NY
1-914-784-7286
alan_webb at us.ibm.com

Sean Dague <sdague at gmail.com>
Sent by: opensim-dev-bounces at lists.berlios.de 11/03/2008 03:12 PM
Please respond to
opensim-dev at lists.berlios.de

To

opensim-dev at lists.berlios.de

cc

Subject

[Opensim-dev] Proposed additional db fields

I've got a couple of proposed db fields that I think we should add in,
but I want feedback before just putting it in.

users:
* email - this is added by a lot of the web based management stacks,
and would be really handy to be in the base user definition.  I suspect
this is non controversial.

assets:
* create_time - the unix timestamp when the asset is created
* access_time - the unix timestamp for last asset access

The rationale for these asset additional fields was some brainstorming
this weekend on how we'd ever support asset reaping.  Why not perfect,
this may help in determining what are active assets, and what are
ancient assets that may be suitable for reaping.  Without these bits of
information, we've got a hard time here.

Comments welcomed,

                -Sean

--
Sean Dague / Neas Bade
sdague at gmail.com
http://dague.net

_______________________________________________
Opensim-dev mailing list
Opensim-dev at lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-dev

_______________________________________________
Opensim-dev mailing list
Opensim-dev at lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20081104/9ddbfac0/attachment-0001.html>