SitePoint Sponsor

User Tag List

Results 1 to 6 of 6

Thread: Data Bases

  1. #1
    SitePoint Zealot
    Join Date
    Nov 2000
    Posts
    164
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok, I have a basic understanding of PHP, perl, Java and JSP, but I want to now put it all together and I am noticing that I am unsure of how to manage and configure a database.

    I guess I want to know of any links out there or even some examples, of how databases should be set up.

    The way I have always been doing it is a single database, but I want to get into complex data bases with more then just one table, having multiple tables and having links from each table to do interesting stuff with.

    If anyone could give me a hand it would be really appreciated.

  2. #2
    SitePoint Wizard creole's Avatar
    Join Date
    Oct 2000
    Location
    Nashvegas Baby!
    Posts
    7,845
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    if you are going to use mySQL which most people here will recommend, then I TOTALLY recommend that you get and read this book. It will explain everything!

    http://www.booksamillion.com/ncom/bo...pid=0735709211

    Alos, Kevin Yank's tutorial on PHP and mySQL is a good read. He doesn't go too much into detail, but he still gives you the basics.
    Adobe Certified Coldfusion MX 7 Developer
    Adobe Certified Advanced Coldfusion MX Developer
    My Blog (new) | My Family | My Freelance | My Recipes

  3. #3
    SitePoint Zealot
    Join Date
    Nov 2000
    Posts
    164
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well I was actually more interested in the design of databases in general. I can comunicate with them fairly easily, but I want to know how to best implement a database for a large community of people.

    For example, how is site points database set up. How many and what kind of tables do they have, do they a user data base and then a forum data base and the names are primary fields for each one.

    The is the kind of idea I want to get.

  4. #4
    SitePoint Wizard westmich's Avatar
    Join Date
    Mar 2000
    Location
    Muskegon, MI
    Posts
    2,328
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Some general sites -
    http://dbasupport.com/
    http://www.sqlcourse.com/


    Basic explanations of the Structured Query Language. SQL is the language used with databases, although, it has syntax varients with some databases. http://w3.one.net/~jhoffman/sqltut.htm
    Westmich
    Smart Web Solutions for Smart Clients
    http://www.mindscapecreative.com

  5. #5
    SitePoint Member
    Join Date
    Mar 2001
    Location
    Georgia & Washington
    Posts
    16
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    So I would suggest that MySQL or Postgres are both good places to start. MySQL seems to have a good level of support from the PHP community. You can go to http://www.mysql.com to get more information. Their docs are getting much better and installing it shouldn't be too bad.

    bill
    Spoke Technologies provides a fast and easy way to build web sites where people interact and contribute. Spoke's customizable, ready-to-use web components dramatically simplify the creation and maintenence of complex web sites. Spoke is a turnkey solution that integrates content management, membership, forums, articles, links, distributed publishing, administration, and more, while offering full control over look, feel, and features.

  6. #6
    SitePoint Member
    Join Date
    Mar 2001
    Location
    Georgia & Washington
    Posts
    16
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Oh... the MySQL New Rider book is a must if you go that way. Noticed a bunch of other new titles out recently, but we have moved from MySQL to Postgres for a number of reasons. All have proven to be postive.

    Bill
    Spoke Technologies provides a fast and easy way to build web sites where people interact and contribute. Spoke's customizable, ready-to-use web components dramatically simplify the creation and maintenence of complex web sites. Spoke is a turnkey solution that integrates content management, membership, forums, articles, links, distributed publishing, administration, and more, while offering full control over look, feel, and features.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •