migrations 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

July 16, 2026

Windows 10 refuses to die, and the security bill is coming due

Approximately 16.9 percent of monitored Windows devices are still running Windows 10, a decline from about half a year ago. Windows 10 will receive updates until October 12, 2027, for consumer devices and until October 10, 2028, for commercial customers. Small and medium-sized businesses (SMBs) have 21.4 percent of their machines on Windows 10, with 23 percent in healthcare and pharmaceutical sectors and 22.7 percent in consumer and retail. A Windows 10 device has an average of 1,903 active Common Vulnerabilities and Exposures (CVEs), compared to 652 on Windows 11. Only 14 percent of Windows 10 assets have Extended Security Updates (ESU) patches applied. Many devices are tied to vendor certifications that complicate upgrades, and the rising cost of new PC hardware is a concern. The stagnation of Windows 11 adoption continues, with minimal change in market share distribution.

BetaBeacon

July 13, 2026

Dinosaur Survival Simulator Mesozoic Dawn Released on Android

Players in Mesozoic Dawn start as hatchlings or larvae and evolve to the top of the food chain by foraging for food, avoiding predators, and building nests to have offspring with the best genes for survival.

BetaBeacon

July 11, 2026

Dinosaur Survival Simulator Mesozoic Dawn Released on Android

Mesozoic Dawn is an MMO survival game where players start as hatchlings and evolve to the top of the food chain by navigating the prehistoric world, foraging for food, and avoiding predators. Players must build nests, have offspring, and unlock new species with each generation inheriting the best genes from their parents. The game features over 70 prehistoric creatures adapted to specific climates, and players must manage hunger, thirst, stress, and injuries to survive. Mesozoic Dawn has received positive reviews on Steam and Google Play, with over 50 thousand downloads on Android.

Tech Optimizer

July 8, 2026

PostgreSQL Extensions Are an Architecture Decision, Not an Afterthought

A common issue in database migrations is the unplanned accumulation of extensions in PostgreSQL, leading to extension sprawl. Teams often install extensions without documenting the rationale, resulting in a complex web of dependencies that complicates future upgrades and removals. The installation process involves PostgreSQL accessing a control file that details the extension's version and dependencies, which can lead to multiple extensions being installed unintentionally. Upgrading and removing extensions are often neglected, causing risks such as the loss of dependent objects. Extensions typically default to the public schema, which can become cluttered; relocating them to dedicated schemas can improve organization. Trusted Language Extensions (TLE) allow non-privileged users to utilize procedural languages in managed databases without needing superuser access. Key extensions recommended for use include pg_stat_statements, pg_trgm, hstore, citext, and PostGIS, each serving specific use cases. Proper governance is essential for managing extensions, including documenting their purpose, ownership, and dependencies, to prevent operational surprises.

Tech Optimizer

July 3, 2026

Percona & HexaCluster team up on database migrations

Percona has formed a strategic alliance with HexaCluster to assist organizations in migrating from proprietary databases to open-source alternatives, specifically PostgreSQL, MySQL, and MariaDB. The partnership combines Percona's migration assessment and production support with HexaCluster's migration software for diverse database environments. The migration process will begin with a comprehensive assessment by Percona to outline the scope and plan the transition. Percona will lead the migration efforts, while HexaCluster will provide software solutions for complex migrations. This collaboration aims to help enterprises reduce costs associated with proprietary databases and minimize risks during migration. HexaCluster specializes in PostgreSQL migration and offers tools for migration assessment, schema conversion, data migration, and live replication. Percona supports various database systems and emphasizes open-source solutions to give organizations more control over their data infrastructure.

Tech Optimizer

June 18, 2026

Companies turn to EnterpriseDB for AI data control

Organizations are increasingly adopting EnterpriseDB's EDB Postgres AI platform due to a rising demand for enhanced control over data in AI systems, particularly in sectors like banking, insurance, retail, and trading. Research from MIT Technology Review Insights indicates that prioritizing AI and data sovereignty significantly predicts success in AI initiatives, with such organizations achieving five times the return on investment. In South Korea, the Industrial Bank of Korea migrated 15 core systems to EDB Postgres AI, citing significant reductions in licensing costs compared to Oracle and improved scalability for future AI services. Shinhan EZ Insurance transitioned its core system to the public cloud using EDB, overcoming challenges related to legacy database licensing and emphasizing the importance of operational stability. Beyond finance, companies like MNTN, Euronext FX, and Kyobo Book Centre have adopted the platform to reduce vendor reliance, manage data workloads, and enhance compliance control. MNTN uses EDB for large-scale analytical processing, Euronext FX has implemented it across four data centers, and Kyobo Book Centre migrated from a costly data warehouse to the EDB solution. A common trend among these deployments is the use of a single Postgres-based platform for transactional processing, analytics, and AI tasks, reflecting an industry initiative to simplify operations and reduce costs. Hensley noted the critical convergence of AI systems with operational data, as AI agents operate against live data in high-volume workflows, highlighting the drawbacks of using separate platforms for transactions and analytics. EnterpriseDB has also received industry accolades for its data management and contributions to the open-source community, reinforcing its market position.

Tech Optimizer

June 6, 2026

PostgreSQL Dump and Restore: The Complete pg_dump Guide

pg_dump is a utility for exporting a PostgreSQL database into a file, which can be restored on the same or different servers. It exports a single database's tables, views, sequences, functions, indexes, triggers, and in-database grants but does not include roles, tablespaces, or server-level configurations. To capture global objects, pg_dumpall --globals-only should be executed prior to the per-database dump. pg_dump requires CONNECT and SELECT privileges on all tables and sequences within the target database, and a dedicated backup role is sufficient for single-database dumps, while superuser access is needed for global objects. pg_dump supports various output formats: plain SQL (.sql), custom binary (.dump), directory of files, and tar archive (.tar), each with different capabilities for restoration and compression. The custom format allows for selective and parallel restoration. For non-interactive use, credentials can be stored in a .pgpass file or passed via the PGPASSWORD environment variable. Restoration methods depend on the dump format: psql is used for plain SQL files, while pg_restore is used for custom and directory formats. The restoration process requires the target database to be created beforehand. Version mismatches between pg_dump and pg_restore can lead to failures, so it's essential to ensure that the binaries are version-matched. In Docker, pg_dump and pg_restore can be executed within containers, but care must be taken to manage credentials and ensure version compatibility. Exit codes from pg_dump should be checked to confirm successful operations.

Tech Optimizer

June 6, 2026

Supabase Raises $500M at $10.5B to Accelerate Lead in Agentic Infrastructure

Supabase has secured 0 million in Series F funding, raising its post-money valuation to .5 billion. The funding round was led by GIC, with participation from investors including Accel, Y Combinator, Craft, Felicis, Peak XV, Coatue, Stripe, and Salesforce Ventures. This follows a Series E round just seven months prior, bringing the total capital raised to over 0 million. Supabase's user base has more than doubled since the Series E, with a 600% year-over-year increase in databases. The platform currently has over 250,000 customers and has seen a 370% growth in customer adoption for its Supabase for Platforms service. Supabase has also released a preview of Multigres, an open-source scaling layer for Postgres, which is available under the Apache 2.0 license. Founded in 2020, Supabase serves over 9 million developers and offers a comprehensive backend solution.

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.