lence 0.4.0

A lightweight data visualization framework

Lence

Lightweight BI as code and data visualization framework. Write markdown pages with SQL queries, render charts and tables.

Usage

# Install lence
pip install lence

# Create a new project
lence init my-project
cd my-project

# Run development server
lence edit

Then open http://localhost:7700

Example Page

Create pages/dashboard.md:

# Sales Dashboard

```sql monthly
SELECT strftime(date, '%Y-%m') as month, SUM(amount) as total
FROM orders GROUP BY 1
```

{% line_chart data="monthly" x="month" y="total" /%}

{% datatable data="monthly" /%}

Development

# Set up environment
make env

# Run development server
make dev

Tech Stack

• Backend: Python, FastAPI, DuckDB
• Frontend: TypeScript, Lit, Vite
• Syntax: Markdoc