SQLite or MySQL? - Printable Version

SQLite or MySQL? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SQLite or MySQL? (/showthread.php?tid=623316)

SQLite or MySQL? - Infernux - 30.11.2016

Hello everyone, I have a Gamemode running with MySQL, but I have a problem, I don't want to have a VPS so I must have my database separated of my server samp...

I have read few topics, some people say mysql is better, but some others say sqlite...

And I had a server with the database separated from it before, and sometimes when the users connected, they couldn't see the login dialog (what appeared after connect to the database), it means... connection lost.

So I need help, and tell me the advantages of both, and why I should use each one...

Thanks for your help

Re: SQLite or MySQL? - StrikerZ - 30.11.2016

See. Mysql is good but it requires phpmyadmin to run on and a host ofcourse for it. And sqlite it needs no host it creates its own file in format .db. With Mysql you can create ucp and can link other things. But i'll prefer mysql.

Re: SQLite or MySQL? - Infernux - 30.11.2016

Yes... But, how can I solve the lost connection problem?

Re: SQLite or MySQL? - SickAttack - 30.11.2016

Use either one, neither is better. The lost connection issue is most likely your fault for making a mistake in the code.

Re: SQLite or MySQL? - Infernux - 30.11.2016

Quote:

Originally Posted by SickAttack

Use either one, neither is better. The lost connection issue is most likely your fault for making a mistake in the code.

But it only happens when it is in the host... In my pc (with both the database and the server in the same host), never happens...

Re: SQLite or MySQL? - SickAttack - 30.11.2016

Quote:

Originally Posted by Infernux

But it only happens when it is in the host... In my pc (with both the database and the server in the same host), never happens...

The lost connection issue is most likely your fault for making a mistake in the code. End.

Re: SQLite or MySQL? - Infernux - 30.11.2016

Quote:

Originally Posted by SickAttack

The lost connection issue is most likely your fault for making a mistake in the code. End.

Do you think there is an issue connecting to the database? Or at the moment when the user connects?

Thanks

Re: SQLite or MySQL? - Vince - 30.11.2016

Quote:

Originally Posted by Infernux

I don't want to have a VPS so I must have my database separated

What? Most shared hosts (i.e. buying slots) provide at least one free MySQL database.

Re: SQLite or MySQL? - Infernux - 30.11.2016

Quote:

Originally Posted by Vince

What? Most shared hosts (i.e. buying slots) provide at least one free MySQL database.

Could you tell me one, please?

Re: SQLite or MySQL? - Micko123 - 30.11.2016

www.frag.gs is free and it have one MySQL Database..
If free has one than paid hosts must have it also..