January 2022 Summaries

PostgreSQL 14 has been released with various features including pipeline API, improved query parallelism, and enhanced replication capabilities. The database system uses Write-Ahead Logging (WAL) to ensure data integrity, which involves writing changes to the server's file system before they are acted upon by consumers. WAL records can be replicated across multiple servers using a file-based or streaming approach, with the latter being typically asynchronous but can be tuned to be synchronous. Logical decoding is used to extract persistent changes from database tables into a coherent format that can be interpreted without detailed knowledge of the internal state. This process enables replication solutions and auditing to be achieved easily. The PostgreSQL instance needs configuration changes to enable logical decoding, including setting the `wal_level` parameter to `logical`, adjusting `max_replication_slots`, and configuring output plugins like `decoderbufs`. Output plugins transform WAL records into a specified format, such as JSON, which can be consumed by applications or used for change data capture (CDC) solutions. The process of sending push notifications involves modifying the configuration to use a different plugin, such as changing from email integration to notification integration supported by Courier.

Courier's internal hackathons promote innovation, employee engagement, and teamwork by giving employees time to explore ideas and solve customer problems. These events are supported by the company and allow teams to create prototypes that can be turned into regular product features. The hackathons reflect Courier's core values of "have an opinion," "just f-cking do it," and "talk to customers." They highlight the importance of collaboration, experimentation, and customer feedback in driving business growth and improving products. Through these events, employees are encouraged to challenge each other, share their ideas, and push themselves to win, promoting a culture of innovation and teamwork.

As modern applications become increasingly feature-rich and performant, user expectations are at an all-time high, making it essential to communicate key information promptly and accurately. To achieve this, developers can utilize specialized communications APIs that provide features like real-time order update emails, push notifications, and live chat with sales and support. Communications APIs have evolved into three core types: App-to-user APIs, which form a core part of the application experience, sending transactional messages instantly; Brand-to-user APIs, used for sending targeted messages to specific groups of users, saving engineering time but often with implementation delays; and User-to-user APIs, facilitating active conversations between individuals, whether internal staff or app users. By understanding the strengths and weaknesses of each type, developers can create a seamless user experience while enabling their teams to save time and work efficiently.