Knowledge base
Guides for moving work out of spreadsheets
Practical articles on data modeling, access control, internal tools and putting AI agents to work on business data. No fluff, no gated PDFs.
· 7 min read
Notion as a database: what it does well and where it stops
Notion databases, relations and rollups cover a lot of small-team needs. This guide explains where they shine, the limits you meet at scale, and when to pair Notion with a real application database.
notiondatabasesrelationsknowledge managementcomparison
· 7 min read
Forms, reports and dashboards: the three screens every small team needs
How to design data-entry forms, operational reports and management dashboards on top of a business database, with practical rules for each and the mistakes that make them unused.
formsreportsdashboardsuxinternal tools
· 7 min read
Excel and Google Sheets limits: the hard caps and the soft ones that hurt first
Row, cell and file limits in Excel and Google Sheets, plus the practical limits (collaboration, versions, permissions, performance) that force teams to look for something else.
excelgoogle sheetslimitsperformancespreadsheets
· 7 min read
Per-seat vs usage-based pricing: which model fits your team?
Most no-code and collaboration tools charge per user, a few charge by usage. A practical comparison with a worked cost example, the hidden costs of seat pricing and how to choose.
pricingper-seatusage-basedsaas costscomparison
· 7 min read
Data ownership and self-hosting: when it matters and how to decide
Cloud or your own server? A plain-language guide to data ownership, portability, backups and self-hosting for small and medium businesses, with a decision framework and a realistic look at the costs.
self-hostingdata ownershipsecuritybackupsprivacy
· 7 min read
When you outgrow Airtable: signs, options and how to migrate
Airtable is an excellent starting point. Here are the concrete signs that a team has outgrown it, the alternatives worth considering, and a step-by-step plan for moving without losing data or momentum.
airtablemigrationalternativesno-codedatabases
· 8 min read
Building internal tools with AI agents: MCP, REST API and what actually works
How AI agents build and operate business apps through a REST API or an MCP server: the workflow, the guardrails, prompts that work, and the failure modes to plan for.
ai agentsmcprest apiinternal toolsautomation
· 7 min read
Access control for teams: roles, permissions and sharing without chaos
How to design roles and access rights for a shared business database: least privilege, row-level versus table-level rules, external users, auditing, and the traps of sharing spreadsheets.
access controlrolespermissionssecurityteams
· 7 min read
Relational data vs spreadsheets: why linked tables beat one big sheet
What a relational model is, why copy-pasted customer names and lookup formulas break at scale, and how to restructure a flat spreadsheet into linked tables without a computer science degree.
relational dataspreadsheetsdatabase designairtablenotion
· 7 min read
How to turn an Excel or Google Sheets file into a web app
A practical guide to moving a business spreadsheet into a real web app with forms, roles and reports: what to clean up, how to model the data, and what to expect from the first version.
excelgoogle sheetsweb appno-codegetting started
Your spreadsheet, working as an app, today
Start free with your own file. No credit card, no sales call. If you would rather have us build it, book a demo.