NewApp Digest
search bot

database management

Postgres pioneer credits Oracle with helping his database take over the world
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.
Own Microsoft Office Professional 2021 for Windows for Just $33
Winsage
August 3, 2026

Own Microsoft Office Professional 2021 for Windows for Just $33

Microsoft Office Professional 2021 for Windows is available for .97 until August 9, down from its regular price of 9.99. The suite includes Word, Excel, PowerPoint, Outlook, OneNote, Access, Publisher, and a free version of Microsoft Teams. It offers lifetime access on a single Windows PC and features significant performance enhancements and updated collaboration tools. The software is installed locally, allowing use without an internet connection for many tasks. It does not include continuous feature updates like Microsoft 365, providing a stable, perpetual version of the software.
'PGSimCity' shows how the PostgreSQL database actually works internally in a SimCity-like 3D environment.
Tech Optimizer
July 28, 2026

‘PGSimCity’ shows how the PostgreSQL database actually works internally in a SimCity-like 3D environment.

PGSimCity is a web application that provides a 3D visualization of PostgreSQL's architecture, allowing users to explore its internal operations during SQL query execution. The application features an interactive interface that guides users through the connection process to PostgreSQL, illustrating how client connections reach the Postmaster and backend processes. It highlights the significance of connection pooling and the impact of increasing connections on backend processes. In the 'Query Lab' section, SQL statements are transformed into execution plans, showcasing processes like Parser, Rewriter, Planner, and Executor, along with execution paths such as Seq Scan and Index Scan. The shared_buffers area represents PostgreSQL's buffer cache, optimizing performance by reading data in 8KiB pages. Visualizations depict data pages stored on disk, with pathways showing the movement of pages to shared_buffers. The Write-Ahead Log (WAL) mechanism records changes for recovery, and transaction commits wait for WAL records to be flushed. Checkpointing writes dirty pages to storage in batches, which can cause latency spikes. PostgreSQL uses Multi-Version Concurrency Control (MVCC) to manage updated rows and dead tuples, which are cleaned up by autovacuum processes. The application also illustrates replication, where WAL from the primary server is sent to the standby server to maintain data consistency. Overall, PGSimCity provides a comprehensive view of PostgreSQL's components and potential performance issues related to caching, WAL management, checkpointing, vacuuming, and replication.
What Is Serverless PostgreSQL?
Tech Optimizer
July 12, 2026

What Is Serverless PostgreSQL?

Serverless PostgreSQL is a fully managed cloud database model that separates compute and storage, allowing them to scale independently and automatically based on demand. It eliminates the need for manual infrastructure provisioning and capacity planning, charging only for active usage. Unlike traditional PostgreSQL setups, which require continuous resource allocation and manual scaling, serverless PostgreSQL provisions resources on demand and can scale down to zero during idle periods. Serverless PostgreSQL integrates with serverless compute platforms, enabling analytical queries to access the same data within a unified architecture. Key differences between traditional and serverless PostgreSQL include manual versus automatic provisioning and scaling, fixed versus usage-based billing, and high versus reduced operational overhead. Lakebase architecture is an emerging model that combines transactional databases with lakehouse foundations, allowing operational and analytical workloads to coexist on a single platform. This architecture minimizes data duplication and simplifies access, enhancing data management and analysis. Serverless PostgreSQL operates on a cloud-native architecture that enhances efficiency by allowing compute and storage to scale autonomously. It features scale-to-zero behavior, where compute resources are suspended when inactive and reactivated upon new queries. Major providers include Databricks Lakebase, Amazon Aurora Serverless v2, and Neon, each offering varying capabilities and integrations. Pricing for serverless PostgreSQL typically includes charges for compute resources, storage, and data transfer, with costs fluctuating based on workload activity. Cold start latency is a performance consideration, as reactivating compute resources can introduce delays. Strategies to mitigate this include keeping resources partially active or selecting providers with minimal cold start impacts. Serverless PostgreSQL is well-suited for OLTP workloads, while lakebase architecture is better for AI development, variable workloads, and environments requiring rapid iteration. Setting up serverless PostgreSQL involves choosing a provider, creating a database instance, and configuring access settings. It can also be used alongside serverless compute platforms for analytics, further extending its capabilities.
DBA2: Configuration and Monitoring of PostgreSQL 16 is now available in English
Tech Optimizer
July 9, 2026

DBA2: Configuration and Monitoring of PostgreSQL 16 is now available in English

Postgres Professional has translated the DBA2: Configuration and Monitoring of PostgreSQL 16 course into English. This four-day program is designed for PostgreSQL administrators with basic Unix skills and knowledge equivalent to the DBA1 course. The curriculum covers topics such as Multi-Version Concurrency Control (MVCC), isolation levels, vacuuming, buffer cache management, write-ahead logging (WAL), and server upgrades. Participants will learn to configure PostgreSQL parameters, monitor the server, manage localization settings, and handle extensions. The course materials include a student guide for setting up a virtual machine and performing practical tasks. The translation was done by Elena Sharafutdinova, with assistance from Ilya Bashtanov and Alexander Meleshko.
Why most AI projects fail: It’s infrastructure and people
Tech Optimizer
July 6, 2026

Why most AI projects fail: It’s infrastructure and people

AI technology faces significant criticism for its low success rates in delivering business results, with studies indicating a 95% failure rate for enterprise AI solutions and only 9% of organizations in Europe, the Middle East, and Africa achieving measurable outcomes from AI initiatives. Four main shortcomings hinder the transition of AI prototypes to production: 1. Deployment Flexibility: Prototyping environments often lack the necessary flexibility for large-scale production deployment, particularly in regulated sectors. 2. Data Sovereignty: Production transitions can complicate data sovereignty at enterprise and regional levels. 3. Reliability: High availability is crucial for production environments, but vendor-managed platforms may not guarantee seamless upgrades or hardware swaps without downtime. 4. Disconnect in Tool Selection: Developers often choose tools for prototyping without considering production implications, leading to difficulties in scaling. The shortage of database administrators (DBAs) is exacerbated by the increasing use of AI tools, with 84% of developers utilizing them according to a 2025 survey. To address these challenges, Merrick suggests leveraging AI DBA agents to support human DBAs and improve database management efficiency. He emphasizes the need for both robust data infrastructure and enhanced operational support to improve the success rates of AI prototypes.
Get Office 2021 + Windows 11 Pro lifetime access for just $39.19 today only
Winsage
July 5, 2026

Get Office 2021 + Windows 11 Pro lifetime access for just $39.19 today only

Consumers can purchase lifetime licenses for Microsoft Office Professional 2021 and Windows 11 Pro for .19, reduced from 9.99, using the promotional code JULY30 until July 5 at 11:59 p.m. PT. The bundle allows installation on a single compatible Windows PC without ongoing subscription fees. Microsoft Office Professional 2021 includes applications such as Word, Excel, PowerPoint, Outlook, OneNote, Access, Publisher, and Teams. Windows 11 Pro features include BitLocker, Hyper-V, Windows Sandbox, Azure AD support, and Copilot.
Latest EnterpriseDB features unify data for AI development
Tech Optimizer
June 24, 2026

Latest EnterpriseDB features unify data for AI development

EnterpriseDB is addressing challenges in AI development projects, particularly data sprawl, by introducing features in the EDB Postgres AI platform. The platform now includes Converged Analytics, which bridges operational and analytical data without complex ELT pipelines, and the Agentic Database, which transforms the system into an autonomous database that proactively manages over 200 metrics. These innovations aim to consolidate various data types into a single governed platform, reducing complexity and costs associated with database administration. The update also introduces governance capabilities at the data layer, expected to be available in the latter half of 2026, and a bring-your-own-cloud option for applying AI to data. Customer feedback has influenced these developments, highlighting the need for reduced manual intervention in data management.
Search