[TUTORIAL] Twitter PostgreSQL - leonardoms/BuzZ GitHub Wiki

This small tutorial will show how to collect data from Twitter stream and store it on a PostgreSQL Table.

The Database

First create the table named twitter_tbl where we will store the twitter data, with the bellow structure:

CREATE TABLE twitter_tbl 
	created_at			character varying(64) not null,
	id_str				character varying(32) not null,
	text				character varying(256) not null,
	user__id_str			character varying(32),
	user__screen_name		character varying(64)
);

TODO