NewApp Digest
search bot

media

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.
Designing a Concurrent Donation Ledger With FastAPI and PostgreSQL
Tech Optimizer
October 10, 2026

Designing a Concurrent Donation Ledger With FastAPI and PostgreSQL

Every year, billions of dollars flow through online crowdfunding platforms, leading to donor concerns about the allocation of funds. Traditional crowdfunding applications lack transparency, often leaving funds in unverified balances without real-time auditability or guarantees against double-allocations. GoodCause, a social impact platform, aims to address this issue by creating a system that ensures financial integrity and atomic fund distribution. Its architecture is based on mobile-first delivery, atomic auditability, and strict data isolation, utilizing technologies such as React Native, FastAPI, and PostgreSQL. The platform incorporates a mobile client for cross-platform navigation, a backend API for domain-driven routing, a database with Row-Level Security, and a payment gateway for secure transactions. A significant engineering challenge is preventing race conditions and double-spending in concurrent donation scenarios.
It's Not Gone: The Feature Android Auto Users Love Is Still There, Google Says
AppWizard
October 10, 2026

It’s Not Gone: The Feature Android Auto Users Love Is Still There, Google Says

The wavy progress bar in Android Auto's music applications has disappeared for some users, leading to speculation about its permanent removal. Google clarified that the squiggly line has not been eliminated, attributing the inconsistency to app developers' ability to customize the progress bar's appearance. Users have observed that the wavy progress bar may appear in the Coolwalk screen but reverts to a standard straight line in full-screen mode. Additionally, any app capable of playing media now utilizes a dedicated card on the Coolwalk screen, allowing users to see song information and playback controls. This feature is live on production devices with the latest updates of Android Auto.
Walmart is selling a Android tablet for only $90
AppWizard
October 10, 2026

Walmart is selling a Android tablet for only $90

The Zonko Android 16 Tablet is currently available at Walmart for under 0 during a limited-time Flash deal, including an accessory bundle. It features a 10-inch display with a resolution of 1280×800 HD, dual speakers, and a dual-camera setup with an 8MP front camera and a 13MP rear camera. The tablet runs on the Android 16 operating system, has 12GB of RAM, and 64GB of storage, expandable up to 512GB. It is equipped with a 6000mAh battery that lasts between 32 to 48 hours, and offers dual-band 2.4G/5G WiFi. The purchase includes a Bluetooth keyboard, mouse, stylus pen, screen protector, protective case, and charger. The device supports Google Mobile Services and comes with parental controls. However, it has received only a few reviews and does not support downloading Apple apps, except for Apple TV or Apple Music.
This App Wants to Make Your Android Handhelds Last Even Longer
AppWizard
October 10, 2026

This App Wants to Make Your Android Handhelds Last Even Longer

Battery life is a significant concern for Android handheld device users, prompting some to use custom firmware while others prefer stock Android. Strategies to extend battery life exist but vary in effectiveness and effort required. SleepManager is an application designed to optimize battery usage during inactivity by automatically disabling Wi-Fi and Bluetooth, activating Battery Saver, managing specific applications, scheduling syncs, and preventing clamshell devices from waking inadvertently. It is accessible without rooting or complex commands, allowing users to download and configure it easily. The developer noted that SleepManager was created using AI-assisted development, which has sparked discussions about AI's role in app creation.
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.
Threads takes 'Gems' to new places with badges for users who spur conversation
AppWizard
October 9, 2026

Threads takes ‘Gems’ to new places with badges for users who spur conversation

Threads, a social media platform under Meta, is launching a new initiative in the U.S. called "Gems," which will award a distinctive purple badge to public posts and replies that contribute to meaningful discussions. This feature aims to foster engaging discourse among users. Additionally, Threads has introduced "ghost posts," which disappear after 24 hours, allowing users to share temporary thoughts and receive replies in direct messages. Another feature, "Dear Algo," lets users customize their content feed for up to three days and share their preferences with others.
Microsoft entertains resurrecting 3D Pinball for Windows 11
Winsage
October 9, 2026

Microsoft entertains resurrecting 3D Pinball for Windows 11

Microsoft has acknowledged the demand for the return of the 3D Pinball game to contemporary Windows systems, with Pavan Davuluri, executive vice president of Windows and devices, stating that the team would consider it in their future planning. The game was originally part of the Microsoft Plus! 95 expansion and was removed with the launch of Windows Vista due to the transition from 32-bit to 64-bit operating systems. Reintroducing 3D Pinball may face challenges, as the Space Cadet table was licensed from Full Tilt! Pinball and the complete game was published by Maxis, now part of Electronic Arts.
Search