The database aside entirely, that story was a really fun read. Thanks for writing it up and sharing. Rooting for you!
Launch HN: QuestDB (YC S20) – Fast open source time series database
131–140 of 173 posts
Re: Launch HN: QuestDB (YC S20) – Fast open source time series database
#132Amazing story and congrats on all the progress!
Shameless plug: if you'd like to try it out in a production setting, we just created a one-click install for it:
Re: Launch HN: QuestDB (YC S20) – Fast open source time series database
#133There'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…
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.
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.
Re: Launch HN: QuestDB (YC S20) – Fast open source time series database
#134The SQL explorer at http://try.questdb.io:9000/ is pretty slick – was that built in-house, or is it based on something that's open-source?
Re: Launch HN: QuestDB (YC S20) – Fast open source time series database
#135Earlier quoted context omitted.
FYI M3 is now backed by M3DB, a distributed quorum read/write replicated time-series based columnar store specialized for realtime metrics. You can associate multiple values/timeseries with a single set of dimensions if you use Protobuf's to write data, for more see the storage engine documentation[0]. The current recommendation is not to limit your queries but limit the global data queried per second[1] by a single…
Recommended reading on FST for the curious: https://blog.burntsushi.net/transducers/
I love FST's and similar structures, they're just such a cool idea.
Anyone know if there are any other similar interesting blog posts/articles about FST's?
Re: Launch HN: QuestDB (YC S20) – Fast open source time series database
#136[deleted]
Re: Launch HN: QuestDB (YC S20) – Fast open source time series database
#137[deleted]
Re: Launch HN: QuestDB (YC S20) – Fast open source time series database
#138The SQL explorer at http://try.questdb.io:9000/ is pretty slick – was that built in-house, or is it based on something that's open-source?
Thanks! This is something we built in house. In fact, ‘mpsq’ did all of that. All credit should go to him!
Re: Launch HN: QuestDB (YC S20) – Fast open source time series database
#139How do i join the slack group? It says to request invite from the workspace administrator?
Re: Launch HN: QuestDB (YC S20) – Fast open source time series database
#140Absolutely love the story. TimescaleDB & InfluxDB have had a lot of posts on HN, so I'm sure others are wondering - how do we compare QuestDB to them? It sounds like performance is a big one, but I'm curious to hear your take on it.
As you said, performance is the main differentiator. We are orders of magnitude faster than TimescaleDB and InfluxDB on both data ingestion and querying. TimescaleDB relies on Postgres and has great SQL support. This is not the case for InfluxDB and this is where QuestDB shines: we do not plan to move away from SQL, we are very dedicated in bringing good support and some enhancements to make sure the querying languag…
Did you also compare to VictoriaMetrics?