lence 0.2.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.

Quick Start

# Set up environment
make env

# Run development server
make dev

Then open http://localhost:8000

Usage

# Install lence
pip install lence

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

# Run development server
lence dev

Example Page

Create pages/dashboard.md:

# Sales Dashboard

{% query name="monthly" source="orders" %}
SELECT strftime(date, '%Y-%m') as month, SUM(amount) as total
FROM orders GROUP BY 1
{% /query %}

{% chart data="monthly" type="line" x="month" y="total" /%}

{% table data="monthly" /%}

Tech Stack

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