January 2022 Summaries

Temporal offers a microservice orchestration platform while Aiven provides data infrastructure management services. The two companies have partnered to offer fully-managed cloud services, including Postgres, Apache Cassandra, and others. Aiven ensures the integrity of open source code and delivers consistent uptime with no downtime for upgrades or downgrades. Temporal's microservice orchestration platform is used by major companies like Stripe, Netflix, and Coinbase. The partnership between Temporal and Aiven allows users to quickly switch databases and focus on getting the most out of Temporal.

OpenSearch is an open source search and analytics suite that serves as an alternative to Elasticsearch. It includes a search engine daemon, NoSQL database, and visualization interface. The distributed, full-text search engine is based on Apache Lucene with RESTful API interface support for JSON documents. Key components of OpenSearch include clusters and nodes, indices, REST API, and aggregations. Its primary use cases involve log analytics, real-time application monitoring, clickstream analytics, and search backend. To get started with OpenSearch, users can deploy it through the Aiven Console and connect using Python or NodeJS.

PostgREST is a tool that generates a RESTful API directly from your PostgreSQL data model, removing the need to write your own interface. It can be used with Aiven for PostgreSQL as a database layer and a dataset from Kaggle. The process involves setting up a PostgreSQL service on Aiven, importing data into PostgreSQL, configuring the PostgreSQL, running PostgREST, exploring the RESTful API, and learning about next steps. This tool is useful for creating a RESTful API without needing to code in a high-level programming language or use a web framework.

PostgreSQL 15 introduces a new feature called READ_REPLICATION_SLOT command, developed by Aiven to improve the reliability of physical replication clients like pg_receivewal. The command allows these clients to read the current restart LSN and timeline associated with a replication slot, making them more reliable. This feature will help address issues encountered when using pg_receivewal and benefit other replication clients as well.