migrations Archives

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.

Tech Optimizer

June 5, 2026

GIC leads Supabase’s $500M Series F funding

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 existing investors including Accel, Y Combinator, Craft, Felicis, Peak XV, and Coatue. Stripe made a second investment in Supabase, and Salesforce Ventures also participated in this round. This funding comes seven months after Supabase's Series E, bringing the total capital raised to over 0 million. The user base has more than doubled since Series E, with a 600% increase in databases year-over-year. Supabase currently serves over 250,000 customers, with a significant number using its infrastructure for AI applications. Supabase for Platforms has seen a 370% growth in customer adoption in the last six months. The company has introduced Multigres, an open-source scaling layer for Postgres, which offers horizontal scaling, sharding, zero-downtime migrations, and high availability while remaining compatible with the Postgres ecosystem.

Winsage

June 4, 2026

ADCS Now Generates Post-Quantum Certificates For Windows

Active Directory Certificate Services (ADCS) now supports the generation of post-quantum certificates, enhancing quantum-safe cryptography within Windows' secure connection protocols. Microsoft has integrated PQ TLS hybrid key exchange into the Windows Transport Layer Security (TLS) stack, providing protection against "Harvest Now, Decrypt Later" attacks. The PQ TLS hybrid key exchange combines traditional cryptographic methods with the NIST ML-KEM algorithm, offering three hybrid combinations: X25519MLKEM768, SecP256r1MLKEM768, and SecP384r1_MLKEM1024. This feature is available in preview via the Windows Insider Program and will be rolled out to Windows 11 and Windows Server. Additionally, Windows cryptography APIs now support composite ML-KEM and ML-DSA algorithms, which are NIST-approved standards for key exchange and digital signatures, enhancing security by requiring multiple components to be compromised. Microsoft emphasizes the importance of establishing new Certification Authorities (CAs) for implementing post-quantum certificate issuance, as existing CAs cannot be upgraded. The introduction of ML-DSA support within ADCS allows organizations to counter HNDL risks associated with long-lived data. Organizations are encouraged to inventory their use of public-key cryptography, prioritize systems protecting sensitive data, and test hybrid and composite approaches in non-production environments to facilitate a smooth transition to quantum-safe cryptography.

Tech Optimizer

June 2, 2026

Accelerating developer productivity in the agentic AI era with Amazon Aurora PostgreSQL

Pravin, who leads engineering for Amazon Aurora, shared an anecdote about his son and friends using AI-assisted coding tools to develop an app without needing to worry about database setup. Elizabeth from AWS Databases noted that teams can now deliver projects in days instead of months, with a broader demographic of builders, including analysts and designers. Engineers in Pravin's organization are creating agents that significantly reduce on-call work, and product managers are drafting documents more efficiently. Aurora aims to address the challenges posed by rapid development changes by adhering to three core principles: meeting developers where they work, absorbing workload variability, and growing with applications. Aurora PostgreSQL is integrated into AI coding tools, allowing developers to set up databases quickly. It features a serverless model that automatically scales to meet fluctuating demands, accommodating workloads from small projects to large-scale applications. The database supports existing tools and frameworks, ensuring compatibility and easing migration challenges. Examples of successful transitions to Aurora PostgreSQL include SurveySparrow, which achieved cost savings and improved query latency, and Netflix, which reported significant performance improvements. Aurora's flexibility allows developers to use both serverless and provisioned instances within the same cluster, optimizing operations without data migration. It also provides options for tuning performance and maintaining an up-to-date database with minimal disruption. Aurora Global Database enables applications to expand across regions without overhauling the data layer, supporting cross-region disaster recovery and low-latency reads. Companies like S&P Dow Jones Indices and DraftKings have successfully leveraged Aurora to support their growth and operational needs. Aurora PostgreSQL is designed to empower developers, facilitating innovation across various project scales.

Tech Optimizer

May 18, 2026

Google Pushes AI for PostgreSQL Development

Google is integrating artificial intelligence into PostgreSQL engineering while ensuring engineers remain responsible for their code contributions. This initiative aims to improve productivity and streamline processes, particularly in version upgrades, replication behavior, and production recovery. Sailesh Krishnamurthy, Google Cloud's VP of Databases, emphasized the importance of human oversight in this AI-driven approach. Between July and December 2025, Google's PostgreSQL engineering focused on logical replication, improvements to pg_upgrade, and upstream bug fixes. Logical replication allows selective database change transfers, which is beneficial for migrations and upgrades. The roadmap includes Automatic Conflict Detection and logical replication of sequences to minimize manual synchronization issues. Enterprise teams are particularly interested in these developments due to the challenges posed by write collisions and misaligned sequence values. The demand for PostgreSQL services at Google is increasing due to migration needs from Oracle and SQL Server. Recent data shows PostgreSQL's rising popularity, ranking fourth in the DB-Engines ranking and gaining 8.37 points year over year, while its competitors experienced declines.

Tech Optimizer

May 18, 2026

Google tells database devs to lean hard on AI for PostgreSQL work

Google is encouraging developers to use AI coding tools for open source projects like PostgreSQL, highlighting the productivity improvements seen internally. Sailesh Krishnamurthy, Vice President of Databases at Google Cloud, emphasized that developers remain accountable for their contributions, regardless of AI usage. The suitability of AI tools for open source projects is due to the accessibility of the codebase, which aids in training generative models. PostgreSQL is noted for its extensibility, allowing for rapid experimentation and innovation. A recent Stack Overflow survey identified PostgreSQL as the most favored database among developers in 2023, attributed to increased investments from major cloud providers. Microsoft has made significant contributions to PostgreSQL, including the development of pg_documentdb_core and pg_documentdb_api, and has introduced a distributed PostgreSQL database service called HorizonDB. Research from Gartner shows that only Microsoft has grown its market share among leading database vendors over the past 15 years, while Google and other cloud providers are shifting momentum towards open source solutions like PostgreSQL.