First item of the launch week: new release! Before the most exciting announcements, we made lots of bug fixes that are listed here: https://github.com/questdb/questdb/releases/tag/7.1.2 We will zoom into the new UI for CSV Import + Superset integration in the coming days!

New CSV Import! Documentation: https://questdb.io/docs/develop/web-console/#import QuestDB 7.1.2 introduces the brand new CSV Import UI available in the Web Console. It allows for a more fine-grained control over data ingestion: selecting a target table name, setting up partitioning, designated timestamp and its format, and, last but not least, provide a custom table schema. Moreover, you can tune all the available REST API parameters in Settings panel for each file separately.

Hi folks, an extra bonus day for the release week as we could not fit it in time: QuestDB Cloud is now GA, and we now offer $200 free credits without credit card details! You can track the status of your free PoC on the billing page. https://cloud.questdb.com/

Hi folks - 7.3 is out! https://www.linkedin.com/feed/update/urn:li:activity:7097518870793519105/

New QuestDB Release today - 7.3.2

Yesterday we were trending all day on HackerNews with the following blog post: https://questdb.io/blog/leveraging-rust-in-our-high-performance-java-database/ If you’d like to check the comments, here is the conversation: https://news.ycombinator.com/item?id=37557880

We've just released version 3.0.0 of the

c-questdb-client

for C, C++ and Rust. We recommend upgrading as the new release contains a number of minor bug fixes and improvements. • Release notes here: https://github.com/questdb/c-questdb-client/releases/tag/3.0.0 (including docs on a few small breaking changes) • C & C++: ◦ Docs: https://github.com/questdb/c-questdb-client ◦ Examples: https://github.com/questdb/c-questdb-client/tree/main/examples • Rust: ◦ Docs: https://docs.rs/questdb-rs/3.0.0/questdb/ ◦ Examples: https://github.com/questdb/c-questdb-client/tree/main/questdb-rs/examples

Hi <!here>, today QuestDB is trending on Github! With your support, we can stay on this trending page for many more days and get a lot of awareness! To help us, you can star and fork the repo. Thank you all! https://github.com/trending/java?since=daily

Hi folks , @Adam Cimarosti and @javier ramirez will be presenting at Modern Databases for Finance 2023, today! 2PM UK, 9am NYT https://www.timestored.com/data/modern-databases-finance-2023

Hello <!here>, today we announce QuestDB OSS 7.3.4: • Brand new SQL Web Console (check it out!) • Window functions (moving averages, running totals, or Top-N results within a group, and more via a “window”, defined by an

OFFSET

against a

RANGE

or

ROWS

. • More functions, added by our incredible community of developers:`first(boolean)`,

last(boolean)

,

first(string)

,

last(string)

, mathematical exponent

exp(D)

and

first_not_null()

,

last_not_null()

Let us know what you think, the documentation is also updated accordingly.

👏 Hello <!here> Today marks the start of the 4th Launch Week of #QuestDB. Thanks for being part of this journey! Throughout this week, we will be announcing: - New UI - New Open Source release - New QuestDB Cloud release - QuestDB Enterprise with Cloud-native replication More to come!

Hello <!here>, time to update your dependencies! ⤴️ 🚀 New ILP client library releases for C, C++ and Rust 🦀 (

3.1.0

) and Python python (

1.2.0

)! These introduce a few minor features and bug fixes without any breaking API changes. • Python: https://py-questdb-client.readthedocs.io/en/latest/ • Rust: https://docs.rs/questdb-rs/3.1.0/questdb/ • C: https://github.com/questdb/c-questdb-client/blob/main/doc/C.md • C++: https://github.com/questdb/c-questdb-client/blob/main/doc/CPP.md Release notes: • https://github.com/questdb/py-questdb-client/releases/tag/v1.2.0 • https://github.com/questdb/c-questdb-client/releases/tag/3.1.0

Just created a #jobs channel. Feel free to post any offers where you need QuestDB skills

Hi everybody, happy new year from the QuestDB team! To kick things off with a 💥, we have released a beta version for you to try. This version includes multi threaded Group By query execution, with massive query speed improvements. QuestDB’s ingestion protocol InfluxDB Line Protocol via HTTP is also available in beta: this now includes feedback, and can work through the InfluxDB drivers. Note that we will be releasing the updated QuestDB drivers that will support the HTTP implementation in due course. Link: https://github.com/questdb/questdb/releases/tag/7.3.8b

This version goes from pre-release to full-fledged release, labelled as 7.3.9: https://github.com/questdb/questdb/releases/tag/7.3.9 As a preview of what these multi-threaded GROUP BY queries can do, here is a quick benchmark versus the only TSDB on Clickbench, TimescaleDB, to put things in perspective:

Hi All! Next week we will be hosting an online Community Meetup. This time we will have two members from our community, @Riccardo Solazzi and @Newskooler, telling us how they are using QuestDB, and which are the good and bad parts in their experience. We will also have part of the core team attending the call, and you will be able to comment or ask anything you want. The event will happen live on Zoom, and you can register at https://us02web.zoom.us/meeting/register/tZIvcOChqj8jGNNBAhTeqksTppiRrkUM8xqq#/registration

Gently reminder that this happens in a few hours from now https://us02web.zoom.us/meeting/register/tZIvcOChqj8jGNNBAhTeqksTppiRrkUM8xqq#/registration

Last week we released 7.3.10, with the following additions: • 5x-10x speed-up in

ASOF

and

LT JOIN

queries, as well as a number of optimizations in parallel filters,

GROUP BY

, and within the JIT compiler. Further,

UUID

and

LONG256

columns are now supported by parallel

GROUP BY

for efficient use of all hardware resources. For workloads that feature small, but frequent transactions you’ll also see improved performance. • This release provides 5x faster ingestion performance when multiple connections are in use, further increasing overall throughput strength compared to InfluxDB, especially in data with high cardinality. • New approx_count_distinct() SQL function that is 3x-5x faster and more memory efficient than the existing count_distinct() function for high cardinality data sets. High Cardinality Benchmark vs InfluxDB OSS:

Invitation to our upcoming Data Stream Social Meetup Whether you are gearing up for the Kafka Summit conference or just happen to be in London, we'd like to invite you to the upcoming Data Stream Social Meetup, hosted by QuestDB together with our co-hosts Quix, WarpStream and RisingWave. Join us the night before the Kafka Summit for a low-key get-together for some food, drinks and a dazzling data streaming quiz 📅 Date: Monday, March 18th ⏰ Time: 6-9pm GMT 📍 Location: Level39, One Canada Square Floor 1 - Canary Wharf, London, E14 5AB Entry is absolutely FREE, but spots are limited. Secure your spot now and be a part of this unforgettable pre-summit social! 👉 Register here: https://www.eventbrite.co.uk/e/data-stream-social-tickets-855864272077 We look forward to see you there!

Hello <!here>, time to update your dependencies! ⤴️ 🚀 New major ILP client library releases for C, C++ and Rust 🦀 (

4.0.0

) and Python python (

2.0.0

)! These introduce ILP over HTTP with better error messages and explicit transaction support. • Python: https://py-questdb-client.readthedocs.io/en/latest/ • Rust: https://docs.rs/questdb-rs/4.0.0/questdb/ • C: https://github.com/questdb/c-questdb-client/blob/main/doc/C.md • C++: https://github.com/questdb/c-questdb-client/blob/main/doc/CPP.md Release notes: • https://py-questdb-client.readthedocs.io/en/latest/changelog.html • https://github.com/questdb/c-questdb-client/releases/tag/4.0.0

Hello, Our Go client also got a major upgrade! Now it also supports ILP over HTTP with better error messages, automatic retries and explicit transaction support. Combined with data deduplication (https://questdb.io/docs/concept/deduplication), this gives you full control over writes and better reliability. Release notes: https://github.com/questdb/go-questdb-client/releases/tag/v3.0.0

Excited to bring you all a new open-source release focused on core database performance! This time, we introduce multi-threaded query optimizations to your beloved

SAMPLE BY

. The first/last aggregate functions for string columns have also been optimized. Note that there are a few breaking changes:

SAMPLE BY

queries now use

ALIGN TO CALENDAR

CREATE TABLE AS

and `INSERT INTO SELECT`statements now operate non-atomically and are batched by default. Java client: The ILP Sender used in our first-party Java client now requires an explicit selection of Transport, (HTTP or TCP) for enhanced reliability and clarity in data ingestion workflows. You will need to pass this value forward. Happy querying! https://github.com/questdb/questdb/releases/tag/7.4.0

To illustrate the power of the new SAMPLE BY implementation, here is an example from the live demo that has more than 1y of crypto data from Coinbase. https://demo.questdb.io/ The following query spans 1 year of intraday crypto market data and includes multiple aggregations and a filter. QuestDB processes 105 Million rows, and the query produces an output of 35K rows. The total query execution time is 477 milliseconds 🔥

Hi folks, today we release 7.4.2: In focus this week is the refinement of our updated ingestion clients. Built atop the InfluxDB Line Protocol (ILP) and leveraging HTTP instead of TCP, our clients and core database now offer a primary ingestion path that is robust, responsive and fast. They’re available in popular languages, including Rust, Python, Java, Go, C & C++, and more. New Features • Added bind variable support for long256 and IPv4 operators, milliseconds and microseconds support to datediff and dateadd. • Enabled FILL(LINEAR) to support ALIGN TO CALENDAR. Performance • ILP: Optimized data ingestion for tables with a large number of columns. • Core: Improved hash table lookup for small string keys and optimized memory usage to reduce OS kills. • SQL: Faster SQL COPY and REST API CSV import, optimized binary search corner cases, and fixed the stuck parallel GROUP BY queries via better query timeout handling. Several bugs have also been fixed. Let us know any feedback you may have!

Hi all, As part of the QuestDB client revamp the Node.js client has just got a major release. The new version supports ILP over HTTP which brings improved error messages, automatic retries and explicit transaction support. Release notes: https://github.com/questdb/nodejs-questdb-client/releases/tag/v3.0.0 Documentation: https://questdb.github.io/nodejs-questdb-client

QuestDB is now an official data source for Grafana Labs 🔥 https://grafana.com/grafana/plugins/questdb-questdb-datasource/ Grafana is the time-series dashboard of choice for many QuestDB users in Finance and IoT. The new official QuestDB Plugin for Grafana improves the developer experience and unlocks new features, such as the query builder. You can get started today via the #QuestDB documentation: https://questdb.io/docs/third-party-tools/grafana/

QuestDB 8.0.1 is out! This is a maintenance release focused on fixing bugs without introducing any major features. https://github.com/questdb/questdb/releases/tag/8.0.1

We announce QuestDB Community! This is a new public forum: this decision was made because we think it’s a better experience overall. Also, Slack decided to change its policy, where history is not kept at all after 90 days. https://community.questdb.io/ This will also help google index the questions so that new users can find the most helpful answers to the usual questions

QuestDB 8.0.3 is out! • JSON support : Extracts fields from a JSON document stored in VARCHAR columns. • New mid() and spread() functions for deeper financial analysis • Faster SQL: More queries now run in parallel • Smarter Web Console: Improved error handling and guidance Link: https://github.com/questdb/questdb/releases/tag/8.0.3 Blog post: https://questdb.io/blog/questdb-release-8-0-3/ Some of the new web console highlights:

QuestDB 8.1 is out! • The biggest news of all is Parquet read beta support! 🔥 ◦ Use the

read_parquet()

function to read Apache Parquet files. • SAMPLE BY syntax improvements: ◦ FROM-TO syntax: Specify result ranges, with support for prefilling and postfilling data. Also can correct misaligned buckets. ◦ Parallel SAMPLE BY: Now supports

FILL(VALUE)

and

FILL(NULL)

. • Snapshot recovery: Added a trigger file to initiate snapshot recovery, improving database resilience and ease-of-use. • SQL Performance: ◦ Speedup for small transaction writing by 50-100%. ◦ Enhanced performance for the like/ilike operator on symbol columns. ◦ Speed improvements for regexp_replace(varchar) with simple patterns. This is a json extract working on top of a json stored in a column of a parquet file: Happy querying