SQLite or MySQL?
#1

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
Reply
#2

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.
Reply
#3

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

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

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...
Reply
#6

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.
Reply
#7

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
Reply
#8

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.
Reply
#9

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?
Reply
#10

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


Forum Jump:


Users browsing this thread: 1 Guest(s)