When it comes to select a range of date with a date for start and a date for end, it would take 3 to 4 clicks to select a date with datetime picker  [+] in HTML 5.

As viewers in most time, the terms on websites/apps are the least concerned. I'd just click/tap on the "accept" button to shut the terms down asap. However, when table is turned and I wish to switch roles to be makers of online content, I can't help asking myself

I want to study more about database, not just how to query and store data. I wish to know how a database is built, what concerns are to be addressed. I figure h2database  [+] could be a good starting point

In the preparation of another blog talking about spatial feature of MYSQL, I started with data collection, then I wondered how capable MYSQL could be on ETL(Extraction/Transform/Loading)  [+].

Firstly I found some geo data from AshKyd  [+]

The infamous slogan of internet startup, quoted from silicon valley, "social, mobile, local". When it comes to "mobile" & "local", we need to store, query geo location data. So let us study mysql spatial feature  [+].

A note from my study about how to setup and use nginx to work as proxy, so that we could bypass cors  [+] limitation to fetch data (disclaimer!).

Hi! I'm your first Markdown file in StackEdit. If you want to learn about StackEdit, you can read me. If you want to play with Markdown, you can edit me. Once you have finished with me, you can create new files by opening the file explorer on the left corner of the navigation bar.

MDX  [+] is interesting extension for markdown  [+]

As I studied so far, Open-Graph-Protocol  [+] is the protocol recognized by social network. In detail, you could add certain set of meta tags into your web pages, then when the web pages are shared by links in soical networks, such as linkedin  [+], the social network could extract the info from the meta tags according to Open Graph Protocol and display these info to make the shared links more informative.