This new Javascript DB thing is fantastic. It allows one to open and store information offline, and local to the device that was accessing the website. The retrieval of the information is based on standard SQL. Continue reading Javascript Databases for offline storage
Category Archives: Linux
All Linux related posts
Parsing Excel in PERL
i didn’t know where to put this so i placed it here under the scope of development.
For how to parse EXCEL files in rows and columns, look at http://www.ibm.com/developerworks/linux/library/l-pexcel/
Caching in HTML5
Example code for offline Web Apps using caching in HTML5.
For Simple caching Web App, see (http://himiko.dnsalias.net/ws/cexample/index.html).
For Javascript Database Web App, see (http://himiko.dnsalias.net/ws/journal/index.html).
Converting Images to be Stored in JS Database
Here is the code on the server side to convert images into base64 such that you can save them into browser JS database for offline retrieval.
#!/usr/bin/perl use MIME::Base64 qw(encode_base64); open (FILE, "z.png"); binmode(FILE); $photobin = ""; while (read(FILE, $buf, 60*57)) { $output = encode_base64($buf); $output=~s/\n//g; $photobin = $photobin.$output; } print $photobin; close(FILE);