Use SQLITE3 or MYSQL For DATA SAVING (COINS)

Discussion in 'Help' started by Levi, Jun 29, 2018.

  1. Levi

    Levi Zombie Pigman

    Messages:
    613
    GitHub:
    captainleviftw
    which one mysql or sqlite3 to store my player coins
     
  2. SOFe

    SOFe Administrator Staff Member PMMP Team Poggit Admin Noobiest member in the PMMP Team

    Messages:
    1,709
    GitHub:
    sof3
    SQLite3 and MySQL are two different things. SQLite3 operates on a single file, and MySQL is a service from a separate process. This totally depends on your individual use case.
     
    HimbeersaftLP and corytortoise like this.
  3. Nader Jafari

    Nader Jafari Silverfish

    Messages:
    16
    If you don't have enough resources (CPU, RAM) use SQLite
    Otherwise, MySQL
    And for your coins
    EconomyAPI uses yaml by default
    Why you don't use it
    Yaml is simple to use, stores in a text file with lowest storage usage you want to store data such as
    playerA: 15Coins
    playerB: 20Coins
    Use SQLite and MySQL for store data such as
    playerA:
    Coins: 15
    NameTag: PlAyErA
    CID: lwjrskvbdxhvkbdoorshghejshg
     
    Last edited: Aug 10, 2018
  4. SOFe

    SOFe Administrator Staff Member PMMP Team Poggit Admin Noobiest member in the PMMP Team

    Messages:
    1,709
    GitHub:
    sof3
    SQLite3 does not necessarily use less CPU.
     
  5. Nader Jafari

    Nader Jafari Silverfish

    Messages:
    16
    I worked with it when I was developing web applications
    You are right but at Theory in Working SQLite uses less than MySQL
     
  6. SOFe

    SOFe Administrator Staff Member PMMP Team Poggit Admin Noobiest member in the PMMP Team

    Messages:
    1,709
    GitHub:
    sof3
    In theory, if your traffic is high and if you have multiple processes accessing it, SQLite would use more CPU.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.