developer experience Archives

Tech Optimizer

July 22, 2026

Migrating mission-critical payments at Nubank to Amazon Aurora PostgreSQL

Nubank, a digital banking platform with approximately 135 million customers in Brazil, Mexico, and Colombia, faced challenges with its payment infrastructure due to inefficiencies in managing 7.5 TB of self-hosted PostgreSQL databases. Queries took over 13 minutes to execute, and replication lags exceeded four minutes during peak times. To address these issues, Nubank evaluated database solutions based on developer productivity, operational efficiency, performance reliability, and scalability. They selected Amazon Aurora PostgreSQL-Compatible Edition for its compatibility, performance improvements, and automated features. The migration to Aurora was facilitated by AWS Database Migration Service (AWS DMS), which minimized downtime and allowed for efficient transition. Post-migration, query performance improved significantly, with some queries executing up to 1,900 times faster, and overall end-to-end service latency decreased, enhancing customer experience. The migration resulted in a 25 percent cost reduction and ensured compliance with regulatory requirements.

Winsage

June 23, 2026

Why is Windows 11 so disliked by programmers – and can Microsoft do anything to change things?

Windows is experiencing a decline in favor among developers, with many preferring macOS and Linux for coding. Although nearly half of developers (49.5%) primarily work on Windows, this is often due to organizational mandates rather than personal preference. Developers interviewed did not select Windows as their preferred environment, citing concerns about Microsoft's developer experience, cumbersome tools, and security issues. The Windows Subsystem for Linux (WSL) allows developers to run Linux environments on Windows 11, addressing some compatibility issues. However, there is a consensus that Microsoft should enhance WSL and align Windows more closely with Linux to attract more developers. Critics also point to the intrusive nature of ads and upselling in Windows 11 as detracting from the developer experience.

Tech Optimizer

June 20, 2026

PostgreSQL 18 on Amazon Aurora and Amazon RDS: Security, monitoring, and developer enhancements

PostgreSQL version 18 has deprecated MD5 password authentication in favor of SCRAM-SHA-256, with a new parameter, md5_password_warnings, enabled by default to log deprecation warnings. It has enhanced monitoring capabilities by adding columns to pg_stat_database and pg_stat_statements to track parallel worker activity, with the default max_parallel_workers_per_gather set to 0 in Aurora PostgreSQL. The pg_stat_subscription_stats view now includes new columns for tracking conflict types in logical replication. Optimizer statistics are automatically transferred during upgrades, while uuidv7() generates timestamp-ordered UUIDs. The default streaming option for CREATE SUBSCRIPTION has changed to parallel, and the idle_replication_slot_timeout parameter automatically invalidates inactive replication slots. Enhancements to the COPY command include REJECT_LIMIT for error tolerance and a silent LOG_VERBOSITY level. OLD and NEW aliases have been introduced in RETURNING clauses for various DML commands.

AppWizard

June 19, 2026

Google sets timeline for Android developer verification enforcement

Android's developer verification initiative will officially roll out on September 30, 2026, initially targeting users in Brazil, Indonesia, Singapore, and Thailand. Developers in these regions must complete the verification process by the deadline. Participating app stores, including Google Play and others, will begin verifying app installations, with a global implementation planned for 2027. The initiative aims to enhance security by linking apps to verified identities. Google is introducing new APIs to facilitate app registration, including the Android Developer ID Status API and the Android Developer Console API, which will support OAuth delegation for third-party platforms. A new system service will be installed on most Android devices to verify developer registrations later this year. The Android Developer ID Status API is set for global launch in July 2026, with early access to the Android Developer Console API. Limited distribution accounts for students and hobbyists will launch globally in August 2026. Starting September 30, 2026, only apps registered by verified developers will be allowed for installation and updates on certified Android devices, although unregistered apps can still be sideloaded. Google has reported that over 99% of Play developers have completed the verification process, and developers can check their verification status in the Play Console.

AppWizard

June 19, 2026

Google shares updated timeline for rolling out Android developer verification

Google, Honor, OPlus, Samsung, Transsion, vivo, and Xiaomi are key players in enhancing app distribution platforms. Google is introducing new APIs to simplify the registration process for developers, including the Android Developer ID Status API and the Android Developer Console API. This month, Google will implement a new system service (com.google.android.verifier) on Android 8 or later devices to restrict the installation of unverified applications, although it will remain inactive until verification is launched in specific regions. In July, new developer APIs will roll out, and testing for "limited distribution" accounts will begin, allowing hobbyists to share apps without fees or ID verification on up to 20 devices. By August, an advanced app verification flow will be globally accessible, allowing users to bypass verification through a complex process. In September, Brazil, Indonesia, Singapore, and Thailand will start verifying app installation status, with plans for expanded developer verification by 2027.

Tech Optimizer

June 14, 2026

Neon vs Supabase 2026: $1B Deal, Scale-to-Zero

Neon and Supabase are two managed PostgreSQL platforms with distinct approaches. Neon adopts a serverless architecture that separates storage and compute, allowing databases to scale to zero when idle and enabling rapid database branching. Supabase, in contrast, provides a comprehensive backend-as-a-service that includes authentication, file storage, real-time subscriptions, and edge functions, all built around PostgreSQL. In 2025, Databricks acquired Neon for approximately billion, motivated by the observation that around 80% of databases created on Neon were generated by AI agents. Post-acquisition, users experienced reduced storage costs and improved pricing structures, although concerns arose regarding Neon's independence. Neon features instant database branching and a scale-to-zero capability, while Supabase offers a fully integrated backend with built-in authentication and storage. Neon operates on a usage-based pricing model, whereas Supabase has a flat-tier pricing structure. Both platforms support the pgvector extension for AI applications, but Supabase is fully open-source and allows for self-hosting, unlike Neon. The developer community recognizes Supabase for its ease of use and rapid application development capabilities, while Neon is praised for its innovative serverless features and cost efficiency. Migration between the two platforms is simplified due to their shared PostgreSQL foundation.

Winsage

June 9, 2026

Windows 11’s Widgets panel is still a wasteland, even after Build

Microsoft's Build conference highlighted tools and hardware for enhancing the developer experience for Windows applications and AI agents, with a focus on refining Windows 11 and its applications through Windows K2. The Widgets panel, accessible via the weather icon or WIN+W shortcut, has not received significant attention and currently offers only 56 widgets, with few providing genuine utility. Notable widgets include MagicPods, Calendar Flyout, and some utilities, but overall, the panel is seen as lacking. Despite improvements in the Microsoft Store and a growing library of applications, the Widgets panel remains underdeveloped, with only minor enhancements made, and its future is uncertain.

Winsage

June 7, 2026

4 Windows 11 tools from Build 2026 that signal what’s coming next for the OS

Microsoft announced several key updates at the Build 2026 developer conference, particularly for Windows 11: 1. Coreutils: This suite brings familiar Linux command-line utilities to Windows 11, allowing developers to use commands like ls, cp, and mkdir natively without third-party solutions. It can be installed via GitHub or the Windows Package Manager. 2. WSL Containers: This feature introduces a built-in container runtime for running Linux containers on Windows 11, eliminating the need for external platforms like Docker. It utilizes a command-line tool called "wslc.exe" and allows for OCI-compatible Linux containers. 3. Intelligent Terminal: This feature integrates AI agents into the terminal, providing context-aware assistance for developers. It can be installed via the Microsoft Store or Command Prompt. 4. Windows Developer Configurations: This configuration file for the Windows Package Manager automates the installation of essential developer tools and settings, streamlining the setup process for new development or testing machines.

Tech Optimizer

June 6, 2026

PostgreSQL vs SQL Server 2026: $0 vs $15K License

PostgreSQL has become the most utilized database for developers for two consecutive years as of 2026, while SQL Server has introduced native AI capabilities and vector search functionalities in its latest release. PostgreSQL is favored for new projects due to its permissive licensing, cross-platform operation, and extensive ecosystem of extensions, whereas SQL Server is preferred by organizations already using Microsoft products for its robust tooling and enterprise support. As of June 2026, SQL Server ranks third in the DB-Engines popularity ranking with a score of 698, while PostgreSQL ranks fourth with a score of 688. Developer adoption trends show that 49% of respondents in the Stack Overflow 2024 Developer Survey use PostgreSQL, compared to 27% for SQL Server. The latest stable version of PostgreSQL is 18.4, released on May 14, 2026, while SQL Server 2025 (version 17.x) became generally available on November 18, 2025. PostgreSQL is free under a permissive license, while SQL Server's Enterprise Edition can cost upwards of ,123 per two-core pack, with an eight-core minimum. PostgreSQL supports various operating systems, including Linux, Windows, macOS, and BSD, while SQL Server operates on Windows and Linux. PostgreSQL uses PL/pgSQL as its primary procedural language, allowing for multiple procedural languages, whereas SQL Server uses T-SQL. PostgreSQL's JSONB type offers rich indexing, while SQL Server added native JSON support in its 2025 release. Both databases are capable of handling high transaction volumes, but PostgreSQL excels in read-heavy scenarios due to its multi-version concurrency control, while SQL Server's columnstore indexes provide advantages for analytical workloads. PostgreSQL supports tables up to 32 TB, while SQL Server can handle a maximum database size of 524 PB. SQL Server's high availability technology includes Always On Availability Groups, while PostgreSQL offers built-in streaming and logical replication. The security features of both databases meet enterprise standards, with PostgreSQL providing a transparent patching process and SQL Server integrating with Microsoft tools. Real-world usage examples include Stack Overflow using SQL Server, while Instagram and Reddit utilize PostgreSQL. Developer sentiment increasingly favors PostgreSQL for new projects, emphasizing flexibility and open-source solutions. For new startups or greenfield projects, PostgreSQL is recommended due to its zero license cost and compatibility. Existing Microsoft enterprises are advised to stick with SQL Server for its integration benefits. Migration from SQL Server to PostgreSQL is becoming common, with a structured approach required for successful transitions.

Winsage

June 3, 2026

Microsoft’s new developer-optimized Windows embraces Linux even more

Microsoft is enhancing its Windows operating system by integrating Linux-like command line utilities and further developing its Linux subsystem. This includes the introduction of frequently used command line utilities, a streamlined setup process, and a built-in mechanism for creating and interacting with Linux containers on Windows. Notable advancements include the introduction of Coreutils for Windows, which brings Linux-like command-line utilities to the platform, and deeper integration of Windows Subsystem for Linux (WSL) with WSL containers that allow developers to create, run, and manage Linux containers within Windows. A command-line interface and API for WSL containers will be available in public preview soon. Additionally, Microsoft is enhancing the Windows Terminal with a new feature called the Intelligent Terminal, which provides contextual assistance for tasks like querying and debugging. Microsoft is also rolling out Windows Developer Configurations to simplify the setup of new machines with developer-friendly settings, installing essential tools such as WSL, PowerShell 7, and Visual Studio Code.