I need your advice

User avatar
LMD
Member
 
Posts: 624
Joined: Sat Apr 08, 2017 08:16
Location: Somewhere over the Rainbow : Bonn, Germany
GitHub: appgurueu
In-game: LMD + PRO_LMD + Limo

I need your advice

by LMD » Wed Mar 14, 2018 19:45

So I am developing a SQLite DB application for MT, client-side, called MTPC - Minetest Package Control, and need the opportunity that my program(and any user) can update and sync an online stored DB, BUT WHERE SHOULD I HOST IT ?
GitHub + Java Git Library - Pros : not that hard, Cons : 25 MB Limitation
any other ideas ?
Magic-CTF(soon)MTPCFractal-SuiteModel Creator Schematic CreatorColorfulXmas BallsWebsite • Never judge me by my age
 

hajo
Member
 
Posts: 594
Joined: Thu Oct 13, 2016 10:45
Location: DE

Re: I need your advice

by hajo » Wed Mar 14, 2018 20:16

LMD wrote:SQLite DB application for MT .. Minetest Package Control ..WHERE SHOULD I HOST IT ?

What exactly do you want to store in that db,
and how much data would that be, per user/account ?
 

User avatar
LMD
Member
 
Posts: 624
Joined: Sat Apr 08, 2017 08:16
Location: Somewhere over the Rainbow : Bonn, Germany
GitHub: appgurueu
In-game: LMD + PRO_LMD + Limo

Re: I need your advice

by LMD » Thu Mar 15, 2018 13:21

Nope I dont store any userdata, I store mod/subgame/TP data. You can estimate the mod amount.
Magic-CTF(soon)MTPCFractal-SuiteModel Creator Schematic CreatorColorfulXmas BallsWebsite • Never judge me by my age
 

hajo
Member
 
Posts: 594
Joined: Thu Oct 13, 2016 10:45
Location: DE

Re: I need your advice

by hajo » Fri Mar 16, 2018 09:33

LMD wrote:I dont store any userdata, I store mod/subgame/TP data.

What kind of data ?
How & for whom is that useful ?
 

User avatar
LMD
Member
 
Posts: 624
Joined: Sat Apr 08, 2017 08:16
Location: Somewhere over the Rainbow : Bonn, Germany
GitHub: appgurueu
In-game: LMD + PRO_LMD + Limo

Re: I need your advice

by LMD » Fri Mar 16, 2018 18:28

U know some Package Managers ? Where do u search ur software ? This is a PC for MT.
Magic-CTF(soon)MTPCFractal-SuiteModel Creator Schematic CreatorColorfulXmas BallsWebsite • Never judge me by my age
 

sofar
Developer
 
Posts: 1698
Joined: Fri Jan 16, 2015 07:31
GitHub: sofar
IRC: sofar
In-game: sofar

Re: I need your advice

by sofar » Fri Mar 16, 2018 18:52

I wouldn't use Sqlite on the server side. Maybe as a backend to some web interface, but definitely do not expose this file directly to clients.

The server should expose a JSON file instead. There are methods to easily parse JSON in minetest so you can just load the JSON directly using the http api into lua in minetest and use it.

On the client side you can use Sqlite of course just fine, and store it somewhere in ~/.minetest or similar.
 

User avatar
LMD
Member
 
Posts: 624
Joined: Sat Apr 08, 2017 08:16
Location: Somewhere over the Rainbow : Bonn, Germany
GitHub: appgurueu
In-game: LMD + PRO_LMD + Limo

Re: I need your advice

by LMD » Fri Mar 16, 2018 20:39

sofar :
There isn't a "server".
There's only many clients and ONE package list which is always synced with the clients package list :
If the user decides to edit/delete package information, the online stored db is updated too.
In my opinion, it has to made client-side, and not as web interface, to easily allow the user the following features :
- installed mods/subgames/texture packs ?
- update mods/subgames/texture packs ?
- install/remove mods/subgames/texture packs ?
Only a standalone application can be mighty enough.
Magic-CTF(soon)MTPCFractal-SuiteModel Creator Schematic CreatorColorfulXmas BallsWebsite • Never judge me by my age
 

sofar
Developer
 
Posts: 1698
Joined: Fri Jan 16, 2015 07:31
GitHub: sofar
IRC: sofar
In-game: sofar

Re: I need your advice

by sofar » Fri Mar 16, 2018 21:25

LMD wrote:sofar :
There isn't a "server".
There's only many clients and ONE package list which is always synced with the clients package list :
If the user decides to edit/delete package information, the online stored db is updated too.
In my opinion, it has to made client-side, and not as web interface, to easily allow the user the following features :
- installed mods/subgames/texture packs ?
- update mods/subgames/texture packs ?
- install/remove mods/subgames/texture packs ?
Only a standalone application can be mighty enough.


So sqlite on the client to maintain lists is fine, as I already said, and probably the best way to do this.

But what format is "ONE package list which is always synced with the clients package list"? That's the one that should be JSON. How is it created? Who creates the first version? How do clients get it? Why can clients update the online stored DB? THis seems like open to abuse?

I guess I don't understand your architecture, or you are not describing it in enough detail.
 

User avatar
rubenwardy
Moderator
 
Posts: 5470
Joined: Tue Jun 12, 2012 18:11
Location: United Kingdom
GitHub: rubenwardy
IRC: rubenwardy
In-game: rubenwardy
 

User avatar
LMD
Member
 
Posts: 624
Joined: Sat Apr 08, 2017 08:16
Location: Somewhere over the Rainbow : Bonn, Germany
GitHub: appgurueu
In-game: LMD + PRO_LMD + Limo
 


Return to General Discussion



Who is online

Users browsing this forum: Gael de Sailly and 6 guests