News for hackers. Stuff that matters.
Re:Timescale raises $16M from Benchmark, NEA, Two Sigma Vent... by cstanley on Wednesday January 24, 2018 @12:30PM (#16224468)
"We realized that this problem needed a new kind of database, and so we built TimescaleDB: the first open-source time-series database designed for scalability and complex analysis."

I'm not a DB expert, but what have financial firms been using for decades? Likely dealing with much larger securities datasets...

Or, is it just that TimescaleDB is 'opensource'...

Re:Timescale raises $16M from Benchmark, NEA, Two Sigma Vent... by stalller on Wednesday January 24, 2018 @08:29PM (#16228045)
Yes, they have. kdb+ has been the standard bearer within finance for more real-time trading applications. Still, q as a query language tends to marginalize more of the organization from having access to the data.

TimescaleDB offers full-SQL at scale, opening the database up to more people. It's used to power longer-term trading platforms (for e.g., commodities trading) and interactive analytical dashboards (for e.g., research analysts). We also see applications in compliance and risk management.

And yes, TimescaleDB is open-source. So we see TimescaleDB as complementary to kdb+, which has been around for much longer as a proprietary system, is certainly full-featured and powerful, but is used more in real-time trading applications.

Re:Timescale raises $16M from Benchmark, NEA, Two Sigma Vent... by beagle3 on Wednesday January 24, 2018 @03:37PM (#16226079)
kdb+ from Kx systems is popular among users who have mostly tick data (billions of trade/bid/offer updates). It has bare bones SQL, and its own query langauge "q" which in many cases simplifies the queries immensely (with two features, "foreign key chasing" and "as-of joins" which are somewhat at odds with Codd's original pure relational model so are unlikely to get into the SQL standard)