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.
Start prototyping, experiment, and spin up your first managed PostgreSQL® database instance in the cloud at no cost. Scale effortlessly to larger production environments as your requirements expand. Benefit from AI-driven optimization recommendations.
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.
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 | ✓ |
AI-driven optimization recommendations | ✓ |
Support |
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 offer maximum security and privacy for your data, consistent performance levels, and the ability to fine-tune for optimal performance.
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.
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.
Aiven services hold certifications such as SOC2, ISO27001, PCI-DSS, and GDPR compliance. You can also set up easy and secure authentication with SSO.
Leverage the Aiven AI database optimizer to review the queries running against your database and receive AI-driven index recommendations to optimize your workloads.
Take advantage of our community support forums to ask questions, get advice, and learn from other developers.
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!
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.
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.
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.
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
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.
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.