Zero-Cost Database Magic πͺπΎ
Giorgi Anakidze
Posted on September 29, 2023
Whether youβre a hobbyist or a professional developer, at some point youβre going to need a database. π We all know the famous solutions like AWS, Azure, or maybe something thatβs more affordable like Linode or DigitalOcean, but what if you only need a database to test some of your ideas? π€ Spinning up your own instance with Docker or just installing it locally may not always be an option. π I wish there were some database services that would be performant enough for testing your ideas and also were freeβ¦ Well, guess what? There are! π And in this article, Iβm going to show off 5 of them, so you can choose the best one for your project! π
PlanetScale π
PlanetScale is a serverless platform for MySQL which offers really good options on a free tier. π€© I think itβd suit most of the developers who want to use MySQL and to save up some money as well. π΅ Hereβs a short brief of what the free tier has to offer:
- Storage - 5GB π¦
- Reads per month - 1 Billion π
- Writes per month - 10 Million βοΈ
- 1 Production Branch π³
- 1 Development Branch π±
As you see, PlanetScale has a pretty good free tier, but thereβs one more service that has even more in theirs, so make sure to read to the end! π
Cloudflare D1 π
Cloudflare D1 is basically a SQLite database that runs on the edge and is used with Cloudflare Workers. So, if you have your web service deployed to Workers which is also running on the edge, it means that your users will be able to always connect to the closest server and get the least amount of latency for them. β‘ Hereβs a short brief of what the free tier has to offer:
- Serverless SQL Database ποΈ
- Reads per day - 5 Million π
- Writes per day - 100K βοΈ
If youβre someone who enjoys using Cloudflare Workers, D1 might be the best choice for you, make sure to check it out at - Cloudflare D1. π
Xata π
Xata is another serverless relational database that is based on PostgreSQL and ElasticSearch under the hood. π It treats your tables like a spreadsheet and whatβs really cool about it is that it has full-text search built-in. π No need to duplicate data to an ElasticSearch instance! They have SDKs for many languages and a visual schema editor. Hereβs a short brief of what the free tier has to offer:
- 15 GB Storage for your data π¦
- Total records - 750K π
- Branches per database - 15 π³
- Requests per second - 75 β‘ Make sure to check it out at - Xata. π
Fauna πΎ
Fauna is another serverless database created by ex-Twitter engineers. It's kind of like MongoDB, but with native JOIN operations, many document databases miss. They have their own language, FQL, and also a GraphQL API. Here's a quick overview of their free tier:
- 100K TROs (Total Read Operations) π
- 50K TWOs (Total Write Operations) βοΈ
- 1GB Storage π¦
- 5 Databases ποΈ Sounds good, but the next one is my personal favorite! π
Neon π‘
Neon is a serverless PostgreSQL option written in Rust. π It has a great free tier, good docs, and supports data branching for various environments. Here's a glance at their free tier:
- Storage - 3GiB π¦
- Branches - 10 π³
- Active time per month - 100 hours (Primary branch stays active even if you go over!) β³
- History retention - 7 days ποΈ
- Choose the PostgreSQL version and server location π
By far, Neon is my top pick! Check it out for yourself at - Neon. π
Enjoy these databases and happy coding! π
Thank you for taking the time to read!Β :)
All of the stories are also available at my personal websiteβ-βhttps://anakidze.dev
Posted on September 29, 2023
Join Our Newsletter. No Spam, Only the good stuff.
Sign up to receive the latest update from our blog.