IoT on QuestDB
davidgs.com
davidgs.com
“QuestDB is an open source database which makes time-series fast and easy.”
This almost looks faster and easier. Will look into it. Thanks for sharing!
In terms of queries, see our previous post on HN to get a sense https://news.ycombinator.com/item?id=22803504
To manipulate data we support "add" and "delete" column on the fly. We can also add column replace and type change if needed. This is pretty easy to do.
PostgreSQL wire is in beta. It works with JDBC driver and we will add metadata support quite soon.
The product is impressive, but it looks like the documentation has some way to go. This is often indicative of the maturity of the product itself.
I was very interested in the Postgres wire protocol and its usage.
This part does not seem to be very mature.
Examples:
* The documentation doesn't mention a word of the default username/password on port 8812. I had to find this on a mailing list somewhere after 10 minutes of googling. Has this been hardcoded into the code?
* If you were to connect a typical Postgres tool this port, you'd be able to do selects but not even see the tables. If using psql and doing \d I get:
ERROR: Invalid column: oid