NewApp Digest
search bot

analytical capabilities

Postgres + ClickHouse: The OSS Stack To Handle Agentic AI Scale
Tech Optimizer
December 10, 2025

Postgres + ClickHouse: The OSS Stack To Handle Agentic AI Scale

Postgres is a popular choice for developers due to its flexibility and reliability, but it faces limitations as applications scale, especially in AI-driven environments where rapid growth increases the demand for analytical capabilities. To overcome these challenges, a trend has emerged to combine Postgres with ClickHouse, where Postgres handles transactional workloads and ClickHouse manages analytics. There are two main methods for integrating ClickHouse with Postgres: split or dual-write, where applications write data to both databases based on use cases, and change data capture (CDC), where all writes occur in Postgres, which serves as the source of truth, streaming changes to ClickHouse for analytical queries. The integration aims to leverage the strengths of both databases, with some queries remaining on Postgres and others transitioning to ClickHouse. Developers must identify which queries to migrate and can use foreign data wrappers (FDWs) to simplify the integration process. The ecosystem around Postgres and ClickHouse has developed into a robust stack with various open source and commercial tools to support production-scale operations, including PeerDB, which provides high-throughput PostgreSQL CDC and reliable replication into ClickHouse. As applications increasingly start with Postgres and later adopt ClickHouse, the transition timeline is shortening, indicating a shift towards managed services and deeper integrations for a seamless experience between transactional and analytical systems.
SereneDB lands $2.1M to fuse search, analytics and Postgres into one engine
Tech Optimizer
December 3, 2025

SereneDB lands $2.1M to fuse search, analytics and Postgres into one engine

Berlin-based startup SereneDB has completed its Pre-Seed funding round, raising .1 million from venture funds Entourage and High-Tech Gründerfonds (HTGF). The company aims to improve traditional search and analytics tools, which struggle with dynamic datasets. SereneDB integrates live data and analysis within a single system, combining a search engine with OLAP execution under PostgreSQL for real-time data ingestion and updates. The platform allows for rapid retrieval of complex results and supports insightful queries from both human users and AI agents. CEO Alexander Malandin and CTO Andrey Abramov lead the company, drawing on their extensive experience in IT and database design. They aim to create a unified engine that integrates search and database functionalities, addressing the limitations of existing enterprise search technologies. The initial response from the developer community has been positive, with interest in SereneDB's capabilities, particularly among startups and existing search users. The funding will help expand the team and support open-source development.
Introducing pg_lake: Integrate Your Data Lakehouse with Postgres
Tech Optimizer
November 17, 2025

Introducing pg_lake: Integrate Your Data Lakehouse with Postgres

pg_lake is a tool developed by the team at Crunchy Data, now part of Snowflake, that provides a native Postgres experience for working with open data lakehouse formats like Iceberg and Parquet. The initiative began with the launch of Crunchy Bridge for Analytics over 18 months ago, aimed at addressing the fragmentation of data between Postgres databases and object storage. The decision to open source pg_lake is intended to establish a standard for the Postgres ecosystem, empower developers to create modern applications, and demonstrate Snowflake's commitment to enhancing Postgres capabilities. pg_lake is now available for exploration and use by developers.
Google's analytical October Workspace Drop simplifies data in Sheets, bolsters AI security
AppWizard
November 1, 2025

Google’s analytical October Workspace Drop simplifies data in Sheets, bolsters AI security

Google has released updates for its Workspace suite in October, enhancing data comprehension, structure, and formatting in Sheets through Gemini AI. Key features include improved understanding of complex instructions for data manipulation. Google Drive has introduced a ransomware detection feature for desktop users, which alerts them to suspicious activity and pauses data synchronization. Gmail now includes end-to-end encryption for emails to enhance privacy and security. These updates build on August's enhancements, which featured file summaries for Chat, Video Overviews for NotebookLM, and the Veo 3 model in the Vids app, with the recent transition to Veo 3.1 providing greater creative control, improved sound capabilities, and more realistic textures.
Google releases Gemini 2.5 Deep Think for AI Ultra subscribers
AppWizard
August 1, 2025

Google releases Gemini 2.5 Deep Think for AI Ultra subscribers

Google is rolling out its latest AI model, Gemini 2.5 Deep Think, which is available exclusively through the Gemini app and requires a subscription to Google's premium AI Ultra plan. Deep Think enhances the capabilities of Gemini 2.5 Pro by increasing "thinking time" through greater parallel analysis, allowing it to explore various problem-solving methods. It requires several minutes to formulate a response, contributing to its proficiency in design aesthetics, scientific reasoning, and coding. Deep Think has been benchmarked against other models, showing superiority over Gemini 2.5 Pro and competing models like OpenAI's o3 and Grok 4. It scored 34.8 percent on Humanity's Last Exam, outperforming other models that typically score between 20 to 25 percent.
Search