Best free services for PostgreSQL databases
NeonDB
One of the best options currently available with a very generous free plan, great machine resources and good storage for small or personal projects. Personally I build my university projects here.
| Item | Capacity |
|---|---|
| Projects | 10 |
| Compute Hours | 190 |
| CPUs | 2 |
| RAM | 8GB |
| Storage | 0.5GB |
Advantages
- Integrated web client to manage databases.
- Excellent metrics dashboard (shows up to 14 days of history in the free plan), including queries history.
- SQL editor to make queries directly from the browser.
Render
A very simple alternative to get started, with a free functional layer for testing or basic development environments.
| Item | Capacity |
|---|---|
| CPU per VM | 0.1 |
| Connections limit | 100 |
| RAM | 256MB |
| Storage | 1GB |
Advantages
- Access to database logs.
- Detailed metrics on RAM, storage, CPU usage, among others.
Aiven
Aiven offers a free plan for PostgreSQL databases, you will have an exclusive virtual machine without sharing resources and has a very simple but limited interface compared to the previous options.
| Item | Capacity |
|---|---|
| VMs dedicated | 1 |
| CPU per VM | 1 |
| RAM per VM | 1 |
| Storage | 1GB |
| Connections limit | 20 |
Advantages
- Metrics panel, you can filter the data up to 1 year ago.
- Panel of the database logs.
- Shows the list of queries performed.
- Performs automatic backups.
From my experience using all these services, I can say that the best option is undoubtedly NeonDB, it is the one with the best resources, faster and more stable. And it also has a great graphical interface, you can access the logs and manage the database tables.