Does it matter? Well not right now, not until you have the community setup.

Once things are up and running though performance would almost certainly be better if you were using a database - since you'll be wanting to display things like username, last login tim, profile details, etc.

It just makes sense to me to use a database - especially because I'm assuming you'll have to store login names and passwords anywhere. A database is designed to get fast at queries and to link things together.

Maybe something simple will get you started, something like this:

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(25) NOT NULL default '',
  `password` varchar(32) default NULL,
  `email` varchar(75) default NULL,
  `joined` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `username` (`username`)
);

CREATE TABLE `user_info` (
  `userid` int(11) NOT NULL,
  `profile_text` TEXT default '',
  `location` varchar(30),
  `age` int default 0,
   ...
   ..
);

CREATE TABLE `user_preferences` .. ;

CREATE TABLE `user_friends` ... ;

[download]

Then you can run a simple query to get the profile text, age, etc, from the user_info table, and all the other details from any other tables you might create.

Steve
--

In reply to Re: Member profiles - file or db? by skx
in thread Member profiles - file or db? by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.