32 lines
639 B
Markdown
32 lines
639 B
Markdown
---
|
|
id: 2026-03-06T12:20:32-0500
|
|
title: 2026-03-06 12:20:32
|
|
tags:
|
|
- status/draft
|
|
date-created: 2026-03-06T12:20:32-05:00
|
|
daily: "[[2026-03-06]]"
|
|
---
|
|
# 2026-03-06 12:20:32
|
|
|
|
## Sqlean
|
|
|
|
[Sqlean](https://github.com/nalgeon/sqlean)
|
|
is a [[sqlite|SQLite]] extension
|
|
implementing an opinionated list of helper functions.
|
|
|
|
### Installation
|
|
|
|
Sqlean and its companion shell can be installed
|
|
via your favorite [[package-managers|package manager]].
|
|
|
|
```sh
|
|
choco install sqlean sqlean-shell
|
|
```
|
|
|
|
The extension can be loaded into the vanilla SQLite shell via `.load`,
|
|
|
|
### Usage
|
|
|
|
```sqlite
|
|
sqlean> SELECT MEDIAN(VALUE) FROM GENERATE_SERIES(1, 99);
|
|
``` |