SQLite for servers
#5

Quote:
Originally Posted by ******
Посмотреть сообщение
If you are using SAMPGDK, you could go through the PAWN natives to the inbuilt SQLite database, but you might be as well off including the latest version directly in to your plugin. I can't see any real downside to doing that, you will have full access to all functions, a more direct and faster connection, and know that it is the version you want.
Going through the PAWN natives would be slower and actually a little harder, heh. Nah, I'm compiling it myself. I pointed out the lack of distinction about SA-MP's SQLite version as I was interested in knowing how valid any opinions on using SQLite would be here. I can easily assume any complaints about the performance of SQLite compared to say, the much popular MySQL, wouldn't apply for me.

I'm not sure about access from a web server either. Obviously it's going to be required on some level eventually. Though if the server is running will it be readable or even flushed until the database is closed? Would it be necessary or even better to have the server sync the local database with the MySQL one periodically? Maybe I'm just over-complicating things in my mind now...

It's perfect in every way to handle most other things I need it for - those that are only going to be accessed by the server. I just need re-assurance that I can avoid MySQL altogether.
Reply


Messages In This Thread
SQLite for servers - by Deji - 03.06.2014, 20:12
Re: SQLite for servers - by Calgon - 03.06.2014, 20:38
Re: SQLite for servers - by Deji - 03.06.2014, 20:57
Re: SQLite for servers - by Calgon - 03.06.2014, 21:03
Re: SQLite for servers - by Deji - 03.06.2014, 21:08
Re: SQLite for servers - by Deji - 03.06.2014, 21:50

Forum Jump:


Users browsing this thread: 3 Guest(s)