+- SphereCommunity (https://forum.spherecommunity.net)
+-- Forum: Sphere 0.56d (/Forum-Sphere-0-56d)
+--- Forum: General Help (/Forum-General-Help)
+--- Thread: Local Database Support (/Thread-Local-Database-Support)
Pages: 1 2
Local Database Support - Extreme - 12-26-2013 02:53 AM
Hello guys!!!
How this new feature works?
Can I use my old database?
Thanks
RE: Local Database Support - Feeh - 12-26-2013 05:21 AM
Seems to be the very same as the MySQL, but instead of using the SQL server, the Sphere itself will handle the database using SQLite. , you can store a lot of things without the need of an external SQL server, since it is handled by Sphere's SQLite. As the name suggest, you will not be able to access those data through other services (web and etc...), you will still need the SQL server if you want to use the database with your webpage, like Web Paperdoll script.
In a few words, it is a MySQL database that is used only by Sphere with no need of external SQL server, it may be faster for in-game only data storing
You can clone your old database to the local, but it is limited to Sphere-Only (or any other SQLite program)
RE: Local Database Support - XuN - 12-26-2013 05:30 AM
Yes, it's like SQL server but integrated in the sphere itself, I'm moving my add dialog script to use this SQLite addition, it's gonna be faster and better
RE: Local Database Support - Extreme - 12-26-2013 06:18 AM
Thank you guys!
RE: Local Database Support - Avatar - 12-26-2013 08:20 PM
Have you really tested whether mysql influences game ? I have huge database in my living shard for instance and it is working as "local" and i'm sharing mydatabase with remote connection via permission and editing the content with workbench. I don't really get the main reason of change like this. I do not think it will change anything. Anyway, i bored changing all thing week by week. Really bored
I suppose the main reason is people do not know how to setup mysql server locally, isn't it
. Dont make everything so easy guys.
RE: Local Database Support - Ben - 12-27-2013 12:09 AM
MySQL was not replaced, it's still how it was. SQLite was added as another DB option and it is much faster then a client<->server application.
There are some plans in the future for using this internally, but I thought I would make it available in scripts instead of just sitting there waiting for implementation in the core.
To add to Feeh's comment, you can access the database from web if your server is on your local machine and the files is placed in a location accessible to it, but this is not the intended use of SQLite
RE: Local Database Support - Avatar - 12-27-2013 12:16 AM
Totally misunderstood, at the beginning, i thought you completely changed mysql stuff
) Sorry. I got it.
RE: Local Database Support - babazar - 12-27-2013 07:14 AM
what benefits do you get using mysql with sphere?
RE: Local Database Support - XuN - 12-27-2013 08:26 AM
Having data stored in other source to access it however and wherever you want, ie with PHP, you can do quick search throught the data you have, you can store a lot of things without increasing your save files and time, you don't have to access sphere in each output of data thus having it free for it's proccesses... idk... just look here http://arstechnica.com/information-technology/2013/05/why-use-a-database-instead-of-just-saving-your-data-to-disk/ or search in google the million of reasons to use a DataBase instead of local writing on disk from the program itself.
RE: Local Database Support - Avatar - 01-01-2014 06:18 AM
So Why dont we turn sphereserver save process totally to database from local writing.
Hahaha, That would be awesome and some pain in the ass. I can see that ups.