extensions

Tech Optimizer
May 19, 2025
Performance issues in PostgreSQL can arise as databases grow, leading to declines in query performance. To identify problematic queries, one can log long-running queries by setting the `log_min_duration_statement` parameter in the `postgresql.conf` file. The `pg_stat_statements` module can be enabled to monitor execution statistics of SQL statements, providing insights into query performance, including execution time and the number of calls. Queries with high standard deviation in execution time may indicate inconsistency, while sorting query statistics by total execution time can reveal excessive load from multiple fast queries. Real-time monitoring can be done using the `pg_stat_activity` view to check active queries and their states, and the `pg_locks` view can help identify blocked processes. The `EXPLAIN` command can analyze query execution plans, and using the `auto_explain` module can log plans for slow queries. Understanding cost parameters in query plans helps in optimizing performance, and different join methods (Nested Loop, Merge Join, Hash Join) have varying complexities and costs. To influence the planner's choice of scanning methods, configuration parameters can be adjusted, such as disabling sequential scanning. Extensions like `sr_plan`, `pg_hint_plan`, and `AQO` can further optimize query execution. Monitoring query progress can be done using dynamic views like `pg_stat_progress_*` for various commands.
Tech Optimizer
May 17, 2025
PostgreSQL Version 17 has launched on IBM Cloud, featuring optimized memory management, faster query execution, and accelerated bulk operations. These enhancements improve performance, scalability, security, and developer productivity. IBM Cloud's ecosystem of extensions and plugins supports PostgreSQL 17, enabling efficient management of complex applications.
Winsage
May 17, 2025
In this week's roundup of applications for Windows 10 and 11, it is noted that consumer support for Windows 10 will end in October 2025, but users can purchase a year of extended support and receive three years of security updates for Microsoft 365 apps. New applications highlighted include: - DiskCopy: Free disk and partition cloning software for backing up partitions or entire disks, facilitating data migration. - IrfanView: An image viewer that now includes batch file multithreading and new hotkeys in its latest version. - Registry Finder: A freeware tool for managing the Windows Registry, with improved search capabilities and usability.
Tech Optimizer
May 16, 2025
Databricks plans to acquire Neon, a company specializing in serverless Postgres technology, to enhance its AI-driven database offerings and developer workflows. The acquisition reflects Databricks' commitment to the evolving database market, which is increasingly influenced by artificial intelligence. Neon’s technology is designed for AI agents, with over 80% of databases on its platform provisioned automatically by AI. Key features of Neon's platform include rapid provisioning of Postgres instances, cost efficiency through separated compute and storage, and full compatibility with the open-source Postgres ecosystem. The integration aims to address limitations of traditional databases, streamline infrastructure, and support the development of AI agent systems. Upon completion of the acquisition, Neon's team will join Databricks, and both companies aim to simplify data architecture and enhance AI agent capabilities. The acquisition is subject to regulatory approvals. Neon was founded in 2021 and focuses on serverless Postgres solutions, while Databricks serves over 10,000 organizations globally with its Data Intelligence Platform.
Tech Optimizer
May 14, 2025
Databricks plans to acquire Neon, a serverless Postgres provider designed for automation and AI-driven database interactions. Neon's architecture allows for 80% of databases on its platform to be provisioned automatically by AI agents, enabling rapid execution and unpredictable scaling. It can provision fully isolated Postgres instances in under 500 milliseconds and features instant schema and data forking. Neon's usage-based pricing model charges organizations only for executed queries, addressing cost inefficiencies of traditional databases. It is fully compatible with Postgres and supports common extensions, facilitating ease of use for developers. After the acquisition, Neon's team will join Databricks to support existing users and develop tools for AI-native systems.
Tech Optimizer
May 14, 2025
Databricks intends to acquire Neon, a leader in serverless Postgres technology, to enhance its database and developer experience. The database market is valued at over [openai_gpt model="gpt-4o-mini" prompt="Summarize the content and extract only the fact described in the text bellow. The summary shall NOT include a title, introduction and conclusion. Text: Databricks, a prominent player in the Data and AI landscape, has announced its intention to acquire Neon, a leading innovator in serverless Postgres technology. This strategic move comes as the database market, valued at over 0 billion, stands on the brink of significant transformation driven by advancements in AI. Databricks aims to enhance Neon's database and developer experience, catering to both existing and prospective customers and partners. Neon: An Open, Serverless Foundation for Developers and AI Agents In the evolving landscape of software development, AI agents are becoming indispensable. Neon is specifically designed to facilitate the workflows of these agents. Recent telemetry data indicates that more than 80 percent of databases provisioned on Neon are generated automatically by AI agents, highlighting the rapid growth of agent-driven workloads. These workloads present distinct characteristics that set them apart from traditional human-driven processes: Speed + flexibility: AI agents operate at machine speed, eliminating the bottlenecks often associated with traditional database provisioning. Neon's capability to launch a fully isolated Postgres instance in under 500 milliseconds, along with its support for instant branching and forking of database schemas and data, ensures that experiments can be conducted without disrupting production environments. Cost proportionality: The demand for a cost structure that scales with usage is paramount for agents. Neon's architecture separates compute and storage, allowing for a total cost of ownership that aligns with the actual queries executed across thousands of ephemeral databases. Open source ecosystem: AI agents thrive in an environment that leverages the extensive Postgres community. Neon is fully compatible with Postgres and integrates seamlessly with popular extensions. Ali Ghodsi, Co-Founder and CEO of Databricks, remarked on the significance of this acquisition: "The era of AI-native, agent-driven applications is reshaping what a database must do. Neon exemplifies this shift, with four out of five databases on their platform being created by code rather than human intervention. By integrating Neon into Databricks, we are providing developers with a serverless Postgres solution that meets the demands of agentic speed, flexible economics, and the openness of the Postgres community." Databricks and Neon's Shared Vision The collaboration between Databricks and Neon aims to dismantle the conventional constraints of databases that require simultaneous scaling of compute and storage, a limitation that can impede AI workloads. The fusion of Neon's serverless Postgres architecture with the Databricks Data Intelligence Platform is set to empower developers and enterprise teams to efficiently construct and deploy AI agent systems. This integration not only mitigates performance bottlenecks associated with numerous concurrent agents but also streamlines infrastructure, reduces costs, and fosters innovation—all while maintaining Databricks' core principles of security, governance, and scalability. Nikita Shamgunov, CEO of Neon, expressed optimism about the future: "Four years ago, we set out to build the best serverless Postgres for the cloud, highly scalable and open to all. With this acquisition, we aim to accelerate that mission, bolstered by the support and resources of an AI powerhouse. Databricks was founded by open-source pioneers dedicated to simplifying the interaction between developers and data at any scale. Together, we are embarking on a new chapter in our ambitious journey." Following the completion of the transaction, Neon's skilled team is expected to join Databricks, bringing valuable expertise and continuity to Neon's thriving community. This partnership will enable organizations to break down data silos, streamline architecture, and develop AI agents that are more responsive, reliable, and secure. Further insights will be shared at the upcoming Data + AI Summit, scheduled to take place in San Francisco from June 9 to 12. Details Regarding the Proposed AcquisitionThe acquisition is subject to customary closing conditions, including necessary regulatory approvals. About NeonFounded in 2021 by a team of seasoned database engineers and Postgres contributors, Neon aims to provide a serverless Postgres platform that accelerates the development of reliable and scalable applications, catering to projects ranging from personal endeavors to enterprise-level solutions. About DatabricksDatabricks is a leader in Data and AI, trusted by over 10,000 organizations globally—including notable names like Block, Comcast, Condé Nast, Rivian, and Shell, as well as over 60% of the Fortune 500. The Databricks Data Intelligence Platform empowers organizations to harness their data effectively and leverage AI capabilities. Headquartered in San Francisco, Databricks was founded by the original creators of Lakehouse, Apache Spark™, Delta Lake, and MLflow. For more information, follow Databricks on X, LinkedIn, and Facebook." max_tokens="3500" temperature="0.3" top_p="1.0" best_of="1" presence_penalty="0.1" frequency_penalty="frequency_penalty"] billion and is undergoing transformation due to AI advancements. More than 80% of databases on Neon are provisioned automatically by AI agents, which operate at machine speed and require a cost structure that scales with usage. Neon's architecture separates compute and storage, aligning costs with actual queries. The integration of Neon's serverless Postgres with Databricks aims to improve AI workloads by dismantling traditional database constraints. Following the acquisition, Neon’s team will join Databricks, enhancing their community and capabilities. The acquisition is subject to customary closing conditions and regulatory approvals. Neon was founded in 2021 to provide a scalable serverless Postgres platform. Databricks serves over 10,000 organizations globally, including many Fortune 500 companies.
AppWizard
May 14, 2025
Since April 2024, the threat actor Marbled Dust has been exploiting a zero-day vulnerability (CVE-2025-27920) in the Output Messenger chat application, targeting user accounts that have not applied necessary fixes. This exploitation has resulted in the collection of sensitive data from users in Iraq, specifically linked to the Kurdish military. Microsoft has high confidence in this assessment and notes that Marbled Dust conducts reconnaissance to identify potential targets using Output Messenger. Marbled Dust has successfully utilized this vulnerability to deploy malicious files and exfiltrate data. Microsoft notified the application’s developer, Srimax, about the vulnerability, leading to the release of a software update. A second vulnerability (CVE-2025-27921) was also found, but no exploitation of this second flaw has been observed. The zero-day vulnerability allows an authenticated user to upload malicious files to the server's startup directory. Marbled Dust has exploited this flaw to place a backdoor file, OMServerService.vbs, in the startup folder, enabling them to access communications and sensitive data indiscriminately. The attack chain begins with Marbled Dust gaining access to the Output Messenger Server Manager, likely through DNS hijacking or other credential interception techniques. Once inside, they exploit the vulnerability to drop malicious files, including a GoLang backdoor, which connects to a Marbled Dust command-and-control domain for data exfiltration. To mitigate this threat, Microsoft recommends updating to the latest version of Output Messenger, activating various security protections, and implementing rigorous vulnerability management strategies. Microsoft Defender XDR customers can identify potential threat activity through specific alerts related to Marbled Dust and utilize advanced hunting queries for detection. Indicators of compromise include traffic to the domain api.wordinfos[.]com, associated with Marbled Dust activities.
Tech Optimizer
May 12, 2025
pgpro_pwr is a database workload monitoring tool for database administrators (DBAs) to identify resource-demanding operations. It was launched in 2017 as pg_profile by Andrey Zubkov, who moved from being a DBA to an engineer at Postgres Professional. pg_profile is compatible with open-source PostgreSQL and has been integrated into PostgreSQL 17 as of 2024, while pgpro_pwr offers advanced statistical insights and is included in Postgres Pro releases. Both tools monitor database workload metrics through continuously incrementing counters, capturing values at intervals and archiving differences. They do not provide alerting capabilities but are useful for assessing system stability, analyzing load testing outcomes, and identifying system-intensive activities. The tools consist of repository tables, data collection functions, reporting functions, and service tables. To use them, one must install the extension, configure roles, and set up parameters. Reports can be generated for workload statistics over time and comparisons between different time intervals. Examples of report types include wait event statistics and advanced vacuum statistics. Future plans include submitting a patch to introduce vacuum statistics to vanilla PostgreSQL.
AppWizard
May 9, 2025
Google has announced a new security feature for Chrome on Android that uses machine learning through its Gemini intelligence to alert users about potential scams, spam, and unwanted notifications from malicious websites. This update allows Chrome to analyze website notifications more effectively, enhancing user protection. In September, Google also updated Chrome's Safety Check for Android, which now includes improved background tasks, notification alerts, and scans for security risks in passwords and installed extensions. The machine learning model was trained using synthetic data evaluated against real notifications to ensure effectiveness. The enhancements aim to provide a stronger defense against online threats.
AppWizard
May 6, 2025
Google's Gemini platform is evolving to perform tasks across various applications, with the recent rebranding of Extensions to Apps enhancing its interaction with software and services. Analysis of the beta release of the Google app for Android indicates upcoming support for Gemini Apps in Live mode, suggesting real-time capabilities are being developed. The rollout of Gemini Apps is expected to be phased, with "phase one" indicating a gradual introduction of features, though details on the initial applications remain unclear. The tech community is anticipating more information about compatible apps and the official announcement of these functionalities.
Search