Developer Center
A cheatsheet for the PostgreSQL® JSONB functions, providing a set of consistent examples of all the most common JSONB (and JSON) functions and operators.
Who is it for?
Aiven’s free PostgreSQL® plan is ideal for anyone who is looking to easily get started with managed PostgreSQL®, whether it's for personal or professional use. It's perfect for small-scale projects, prototypes, and experiments, it offers essential features for a quick start.
Temporarily test and prototype during product development
Learn more about the basic database concepts, SQL language, and application development
Integrate your favourite application framework
What’s included in your free PostgreSQL® database?
With Aiven’s free PostgreSQL® plan, you operate on an exclusive virtual machine, ensuring there is no sharing of resources and no disturbances from other users. Our user-friendly interface makes managing your database easy, but you can also use Aiven’s CLI or Terraform.
Feature | |
|---|---|
Dedicated VMs | 1 |
CPU per VM | 1 |
RAM per VM | 1 |
Total storage | 5 GB |
Cloud | Digital Ocean with selected regions available around the world |
All networking costs included | ✓ |
Seamless upgrade to other plans | ✓ |
One-click version upgrade | ✓ |
Performance graphs | ✓ |
Data encrypted on disk and network | ✓ |
Backups for disaster recovery | ✓ |
Support |
Benefits of your free Aiven for PostgreSQL® service
Covers everything
Save time with Aiven’s free plan that covers all the essentials, including virtual machine, backup, and networking costs. No unexpected charges arising.
Aiven's dedicated PostgreSQL® instances
Aiven's dedicated PostgreSQL® instances offer maximum security and privacy for your data, consistent performance levels, and the ability to fine-tune for optimal performance.
Monitoring and log access
By having access to monitoring and logs, you can proactively identify and address issues before they escalate, gaining valuable insights into the performance of your database over time.
Terraform integration
Manage your service using the Aiven Terraform provider, and automate the provisioning and management of your PostgreSQL® database. Easily deploy, manage and scale your database infrastructure with the most popular infrastructure-as-code tool.
Secure and compliant
Aiven services hold certifications such as SOC2, ISO27001, PCI-DSS, and GDPR compliance. You can also set up easy and secure authentication with SSO.
Backups for disaster recovery
Join Aiven Community for support
Take advantage of our community support forums to ask questions, get advice, and learn from other developers.
Create your free Aiven for PostgreSQL® service
Set up your fully managed PostgreSQL® db in less than 10 minutes. It's easy and quick - simply access our web console or use our API, CLI, or Terraform. Check out our docs and sign up with your Github or Google account!
Next steps
- Connect to your servicevia command line (psql, pgAdmin) or your application (Go, Java, NodeJS, PHP, Python, Rivery, Skyvia, Zapier)
- Migrate your own database to test it on Aiven platform from an external PostgreSQL® with this migration process (aiven-db-migrate)
- If you don’t have data ready to use, import exoplanets dataset or Pagila sample dataset to your Aiven for PostgreSQL® to see it in action.
Gain freedom and flexibility with open source technology on Aiven Platform
Standard Open Source Technology
Utilizing PostgreSQL® allows for effortless data transfer to various services or platforms without incurring extra costs or complications. This ease of data migration ensures a smooth transition to Aiven from another service or platform.
Same robust Aiven services
Aiven’s free PostgreSQL® hosting is built on the same robust platform that our enterprise customers trust. You can be confident that your database is in good hands, and that it's backed by the same powerful tools and technology that all our customers rely on.
Add more services
You can expand your PostgreSQL® database with other free services like Aiven for Redis®* or Aiven for MySQL®. Redis, for instance, can be used as a cache to speed up queries and reduce latency, which can be particularly useful for applications that require real-time data processing or handling large volumes of data.
FAQ
PostgreSQL® is free as an open-source software, but if you opt for managed services or choose to use it in conjunction with specific platforms, there might be associated costs.
Aiven offers free managed PostgreSQL® service and also a paid version with full capabilities, support and features of the Aiven data platform.
Sign up with Aiven to deploy your initial PostgreSQL® database is quick and easy through our web UI. No credit card needed.
First, choose your preferred region, then click 'Create Service.' Then connect to your database using provided connection details for popular tools. Lastly secure your connection and load data with available workflows for migrating from an existing database or importing sample data.
Alternatively, manage your free service using the Aiven CLI or our Terraform provider.
While free plans come with certain restrictions, they are available at no cost indefinitely. If you require additional memory or access to the complete set of features, opting for the free trial might be a more suitable choice.
Aiven free plans don't have any time constraints. However, free plans will be automatically powered off if they aren't actively used. You will be notified in advance about any free plans that are scheduled to be powered off, via email and notification in the Aiven platform.
Aiven also reserves the right to terminate services if they are deemed to violate the acceptable use policy.
See the detailed list of features and limitations here
You might be interested in
Developer Center
Choosing the name of your new child is really serious, so as a data professional you will naturally want to reach for PostgreSQL®. Find out more below.
Developer Center
Caching is used to speed up cloud applications, particularly for database reads. Read on to learn more, and find out how to build caching with Redis®* into a simple PostgreSQL® web app.