Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Using WebSQL Instead of Local Storage In Your Web App

February 22, 2015
Nic Raboy

When developing web applications a common way to store data is to use local storage. This NoSQL approach is great, but what if you’re coming from an RDBMS? With HTML5, you have access to the WebSQL API which allows us to use SQL queries for handling client side storage.

This guide will show you how to use the WebSQL API, which is based around SQLite, in your web application. This information can even be extended for use with mobile hybrid applications.

January 25, 2015
Nic Raboy

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.

January 8, 2015
Nic Raboy

A follower of my blog recently came to me asking for help with their Magento API service. If you’re unfamiliar with Magento, it is an Ecommerce solution by eBay that uses Oauth 1.0a to handle API requests. If you’ve been keeping up with my blog you’ll notice I had done a previous post on Oauth 1.0a, and it was everything, but fun.

So how does a newbie go about making quick tests to Oauth providers or RESTful APIs without a lot of stress? If you’re using Google Chrome like I am, there is a nifty application called Postman which does very thorough API testing.

January 3, 2015
Nic Raboy

If you’ve been keeping up with my work, you’ll remember in 2014 I released an app called OTP Safe for Android and iOS. This was a hybrid application created with Ionic Framework, that manages time-based one-time passwords (TOTP) commonly used for two-factor authentication (2FA).

I’m starting 2015 off with a bang by releasing my first ever Google Chrome extension. OTP Safe for Chrome was designed to mimic the functionality of the iOS and Android versions, but for laptop and desktop computers.

December 19, 2014
Nic Raboy

I’ve recently been exploring other options when it comes to web frameworks. I come from a PHP ZendFramework background, but since having upgrading to ZendFramework 2, I’ve not been impressed.

Since then I’ve been exploring more of Node.js. However, like PHP, web programming often works best with a framework. This is why I’ve been exploring Node.js with Express as the framework.

December 6, 2014
Nic Raboy

When coding, it is good practice to reduce duplicating your code as much as possible. When you build a website, multiple pages may be grouped with specific layouts that are used any number of times. You don’t want to duplicate your layout code across these pages.

A common thing to do in web design is to use templating. This exists similarly across many web languages, but in this example I’m going to demonstrate how to do this with AngularJS and the UI-Router extension.

December 2, 2014
Nic Raboy

I’ve been doing a lot of work with AngularJS lately, and in particular Ionic Framework. However, up until recently I have been using either HTML5 local storage or SQLite.

Now I’ve switched gears and started using the AngularJS module ngStorage which has made my life a lot easier.