Skip to content

Instantly share code, notes, and snippets.

@PaulieScanlon

PaulieScanlon/analytics-query.ts

Created May 17, 2024 21:45
Show Gist options
  • Save PaulieScanlon/30b90231a7f497e9a9c7ca30d7a3f6da to your computer and use it in GitHub Desktop.
Save PaulieScanlon/30b90231a7f497e9a9c7ca30d7a3f6da to your computer and use it in GitHub Desktop.
Download ZIP
Example analytics query
Raw
analytics-query.ts
const results = await db
.select({
city: analytics.city,
country: analytics.country,
flag: analytics.flag,
})
.from(analytics)
.where(eq(analytics.country, 'US'))
.orderBy(analytics.date)
.limit(10);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment