There's an opportunity for a tool that combines this sort of technology in the backend with a spreadsheet-like GUI powered by formulas and all the user friendliness that comes with a non-programmer interface. Wall Street would forever be changed. Source: I'm one of the poor souls fighting my CPU and RAM to do the same thing with Excel and non-native add-ins by {FactSet, Capital IQ, Bloomberg}
This stuff
SELECT * FROM balances
LATEST BY balance_ccy, cust_id
WHERE timestamp <= '2020-04-22T16:15:00.000Z'
AND NOT inactive;
Makes me literally want to cry for knowing what is possible yet not being able to do this on my day job :(
We are working on building a solid PostgreSQL support insofar as allowing ODBC driver to execute this type of query from Excel. This is work in progress with not that much left on it.
Awesome! I think about this almost on a daily basis, and could very well be wrong, but from my perspective think the killer feature is integrating the querying with the financial data providers I mentioned above so they could sell the whole thing as the final product to end users. (EDIT: from a reply to another comment, it seems like some people are onto the concept: https://factset.quantopian.com)
If you ever install FactSet for a trial period and try querying time series with even ~10,000+ data points, you'd be amazed at how long it takes, how sluggish it is and how often Excel crashes.
My real perspective is Microsoft should roll something similar out as part of Excel and also get in the business of providing the financial data as they continue the transition into services over products
Perhaps this is an aside, but the questdb.io website claims "postgres wire support", but doesn't clarify whether that's _full_ wire support, or a subset of postgresql (which would be understandable) and if so, what the subset is.
For Excel-like analysis with pivot tables take a look to our https://www.seektable.com; it can connect to various DW that are suitable for near real-time big-data analytics (like Redshift, BigQuery, Snowflake, Clickhouse). SeekTable has can be deployed on-premise.
We can add a connector for QuestDB if someone is really interested in this.
This stuff
Makes me literally want to cry for knowing what is possible yet not being able to do this on my day job :(