Home
HouseNotes
The source code for this blog is available on GitHub.

David Yu's Blog.

Look into database providers

Cover Image for Look into database providers
David Yu
David Yu

Database background

Excel powers businesses, databases power software, technically everything is just a giant table. Arguably the most important part of your service is the data, it is what makes it unique. The code can easily be copied, replaced, deleted but you can't do that with data. The greatest disaster for any company's IT team would be data loss not when their services go down. I spent some time searching the web for the current offerings, the reason I don't want to host my own database is because it takes time and I can't memorise SQL its one of those skills that you use in bursts. There will be long periods where you don't write any and so you forget it. Therefore I love database providers that have a simple UI for me to view, edit, delete my data and tables. I briefly looked at the offerings of table storage available are my key findings are:

  • The leading providers all over similar free tier and pricing of 500MB storage
  • Smaller providers can offer more generous storage but they like refinement of the major providers
  • Serverless and branching are common features now

Options

| Provider | Storage (GB) | Pros | Cons | | ----------- | ------------ | ---------------------------------------------- | ---------------------------------- | | Supbabase | 500MB | No need for SQL queries, Builtin auth, popular | | | PlanetScale | | Branching | No free tier | | Railway | | | Focused on hosting entire app | | TiDB | 25GB | Most storage | | Neon DB | 500MB | Serverless, branching, Point in time recovery | Less popular, no UI to edit tables | | MongoDB | 500MB | NoSQL, Flexible - no schema | Paid tiers get expensive |