Over the last week I’ve started a new project, GTFSrDB, which allows you to connect GTFS-realtime with an SQL database, allowing app developers to use realtime data through SQL, just as easily as they use static data. Rather than worry about plumbing to connect GTFS and GTFS-realtime, they can focus on writing apps. It accomplishes two primary tasks: Keeping a database up-to-date with the latest realtime data, and Archiving historic real-time data.