SQLite capabilities on MTA, What is possible

[RughCuttle]

 So, i choose MTA over SAMP recently, to start learn scripting and developing my own server. Okay...

  I'm reading some scripts and by them, start browsing about the MTA's integrated systems that could help me develop an amazing or at least good experience, to my self and other players. The first thing that I've been facing is SQLite. I understood that it's a language  of some kind to create a database, which could have: group names with their slots and store any change related with those; Items in market with fluctuating price; Car names, colors or price that are owned by the players; Inventory system, etc... But, when i read about SQlite i noticed that there's some features that could be invasive, since it can access third-party programs or CSV files to create analysis between variables. In resume, i want to know if all assets that i could use normally with SQlite is available on MTA:SA.

[Dimos7]

What dou you mean?

[LilDawage]

Sqlite is available on MTA:SA. , you can save all data of players groups skins /health /armour /cars /and groups name /dates .......................

Sqlite system can be connected in local host , but SQL system you need a host to connect it 

if you want more info , explian us wut do you want know exectly

thank you

[RughCuttle]

3 hours ago, LilDawage said:

Sqlite is available on MTA:SA. , you can save all data of players groups skins /health /armour /cars /and groups name /dates .......................

Sqlite system can be connected in local host , but SQL system you need a host to connect it 

if you want more info , explian us wut do you want know exectly

thank you

I want to know if all SQLite's power is available on MTA (with no restrictions, i mean). Basically. Or there's something that i can't do with SQL due to some restriction on the MTA's side.

[LilDawage]

21 minutes ago, RughCuttle said:

I want to know if all SQLite's power is available on MTA (with no restrictions, i mean). Basically. Or there's something that i can't do with SQL due to some restriction on the MTA's side.

yeh all functions all available on mta sa , the Basic system Not changed on mta sa , you can create your own SQLITE save system with any way you want to do

as you can do : 

executeSQLDropTable

executeSQLQuery

executeSQLCreateTable

executeSQLUpdate

as you see there is many ways to create /Update /load your SQLITE system , it based for creating The  Columns > name > value  

>>>>>>>>>>>>>>> CREATE TABLE IF NOT EXISTS accountdata ( Username VARCHAR(100), Money INT, Armour INT, Health INT) , create table inside it we found The Name of account and the value  of Money Health and armour for that account 

the same for Position for player , and Groups ... and more

Edited April 21, 2018 by LilDawage

[Master_MTA]

22 minutes ago, RughCuttle said:

I want to know if all SQLite's power is available on MTA (with no restrictions, i mean). Basically. Or there's something that i can't do with SQL due to some restriction on the MTA's side.

you can use mysql module to use lua formula mysql functions

[RughCuttle]

19 hours ago, LilDawage said:

yeh all functions all available on mta sa , the Basic system Not changed on mta sa , you can create your own SQLITE save system with any way you want to do

as you can do : 

executeSQLDropTable

executeSQLQuery

executeSQLCreateTable

executeSQLUpdate

as you see there is many ways to create /Update /load your SQLITE system , it based for creating The  Columns > name > value  

>>>>>>>>>>>>>>> CREATE TABLE IF NOT EXISTS accountdata ( Username VARCHAR(100), Money INT, Armour INT, Health INT) , create table inside it we found The Name of account and the value  of Money Health and armour for that account 

the same for Position for player , and Groups ... and more

Thanks. m8

19 hours ago, Master_MTA said:

you can use mysql module to use lua formula mysql functions

Also, i appreciate your explanation to.

[MIKI785]

On 4/21/2018 at 23:34, Master_MTA said:

you can use mysql module to use lua formula mysql functions

No need for a module, just use db* functions listed here: https://wiki.multitheftauto.com/wiki/Template:SQL_functions.

You can do whatever you want with those, supports both SQLite and MySQL.

[Master_MTA]

16 minutes ago, MIKI785 said:

You can do whatever you want with those, supports both SQLite and MySQL.

just try to read what i wrote above there