I'm a big fan of WebSQL, which is, unfortunately, going the way of the Dodo since it was apparently just too easy to use. One of the nice things about the feature is that Chrome Dev Tools make it real easy to use. As an example, here is what you can see on a page making use of WebSQL.
As you can see, both the database and its tables are enumerated. If you click on the table, you get a list of data.
There's no UI hint to this, but you can click the columns to sort.
The coolest feature though is the one that is very non-obvious (in my opinion). If you click the database name, you may notice the right side of the panel empties out...
That's actually an editor. If you start typing you can execute arbitrary SQL. Hell, Chrome will even autocomplete table names and SQL commands for you. Here's an example:
One thing to watch out for. If you execute a SQL command that returns no results, Chrome doesn't display anything. You don't get a nice "0 Results". In fact, Chrome will remove the SQL from the pane.
Archived Comments
Are there similar features for IndexedDB?
Or is this nice feature exclusive to the lesser of the web databases
Yep. In the screen shots, look below Web SQL. :)
Thought WebSQL is dead?
http://www.w3.org/TR/webdat...
Unfortunately yes. You sir, the Spec Lords decided that SQL was far too easy and decided that a NoSQL solution (IndexedDB) would be better.
Ok - snark aside - yes - the spec is dead. However, it is supported *very* well on mobile and in PhoneGap. I only use WebSQL for PG. Since I do most of my PG dev directly in Chrome, tools like this are very helpful.
Seems simple when you know how. This is the coolest. I too and building PG apps with WebSQL. Yes it is the best supported solution for mobile at present and Chrome is the best development environment to test.
Great little tip. Keep it up.
I've just started doing WebSQL in Phonegap, remember this post, so useful. Thank you Ray.
I like the way this interface is set up. It seems like it would be easy to use and edit. It also organizes the information and outputs pretty well. It's easy to see what commands the program is performing and what the results are. I think that's one of the great values of SQL tool s. http://www.datasparc.com
unfortunately ,one cannot run select query on websql when your database is document-store /pouch db
Um, right, as that's a totally different technology.