Welcome to Rants and Raves!
I kept hearing that I needed to write, so here is the blog that I ended up starting.
It is mostly an accounting of my progression through creating a web site, nuances with code, and tips about what I did to make things work.
In there you will find sprinkled about some gems of life, and letting loose fun.
Enjoy!
Too Long Since A Rave
2022-07-18
boots and cats and boots and cats and boots and cats and boots and cats and boots and cats and boots and cats and boots and cats and boots and cats and boots and cats and boots and cats and boots and cats and boots and cats and boots and cats and boots and cats and boots and cats and boots and cats and
Azure Flexible Server Troubles
2022-07-17
First off, deploying is slow. Had issues creating a flexible server. Determined it needs the --public-access parameter, I set it to "None". A location region is also mandatory. Looks like Microsoft is having issues in the East US region, it's little packed and low on resources. Bump down --storage-size to 20 for lowest cost. Requires vnet for app connection.
Powershell For The WIN!
2022-07-15
Powershell is a wonderful tool for automation. I just put the commands for launching a site and DB to AZure into a PS script. For all these tests, and eventually when I am hoping to launch numorous websites to them, this script will save a lot time.
Third MySQL Option
2022-07-12
I almost forgot that there is the Azure Database for MySQL Flexible Server. I've been playing with the Stand Alone Server. Data cost appear to be similar, but the vCore cost is about 1/4. If I recall correctly, it might run the vCore consistantly though, creating more charge. Need to play with it.
Test Site For Charges
2022-07-08
I did another test site regarding charges, letting is sit with no activity. The site only registers the initial creation connections. There were charges in data and vCores, more than I was hoping. Data is charging for reserved, not used, and was less than vCores, which seems to periodically get used. I'm going to eat some more fun money and let it run a bit longer. Time to try and get MySQL in App working.
Charges
2022-07-05
It took Azure long enough, but I now have charges for my playing around. $4.80 for 4 days of having a small DB and web app. While I do understand that $5 dollars is something I can handle for playing, it's way more than I want for my purposes. I know it's a convenience fee, but it's high enough that hosting my own server is really tempting. If we weren't trying to potentially become mobile I don't think I would continue playing with Azure.
Tutorial: Build A PHP And MySQL App In Azure App Service
2022-07-02
Ran through the updated tutorial provided by Microsoft for setting up a Laravel web app with a MySQL database. There were only 2 big hiccups and 1 minor nuance. The nuance is that it makes use of the Azure Database for MySQL Single Server. There are other options offered that might be better suited for the low cost crowd (i.e. me). One of the big problems is that the code that code that you pull from Microsoft has the database connection variables setup for Azure, not for the local instance. The
Tutorial: Build A PHP And MySQL App In Azure App Service 2
2022-07-02
The second was a minor detail regarding a web.config file that needs created so that Azure can handle the Laravel app.
Database Seeding
2022-07-02
I know it's a small thing, but I successfully seeded the Azure database. Granted the task list is just a bunch of names, but it worked. All I did was modify the DatabaseSeeder.php, copied from the User.php model, and tweaked to the Task.php model, and copied and tweaked the UserFactory.php into a new TaskFactory.php. Tested locally after tweaking the database settings, and then ran on Azure after switching settings back. Might like to utilise the Artisan commands better.
Document Process
2022-07-02
I did spend some time writing down the tutorial process to make a web app and database in Azure. I made some notes to help me rememer some of the nuances to some of the commands. I also noted some areas that I would like to explore more with too. So long as Azure doesn't change too terribly much I think I can use this as a baseline to make a PowerShell template to easily depoy new sites.