Fyrefly

A lightweight Python library to run SQL on databases & compute quant based mathematical operations.

📖 Full documentation: every function, with its formula, what each argument means, and what it returns.

pip install fyrefly

A quick tour

from fyrefly import *

# Math and quant
add(5, 4, 6, 10)                  # 25
ci(1000, 2, 10)                   # 210.0   compound interest
circle.area(7)                    # 153.94
eqn.q(1, 3, 4)                    # roots of x² + 3x + 4
sin(30)                           # 0.5     degrees by default
convert(10, "km", "miles")        # 6.2137

# Data, SQL, Excel-style lookups
c = load("data.csv")              # CSV, Excel, or a shared Google Sheet
d = sql("select * from c where age > 30")
vlook("Alice", "salary")          # like Excel's VLOOKUP
viz(c, "department", "salary")    # 12+ chart types, no API key

# AI (needs an API key; the provider is detected from the key)
ask(c, "total sales by region?", api_key="...")

# Test an API in a Postman-style window
api.gui()

# Physics, all in SI units
projectile.range(20, 45)                 # 40.77 m
circuit.ohm(V=12, R=4)                   # 3.0 A
lorentz.time_dilation(1, lorentz.speed(0.8))   # 1.667 s
nucleus.semf_binding(26, 56)             # 495 MeV

Never commit an API key. Set GEMINI_API_KEY, OPENAI_API_KEY or ANTHROPIC_API_KEY as an environment variable instead.

What's inside

Physics

Every physics function shows its formula in the docs. Angles are in degrees unless you pass mode="rad".

Development

pip install -e ".[dev]"
pytest

License

MIT