Tinybird @tinybird.co · Feb 20 3. Store multi-tenant logs in a single table with row-level security You could create a table per tenant or use a separated storage/compute model, but that adds complexity. Dump all your logs in one table and worry about retrieval latest. This is trivial with the right db.
0 likes 1 replies
?
Replies
4. Index/sort by time When you retrieve logs, you usually want them for a certain time period. Indexing/sorting by time (and using columnar storage) makes retrieval much faster. Bonus: Sort first by client_id if you only want to retrieve logs for one client at a time.