note that if you want range queries in duckdb-wasm to work, you currently need to make sure that you disable `builtin_httpfs`, otherwise you can end up pulling a ton of data: https://github.com/duckdb/duckdb-wasm/issues/2228#issuecomme...

See: Fast Static Symbol Table: https://github.com/duckdb/duckdb/pull/4366

FSST is based on a fixed size (255 items) dictionary of high frequency variable length strings/substrings (learned from the corpus) encoded as one byte.

If you are into geo spatial, worth to check on the same class project - SedonaDB https://github.com/apache/sedona-db

"SedonaDB is an open-source single-node analytical database engine with geospatial as a first-class citizen"

Apache License 2.0 https://github.com/apache/sedona-db/blob/main/LICENSE

MIT License https://github.com/duckdb/duckdb/blob/main/LICENSE

https://duckdb.org/docs/current/core_extensions/spatial/func...

If you merge PRs that have commit mesages like this, it's easy to arrive at 10000 commits in 6 months:

    rename to NodePointer instead
    format
    Revert "format"
    Revert "rename to NodePointer instead"
    rename to OptionalNodePtr
    woops
    update comment
    slot renames
    more renames

Source: https://github.com/duckdb/duckdb/pull/23605

If every Ctrl+S is a commit, it'll go up fast.

"woops"!

You‘re not the only one interested in this. But seems its a big change that would have to change many parts within DuckdB:

https://github.com/duckdb/duckdb/discussions/8444

Excited about a stable C++ API for extensions!

I made a dry run extension a few months ago (https://github.com/aleda145/duckdb-dryrun), will be so nice to build it just once and know that it will always work.

Also urge anyone to make an extension, the template makes it quite smooth: https://github.com/duckdb/extension-template