Nick Woolmer
Nick Woolmer
### Is your feature request related to a problem? Server-side logs are not accessible to users, but often contain important information like warnings and critical errors. These are useful for...
### To reproduce Try this on demo: ```sql SELECT pickup_datetime as t, max(fare_amount) as max_fare FROM trips SAMPLE BY 1s FILL(NULL) LIMIT 5 ``` It will fail with memory page...
### Is your feature request related to a problem? The SAMPLE BY FROM-TO feature added support for pre and post filling result sets, around existing records. It also added support...
### Is your feature request related to a problem? There can be an offset between `writerTxn` and `sequencerTxn`. This is often seen during a table suspension, when ingestion can continue...
### Is your feature request related to a problem? QuestDB supports BETWEEN expressions: ```sql WHERE timestamp BETWEEN x AND y ``` These expressions serve as a convenient syntax for representing...
### Is your feature request related to a problem? QuestDB outputs logs with a number of configuration options. These logs can be configured to write to single files, segmented files,...
### Is your feature request related to a problem? Users frequently have bulk data in another database (i.e InfluxDB) and want to migrate it to QuestDB. The publicised option is...
### To reproduce See https://community.questdb.io/t/sql-format-for-converting-to-microseconds/82 Values in expressions such as: `1720468802 * 1000000` are interpreted as ints, and compiled into `MulIntFunctionFactory`. This factory does not handle numeric overflow. However, we...
First 1 million trades in demo trades dataset. ``` SELECT covar_samp(price, amount) from trades where symbol = 'ETH-USD' -- gives 3.52651152818 -- takes 8-9 ms SELECT covar_samp(price, amount) from trades...
`stddev`, `stddev_samp`, `stddev_pop` First 1 million rows of `trade` demo data. Before and after: ```sql SELECT stddev_samp(price) from trades where symbol = 'ETH-USD' -- gives 75.471371580724 -- takes 8-9 ms...