Photon and user databases

I need to make users in my game, which all have a password and a certain amount of money that is constantly changing and can be used inside the shop. What would be the best approach in creating this? Using a mySQL server? I don’t know anything about databases so I’m just looking for the first step in the right direction any advice would be greatly appreciated.

If you are not familiar with databases - you can use App42 BaaS (Backend as a Service). It has a C# SDK that you can use and has a ready made User management module. So using that you will not have to configure/host/scale a DB etc. as its managed by App42. Here are some links you can see for this

App42 C# getting started
App42 User management guide

I’m working on a mac so I can’t use visual studio, will this be a problem?

No that shouldn’t be a problem. I suggested C# because I assume you are doing your server side in C#. App42 SDK is independent of the IDE/OS that you work in. It supports other languages too other than C#.

So with App42 I could create a user database which handles a buddy list, ratings, ect? and use that with photon?

What if I used this? Would this be able to be used hand in hand with photon?

If you use photon server, you may use mysqlconnector.
If you use photon cloud, you may use http queries to php+mysql.

I can’t comment about it but from a quick look it will require you to host the server side yourself (server side php scripts are provided). With a BaaS such as App42, you only use the SDK and don’t do anything (hosting or writing) server side. The App42 backend SDK is independent of other tools and technologies that you use. So it doesn’t matter if you are using Photon or something else along with it. You can also post your App42 specific questions on http://forum.shephertz.com

Yes, you can use this (or similar) login system with Photon Cloud.

You can host php/mysql on Azure:
http://www.windowsazure.com/en-us/documentation/articles/web-sites-php-mysql-deploy-use-git/

or Google app engine:
https://developers.google.com/appengine/docs/php/

or run your own server on Amazon EC2 etc.

Chris