This page is currently under construction and will contain information on how to program databases with HTML5, JavaScript (Node.js and Node.js Database Drivers), and MySQL, Drizzle (a fork of MySQL), and IndexedDB (a client-side database).

Well, as part of my research and development at work I am investigating ways to write an application once that can be deployed on, and will work on Windows, Linux, Android, ChromeOS, Unix, and MAC OS X servers, desktops, and mobile devices.

Now two possibles are Oracle Java and the Microsoft .NET Framework. These do however rely upon native API programming. Yes it is true that APIs exist to provide abstract layers to protect developers from having to delve into the specifics of native API programming. But is this really the way to go?

Every device has a browser, and most devices have internet connectivity. Is it possible to create a full-blown commercial data-driven web application using no more than standards compliant HTML5, CSS, and JavaScript that will work on servers, desktops, tablets, and phones?

There is a JavaScript framework called node.js that can be installed on Windows, Macintosh, SunOS, and Linux operating systems. What is special about node.js that moved companies such as LinkedIn, backbeam, ebay, Dow Jones, Microsoft, and The New York Times to adopt it as an important part of their overall web architecture?

Well according to the customers themselves the reasons include great performance, fast deployment, huge low-level and high-level functional flexibility, scalability, an active community supporting it, and more.This is starting to sound good. Can node.js access databases? Yes. Take a look at Node.js Database Drivers: Node.js bindings to relational databases.


One of the books I will be working through is the Pro HTML5 Games (Professional Apress). I have managed to persuade my employer to purchase this book as I am responsible for writing tests and assessments in game format in WPF and Silverlight. But for true cross-platform development, I am more interested in exploring the avenue of HTML5, CSS3, and JavaScript on both the client-side and server-side. This book discusses multiplayer capabilities using WebSockets and Node.js. Couple this with the Node.js Database Drivers, and I will hopefully be able to write applications that store and retrieve data in relational databases on the server, write games and administration software that runs on the client-side, and in case the network connection is lost for whatever reason, store and retrieve information on the client-side that will be synchronised with the server database the next time a network connection is established.

Installing Node.js

Download and install Node.js from: http://nodejs.org/.

Installing The MySQL Database

Download and install the MySQL Database from: http://dev.mysql.com/downloads/.

Install Ruby

Ruby is necessary for installing certain Node.js extensions. Install Ruby from: http://rubyinstaller.org/downloads/.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s