NewApp Digest
search bot

lag

From monolith to Lakebase to LTAP: rethinking the database from storage up
Tech Optimizer
July 2, 2026

From monolith to Lakebase to LTAP: rethinking the database from storage up

Sixteen years ago, the author began their PhD at UC Berkeley and was advised to focus on analytics rather than OLTP databases, which were considered solved. This led to the creation of Apache Spark and Databricks. However, during the development of Databricks, it was found that OLTP databases were not solved problems; they were difficult to scale and fragile. This realization led to the development of Lakebase, a serverless Postgres database designed with modern technology. Lakebase architecture separates the write-ahead log (WAL) and data files into independent, scalable services. The WAL is externalized to a service called SafeKeeper, which uses Paxos-based replication for durability, while data files are managed by PageServer, which stores them in cloud object storage. This design addresses challenges such as data loss, scaling, and performance interference between transactional and analytical workloads. Lakebase maintains compatibility with Postgres, offers unlimited storage, serverless compute, durable writes, and simpler high availability. It also introduces LTAP (Lake Transactional/Analytical Processing), which allows both transactional and analytical processing to operate on a single data copy in real time, eliminating the need for separate data copies and reducing costs. LTAP utilizes a unified storage layer that allows data to be materialized in both row and columnar formats, optimizing it for both transactional and analytical workloads. The system ensures that analytics can access the most current data without affecting transactional performance by using a log sequence number (LSN) to retrieve the latest changes. Unlike traditional CDC approaches, LTAP requires no explicit table replication, as all data is stored in a single governed copy. This architecture circumvents common issues faced by hybrid transactional/analytical processing (HTAP) systems, such as incomplete feature sets, lack of ecosystem support, and performance contention. The Lakebase architecture has unlocked capabilities like unlimited storage, elastic compute, durable writes, and instant branching, with ongoing developments anticipated in the future.
Pixel phones are reportedly choking on basic games after Android 17
BetaBeacon
July 2, 2026

Pixel phones are reportedly choking on basic games after Android 17

Pixel phones are facing gaming performance issues after the Android 17 update. Some affected games include Brawl Stars, Clash Royale, and Hill Climb Racing 2. Users have tried makeshift solutions but are waiting for an official resolution from Google. The Pixel 10, Pixel 9, and Pixel 8 series are the most impacted. The exact cause of the problem is unclear, with some pointing to the Android 17 update or recent Play Services updates. Users have suggested clearing the cache for Google Play services and adjusting GPU driver preferences as potential solutions.
Minecraft Adventure Maps — okay so let me just tell you what actually works
AppWizard
June 26, 2026

Minecraft Adventure Maps — okay so let me just tell you what actually works

Adventure maps in Minecraft allow players to experience curated gameplay without survival mechanics or resource gathering. These maps are designed in Adventure Mode, preventing players from altering the environments. They vary in length and complexity, with some lasting only 20 minutes and others several hours, often featuring custom dialogue and narratives. Quality adventure maps can be found on platforms like Planet Minecraft, MCPEDL, CurseForge, and the Minecraft Marketplace. It's important to check version compatibility to avoid glitches. Recommended adventure maps include Herobrine’s Mansion, Diversity 3, SkyBlock, The Forgotten, Chronos, and Parkour Paradise. Multiplayer maps should be labeled as such to avoid common issues like skipped puzzles and disrupted story pacing. Installing maps differs between Java and Bedrock editions, with Java scanning the saves folder and Bedrock requiring the opening of a .mcworld file. Players may face issues like command blocks failing or visual discrepancies due to missing resource packs or version mismatches. To evaluate a map's quality before downloading, check the download count and read comments for potential bugs. Java and Bedrock maps are not interchangeable, so verifying the edition and compatibility is crucial for a smooth experience.
Malware Has Gotten Smarter. Here's How Your Antivirus Has, Too
Tech Optimizer
June 21, 2026

Malware Has Gotten Smarter. Here’s How Your Antivirus Has, Too

Antivirus software is evolving from relying on static databases of known malware signatures to employing behavioral monitoring and machine learning for threat detection. Traditional antivirus solutions focused on recognizing known threats through unique signatures, but this approach has become inadequate due to the rapid evolution of malware, including polymorphic and metamorphic types. Modern antivirus systems now monitor program behavior, looking for suspicious activities such as unexpected file encryption or unusual network communication. Machine learning models analyze large datasets to identify patterns associated with malware, allowing for the classification of files as safe, potentially unwanted, or malicious. Techniques like sandboxing and dynamic analysis are used to preemptively neutralize threats. However, advancements in AI also present challenges, as cybercriminals can exploit these technologies to create sophisticated malware that evades detection. Despite improvements in antivirus effectiveness, modern cyberattacks increasingly target individuals through methods like phishing and social engineering, necessitating a combination of robust antivirus solutions and good cybersecurity practices.
PostgreSQL 18 on Amazon Aurora and Amazon RDS: Security, monitoring, and developer enhancements
Tech Optimizer
June 20, 2026

PostgreSQL 18 on Amazon Aurora and Amazon RDS: Security, monitoring, and developer enhancements

PostgreSQL version 18 has deprecated MD5 password authentication in favor of SCRAM-SHA-256, with a new parameter, md5_password_warnings, enabled by default to log deprecation warnings. It has enhanced monitoring capabilities by adding columns to pg_stat_database and pg_stat_statements to track parallel worker activity, with the default max_parallel_workers_per_gather set to 0 in Aurora PostgreSQL. The pg_stat_subscription_stats view now includes new columns for tracking conflict types in logical replication. Optimizer statistics are automatically transferred during upgrades, while uuidv7() generates timestamp-ordered UUIDs. The default streaming option for CREATE SUBSCRIPTION has changed to parallel, and the idle_replication_slot_timeout parameter automatically invalidates inactive replication slots. Enhancements to the COPY command include REJECT_LIMIT for error tolerance and a silent LOG_VERBOSITY level. OLD and NEW aliases have been introduced in RETURNING clauses for various DML commands.
Users are complaining that the new Windows version of Outlook is running slowly.
Winsage
June 20, 2026

Users are complaining that the new Windows version of Outlook is running slowly.

Microsoft has introduced two versions of Outlook in Windows 11: Outlook Classic (a Win32 desktop application) and the New Outlook. Users have reported significant performance issues with the New Outlook, noting a lag of approximately 10 seconds for tasks that Outlook Classic performs instantly. The New Outlook operates on WebView2, which involves multiple processes and higher memory consumption, while Outlook Classic runs as a single process. Microsoft is aware of these performance challenges and is testing a new API called 'Delayed Message Timing' to address them. Users find Outlook Classic to be more reliable and faster, particularly for businesses that need efficient notification processing.
pgEdge Announces ColdFront for PostgreSQL, Seamlessly Uniting AI, Analytical and OLTP Workloads
Tech Optimizer
June 20, 2026

pgEdge Announces ColdFront for PostgreSQL, Seamlessly Uniting AI, Analytical and OLTP Workloads

pgEdge ColdFront is a data tiering solution for PostgreSQL that allows seamless access to hot and cold storage without changing application code, reducing storage costs by up to 90%. The cold tier is writable, enabling operations like UPDATE and DELETE on archived rows using standard SQL commands. ColdFront automatically migrates older data to Apache Iceberg in Parquet format, compatible with S3-compatible object stores, while maintaining full accessibility through a single Postgres table name. It enhances performance with the DuckDB vectorized columnar engine, achieving 10-100x faster analytical performance on cold data. ColdFront simplifies data management by automating the movement of cold data to cost-effective storage, addressing challenges like increased storage costs and operational complexities. It allows for compliance tasks, such as GDPR deletion requests, to be executed with a single SQL statement. Key features include a directly writable cold tier, no application changes required, open-source operation, automated partition lifecycle management, cost-effective operations, and distributed access in multi-master clusters. ColdFront is beneficial for sectors like SaaS, IoT, and regulated industries, and is currently available as a production-grade beta, set to be integrated into pgEdge Cloud in the second half of 2026.
silver Android smartphone
Winsage
June 18, 2026

This $13 Windows 11 Pro offer is too good to ignore

Microsoft Windows 11 Pro is currently available for .97, reduced from its regular price of 5.00, offering a savings of 5.03. Key features include BitLocker encryption, Hyper-V virtualization, Windows Sandbox, TPM 2.0 support, and advanced authentication protections. Productivity enhancements consist of Snap Layouts, improved desktop organization, voice typing enhancements, better search functionality, and seamless multi-monitor support. The integration of Microsoft’s AI assistant, Copilot, assists with content summarization, answering queries, generating writing prompts, and coding suggestions.
Search