Basic MySQL

[Samten]

Hi,

currently working on a project requiring me to make a user database, first time for that. Semi experienced programmer. Anyone who has got any experience with creating databases like this, could you give me a short explanation of how it works and how to set it up, important things to note and helpful tips? Will probably be running it virtualized locally to begin with as a beta, and then if it works well will probably rent servers later on. As far as my understanding goes atm i dont need anything advanced as all i need is to grant permission to is a browser based software utility and the user database will give permission to those who have bought the software.

[geo3]

Never used mySQL, I've heard it's kinda crap. Maybe look intro using postgresql instead. 

[Flameytail]

Redis is pretty good. i ran a personal game server on redis once. 

[Thias.TG]

MySQL is fine for SMALL applications and websites.

For anything larger look into MSSQL

[Cruorzy]

You guys aren't providing answers which is the most annoying thing to do, leading him on 3 different path's which might even not be necessary.

 

Tell us about the scale of the project,

From what i see you need a login system? which you get credentials to when you have bought the "software" ?

[MyName13]

On 1/22/2018 at 1:28 AM, geo3 said:

Never used mySQL, I've heard it's kinda crap. Maybe look intro using postgresql instead. 

What makes it crap?

[Senior Jay]

First, I would deploy PHPMyAdmin to the SQL Database. This will make everything so much easier. Next, have your login system that co-ordinates with the database be written in php, as so the user cant change the code to create a different outcome. https://www.w3schools.com/php/php_mysql_intro.asp here is a good place to start with PHP Server side programming.

[Cieronph]

First off MySQL is great for anything that isnt enterprise level.... Sure its not the "most" efficient thing ever however it is very close to Vanilla SQL and has by far the most useful tutorials, software etc around for it. I personally would recommend downloading a piece of software called SQL Workbench, at a basic level it connects to your SQL database and checks your syntax + allows you to easily run / manage queries. I would then be writing the SQL in that environment trying to roughly mimic what you think your system will need to do. If you dont have a database environment XAMPP is a great little tool you can install on any windows pc and allows you to very quickly using a GUI  set up a MySQL environment with the default config and PHPmyAdmin (a web interface that allows you to browse SQL tables etc.).

 

From there you kinda need to get into the language a bit, as others have mentioned W3schools is great and has some good examples, however I would urge you try to understand the basics of INSERT, SELECT, DELETE etc as well as JOINS and relationships before trying to code. Joins and unions make your life much simpler when it comes to storing data in multiple tables.

 

For now thats probably enough to be getting on with, but if you have specific examples your stuck on once you've had a go and im sure someone on here will be willing to help out