database Archives

Tech Optimizer

August 29, 2026

Overcoming the Barriers of Commercial DBs with Open Source and AI… EDB Hosts ‘PostgreSQL AI Summit’

A company's approach to artificial intelligence (AI) begins with determining the optimal structure for data storage and management, often facing challenges such as high costs of commercial databases and reliance on specific enterprise technologies. To effectively utilize AI, companies need to establish new infrastructures, including vector search capabilities, Search Augmentation Generative (RAG) systems, and data lakehouses. EDB is notable for connecting companies and technology partners that have transitioned to open-source databases. On September 3, EDB will host the 'EDB Postgres AI Summit Seoul 2026' at the Sofitel Ambassador Seoul, starting at 10:00 AM. This event is the largest PostgreSQL conference in Korea, themed 'Change the Game,' focusing on the shift from commercial databases to open-source and AI-driven frameworks, featuring real-world case studies. Approximately 300 C-level executives and IT decision-makers from various sectors are expected to attend, with participation by invitation only. The summit will include 15 sessions with customer case studies and technical presentations. Notable discussions will include IBK Industrial Bank of Korea's migration of 15 core systems to PostgreSQL, a semiconductor company's diversification of MPP databases on a DBaaS platform, and Kyobo Book Centre's database modernization strategy. Shopcast will present its development of an 'Agentic Lakehouse' integrating AI technology with a data lakehouse framework. The keynote address will be given by Kim Deok-joong, discussing organizational management strategies for integrating AI agents. The technical sessions will cover the architecture of the 'EDB Postgres AI' platform, which supports AI vector search and RAG, with live demonstrations of the analytics engine ClickHouse and LakeHouse technology for analyzing petabyte-scale data. EDB's domestic distributors and international partners will participate as sponsors. The summit aims to showcase technologies and case studies from the domestic ecosystem, addressing PostgreSQL adoption, system migration, operations, data analysis, and AI implementation. EDB manages transaction, analytics, and AI workloads using Postgres in cloud environments, serving over 1,500 global customers. Herve Timsit, EDB's Chief Revenue Officer, emphasized the event's focus on sharing tangible results and addressing the challenges of commercial databases while investing in AI infrastructure.

Tech Optimizer

August 29, 2026

Databricks Unveils Lakebase Postgres

Lakebase Postgres features a two-layer architecture that separates operations for durability and scalability. The compute layer uses standard Postgres for SQL parsing, query planning, and execution, designed to be ephemeral for dynamic scaling. The storage layer ensures correctness, durability, and historical accuracy, consisting of three components: Safekeepers replicate Write-Ahead Logging (WAL) records using a quorum-based protocol; Pageserver transforms WAL records into page versions; and Object Storage retains materialized versions and historical states in an immutable format. This architecture enhances data durability and system scalability.

AppWizard

August 26, 2026

GBA Emulator Android: My Boy! vs John GBAC vs RetroArch

Game Boy Advance emulation on Android has gained significant traction in 2026, with key applications like My Boy! priced at .99, John GBAC receiving an update on May 19, 2026, and RetroArch enhancing its mGBA core for free use. The search term "gba emulator android" sees around 8,100 monthly searches in the U.S., reflecting a resurgence in interest, particularly among former GBA owners now in their late 20s and 30s who prefer using their smartphones for gaming. All five apps—My Boy!, GBA.emu, John GBAC, RetroArch, and Lemuroid—can run the entire GBA library at full speed on devices from the last six years. The main differences lie in software quality, including save state management, cheat code reliability, controller mapping, and update frequency. My Boy! and GBA.emu utilize cores derived from VisualBoyAdvance (VBA), while John GBAC uses a custom core, and RetroArch and Lemuroid rely on the mGBA core. In terms of features, all apps support save states, but My Boy! offers multiple named slots with thumbnail previews, while RetroArch has a more complex system. Cheat code support is available across the board, with My Boy! and GBA.emu accepting GameShark and CodeBreaker formats, and RetroArch providing a built-in cheat database. My Boy! stands out for its link-cable emulation, allowing local multiplayer connections, whereas RetroArch's netplay is designed for online gaming. All apps support external controllers, but RetroArch excels in visual enhancements with its extensive shader options. The setup process for all five apps is similar and typically takes under ten minutes. GBA ROMs are small, ranging from 4MB to 32MB, making them easy to store on modern devices without significant battery drain. Common issues include save files not loading, audio problems, and cheat codes failing to apply, with solutions often involving file management and settings adjustments. Users can migrate save files between emulators by ensuring the correct file naming and directory structure. Pros and cons of each app include: - My Boy!: Ad-free, strong multiplayer support, but lower rating and closed-source. - GBA.emu: High rating and broad support, but outdated and lacks a free trial. - John GBAC: Free and recently updated, but lower rating and ad-supported. - RetroArch: Free and feature-rich, but complex setup. - Lemuroid: User-friendly and actively maintained, but limited shader options. All five apps are legally available on Google Play, as they do not distribute copyrighted ROM files. Users are advised to source their ROMs legally, ideally by dumping from their own physical cartridges. GBA emulation remains an accessible entry point into retro gaming on Android, especially compared to more demanding systems like the PS2 or GameCube.

Tech Optimizer

August 25, 2026

EDB Brings Postgres-Proven Disaster Recovery to Petabyte-Scale WarehousePG Where Downtime Is Not Possible

On August 20, 2026, EnterpriseDB (EDB) announced the general availability of its Disaster Recovery feature for WarehousePG, enhancing EDB Postgres AI's analytical capabilities by enabling recovery of petabyte-scale data in minutes rather than days. This feature allows organizations to maintain a current recovery environment across on-premises, cloud, or hybrid setups, and provides flexibility in activating recovery. The implementation of Disaster Recovery for WarehousePG resulted in approximately 180 times faster recovery, with restore-point replay averaging 16 minutes, full backups decreasing from 44 hours to about 11 hours, and nearly 99% less query lock time. The recovery model was achieved without any modifications to the application architecture. WarehousePG leverages the Postgres framework for disaster recovery processes and includes built-in high availability to safeguard against component failures. The upcoming September version update will integrate Disaster Recovery configuration into WarehousePG Enterprise Manager, allowing operational teams to manage cluster health and resource utilization effectively.

Tech Optimizer

August 25, 2026

Migrate Vaultwarden to PostgreSQL: Scale for Teams [2026]

Self-hosting Vaultwarden with SQLite can lead to performance issues as the user base grows, particularly due to SQLite's limitations with concurrent writes. Transitioning to PostgreSQL allows for better performance, multi-user support, and enhanced data durability. PostgreSQL supports concurrent connections and row-level locking, making it more suitable for team environments. To migrate from SQLite to PostgreSQL, certain prerequisites must be met, including having an existing Vaultwarden deployment, Docker Engine, a PostgreSQL server, and pgloader installed. The migration process involves backing up existing data, deploying a PostgreSQL container, updating configuration files, and using pgloader to transfer data. A VPS with 2 vCPU and 4GB RAM can support up to 50 users, with larger teams requiring more resources. PostgreSQL also allows for the creation of organizations for shared vault access and the configuration of group policies for security. Regular backups and performance tuning are necessary to maintain optimal operation. Common pitfalls during migration include not stopping the Vaultwarden container before migration, failing to encode special characters in the database password, and neglecting to back up data. Troubleshooting may involve checking connection strings and ensuring the PostgreSQL container is healthy. Advanced configurations can enhance performance and functionality, and understanding the differences between Vaultwarden and Bitwarden's official self-hosted server can aid in decision-making.

AppWizard

August 24, 2026

You Can Save 23% Off Metal Gear Solid Master Collection Vol. 2 for PC – But the Offer Ends Soon

The Metal Gear Solid Master Collection Vol. 2 is set to release on August 27, and Fanatical is offering Steam codes for preorder at .49, which is a 23% discount off the standard retail price of .99. The collection includes Metal Gear Solid 4: Guns of the Patriots, Metal Gear Solid: Peace Walker (HD Collection version), and Metal Gear: Ghost Babel. Preorder bonuses include Cardboard Camouflage for Metal Gear Solid 4 and the LOVE BOX Uniform for Metal Gear Solid: Peace Walker. The collection also features additional content such as digital soundtracks and screenplay books.

BetaBeacon

August 24, 2026

PPSSPP vs Dolphin vs RetroArch Android: 127 Cores

PPSSPP is a dedicated PSP emulator that does not require a BIOS file to boot a game. Dolphin emulates GameCube and Wii consoles and requires newer Android versions for better performance. RetroArch is a frontend that loads separate cores for different systems, offering a wide range of emulation options.

Winsage

August 24, 2026

Weekly Recap: Microsoft (MSFT) cloud growth and China Windows 10 phase-out

ICE Data Services is expanding its market data offerings to enhance accessibility and quality for investors and analysts. FactSet is providing enhanced reference data services to improve decision-making for clients. Both companies are leveraging advanced technology to streamline data delivery. The American Bankers Association is partnering with FactSet to provide the CUSIP Database for tracking and trading securities. Quartr supplies SEC filings and essential documents to support transparency and compliance in financial markets.

Tech Optimizer

August 19, 2026

Electric Joins Databricks to Bring WASM Postgres to AI Agent Sandboxes, Expanding Databricks Postgres from the Lakehouse to the Edge

Databricks has integrated the Electric team to enhance its capabilities by incorporating WASM Postgres into AI agent sandboxes. Electric has developed PGlite, which provides each agent with a lightweight Postgres instance for low-latency access to local context, facilitating real-time data processing. Their real-time sync engine maintains synchronization of agents' distributed states with a central Lakebase, allowing effective collaboration among agents. Both Electric and Lakebase utilize Postgres, with Lakebase offering it at a production scale and PGlite introducing WASM Postgres into the agent's environment. This integration allows for collaborative applications, execution of Postgres within the agent sandbox, and ensures synchronization among agents while centralizing control in Lakebase Postgres.

Tech Optimizer

August 19, 2026

Postgres pioneer credits Oracle with helping his database take over the world

Michael Stonebraker, the creator of PostgreSQL, noted that Oracle's acquisition of MySQL inadvertently boosted PostgreSQL's prominence among major tech companies like Microsoft, AWS, and Google. PostgreSQL, which originated from Stonebraker's earlier Postgres system proposed in 1986, celebrated its 30th anniversary this summer. Its popularity surged over the past five years, becoming the preferred database among developers in 2023, as per a Stack Overflow survey. Microsoft has launched a distributed PostgreSQL database service to compete with other offerings. Stonebraker highlighted the extensive adoption of PostgreSQL's wire format by major companies, contrasting it with MySQL's declining competitiveness since Oracle's acquisition in 2010. He expressed gratitude towards Oracle for prompting users to consider PostgreSQL as an alternative, emphasizing its open-source nature and community-driven control. Stonebraker has founded several database companies and co-founded DBOS three years ago, which has pivoted towards AI agents and partnerships with Databricks and CockroachDB.