Hacker News new | ask | show | jobs
by 0cf8612b2e1e 331 days ago
Could you give an example of where it shines? I have had to answer many a SQL/pandas question with someone over my shoulder, so curious where you see the sharpest benefit.

Admittedly, I am unlikely to learn this proprietary DSL, but always good to know what is the best tool for a job.

2 comments

Q is not just a query language or a database. It's an array programming language with database capability. You can build an entire framework with just Q, from real-time streaming, to in memory database to on disk database. You can build all APIs and business logic around it. Because it's vector oriented and in memory it's faster than pretty much everything else, no loops required. I have seen a team of 15 KDB developers build what would require an entire etrading department of 200+ developers
Given Wes McKinney created Pandas for quantitative analysis, it's possible that Pandas wouldn't exist if AQR were paying for a q license.