1. This forum is ARCHIVED! Visit the new Cloud Sixteen forums, codename Eden, at https://eden.cloudsixteen.com. These forums will remain archived for a few months before being closed down, so try to encourage plugin developers to begin moving their content across to the new forums.
Dismiss Notice
Hi Guest, you need a Steam account to register and post on these forums. Login with Steam at the top of the forums to get started!
Dismiss Notice
Hi Guest, do you want to buy HL2RP or another Clockwork schema? Visit the Cloud Sixteen Store to get started!

(I need a(n)) Explanation of MySQL Databases.

Discussion in 'Discussion' started by Devin, Sep 8, 2014.

  1. Devin

    Devin Guest

    Explanation of MySQL Databases?
    What is it used for?
    Why is it used?
    What can it do for a server owner and/or Developer?

    (I'll more frequently be coming to C16 for questions regarding programming - hope that's cool with you guys. Maybe someone [me] could compile it in the end for resources for new people like I [will] would at that time be.
     
    Devin, Sep 8, 2014
    #1
  2. Sir Trolled

    Sir Trolled Guest

    MySQL (My Structured Query Language) is an open-source relational database management system. In Clockwork, it used to store character data, such as the contents of a character's inventory.

    What can it do for an owner/dev? Well.. it makes the server work..
     
    Sir Trolled, Sep 8, 2014
    #2
  3. Devin

    Devin Guest

    So a database that holds character information.
    Simple enough.
     
    Devin, Sep 8, 2014
    #3
  4. Sir Trolled

    Sir Trolled Guest

    I mean, it holds other stuff too. Like the placement of props around the map, who's whitelisted for Faction A and who's not whitelisted for Faction A, etc.

    It's crucial to the correct functioning of a server.
     
    Sir Trolled, Sep 8, 2014
    #4
  5. Sophia

    Sophia Guest

    MySQL Also does a lot more than just hold information for HL2RP. You can use it to hold information for quite a god damn lot of things :p Clockwork just uses it for some reason. Though... I don't know why a local database file couldn't have been used instead... Mhmm... Would definitely save on server costs perhaps...

    Perhaps some kind of mod/plugin that forces clockwork to use a local database file instead of an external server based database. (No, I'm not on about 127.0.0.1 or localhost or whatever, I mean a literal database file.)
     
    Sophia, Sep 8, 2014
    #5
  6. Sir Trolled

    Sir Trolled Guest

    I know, but he's on a forum for a framework that utilizes MySQL in such a way. I mean, what do you want me to say?
     
    Sir Trolled, Sep 8, 2014
    #6
  7. Sophia

    Sophia Guest

    I know, I was just giving/creating a bigger discussion point :p
     
    Sophia, Sep 8, 2014
    #7
  8. Vortix

    Vortix Moderator Staff Member Moderator Legend Clockwork Customer

    Lots of data is stored using MySQL.
    When you signed up for the forums your information became stored in a MySQL database. These details will be checked whenever you log in in the future (If you are wondering, your password isn't visible to someone accessing the database, not directly at least. It is hashed (Basically, not in plain text).
    So, to answer your questions:

    What is it used for?: To store important information
    Why is it used?: Very easy way of storing and retrieving information
    What can it do for a server owner and/or Developer?: For a typical server owner/developer it won't do much. It will only allow them to use Clockwork, as that required connection to a MySQL database. I can't see developers having much use for it as when developing I find that there are so many ways to save information that I wouldn't need to use MySQL.
     
    Vortix, Sep 8, 2014
    #8
  9. duck

    duck Phant0m Legend

    No. Props are not in the SQL.
     
    duck, Sep 8, 2014
    #9
  10. Dremek

    Dremek

    MySQL is pretty much an easier, faster, more organized way to store data in tables, that require to read/write constantly, or quickly.

    It stores (for clockwork):
    - Characters
    - Player Information, Including Flags, Whitelists, and So On.
    - Bans

    And that's about it. (Some plugins utilize MySQL though, and add things like ViewData.)

    It's used because it's easier to make new tables, entries, etc under a preset value that the tables will have, with different data, instead of having to write it ALL to a file, which is slower, takes up more power, unorganized, a larger amount of data, and so on.

    Instead of having to write table "CharName" in a .cw file as; "CharName = GuyMoon", with a MySQL database you can write "Charname" as the parameter, and it's easy to create new "CharName" entries on the go.

    I'm really bad at explaining, but that's essentially it.
     
    Dremek, Sep 11, 2014
    #10

Previous Readers (Total: 0)