Highlights
Lance Support
GlareDB now offers support for [Lance](https://lancedb.github.io/lance/).
[Lance](https://lancedb.github.io/lance/) is a Modern columnar data format optimized for ML and LLM workflows.
sql
SELECT * FROM lance_scan('path/to/file.lance');
Documentation Improvements
We have made it easier to find the information you need, where you need it most.
Our functions catalog now contain 2 additional columns `description` and `example`.
These contain a short description of the function and an example of how to use it.
sql
SELECT
function_name,
example,
description
FROM glare_catalog.functions
Installing or Updating
CLI
To install or update just run the following command in the directory you want
the binary:
sh
curl https://glaredb.com/install.sh | sh
Python
py
pip install glaredb
What's Changed
New Features
- `lance_scan` function by universalmind303 in https://github.com/GlareDB/glaredb/pull/2108
- bump prql version by universalmind303 in https://github.com/GlareDB/glaredb/pull/2111
- Allow trailing commas in select list by scsmithr in https://github.com/GlareDB/glaredb/pull/2117
- Remove 'parquet' feature from deltalake dep by scsmithr in https://github.com/GlareDB/glaredb/pull/2121
- add lance as external table by universalmind303 in https://github.com/GlareDB/glaredb/pull/2120
- Bump deps by scsmithr in https://github.com/GlareDB/glaredb/pull/2131
- Send metrics for hybrid exec queries (rpc) by vrongmeal in https://github.com/GlareDB/glaredb/pull/2103
- make tokio a workspace dependency by tychoish in https://github.com/GlareDB/glaredb/pull/2139
- Enable corepack before setting up node by scsmithr in https://github.com/GlareDB/glaredb/pull/2146
- Send `user_id` in RPC execute request to collect metrics by vrongmeal in https://github.com/GlareDB/glaredb/pull/2140
- Bump deps by scsmithr in https://github.com/GlareDB/glaredb/pull/2159
- Add 'access_mode' column for databases and tables by scsmithr in https://github.com/GlareDB/glaredb/pull/2162
- Remove background jobs by vrongmeal in https://github.com/GlareDB/glaredb/pull/2148
- Split session catalog out into its own crate by scsmithr in https://github.com/GlareDB/glaredb/pull/2167
- Scheduling by scsmithr in https://github.com/GlareDB/glaredb/pull/1924
- Expose catalog through table func context by scsmithr in https://github.com/GlareDB/glaredb/pull/2172
- rename CREATE CREDENTIALS to CREATE CREDENTIAL by Lilit0x in https://github.com/GlareDB/glaredb/pull/2180
- Send query text when executing query over RPC by vrongmeal in https://github.com/GlareDB/glaredb/pull/2179
- alias read_parquet, read_njson, read_csv to their scan counterpart by Lilit0x in https://github.com/GlareDB/glaredb/pull/2185
- builtin descriptions & examples by universalmind303 in https://github.com/GlareDB/glaredb/pull/2178
- Simple query interface by scsmithr in https://github.com/GlareDB/glaredb/pull/2201
- clean up lint target by tychoish in https://github.com/GlareDB/glaredb/pull/2204
- bump google-github-actions/auth from 1 to 2 by dependabot in https://github.com/GlareDB/glaredb/pull/2189
- Bump deps by scsmithr in https://github.com/GlareDB/glaredb/pull/2206
- kdl_match function by tychoish in https://github.com/GlareDB/glaredb/pull/2145
- Move table func trait by scsmithr in https://github.com/GlareDB/glaredb/pull/2208
- improve+cleanup func param processing by tychoish in https://github.com/GlareDB/glaredb/pull/2203
- Data source cache by scsmithr in https://github.com/GlareDB/glaredb/pull/2164
Bug Fixes
- add better error message for invalid "version" cmd, and invalid sql files by universalmind303 in https://github.com/GlareDB/glaredb/pull/2110
- stdin piping by universalmind303 in https://github.com/GlareDB/glaredb/pull/2137
- case sensitivity in create table by universalmind303 in https://github.com/GlareDB/glaredb/pull/2141
- improvements to schema inference by tychoish in https://github.com/GlareDB/glaredb/pull/2143
- Properly compute stats for globbed paths by tychoish in https://github.com/GlareDB/glaredb/pull/2171
- Mark 'default' database as READ_WRITE by vrongmeal in https://github.com/GlareDB/glaredb/pull/2173
- create or replace for credentials by universalmind303 in https://github.com/GlareDB/glaredb/pull/2134
- handle integer overflows by tychoish in https://github.com/GlareDB/glaredb/pull/2205
New Contributors
* Lilit0x made their first contribution in https://github.com/GlareDB/glaredb/pull/2180
**Full Changelog**: https://github.com/GlareDB/glaredb/compare/v0.7.0...v0.7.1