ari

package module

v0.4.0 Latest Latest Go to latest Published: Sep 9, 2026 License: MIT Imports: 12 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/semperos/ari

Links

Open Source Insights

README ¶

Ari

Ari stands for Array Relational Interactive programming environment.

Ari is a set of extensions to the Goal programming language that includes SQL support (SQLite and DuckDB) and an HTTP client with rate limiting support.

This is my personal daily driver for scripting and data analysis, even in the age of coding agents. Parts of this code base have been developed using coding agents and LLMs.

Installation

go install github.com/semperos/ari/cmd/ari@latest

Practical Usage

Development

Ari is implemented in Go and Goal. See the scripts folder for common development operations.

To publish a new version of Ari:

./scripts/release vx.y.z

SQL

The sql package exposes a uniform set of verbs for any supported database. Open a connection with a URI whose scheme selects the driver:

db: sql.open "sqlite://:memory:"   / SQLite in-memory (pure Go, no CGo)
db: sql.open "sqlite://data.db"    / SQLite file
db: sql.open "duckdb://"           / DuckDB in-memory
db: sql.open "duckdb:///data.db"   / DuckDB file

Verb	Form	Description
`sql.open`	`sql.open uri`	Open a connection; returns `sql.conn`
`sql.close`	`sql.close db`	Close a connection; returns `1i`
`sql.q`	`db sql.q "SELECT ..."`	Query; returns columnar dict
`sql.q`	`sql.q[db; "SELECT ... WHERE x=?"; args]`	Parameterised query
`sql.exec`	`db sql.exec "INSERT ..."`	Execute statement; returns exec dict
`sql.exec`	`sql.exec[db; "INSERT ... VALUES(?)"; args]`	Parameterised exec
`sql.tx`	`db sql.tx {[tx] ...}`	Lambda-scoped transaction

Query results are columnar dicts mapping column name strings to typed arrays (AI, AF, AS, or AV). SQL NULL maps to Goal's 0n (float NaN).

Note: DuckDB requires CGo. SQLite uses a pure-Go implementation (modernc.org/sqlite) and has no CGo dependency.

Background

In 2024 I stumbled into a flexible, powerful setup using Julia and DuckDB to do data analysis. Read BACKGROUND.md for more details.

License

Ari

Original software in this repository is licensed as follows:

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the “Software”), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Goal

Source code copied and/or adapted from the Goal project has the following license:

Permission to use, copy, modify, and distribute this software for any purpose with or without fee is hereby granted, provided that the above copyright notice and this permission notice appear in all copies.

THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.

Rye

Source code copied and/or adapted from the Rye project has the following license:

Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
Neither the name of the copyright holder nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS “AS IS” AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

Documentation ¶

Rendered for

Overview ¶

Package ari provides a Goal interpreter with extensions for SQL and HTTP, consumable as a library or via the cmd/ari CLI.

Create a fully-configured Goal context with New:

ctx, err := ari.New(ari.FullOptions())

Embed just the cross-platform subset (no CGo, works in WASM) with:

ctx, err := ari.New(ari.DefaultOptions())

DO NOT EDIT THIS FILE. Generated by the ./scripts/release script.

Index ¶

Constants
func New(opts Options) (*goal.Context, error)
type Options
- func DefaultOptions() Options
- func FullOptions() Options

Constants ¶

View Source

const AriVersion = "v0.4.0"

AriVersion is the current version of ari. Accessible at runtime via rt.get"v".

Variables ¶

This section is empty.

Functions ¶

func New ¶ added in v0.3.0

func New(opts Options) (*goal.Context, error)

New creates a Goal context configured with the ari extensions requested by opts. The returned context has the following always-enabled extensions:

Math verbs (cos, sin, sqrt, round, …)
Base64 verbs (base64.enc, base64.dec, …)
Zip verbs (zip.open, zip.write)
Rate-limit verbs (ratelimit.new, ratelimit.take)
HTTP client verbs (http.client, http.get, http.post, …)
libs global (embedded libs/)

Platform-specific extensions (OS I/O, SQL) are added when the corresponding Options field is true and the build supports them.

Types ¶

type Options ¶ added in v0.3.0

type Options struct {
	// OS enables standard OS/IO verbs (print, say, read, open, run, shell, …).
	// Not available in WASM builds; this field is ignored there.
	OS bool
	// SQL enables the SQL database verbs (sql.open, sql.q, sql.exec, …).
	// Requires CGo; not available in WASM builds.
	SQL bool
}

Options configures which extensions are loaded into the Goal context returned by New.

func DefaultOptions ¶ added in v0.3.0

func DefaultOptions() Options

DefaultOptions returns a base set of options with only cross-platform (non-CGo) extensions enabled. Suitable for WASM builds and lightweight embeddings that don't require GUI or database access.

func FullOptions ¶ added in v0.3.0

func FullOptions() Options

FullOptions returns options that enable all available extensions, including OS I/O and SQL. SQL requires CGo and is silently omitted in WASM builds regardless of this setting.

Source Files ¶

View all Source files

Directories ¶

Path	Synopsis
cmd
ari command ari: a Goal interpreter with extensions for SQL and HTTP.	ari: a Goal interpreter with extensions for SQL and HTTP.
ari-wasm command Browser REPL for ari – Goal + ari extensions (WASM build).	Browser REPL for ari – Goal + ari extensions (WASM build).
help Package help provides help text for ari extensions combined with Goal's standard language help.	Package help provides help text for ari extensions combined with Goal's standard language help.
http Package http provides Goal bindings for making HTTP requests.	Package http provides Goal bindings for making HTTP requests.
ratelimit Package ratelimit provides Goal bindings for leaky-bucket rate limiting.	Package ratelimit provides Goal bindings for leaky-bucket rate limiting.
sql Package sql provides Goal bindings for SQL databases.	Package sql provides Goal bindings for SQL databases.

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL