# QuestDB 8.1 Release

**URL:** <https://community.questdb.com/t/questdb-8-1-release/124>\
**Category:** Community\
**Tags:** announcement, release\
**Created:** [July 25, 2024, 9:52am UTC](https://community.questdb.com/t/questdb-8-1-release/124 "2024-07-25T09:52:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nicolas](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.questdb.com/nicolas/32/22_2.png) [@Nicolas](https://community.questdb.com/u/Nicolas)\
**Post date:** [July 25, 2024, 9:52am UTC](https://community.questdb.com/t/questdb-8-1-release/124/1 "2024-07-25T09:52:43Z")

</div>

QuestDB 8.1 is out!

The biggest news of all is Parquet read beta support.

- Use the `read_parquet()` function to read [Apache Parquet](https://questdb.io/glossary/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.

SQL example:  
ASOF join between a normal table and a parquet table where we ASOF join by timestamp and also by a column extracted from JSON

 ![image (8)](https://canada1.discourse-cdn.com/flex004/uploads/questdb/original/1X/3143c9ea170b02429629b3d19ca648e9564cab0a.png)

---

<div class="post-metadata">

**Author:** ![nwoolmer](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.questdb.com/nwoolmer/32/24_2.png) [@nwoolmer](https://community.questdb.com/u/nwoolmer)\
**Post date:** [July 25, 2024, 10:00am UTC](https://community.questdb.com/t/questdb-8-1-release/124/4 "2024-07-25T10:00:00Z")

</div>



---

<div class="post-metadata">

**Author:** ![nwoolmer](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.questdb.com/nwoolmer/32/24_2.png) [@nwoolmer](https://community.questdb.com/u/nwoolmer)\
**Post date:** [July 25, 2024, 10:00am UTC](https://community.questdb.com/t/questdb-8-1-release/124/5 "2024-07-25T10:00:08Z")

</div>



---

<div class="post-metadata">

**Author:** ![goodroot](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.questdb.com/goodroot/32/16_2.png) [@goodroot](https://community.questdb.com/u/goodroot)\
**Post date:** [September 16, 2024, 8:42pm UTC](https://community.questdb.com/t/questdb-8-1-release/124/6 "2024-09-16T20:42:49Z")

</div>


