Looking for MySQL Examples


#1

I was searching for examples of how you might use the MySQL integration to access information from multiple tables. For example, perhaps you store user information in one table and a leaderboard in another table.

Would it be something like this.$user.$data.leaderboard.rank or no? Could you use SQL queries?


#2

Thanks @Porterhaus for the great question! :sunglasses:

The quick answer is that the MySQL database is not so deeply integrated that it fetches data from other tables than the one for the user data on each request, or that it directly provides in interface to make SQL queries with. But I’m working on an example project that shows how to use the dependencies and config files of the MySQL integration to query other tables from the same database. Stay tuned!


#3

So, finally I got around to building a sample app that uses some interesting MySQL features - I hope you (everyone, but especially @Porterhaus) find it helpful! :smiley: