Vice City: Multiplayer

VC:MP Discussion => General Discussion => Topic started by: vcmptr on Mar 02, 2015, 05:38 AM

Poll
Question: Which do you use?
Option 1: MySQL votes: 12
Option 2: SQLite votes: 7
Option 3: Other votes: 2
Title: MySQL or SQLite?
Post by: vcmptr on Mar 02, 2015, 05:38 AM
Which do you use?
Title: Re: MySQL or SQLite?
Post by: Gudio on Mar 02, 2015, 07:18 AM
MySQL
Title: Re: MySQL or SQLite?
Post by: DizzasTeR on Mar 02, 2015, 09:54 AM
Currently SqLite but soon MySql.
Title: Re: MySQL or SQLite?
Post by: EK.IceFlake on Mar 02, 2015, 11:29 AM
Quote from: vcmptr on Mar 02, 2015, 05:38 AMWhich do you use?
.ini
Title: Re: MySQL or SQLite?
Post by: hotdogcat on Mar 02, 2015, 12:56 PM
SQlite
Title: Re: MySQL or SQLite?
Post by: Sebastian on Mar 02, 2015, 01:05 PM
I didn't work on my server anymore, so none. :)
Btw, why do you ask ?
Title: Re: MySQL or SQLite?
Post by: Sk on Mar 02, 2015, 01:05 PM
nothing is better then mysql when it comes to features but for the time being i am using sqlite.
Title: Re: MySQL or SQLite?
Post by: . on Mar 02, 2015, 01:06 PM
Neither. You don't have to be locked to a specific database. You get the database you think would work best for your project.

What if everyone answers MySQL and then another user comes by and sees that. He just needs to save a user and password somewhere. Does that mean MySQL is the best in this case?
Title: Re: MySQL or SQLite?
Post by: Kratos_ on Mar 02, 2015, 01:58 PM
Quote from: S.L.C on Mar 02, 2015, 01:06 PMNeither. You don't have to be locked to a specific database. You get the database you think would work best for your project.
What if everyone answers MySQL and then another user comes by and sees that. He just needs to save a user and password somewhere. Does that mean MySQL is the best in this case?

Yes ofcourse .

SQLite permits more than one readers ( Fetching data from the database ) but unfortunately only one writer ( moving the data back to the database ) at a time . It will be ideal for smaller server-side database . ( Our Vehicle, Property, Tournament Winners )  whereas MySQL permits concurrent Reading-Writing process simultaneously upto comparable extent . This is what makes MySQL faster & efficient than SQLite . So , it matters definitely . It will be ideal for client/server db system . ( Player Records - Web Stats )

Our servers will have 100 writers at a time ( players who're playing in it ) if we consider that each one start to write something into the database at one point of time .  MySQL is used where the Sqlite handling capacity gets deminished  .  MySQL is gaining an advantage over SQLite in this category .

Currently , I'm using SQLite . SQLite theoretically supports upto 140 TB but the writing operation in it gets queued up as it waits until one process gets over .  I had planned to upgrade my script to MySQL soon .
Title: Re: MySQL or SQLite?
Post by: Stormeus on Mar 02, 2015, 07:56 PM
I actually prefer PostgreSQL, but there's no VC:MP plugin for it as of yet, so MySQL.
Title: Re: MySQL or SQLite?
Post by: Kratos_ on Mar 02, 2015, 08:11 PM

I aint so hard and fast about PostgreSQL as I haven't worked in its before . But , it is known to be good for those who prefer complex design over time, speed , energy and resource . Wouldn't be an over-kill if we use it in VC:MP where databases are smaller . We have several clients sharing the same database & queries are running simultaneously in the server vicinity . Speed and Time couldn't be neglected . So , MySQL is looking optimum to me for a VC:MP server . But, still I want to use the most optimized system available if any .