|
|
Posted by bob.chatman@gmail.com on 09/29/07 15:42
On Sep 29, 6:57 am, Bruno Barros <rage...@gmail.com> wrote:
> I, for my framework, put:
>
> ID
> USERNAME
> PASSWORD
> EMAIL
>
> That is for the simple login / logout / register data.
> Then, according to the application, there is another user table, which
> holds all the user's information. It is always made from scratch as I
> never know which fields my customer requires or my code needs ;). For
> example, for a social networking site you need about me, musical
> interests, ..., but for a customer account on a shop, you needn't such
> things. The main users table only stores what is essential in ALL
> users. Then I make a relation between them, connecting users by ID.
> The record with ID X on main table belongs to ID X on the other table.
>
> By the way, PHPBB3, MediaWiki and such are not frameworks, they are
> not made to be as broad as possible. They are ONLY made for themselves
> and their specific needs, while a framework needs us to remember that
> it has to work with all websites from top to bottom.
>
> ---
> Bruno Rafael Moreira de Barros
>
> Adobe Photoshop CS2 and CS3
> -
> XML / XSLT
> -
> MySQL / SQLite / TerraDB
> -
> PHP 3, 4, 5 and 6
>
> :: Looking For A Permanent Job ::
> ---
I wasnt really worried about frameworks, but i dont know of any
framework that has details directing the developers to keep the user
tables small. That aside, is the summation of the above to do what
your application needs? I can understand the situation where your user
has multiple accounts, but i dont think that really has much bearing
on most web applications; as Jerry brought up -
[quote]It depends on how you define "account" and "user". In many
systems, each account is considered a different user.[/quote] Ive
actually found that most applications do treat "accounts" and "users"
as one mass, and especially so in my discussions with a few folks on
the oncoming wave of Open ID compliant applications. Are there any
rules of thumb that have come up? this is of course aside from "if it
occurs more than once you should probably be using another table."
Navigation:
[Reply to this message]
|