# Per-user Database

Published articles for Per-user Database.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## 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

## Give each of your users their own SQLite database

DevFeed: [Give each of your users their own SQLite database](<https://devfeed.tech/articles/give-each-of-your-users-their-own-sqlite-database-5953.md>)

Original publisher: [Read original article](<https://turso.tech/blog/give-each-of-your-users-their-own-sqlite-database-b74445f4>)

Author: Jamie Barton

Published: 2024-01-26T00:00:00Z

Content type: tutorial

Language: en

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

Topics: [migration](<https://devfeed.tech/topics/migration.md>)

Tags: [architecture](<https://devfeed.tech/tags/architecture.md>), [database](<https://devfeed.tech/tags/database.md>), [migration](<https://devfeed.tech/tags/migration.md>), [multi-tenancy](<https://devfeed.tech/tags/multi-tenancy.md>), [per-user-database](<https://devfeed.tech/tags/per-user-database.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>)

### AI overview

The article describes migrating an application from a shared multi-tenant database to a separate SQLite database for each user. It considers simpler data isolation and queries, while raising schema migration and cross-user reporting concerns.

### Source excerpt

Journey from multi-tenant to SQLite single-tenant architecture, inspired by DHH's vision. One user, one database.

## Databases have traditionally been expensive. What if we could change that?

DevFeed: [Databases have traditionally been expensive. What if we could change that?](<https://devfeed.tech/articles/databases-have-traditionally-been-expensive-what-if-we-could-change-that-5930.md>)

Original publisher: [Read original article](<https://turso.tech/blog/databases-have-traditionally-been-expensive-what-if-we-could-change-that-ec7f32ab>)

Author: Glauber Costa

Published: 2023-12-15T00:00:00Z

Content type: article

Language: en

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

Topics: [Turso](<https://devfeed.tech/topics/turso.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>), [cloud-infrastructure](<https://devfeed.tech/topics/cloud-infrastructure.md>)

Tags: [cloud](<https://devfeed.tech/tags/cloud.md>), [databases](<https://devfeed.tech/tags/databases.md>), [devices](<https://devfeed.tech/tags/devices.md>), [embedded](<https://devfeed.tech/tags/embedded.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [multitenancy](<https://devfeed.tech/tags/multitenancy.md>), [offline](<https://devfeed.tech/tags/offline.md>), [per-user-database](<https://devfeed.tech/tags/per-user-database.md>), [processes](<https://devfeed.tech/tags/processes.md>), [scale](<https://devfeed.tech/tags/scale.md>), [servers](<https://devfeed.tech/tags/servers.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [sync](<https://devfeed.tech/tags/sync.md>), [turso](<https://devfeed.tech/tags/turso.md>)

### AI overview

The article describes using Turso to create many databases for multitenant SaaS applications, including a separate database for each tenant, user, or location. It presents deployment across infrastructure, including embedded deployments, while noting that Turso Cloud supports querying databases over the network and syncing them with devices and servers for offline use.

### Source excerpt

Build multitenant SaaSes (with a database per tenant, user, location) and deploy databases anywhere including embedded in your own infrastructure. This and more is what having a legendary amount of databases can do for you.