NewApp Digest
search bot

database management

Why is France moving from Microsoft Windows to Linux
Winsage
April 15, 2026

Why is France moving from Microsoft Windows to Linux

The government aims to reduce reliance on non-European digital solutions by transitioning from Windows to Linux-based systems for state operations. The national health insurance body is migrating 80,000 employees to state-approved digital tools, including secure messaging and file transfer platforms, with plans to transition the health data platform to a sovereign solution by the end of 2026. Ministries will submit roadmaps by autumn to outline strategies for reducing dependence on non-European technologies in areas such as workplace software, collaboration tools, cybersecurity, artificial intelligence, database management, and network equipment. A centralized strategy will oversee these initiatives, with industry meetings planned for June to formalize public-private partnerships. Additionally, Japan and France have agreed to enhance cooperation on critical mineral supply chains.
Modernizing Nexus Repository: Moving Beyond OrientDB
Tech Optimizer
April 12, 2026

Modernizing Nexus Repository: Moving Beyond OrientDB

Support for OrientDB in Sonatype Nexus Repository has been discontinued, and older versions of Nexus Repository (prior to 3.70.5) are built on an outdated architecture that presents high-severity vulnerabilities and cannot be fully patched. The recommended database for Nexus Repository is now PostgreSQL, which offers better performance and support for modern architectures. Users have two migration options: transition to Sonatype Nexus Repository Cloud, which is fully managed and eliminates database management, or migrate to PostgreSQL while maintaining a self-hosted environment, which requires ongoing maintenance and infrastructure ownership.
Database Branching in Postgres: Git-Style Workflows with Databricks Lakebase
Tech Optimizer
April 11, 2026

Database Branching in Postgres: Git-Style Workflows with Databricks Lakebase

Database branching is a modern approach that addresses the limitations of traditional database management in development workflows. Unlike conventional database copies, which require significant time and resources to duplicate data and schema, database branching allows for the creation of isolated environments that share the same underlying storage. This method utilizes a copy-on-write mechanism, enabling branches to be created in seconds regardless of database size, with storage costs tied only to the changes made. Key features of database branching include: - Branch creation time: Seconds, constant regardless of database size. - Storage cost: Proportional to changes only, not the total data size. - Isolation: Each branch has its own Postgres connection string and compute endpoint. - Automatic scaling: Idle branches can scale compute to zero, incurring costs only when active. The architecture supporting this approach separates compute from storage, allowing multiple branches to reference the same data without conflict. This design facilitates time travel capabilities, enabling branches to be created from any point in the past for instant recovery and inspection. Database branching unlocks new workflows, such as: - One branch per developer, providing isolated environments for each engineer. - One branch per pull request, automating branch creation and deletion tied to PRs. - One branch per test run, provisioning fresh databases for each CI pipeline execution. - Instant recovery from any point in time within a designated restore window. - Ephemeral environments for AI agents, allowing programmatic database provisioning. Databricks Lakebase offers this database branching capability, transforming the database from a bottleneck into a streamlined component of the development process.
True enterprise sovereignty is more approachable than ever, thanks to K8s-powered cloud-neutral PostgreSQL
Tech Optimizer
April 8, 2026

True enterprise sovereignty is more approachable than ever, thanks to K8s-powered cloud-neutral PostgreSQL

Discussions on digital sovereignty are shifting from infrastructure to databases, driven by geopolitical pressures in Europe. Hyperscalers like Amazon and Microsoft are investing heavily to comply with new regulations, prompting organizations to reconsider their reliance on managed cloud services. Many enterprises are now viewing PostgreSQL as a portable, cloud-neutral foundation to ensure consistent behavior across various environments, leading to interest in Sovereign DBaaS. Gabriele Bartolini, VP and Chief Architect of Kubernetes at EDB, emphasizes that true sovereignty starts with the database and that portability enhances negotiating leverage and compliance. Bartolini warns that while managed cloud services offer convenience, they often sacrifice control. He notes that transitioning away from these services can provide long-term leverage, as evidenced by Microsoft's encouragement for customers to run self-managed PostgreSQL. The Operator Pattern in Kubernetes enables better database management and lifecycle control, with CloudNativePG exemplifying this approach. Bartolini asserts that owning hardware allows organizations to better manage costs, especially for resource-intensive AI workloads, and that moving to bare metal can significantly enhance performance. A cultural shift is necessary for success, with DBAs needing to adapt to cloud-native environments. Bartolini encourages DBAs to develop a broader understanding of Kubernetes to enhance collaboration across teams. He warns that the database team cannot drive change alone and must align with the entire infrastructure direction to avoid dependency on proprietary tools that limit independence and innovation.
EDB Postgres® AI Delivers Superior Predictability vs. Cloud Data Warehouses in High-Concurrency Benchmark, Unveils Q1 Platform Updates to Power the Agentic AI Era
Tech Optimizer
April 1, 2026

EDB Postgres® AI Delivers Superior Predictability vs. Cloud Data Warehouses in High-Concurrency Benchmark, Unveils Q1 Platform Updates to Power the Agentic AI Era

Independent benchmarking by McKnight Consulting Group shows that EDB Postgres AI for WarehousePG provides significant cost efficiency and performance consistency, with organizations potentially saving up to 58% in total cost of ownership compared to leading cloud data warehouse solutions. The evaluation compared EDB PG AI against competitors like Snowflake, Databricks, Amazon Redshift, and Hive on Apache Iceberg using a 10TB extended TPC-DS dataset, focusing on high-concurrency mixed workloads. Key findings include: - EDB PG AI demonstrated unmatched cost efficiency, with an annual cost of ,886 compared to Snowflake’s ,953 for a multi-cluster setup. - It exhibited superior concurrency handling, with the lowest performance slowdown of 2.7x when scaling from one to five concurrent users, outperforming Snowflake (3.9x), Redshift (4.0x), and Databricks (4.1x). - EDB PG AI's core-based, capacity-pricing model eliminates unpredictable pricing fluctuations associated with consumption-based models. EDB announced Q1 2026 platform updates, including: - GPU-Accelerated Analytics for 50–100x faster analytics on large datasets. - Enhanced Agent Studio for quicker AI agent development and deployment. - Upgraded Vector Engine for improved indexing speed and efficiency. - WarehousePG Enterprise Manager for simplified management of MPP workloads. - Agentic Database Management with a native chatbot for natural language database management. - Certification as a mission-critical data layer for the Red Hat Ansible Automation Platform.
Equip either Mac or Windows with permanent MS Office software for an extra 15% off
Winsage
March 23, 2026

Equip either Mac or Windows with permanent MS Office software for an extra 15% off

Users can purchase Microsoft Office Home & Business 2019 for Mac for .48 and Microsoft Office Professional Plus 2019 for Windows for .98 using the promo code MARCH15 before March 29. These are one-time purchases that provide a lifetime license without subscription fees. The Mac version includes Word, Excel, PowerPoint, Outlook, OneNote, and Teams Classic, while the Windows version includes Word, Excel, PowerPoint, Outlook, OneNote, Publisher, and Access.
Microsoft promises all-in-one database wrangling hub on Fabric
Tech Optimizer
March 18, 2026

Microsoft promises all-in-one database wrangling hub on Fabric

Microsoft has launched a new database management tool called Database Hub, which is part of its Fabric data platform. This tool allows for the management of multiple databases using a single SQL engine and serves as a centralized location for overseeing various database services, including Azure SQL Server, Azure Cosmos DB, Azure Database for PostgreSQL, SQL Server with Azure Arc, and Azure Database for MySQL. Currently in early access, Database Hub aims to provide a unified management experience across on-premises, PaaS, and SaaS environments. The tool will incorporate AI capabilities to enhance database management, featuring "agent-assisted" and "human-in-the-loop" approaches for analyzing estate-wide signals. Microsoft’s LLM tool, Copilot, will offer insights into the database estate's status, including aggregate health views and trend analysis. However, specific details on the Database Hub's database tuning and optimization capabilities were not provided. Additionally, a study from Carnegie Mellon University indicated that vector embedding algorithms could improve the performance of PostgreSQL services significantly. Microsoft has also launched various database systems, including a document database platform based on PostgreSQL and a distributed PostgreSQL database service. Other vendors like Databricks and Snowflake have introduced their own transactional database services within their platforms.
Databricks Introduces Lakebase, a PostgreSQL Database for AI Workloads
Tech Optimizer
February 23, 2026

Databricks Introduces Lakebase, a PostgreSQL Database for AI Workloads

Databricks has launched Lakebase, a serverless database solution based on PostgreSQL that allows independent scaling of compute and storage resources. It integrates with the Databricks platform, combining transactional and analytical functionalities. Lakebase aims to simplify real-time application and AI workload development by consolidating database management, analytics, and governance. Key features include instant data branching, point-in-time recovery, and unified access controls. It is designed to address the limitations of traditional operational databases, which struggle with modern AI demands. Lakebase offers a managed PostgreSQL service, supporting up to 8TB per instance and featuring pgvector for AI-driven search. It has been in development since June 2025, utilizing technology from the PostgreSQL company Neon and enhanced by the acquisition of Mooncake. Lakebase is available in Autoscaling and Provisioned versions, with the Autoscaling version billed based on usage. It is currently available on AWS, in public preview on Azure, and expected on Google Cloud later this year. SOC2 and HIPAA certifications are projected for early 2026.
PostgreSQL vs MySQL: Which Database is Better in 2026?
Tech Optimizer
February 14, 2026

PostgreSQL vs MySQL: Which Database is Better in 2026?

PostgreSQL 17 introduces significant enhancements, including refined memory management in VACUUM processes, improved SQL/JSON capabilities with features like JSON_TABLE(), advancements in logical replication and parallel processing, and overall increased efficiency for handling complex queries and large datasets. MySQL, under Oracle's stewardship, focuses on performance, reliability, and cloud integration, with updates unveiled at the HeatWave Summit in 2025 that support both transactional and analytical workloads in a unified system, enabling real-time analytics without data transfer to separate tools.
Search