Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on How to write a crawler.
> id is an incremental value, I choose 11 as a length for this primary key but this value is defined by the number of pages you’ll need to index
Also the visited field would be better to be represented by a timestamp, choosing the right datatype does matter in large tables.
There are no comments on this comment yet.
Also the visited field would be better to be represented by a timestamp, choosing the right datatype does matter in large tables.