Jeff Ferguson and Derek Nelson of PipelineDB (http://pipelinedb.com) will introduce you to their recently-open-sourced streaming PostgreSQL fork:
PipelineDB is an open-source streaming SQL database that runs queries continuously on streams, incrementally storing the results in tables. It is a fork of PostgreSQL. The product was born out of a need for such a product discovered while we were some of the earliest engineers at AdRoll, where we built some of the largest-scale streaming analytics infrastructure around at that time. We were early adopters of technolgies like Storm, Kafka, HBase, Cassandra etc., and we built great technology but it required mastery and integration with all of those systems, glued together with a lot of application code. It was complex.
PipelineDB is built to solve this growing problem of streaming analytics in a way that is accessible to a broad range of developers who are proficient in SQL, without a need to manage an external datastore. It is a unified solution that is no more complex than a standard PostgreSQL deployment.
Hosted by IF(we) (http://www.ifwe.co/).