Archive for the ‘Databases’ Category

Beaver in Action: Practical MySQL Optimization

Posted on: No Comments
Clients with an existing application sometimes ask me to fix bugs, improve efficiency by speeding up the application, or add a new feature to some existing software. The first stage of this is researching the original code – so-called reverse enginee...

Getting Started with PouchDB Client-Side JavaScript Database

Posted on: No Comments
Over recent years, client side web applications have gotten more and more sophisticated. Browsers have consistently been providing better JavaScript performance, and are capable of doing more and more things, with rich JavaScript APIs for things like g...

Horizon: A Scalable Backend Perfect for JavaScript Mobile Apps

Horizon is a scalable backend for cross-platform, JavaScript based mobile apps, especially those needing realtime functionality. It was built by the awesome people at RethinkDB and so uses RethinkDB as the default database. If you're not familiar with ...

Please: Automated CMS and Framework Installs in Vagrant

If you're a web developer, possibly one of your most boring and repetitive tasks is the configuration of the basic setup for every new project. Configuring your my-project.dev domain, creating the database, installing WordPress (or any other CMS/Framew...

Storing Local Data in a Cordova App

Posted on: No Comments
Most mobile apps will need to store data locally and HTML5 introduced new options for storing data locally. To store data locally in an Cordova app we can use HTML5 storage combined with other mechanisms provided by plugins. In this tutorial, I will in...

SQL vs NoSQL: How to Choose

Posted on: No Comments
In the previous article we discussed the primary differences between SQL and NoSQL databases. In this follow-up, we'll apply our knowledge to specific scenarios and determine the best option. To recap: SQL databases: store related data in tables requi...

Offline Support in Firebase, a Truly Mobile Datastore?

Posted on: No Comments
Since being acquired by Google, Firebase has continued to develop into a powerful platform for building both web and mobile applications. The company’s recent announcements from the Firebase team dealt with their pricing structure, which was chan...