joelonsql

--
-- Here comes some general advise on how to use HyperLogLog
-- for someone who wants to implement a YouTube-like service
-- using the awesome https://github.com/citusdata/postgresql-hll PostgreSQL extension
--

CREATE TABLE counter (
id text NOT NULL, 
sketch hll NOT NULL DEFAULT hll_empty(),
PRIMARY KEY (id)