24ways-fts4: articles: 1 row where "published" is on date 2005-12-06 sorted by title descending

Data source: https://github.com/simonw/sqlite-fts4

1 row where "published" is on date 2005-12-06 sorted by title descending

Search:

descending

Link	rowid	title ▲	contents	year	author	author_slug	published	url	topic
336	336	Practical Microformats with hCard	You’ve probably heard about microformats over the last few months. You may have even read the easily digestible introduction at Digital Web Magazine, but perhaps you’ve not found time to actually implement much yet. That’s understandable, as it can sometimes be difficult to see exactly what you’re adding by applying a microformat to a page. Sure, you’re semantically enhancing the information you’re marking up, and the Semantic Web is a great idea and all, but what benefit is it right now, today? Well, the answer to that question is simple: you’re adding lots of information that can be and is being used on the web here and now. The big ongoing battle amongst the big web companies if one of territory over information. Everyone’s grasping for as much data as possible. Some of that information many of us are cautious to give away, but a lot of is happy to be freely available. Of the data you’re giving away, it makes sense to give it as much meaning as possible, thus enabling anyone from your friends and family to the giant search company down the road to make the most of it. Ok, enough of the waffle, let’s get working. Introducing hCard You may have come across hCard. It’s a microformat for describing contact information (or really address book information) from within your HTML. It’s based on the vCard format, which is the format the contacts/address book program on your computer uses. All the usual fields are available – name, address, town, website, email, you name it. If you’re running Firefox and Greasemonkey (or if you can, just to try this out), install this user script. What it does is look for instances of the hCard microformat in a page, and then add in a link to pass any hCards it finds to a web service which will convert it to a vCard. Take a look at the About the author box at the bottom of this article. It’s a hCard, so you should be able to click the icon the user script inserts and add me to your Outlook contacts or OS X Address Book with just a click. So microformats are useful after all. Free…	2005	Drew McLellan	drewmclellan	2005-12-06T00:00:00+00:00	https://24ways.org/2005/practical-microformats-with-hcard/	code

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE [articles] (
   [title] TEXT,
   [contents] TEXT,
   [year] TEXT,
   [author] TEXT,
   [author_slug] TEXT,
   [published] TEXT,
   [url] TEXT,
   [topic] TEXT
);