Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

AppGameKit Classic Chat / SQLITE3 Plugin for AGK2?

Author
Message
Duffer
21
Years of Service
User Offline
Joined: 9th Feb 2003
Location: chair
Posted: 30th Jun 2017 19:41
Hi Paul, All,

Just coming back to this forum to see where things have gone with AGK2. Wondering if it has support now for SQLITE3 or some other open database format?

I'd raised this back in 2015:- https://forum.thegamecreators.com/thread/217482 and wondered if it had been taken any further forward or anyone had built any kind of useful plugin along these lines?
a long time dabbler with DBC and DBPro with no actual talent but lots of enthusiasm...
Dybing
13
Years of Service
User Offline
Joined: 12th Sep 2011
Location: Bergen, Norway
Posted: 1st Jul 2017 19:09 Edited at: 1st Jul 2017 19:11
Repeat after me: You never - EVER - let the client have direct access to the backend database!

Everything need be sanitized, checked and controlled through (usually RESTful HTTPS) backend APIs. That way no sneaky b*st*rd can sniff out your DB credentials by poking around the client or hit the DB directly with various nefarious SQL queries - including ruining your entire day by dropping tables everywhere. Which soon becomes ruining a career if you do not have a strict backup regime...

So, learn a language that is backend friendly. Python, Go, PHP, C# and Java are good ones. Listed in order of easyness to learn. Any of those will happily (and securely) allow you to do any DB juggling you'd ever want, and present to the client the result however you wish over HTTP requests.

So no, the very last thing AppGameKit needs is ability to hook up to DBs directly.
PartTimeCoder
AGK Tool Maker
9
Years of Service
User Offline
Joined: 9th Mar 2015
Location: London UK
Posted: 2nd Jul 2017 07:29
Quote: "So no, the very last thing AppGameKit needs is ability to hook up to DBs directly."


SQLite is local single client access database and the perfect solution for storing local gamedata, so yes, AppGameKit does need to support it, an attack on a local db is.. well... pretty pointless!
Duffer
21
Years of Service
User Offline
Joined: 9th Feb 2003
Location: chair
Posted: 15th Jul 2017 10:23
and looks like you've built something! I will take a look...
a long time dabbler with DBC and DBPro with no actual talent but lots of enthusiasm...

Login to post a reply

Server time is: 2024-09-30 05:38:36
Your offset time is: 2024-09-30 05:38:36