Writing
- [Blog index](https://bionicforms.com/blog)
- [How to build an internal tool without a developer, and how to tell if you should not](https://bionicforms.com/blog/internal-tools-without-a-developer): the phrase covers three different products and they are not substitutes. Connector platforms (Retool and similar) build screens over a database or API you already run, so with nothing to connect to they are a non-starter rather than a cheap option. Spreadsheet-shaped databases (Airtable and similar) hold the records for you and are the fastest start. File-shaped databases, the Microsoft Access tradition, make the database and the application one object you own. The post also says plainly when to hire a developer instead: when the value of the tool lives in a procedure - pricing logic, scheduling, parsing an awkward document - rather than in the records, because configurable automation is a fixed catalogue and anything outside it is refused. It carries a number from the author's own use of his own software: of nine applications, the ones that could only have been filled by typing hold 3, 7 and 10 records, so the question that decides whether any of these tools survives is whether the data already exists in a file.
- [An anonymous form shouldn't know who you are](https://bionicforms.com/blog/truly-anonymous-forms): how the rate limiter keeps the anonymity promise by hashing the caller's address instead of storing it.
- [Turn a Google Sheet into a database](https://bionicforms.com/blog/google-sheet-to-database): every column typed only from what all of its values support, and dates it cannot settle asked, never guessed.
- [Northwind, running in your browser](https://bionicforms.com/northwind): Microsoft's Northwind sample database rebuilt as a working app, opened in one click at https://bionicforms.com/demo with no download, no install, no account and no email. Every other version of Northwind is a script or a file to run against a server first. It is editable and private to the visitor, cleared after about a day unless kept with a free account. It is NOT a SQL console: there is no query box, so someone wanting a SQL playground should use Microsoft's own scripts instead.
- [What happens to the other tabs in my spreadsheet?](https://bionicforms.com/spreadsheet-tabs): every tab is read, not just the first. Tabs holding the same kind of record merge into one collection; a tab of formulas and running totals is left alone; a column's type is decided by every tab that will share it. A value whose unit contradicts its column ("61.9 kg" under "Weight (lbs)") stops the import rather than being converted. For comparison, Google's own AppSheet documentation states that up to five worksheets are imported into an AppSheet database; this does not cap the number of tabs.