How to get started?

Discussion in 'Databases' started by TurkeyEater, Feb 23, 2012.

  1. #1
    Hi everyone. I want to start a website that follows the same style of databaseing (i guess) as you would find on a submit your own recipe site. I want the user to be able to submit information, have a quick admin approval system, and then enter a database where the information can be accessed, voted on, commented on, ect.

    Where would I even start to look for something like this? I have no idea what the different types of databases there are or what they can do.

    Thanks for your help.
     
    TurkeyEater, Feb 23, 2012 IP
  2. StangMan23

    StangMan23 Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    MySQL, to me, is the easiest and most widely supported database platform. For interaction with it, just learn the PHP functions for interacting with MySQL. Best place to start is on the php dot net website and mysql dot com. It's pretty easy to build up something like you are describing.
     
    StangMan23, Feb 24, 2012 IP
  3. techendeavour

    techendeavour Peon

    Messages:
    407
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Any platform you can use to prepare a website.Mysql is the easiest way to build database.Its a user friendly database.
     
    techendeavour, Feb 25, 2012 IP
  4. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #4
    WordPress might be your best bet to start. You don't have to know the inner workings of the site (the database, writing code, etc.) to get it up and running. And if you start on wordpress.com, it's free. Once you have it going for a while, if you decide that you want your own hosting and your own domain name, it's trivial to move it.
     
    Rukbat, Feb 25, 2012 IP
  5. wiseguy212

    wiseguy212 Active Member

    Messages:
    100
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    71
    #5
    I would have to agree with Rukbat.

    Wordpress would be the best place to start. Easy to install and maintain. And with all of the available plugins I'm sure you could fine exactly what you are looking for.

    Good Luck!
     
    wiseguy212, Feb 25, 2012 IP
  6. TurkeyEater

    TurkeyEater Active Member

    Messages:
    264
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #6
    I appreciate all of your help. I am already coding basic php and running/hosting multiple websites though so I dont think moving back to wordpress would be a good move. (unless you all are saying that wordpress has super user friendly database support for what I am looking to do). How hard is integrating Mysql data into a regular html webpage?
     
    TurkeyEater, Feb 25, 2012 IP
  7. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #7
    It's impossible - you do SQL on the server, not in the client, which is where HTML is used. As far as how easy it is - if you know SQL it's pretty easy, if you don't it's not doable. That's like asking how easy it is to speak French. Any 5 year old French kid can do it pretty well. If you've never worked with SQL I wouldn't recommend just "doing it". You'll be spinning your wheels for a long time.

    And to make that something that the user can upload data to the database? That's an additional level you'd have to learn. With WordPress, if you allow everyone to post, you should be able to have the whole thing set up in less than one day, from "I just bought web hosting" to "it's ready for people to post recipes on".
     
    Rukbat, Feb 26, 2012 IP
  8. dpmembers

    dpmembers Member

    Messages:
    178
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    26
    #8
    yup I agree, my sql is the way to go.. :)
     
    dpmembers, Feb 26, 2012 IP
  9. outsource789

    outsource789 Member

    Messages:
    73
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #9
    MySQL is the easiest way to start database website.
     
    outsource789, May 4, 2012 IP
  10. warek44

    warek44 Greenhorn

    Messages:
    37
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #10
    I don't know about cache but the strange thing is I can not see the impressions in Google website for couple of days back and people do come from google which I have seen in Google Analytics, so something is going on with Google.
     
    warek44, May 6, 2012 IP
  11. jassicarunny

    jassicarunny Peon

    Messages:
    26
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #11
    I suggest for MySQL. MySQL is a very popular Relational Database Management System. MySQL is able to handle databases of up to 50 million rows. The size of a table can go up to 4GB but if you really want to and have the resources you can increase it to 8 million terabytes. MySQL provides a implementation of a SQL database very well suited for small to medium web pages.
     
    jassicarunny, May 6, 2012 IP
  12. za1ntc

    za1ntc Peon

    Messages:
    37
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #12
    mysql is the only realistic option for something like this..
     
    za1ntc, May 7, 2012 IP