Thread: Sql

Page 1 of 2 12 LastLast
Results 1 to 10 of 14
  1. #1 Sql 
    Registered Member hybrent's Avatar
    Join Date
    Nov 2007
    Posts
    566
    Thanks given
    73
    Thanks received
    90
    Rep Power
    28
    I am very new to SQL and am wondering which SQL is best fit for rsps.

    Everyone here seems to use MySql, but I know there are others like SQLite, etc.
    Are there any specific pros/cons you can think of between the different ones?
    I'd like to store most of my data in a SQL database, including NPC spawns, player data, and objects.

    Again, I really don't know much about SQL besides what it's for etc, but I would really like to learn.
    Amused as I am not, I must continue to try. -Keith Charles
    Quote Originally Posted by Ayton View Post
    I'm sorry, but I have to agree with Hybrent.
    Reply With Quote  
     

  2. #2  
    Registered Member
    G0nzo's Avatar
    Join Date
    Feb 2009
    Posts
    4,960
    Thanks given
    514
    Thanks received
    546
    Rep Power
    1735
    people use MYSQL for the fact its easy to hook up to there forums so on
    Computer Science Graduate, Java Expert
    Need help with something? PM me
    Reply With Quote  
     

  3. #3  
    Registered Member
    Join Date
    Jul 2006
    Posts
    178
    Thanks given
    2
    Thanks received
    2
    Rep Power
    58
    MySQL is for online use - its possible to connect to it from outside, if you give a username/password. That's why its used for highscores, connecting servers with forums, etc. Because of that, it's more flexible, but also more difficult to set up properly.

    SQLite seems to be more of a back-end engine - SQLite is embedded/linked directly to your program at the compiling stage - no requirement for seperate connecting pieces. That makes it easier to configure, since there is no need for setting ports, security settings, etc. However, that also means you cannot connect to it from the outside, so it's strictly local.

    Both are SQL, however, so the matter is : do you want a flexible online database (MySQL), or a easy-to-install local one (SQLite)
    ~ Known as stmserv on Mopar ~
    ~ Maker of Sly's Cheat Client ~
    Reply With Quote  
     

  4. #4  
    Registered Member

    Join Date
    Sep 2008
    Posts
    275
    Thanks given
    0
    Thanks received
    3
    Rep Power
    229
    Quote Originally Posted by hybrent View Post
    I am very new to SQL and am wondering which SQL is best fit for rsps.

    Everyone here seems to use MySql, but I know there are others like SQLite, etc.
    Are there any specific pros/cons you can think of between the different ones?
    I'd like to store most of my data in a SQL database, including NPC spawns, player data, and objects.

    Again, I really don't know much about SQL besides what it's for etc, but I would really like to learn.
    Down the line you will most likely want to either

    1. Make highscores
    or
    2. Intergrate with your forums.

    I recommend MYsql
    Reply With Quote  
     

  5. #5  
    Registered Member hybrent's Avatar
    Join Date
    Nov 2007
    Posts
    566
    Thanks given
    73
    Thanks received
    90
    Rep Power
    28
    Alright, thanks guys.

    I guess I'll stick with MySql then.
    Repped for the help.
    Amused as I am not, I must continue to try. -Keith Charles
    Quote Originally Posted by Ayton View Post
    I'm sorry, but I have to agree with Hybrent.
    Reply With Quote  
     

  6. #6  
    Renown Programmer
    veer's Avatar
    Join Date
    Nov 2007
    Posts
    3,746
    Thanks given
    354
    Thanks received
    1,370
    Rep Power
    3032
    ppl are noobs and have never heard of spring framework
    Reply With Quote  
     

  7. #7  
    Super Donator


    Join Date
    Jun 2007
    Age
    31
    Posts
    2,157
    Thanks given
    316
    Thanks received
    282
    Rep Power
    779
    Quote Originally Posted by super_ View Post
    ppl are noobs and have never heard of spring framework
    Heard it, never looked into it. Would you care to enlighten me?
    Reply With Quote  
     

  8. #8  
    Renown Programmer
    veer's Avatar
    Join Date
    Nov 2007
    Posts
    3,746
    Thanks given
    354
    Thanks received
    1,370
    Rep Power
    3032
    Quote Originally Posted by HcoJustin View Post
    Heard it, never looked into it. Would you care to enlighten me?
    it's basically amazing and reduces the amount of boiler plate code ten-fold.
    Reply With Quote  
     

  9. #9  
    Super Donator


    Join Date
    Jun 2007
    Age
    31
    Posts
    2,157
    Thanks given
    316
    Thanks received
    282
    Rep Power
    779
    Quote Originally Posted by super_ View Post
    it's basically amazing and reduces the amount of boiler plate code ten-fold.
    Well i'll definitely have to check it out.
    Reply With Quote  
     

  10. #10  
    Valar Morghulis

    Laxika's Avatar
    Join Date
    Sep 2006
    Age
    32
    Posts
    2,813
    Thanks given
    1,804
    Thanks received
    274
    Rep Power
    2128
    I highly recommend MySQL... (If you can't set up yourself, just use Xampp or EasyPHP... )
    Reply With Quote  
     

Page 1 of 2 12 LastLast

Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

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