Monitor MySQL And Auto Recover From A Crash

Since starting this blog in July of 2014, I have had an unexpected amount of growth. So much, that a lot of strain has been placed on my virtual private server (VPS).

A common issue that has plagued me and many other WordPress users is the awful MySQL crash due to exhausted resources. This is because the server has run out of resources due to traffic spikes or other anomalies. The worst part for me is that MySQL tends to crash while I’m sleeping, putting my blog out of commission for up to six hours at a time. This is not good when you’re trying to be a reliable source of information on the internet.

Luckily, I’ve developed a script that will elegantly resolve these related problems.

Embed Video In Your iOS And Android Ionic Framework App

I’ve received a few requests from my subscribers for an article regarding embedding videos in their Ionic Framework application. This could be a challenging task for a few reasons. There are known issues with the HTML5 <video> tag for Android. One might also ask how to make the videos responsive for multiple screen resolutions.

In this guide, I’m going to show how to do responsive embeds of YouTube videos into an Ionic Framework list of cards.

Session Management In Your Express.js Web Application

I’ve still been doing a lot of fiddling with Express web framework for Node.js. I recently ran into an issue with saving data to sessions because much of the documentation online is outdated and no longer functional. However, I did get it working, and am going to discuss it in this guide.

If you’re not familiar with Express, you may want to take a moment and read my other article regarding installation.

Use Native Device Dialogs In Ionic Framework Mobile Apps

So you’ve been playing around with Ionic Framework for a while now and have decided that maybe $ionicPopup dialogs are not meeting your needs because they don’t look native enough. As we’ve come to expect, Apache Cordova has a plugin for us to correct this, giving us native device popup dialogs in our hybrid application.

This guide will show you how to use the Apache Cordova Dialogs plugin in your Ionic Framework Android and iOS mobile application.

Find All Tables In An Oracle Database By Column Name

I work with very large Oracle enterprise databases all the time. Consistently, I find myself trying to sift through schemas in the database to find relationships between tables. When tables aren’t named appropriately and you have a lot of them, this can be a long and painful process if you do it manually.

Lucky for us, there is a convenient way to search for the tables you’re looking for based on column information.

Deploy Ionic Framework App With Pre-Filled SQLite DB

Recently I did an article regarding SQLite as an alternative to local storage in an Ionic Framework application. The article was a guide for using the Apache Cordova SQLite plugin for data management. Since writing that post, a few of my readers asked me how to ship an application with a pre-populated SQLite database.

A scenario where this might be useful is if you created a lookup directory for all the employees at your company. Let’s say you have 10,000 employees, so populating the data via a web request is probably going to take a long time. You could ship each version of your app with the most recent lookup directory, and use an API to update it. Since you’re only doing small changes after the initial, it is more effective than trying to download everyone.

This task is not difficult, but it could get a little confusing. Now I’m not going to show how to do the example scenario I mentioned, but the following should put you on the right path for working with pre-populated SQLite databases.

Making Tinder-Style Swipe Cards With Ionic Framework

The Tinder App recently got a lot of attention, especially the swipe cards are suddenly appearing everywhere. Ionic is already creating a solution for everyone to easily create these kind of cards with HTML5 and Javascript. Therefore, in this tutorial I will show you how to add Tinder-style swipe cards in your Ionic app with the help of a custom ion.