Howdy, Stranger!
We are about to switch to a new forum software. Until then we have removed the registration on this forum.
Categories
- All Categories 25.7K
- Announcements & Guidelines 13
- Common Questions 30
- Using Processing 22.1K
- Programming Questions 12.2K
- Questions about Code 6.4K
- How To... 4.2K
- Hello Processing 72
- GLSL / Shaders 292
- Library Questions 4K
- Hardware, Integration & Other Languages 2.7K
- Kinect 668
- Arduino 1K
- Raspberry PI 188
- Questions about Modes 2K
- Android Mode 1.3K
- JavaScript Mode 413
- Python Mode 205
- Questions about Tools 100
- Espanol 5
- Developing Processing 548
- Create & Announce Libraries 211
- Create & Announce Modes 19
- Create & Announce Tools 29
- Summer of Code 2018 93
- Rails Girls Summer of Code 2017 3
- Summer of Code 2017 49
- Summer of Code 2016 4
- Summer of Code 2015 40
- Summer of Code 2014 22
- p5.js 1.6K
- p5.js Programming Questions 947
- p5.js Library Questions 315
- p5.js Development Questions 31
- General 1.4K
- Events & Opportunities 288
- General Discussion 365
MySQL on Android or fast alternatives for huge data storage
Hello, it seems that it isn´t possible to get the BezierSQL library work on an Android device so I need an other way to store lots of variables online on a webserver. It´s important that I could get them fast to work with them by runtime. My idea behind this is to make a multiplayer game for android devices and change values like player positions etc. at runtime. greetz Flozzel
Tagged:
Answers
Moved to the Android category as it seems to be related...
You seem to mix concepts! The SQL library, "MySQL on Android", would be related to storing data on a device. Not sure if the owner of the device would appreciate to have "huge data storage" on it, but that's another story.
Then you tell us you want to "store lots of variables online on a webserver". That's a very different need / concept! SQL is probably useless there, at least on the device itself, it must be used on the server. Then on the Android device, your problem is to send the data, not to manage a database.
Again, not sure if the user will appreciate to see its data plan to be eaten by a game, but perhaps that's how multiplayer games work, I never tried one on Android.
The SQL data with it tables would be on the webserver,and BezierSQL is for communicate with it.An account and an internet connection are requirements to play. It´s important to get the data by runtime and analyze it fast without performance decreasement.For example there are 100 players online but I only want to display the players you could see on your area,so I have to analyze the player positions to look if its rational to display them. It does not have to be MySQL but it was the first I think about to implement something like this.
greetz Flozzel
For obvious security reasons, and practical ones, a remote script on the user side should not issue SQL commands to a distant database... Particularly commands that can update the DB!
So the solution will probably to send the data to the server, for example in a REST way (GET / PUT / DELETE etc. HTTP commands), and the server will be responsible for authentication, authorization, and DB usage.
Hm I will try to let Processing communicate with the server via PHP and run a server side script for the MySQL management or something like this.
greetz Flozzel