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 / AGK / Server and SQL

Author
Message
puzzler2018
User Banned
Posted: 18th Mar 2019 21:39
Link
Hello

Im developing some tools for work to be able to create some GUI software on Android tablets, the software requires to communicate with a server and an SQL Database

Can this be done?

Thanks in advance
Tier 1 Developer
Back to top
Profile
puzzler2018
User Banned
Posted: 18th Mar 2019 21:45 Edited at: 18th Mar 2019 21:45
Link
If not, then i can still create the GUI and the responses to create a text file using RAW: to send the result file to a server location and the i create a C# app to run every minute which reads that text file to do all the back end stuff for me

)))))
Tier 1 Developer
Back to top
Profile
GarBenjamin
AGK Developer
7
Years of Service
User Offline
Joined: 30th Nov 2016
Location: USA
Posted: 18th Mar 2019 21:49 Edited at: 18th Mar 2019 21:50
Link
I think someone made a SQL Lite plugin around here some place might be helpful
My Projects Most With Full Source...
[Attack of the Crows] [Christmas Command 2016]
[Simple Sprite Shaders Example] [Old School Style 3D FPS]
[Playable 2D Shmup Template] [2D Single Screen Platformer]
[FixSpriteToSprite System & Demo]
[Mutant Invaders 3D Shmup]
[Unity - Atlantic Crisis] [Unity - Treasures of Ali-Gar]
[AppGameKit BASIC Extended API] [Ultra LowRez Tower Defense]
[New!! C3 - Christmas Cube's Amazing Christmas Quest]
[My YouTube Videos] [Twitter]
Back to top
Profile PM
puzzler2018
User Banned
Posted: 18th Mar 2019 21:55
Link
Wow - thank GarBenjamin - ill have a browse for that - would be very useful
Tier 1 Developer
Back to top
Profile
Ortu
DBPro Master
17
Years of Service
User Offline
Joined: 21st Nov 2007
Location: Austin, TX
Posted: 19th Mar 2019 01:03
Link
Sqlite is typically for local data, and i don't know of one for agk, only dbpro.

You definitely don't want to hammer a file system or poll for a text file.

Use the http web request commands to communicate with a web server.

The server can implement the database handling and pass the results back to the app.

Is this a windows server or linux?
Sql server or mysql?



http://games.joshkirklin.com/sulium

A single player RPG featuring a branching, player driven storyline of meaningful choices and multiple endings alongside challenging active combat and intelligent AI.
Back to top
Profile PM Email Website
2D Analyst
AGK Developer
20
Years of Service
User Offline
Joined: 2nd May 2004
Location:
Posted: 19th Mar 2019 01:28
Link
Exactly what the user above mentioned. Using http communications will allow you to pass data from AppGameKit to http to server side script such as php, asp.net, etc to sql dB.

LAMP is probably the most popular open source setup. Linux Apache MySQL PHP.
Back to top
Profile PM Website
Back to top

Login to post a reply

Server time is: 2024-11-26 17:00:27
Your offset time is: 2024-11-26 17:00:27