Getting Started with HTML5 Local Databases

Please note: This article was written in May 2010 and as of November 18, 2010, the Web Applications Working Group has reached an impasse and does not intend to maintain the Web SQL Database any longer. Read more here. Starting with Safari 4, iOS OS3, Chrome 5, and Opera 10.5 (Desktop), HTML5 Local Databases (AKA Web SQL Databases) are now supported. Setting up the Database First we check if the browser supports the openDatabase method, is so we continue and define the database parameters: shortName is the DB name as it will be referred to by the browser and SQLversion openDatabase version. 1.0 for this (more on that here) displayName The full display name / description of the databasemaxSize This is max size in bytes is the size you expect the database to reach. Next, we call the createTables(); function where the table is defined and pre-populated with initial data (optional). Building the Table This basic function executes the executeSql method which runs as the CREATE TABLE query.

Tutorial HTML 5 et les bases de données embarquées « BSoft&Co HTML5 commence à montrer le bout de son nez. Les navigateurs "modernes" dans leurs versions récentes prennent en charge de plus en plus des nouvelles fonctionnalités prévues. Attention tout de même, HTML5 n'est qu'un brouillon! Une version "draft" du W3C . Une des nouvelles fonctionnalités, très pratique pour les applis web et autres sites, est la possibilité de pouvoir embarquer une base de données SQLite directement dans la navigateur du client. Remarque : concernant les bases de données embarquées, la dernière version de Safari (mobile et desktop) semble être celle qui le gère le mieux. Une document HTML 5 commence par : <! La base de données se manipule au sein de balises JavaScript. var db; // variable globale pour manipuler la bdd.try {if (window.openDatabase) { db = openDatabase("maBaseDeDonnees", "1.0", "Ex de bdd avec HTML5", 200000); if (! La méthode "openDatabase" comprend 4 arguments : - Le nom de la base. db.transaction(function(tx) { Exemple de création d'une table :

Call-to-Action Brochure Designing [ad#link-unit-post] In todayâ€™s world, the success of a business greatly depends upon the effectiveness of its marketing communication. It is important for the organization to communicate to the potential customers and the best tool for one-to-one communication is the brochure. Brochures really help the marketers in their pursuit and to achieve their goals well. This source of communication provides greater details about the products in an attracting manner. It is important for the businessman to choose a proper brochure design that will be in accordance with the information about his product or service. Things to Remember while Designing a Brochure Logo As I have mentioned several times in my prior posts, a logo is one of the staple items that you need to have if you are starting out a business. Color Colors are the most expressive elements of any design. Photographs Do not suffocate your brochure with a lot of straight-forward boring text. Discretion â€˜Less is Moreâ€™ Formula Consistency

Introduction à l’HTML5 Cet article est destiné aux débutants en HTML5, et à tous ceux qui souhaitent en savoir un peu plus sur cette nouvelle technologie qui agite le web et le monde mobile. Si vous vous intéressez aux technologies du web, vous avez probablement déjà entendu parler de l’HTML5 aux cours des dernières années. Cette introduction va vous donner un premier aperçu de ce qui se cache derrière le terme HTML5, vous présentera le contexte dans lequel évolue cette technologie, et nous verrons un bon nombre de nouvelles fonctionnalités qu’il apporte. Sommaire : L’HTML5 c’est quoi ? L’HTML5 n’est pas… Tout d’abord, je suis convaincu que parmi vous certains se disent : L’HTML5, c’est un nouveau langage ? Ou encore : Je débute, j’ai envie d’apprendre l’HTML5 directement, ça a l’air mieux que l’HTML d’avant. Voire : Pfff, moi qui venait d’apprendre l’HTML, je vais devoir tout réapprendre… Il est grand temps de clarifier les choses : L’HTML5 n’est pas un nouveau langage. L’HTML5 est… Le W3C et le WHATWG On y arrive !

I Think Therefore I Tweet The responsibility of Twitter updates got you down? D'you think about tweeting but never actually get around to it? Never fear , Adam Wilson is here. The University of Wisconsin-Madison biomedical engineering grad student removes the clunky and outdated interface of keyboard and lets his brain tweet for him. HTML5 Introduction

5 Key Benefits of Monitoring Your Client's Brand on Social Media via @mashable Lauren Fernandez is the Agency Community Manager at Radian6, the social media monitoring and engagement platform. She is @cubanalaf on Twitter, and blogs at LAF and MarketingProfs Daily Fix. From an agency perspective, many utilize social media monitoring at the request of a client who either doesn’t know much about it, or depends on their agency to educate them. Volume, Influence and Sentiment are metrics that will come in handy once these five benefits are realized. 1. Crisis communications strategies are ingrained into most PR professionals’ skulls from the beginning of their education and internships. Creating a presence on social media networks won’t stop this type of conversation from happening, but will enable brands to make the conversation a two-way street. In June 2009, the Holocaust Museum shooter was incorrectly identified as a current American Mensa member. 2. Influencer identification is a processes that is unique to each brand. What platforms are you currently using? 3.

HTML 5 Tutorial | Tutorials, Tips & News for the Designer I'm sat next to the cake in the car....gulp! #fb Bacon sarnies coming up...all hail!