Operations | Monitoring | ITSM | DevOps | Cloud

Discover the incredible cost optimization journey of Talon.One, a prominent promotion and loyalty solution provider.

In this tutorial, we'll guide you through the process of creating allowed IPs for PostgreSQL on the Aiven platform. Ensuring secure access to your database is essential, and Aiven provides robust security features to help you protect your PostgreSQL instances. We'll show you how to configure the allowed IPs or whitelist specific IP addresses to establish controlled access to your Aiven PostgreSQL database. By implementing IP filtering rules, you can restrict connections to trusted sources and enhance the overall security of your database. Join us as we explore the step-by-step process of managing allowed IPs on Aiven and leverage the platform's security settings to safeguard your PostgreSQL environment.

The talk is originally from the Paris Open Source Data Infrastructure Meetup, hosted by Scaleway, on June 22, 2023.

Welcome to our tutorial on executing basic queries on pgAdmin, the intuitive GUI tool for managing PostgreSQL databases. In this video, we'll cover essential SQL commands such as SELECT, UPDATE, DELETE, and INSERT, and demonstrate how to utilize them effectively on pgAdmin. Whether you're a beginner or looking to refresh your SQL skills, this tutorial provides valuable insights and practical examples. Additionally, we'll share helpful resources like SQL cheatsheets and codecademy's SQL commands article to further enhance your understanding.

Created together with Aiven, Google Cloud and IDC, this video talks about cloud-native app trends, the potential of open-source data tech, and simplified cloud data management. Don't miss out on these key factors driving developer productivity and data-driven innovation!

In this tutorial, we'll walk you through the process of creating databases, schemas, and tables on pgAdmin, a powerful GUI tool for managing PostgreSQL databases. Whether you're new to pgAdmin or seeking to enhance your database administration skills, this video provides a comprehensive guide to efficiently create and organize your database structures. We'll also highlight the seamless integration of pgAdmin with Aiven's PostgreSQL service, enabling you to leverage Aiven's reliable and scalable infrastructure while utilizing pgAdmin's intuitive interface.

In this tutorial, we'll walk you through the process of creating databases, schemas, and tables on pgAdmin, a powerful GUI tool for managing PostgreSQL databases. Whether you're new to pgAdmin or seeking to enhance your database administration skills, this video provides a comprehensive guide to efficiently create and organize your database structures. We'll also highlight the seamless integration of pgAdmin with Aiven's PostgreSQL service, enabling you to leverage Aiven's reliable and scalable infrastructure while utilizing pgAdmin's intuitive interface.

In this video, we have a special interview with Yotam Cohen, DevOps Team Lead at Talon.One, who shares insights on how they optimized their cloud infrastructure costs with Aiven's managed services. Discover how Talon.One, the leading promotion and loyalty solution, manages more than 250 databases totaling 17TB in size, while ensuring optimal resource allocation for each customer. With Aiven's standardized PostgreSQL plans, they were able to achieve cost efficiency without compromising performance and scalability.