# Analytics for Per-User Database Architecture

DevFeed: [Analytics for Per-User Database Architecture](<https://devfeed.tech/articles/analytics-for-per-user-database-architecture-5887.md>)

Original publisher: [Read original article](<https://turso.tech/blog/analytics-for-per-user-database-architecture>)

Author: Jamie Barton

Published: 2024-11-18T00:00:00Z

Content type: article

Language: en

Sources: [Turso Blog](<https://devfeed.tech/sources/turso-blog.md>)

Topics: [Per-user Database](<https://devfeed.tech/topics/per-user-database.md>), [Multitenancy](<https://devfeed.tech/topics/multitenancy.md>), [Turso](<https://devfeed.tech/topics/turso.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>), [Platform API](<https://devfeed.tech/topics/platform-api.md>), [Data Management](<https://devfeed.tech/topics/data-management.md>), [Architecture & Design](<https://devfeed.tech/topics/architecture-design.md>), [Software as a service](<https://devfeed.tech/topics/saas.md>), [data-architecture](<https://devfeed.tech/topics/data-architecture.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [architecture](<https://devfeed.tech/tags/architecture.md>), [data-management](<https://devfeed.tech/tags/data-management.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [etl](<https://devfeed.tech/tags/etl.md>), [metrics](<https://devfeed.tech/tags/metrics.md>), [monitor](<https://devfeed.tech/tags/monitor.md>), [per-user-database](<https://devfeed.tech/tags/per-user-database.md>), [platform-api](<https://devfeed.tech/tags/platform-api.md>), [reporting](<https://devfeed.tech/tags/reporting.md>), [saas](<https://devfeed.tech/tags/saas.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [turso](<https://devfeed.tech/tags/turso.md>)

## AI overview

This article explains how to aggregate analytics from a per-user or per-tenant Turso database architecture. It describes using an ETL script to query individual SQLite databases, collect metrics such as orders, revenue, shopping carts, and products, and store the results in a central database for reporting and platform monitoring.

## Source excerpt

Aggregating Multi-Tenant Databases for Analytics and Reporting