Forums

Hi guys, I'm new in the field of web dev, and game dev. However, I'm starting designing games with the Godot Engine and I was looking for a good place to deploy REST API to manage game data. Since I'm a python user, why not trying PythonAnywhere? However, I was wondering why people use Firebase, or Google stuff the most, when game dev comes into play. Is there any limitation I can't figure out right now in using PythonAnywhere for REST API involved in (webGL or Android) Games? Maybe limitations about storaging, bottleneck problems typical in the world of game data managing. I don't know. What do you think?

I'm figuring out that maybe one of the problems can be related to the SQL databases. Suppose I have a game in which I'm interested in saving the stream of coordinates describing the position of a character in time. How should I save this vector of coordinates in MySQL? Is it possible to save vectors or matrices of floats in a column of the database?

I'm not really experienced enough in game development to be able to advise on what kind of server side you would need, but I can certainly answer the second question -- if you're storing vectors, the best thing would be to keep each component of the vector in a separate column, so for a location in 3D space you'd have columns for x, y and z. For a matrix, you could "unroll" it, so if it was a 4x4 matrix you'd have 16 columns, one for each number.

Is this solution inefficient, or expensive, compared to, for instance, saving vectors as strings (e.g. "[0.3, 0.45, 0.3]")?

They're basically the same.