NewApp Digest
search bot

database management

dbForge 2026.2 Adds a PostgreSQL Debugger, Visual Object Editors and Broader Context for dbForge AI Assistant
Tech Optimizer
October 11, 2026

dbForge 2026.2 Adds a PostgreSQL Debugger, Visual Object Editors and Broader Context for dbForge AI Assistant

Devart has released dbForge 2026.2, a unified database management ecosystem for PostgreSQL developers, featuring an embedded PostgreSQL Debugger that allows for efficient error tracking in server-side code. The Debugger enables breakpoints, step-through code execution, and real-time monitoring of variables and query results. Visual editors for PostgreSQL event triggers, functions, and procedures have been introduced, allowing for easier management without manual SQL writing. The dbForge AI Assistant now offers expanded context awareness, enabling users to attach various documents and select from multiple AI models for generating relevant SQL code. A free Express edition of the AI Assistant is available, with limited features compared to paid plans. Additionally, new SQL refactoring commands and schema comparison improvements have been implemented, along with updates for compatibility with MySQL 26.7 and MariaDB 13.x.
AWS embeds DuckDB in its PostgreSQL DBMS to speed queries of live and historical data
Tech Optimizer
October 10, 2026

AWS embeds DuckDB in its PostgreSQL DBMS to speed queries of live and historical data

Amazon Web Services Inc. has enhanced its Aurora PostgreSQL database management system to allow users to query the Apache Iceberg data lake directly. This feature integrates the DuckDB analytical engine, enabling seamless access to live transactions and historical records without data duplication or complex ETL processes. Customers can use existing PostgreSQL applications to query data in Amazon S3, including S3 Tables. The integration aims to reduce the engineering workload associated with data pipelines and supports real-time applications. DuckDB processes analytical scans within Aurora, eliminating extra network hops and allowing single queries to access both live and archived data. The feature supports external catalogs compliant with the Iceberg REST Catalog specification and can create foreign tables referencing data across multiple catalogs. Aurora optimizes query performance by filtering records and caching frequently accessed data. Customers can combine recent transactions in Aurora with historical data from S3 without manual schema definitions. For low-latency workloads, selected data can be copied into native Aurora tables using standard SQL. This capability requires the aurora_analytics extension and an AWS IAM role for S3 and Glue access, and is compatible with Aurora PostgreSQL versions 17.11 and 18.6. The feature is available across all AWS regions at no additional charge, with costs incurred only for Aurora computing resources and S3 requests.
Russian software taught to work more easily with large data arrays
Tech Optimizer
October 10, 2026

Russian software taught to work more easily with large data arrays

Russian Postgres Professional has released an update to Postgres Pro AXE, version 2.0, which allows users to handle analytical data using standard SQL queries instead of specialized stored procedures. This update improves accessibility to analytical data, which is stored in Parquet format and managed through a dedicated metadata catalog. The system is designed for analytical workloads, supporting Online Analytical Processing (OLAP) and hybrid workloads. The first public version of Postgres Pro AXE was launched in January 2026, featuring vectorized analytical queries and compatibility with columnar storage. In the Russian market, alternatives to Postgres Pro AXE include Arenadata DB, optimized for corporate data warehouses, and Arenadata QuickMarts, a clustered columnar DBMS based on ClickHouse for rapid analytics.
DBtune autonomous optimization blows PostgreSQL bottlenecks away
Tech Optimizer
October 10, 2026

DBtune autonomous optimization blows PostgreSQL bottlenecks away

DBtune, a startup based in Malmö/Lund, Sweden, was founded in 2020 by Dr. Luigi Nardi as a spin-off from Stanford University and Lund University. The company focuses on enhancing PostgreSQL's capabilities through autonomous database optimization technology and has raised .4 million in a seed round from various investors in July 2023, with support from the Wallenberg Foundation and Vinnova. DBtune's technology utilizes agentic AI for optimizing PostgreSQL databases by tuning server parameters, optimizing indexes, and monitoring autovacuum processes. The release of DBtune version 4.0 incorporates machine learning and AI to dynamically adjust server parameters and suggest optimal indexing strategies. The platform identifies and ranks potential index opportunities based on workload and provides recommendations for new indexes and maintenance of existing ones. A case study with Midwest Tape demonstrated a 10.8x performance improvement in database query runtime after employing DBtune for performance tuning. Benchmarking tests showed a transaction throughput increase of 87% during initial optimization, with a further 17% improvement on an already optimized system. Disk I/O activity was reduced by 43%, and WAL generation decreased by 23%. Dr. Nardi emphasizes the need for AI-driven optimization to manage the complexities of PostgreSQL databases and rising cloud costs, suggesting that significant code adaptations will be necessary for achieving fully autonomous PostgreSQL.
Devart rolls out dbForge 2026.2
Tech Optimizer
October 6, 2026

Devart rolls out dbForge 2026.2

Devart has released dbForge 2026.2, a database management suite update featuring a PostgreSQL Debugger for error tracking, visual editors for managing PostgreSQL objects, and an enhanced dbForge AI Assistant with broader context awareness. The AI Assistant now supports models from Anthropic and OpenAI and includes a free Express edition with limited features. The update also improves SQL development and schema comparison functionalities, with new refactoring commands and support for MySQL 26.7 and MariaDB 13.x. dbForge 2026.2 is available for download, with current users able to update through the Help menu.
Tom Lane on the Architectural Decisions That Shaped 30 Years of Postgres
Tech Optimizer
September 11, 2026

Tom Lane on the Architectural Decisions That Shaped 30 Years of Postgres

Tom transitioned from image processing to database management, particularly contributing to the Postgres project. He was part of a group that created an open-source implementation of JPEG, leading to the development of libjpeg, where he served as the principal maintainer for about five years. NASA's Perseverance rover uses libjpeg, a fact discovered by Joe Conway through research. Tom noted that the widespread adoption of JPEG was due to its efficient compression and the availability of a free implementation, which aided its integration into early web browsers. His interest in Postgres was influenced by its liberal licensing model, similar to that of libjpeg. Tom's commitment to open-source projects stems from his passion for collaborative software development, which began during his graduate studies in the 1980s. His PhD focused on software architecture, shaping his approach to both image processing and 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.
Search