1. The forums will be archived and moved to a read only mode in about 2 weeks (mid march).

Use SQLITE3 or MYSQL For DATA SAVING (COINS)

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

  1. Levi

    Levi Skeleton

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

    SOFe Administrator Staff Member PMMP Team Poggit Admin

    Messages:
    1,968
    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

    Messages:
    1,968
    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

    Messages:
    1,968
    GitHub:
    sof3
    In theory, if your traffic is high and if you have multiple processes accessing it, SQLite would use more CPU.
     
  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.