What is PubSubSQL?
An open-source in-memory relational database with PUB-SUB and an optional MySQL backend.
No more periodic polling or implementing database triggers!
Subscribe any of your web or backend services to changes in a relational database!
People usually have to choose between a fast in-memory store and a conventional database to give their users a responsive real-time feeling and at the same time allow backend service run analytics in a more analytic-friendly environment. We've been in that same boat and ended up coding complex contraptions with caches, long-term storage and notification systems which more often than not spiral out of control and become a maintenance nightmare. So we thought "Why not have a SQL-like interface with a PUB-SUB interface and just stream data to a normal database?". And PubSubSql was born!
Service is written in pure Go and runs on pretty much anything. We're making heavy-use of Go parallelization wonders (goroutines and channels) along with some low-level networking to allow MySQL streaming and PUB-SUB at the same time.
Code is open-source, so feel free to check it out: https://github.com/pubsubsql/pubsubsql. Just keep in mind it's under development :) All pull-requests, questions and issues welcome!
You can either run the service yourself (MySQL backend is NOT required!), or you can make use of a public server that we are providing for you to play with! More details available here