Comparing working-data storage options — by volume and scenario
Google Sheets
До ~50 тис. рядків, 1–3 користувачі
Free, familiar to everyone, Apps Script automation. Limits: slow on big data, no row-level permissions, structure is easy to break.
Airtable
До ~100 тис. рядків, команда 5–20
Database with simple UI: field types, relations, forms, automations. Paid per user, pricey on big teams.
Notion
Документи + бази, команда до 50
Databases inside wiki: tasks, clients, content plans. Weak for computation and large volumes — not an analytics DB.
CRM (Pipedrive/NetHunt/KeyCRM)
Продажі — будь-який обсяг
Customers+deals out of the box: pipeline, emailing, reports. Limited flexibility — sales entities only; custom via fields.
Baserow / NocoDB
self-hosted альтернатива Airtable
Open source, own server — data stays yours. Needs minimal admin; features slightly behind Airtable.
PostgreSQL + Metabase
Аналітика на серйозних обсягах
Real DB + free BI for dashboards. Needs someone who knows SQL — but scales without limits.
Selection heuristic: <10k rows and 1–2 people — Sheets; structured processes without a developer — Airtable/Notion; sales — CRM; multi-source analytics — PostgreSQL+Metabase. Red flag: a 'master spreadsheet' edited by 5 people — that's a database, not a spreadsheet.