Get the latest tech news

Solving complex billable metrics with custom SQL expressions in Lago


Billing shouldn’t just be PDF generation I hate paying for tools that make me do all the work. This is one of my gripes with conventional billing vendors: Sure, it’s easy enough to bill for seat-based subscriptions and a bit of usage.

This means you’re diverting engineers from building product and create complexity that makes this an even bigger headache. For Mistral AI that’s a million tokens, for cloud providers that might be gigabytes in data storage, but it can be anything you can measure events for. You can now send the row event, and Lago applies the following SQL syntax to this metric to get the Unique Seat per Repo: CONCAT(event.properties.user_id', '-' , event.properties.repo_id)

Get the Android app

Or read this on Hacker News

Read more on:

Photo of SQL

SQL

Photo of Lago

Lago

Related news:

News photo

SQL nulls are weird

News photo

TiDB – cloud-native, distributed SQL database written in Go

News photo

Show HN: Execute SQL against Bluesky firehose