completion Archives

AppWizard

July 24, 2026

I replaced my old Android Auto sideloading method with this, and it’s so much easier

The process of sideloading apps for Android Auto can be complex due to varying permissions by device and app. Users often face issues with platforms like Android Auto Apps Download (AAAD), which may go offline. Some beneficial sideloaded apps include AABrowser for internet browsing and CarStream for watching YouTube. A new sideloading method allows users to bypass AAAD, ensuring app icons appear in the vehicle's infotainment system. This method was effective on a Pixel 10 Pro running Android 17 without being rooted, but results may vary on other devices. To enable this method, users must activate Developer Mode on their Android device and Android Auto. It is important to install apps from reputable sources, such as GitHub, as recent updates to Android Auto may remove sideloaded apps that circumvent restrictions. After enabling the Unknown Sources option in Android Auto's developer settings, users can install apps like AABrowser, which then appears in the Android Auto launcher and the vehicle's infotainment system.

Tech Optimizer

July 23, 2026

Simplify AI agent orchestration with Lakebase Postgres

The auditing process has traditionally been labor-intensive, requiring extensive document reviews. CLA (CliftonLarsonAllen LLP) partnered with the Databricks Forward Deployed Engineering team to develop a document processing application that reduces extraction time from hours to minutes while maintaining quality. The application is built on the Databricks platform, utilizing technologies like Lakebase Postgres, Databricks Apps, Lakeflow Jobs, MLflow, and Unity Catalog Volumes. The application addresses challenges in document parsing, including unpredictable per-task latency, rate-limit-aware throttling, workload prioritization, cost attribution per task, and real-time progress visibility. It eliminates the need for multiple specialized systems by integrating components such as a web application for user interaction, Lakebase for state management, an orchestrator for task management, and AI agents for document processing. The task queue is supported by two Postgres tables in Lakebase, tracking task status and execution attempts. Concurrency safety is ensured through a locking mechanism, and crash recovery is facilitated by lease-based locking. The orchestrator implements rate-limit-aware throttling and idempotent webhook callbacks to manage task processing effectively. An operator dashboard provides real-time metrics on task status, agent performance, and workload costs, with live updates through Postgres LISTEN/NOTIFY events. Cost attribution is managed at the application level, allowing for detailed monitoring of expenditures. Lakebase enhances the orchestration process with features like autoscaling compute, OAuth-rotated authentication, Unity Catalog integration, and support for branching and snapshots.

Tech Optimizer

July 22, 2026

Migrating mission-critical payments at Nubank to Amazon Aurora PostgreSQL

Nubank, a digital banking platform with approximately 135 million customers in Brazil, Mexico, and Colombia, faced challenges with its payment infrastructure due to inefficiencies in managing 7.5 TB of self-hosted PostgreSQL databases. Queries took over 13 minutes to execute, and replication lags exceeded four minutes during peak times. To address these issues, Nubank evaluated database solutions based on developer productivity, operational efficiency, performance reliability, and scalability. They selected Amazon Aurora PostgreSQL-Compatible Edition for its compatibility, performance improvements, and automated features. The migration to Aurora was facilitated by AWS Database Migration Service (AWS DMS), which minimized downtime and allowed for efficient transition. Post-migration, query performance improved significantly, with some queries executing up to 1,900 times faster, and overall end-to-end service latency decreased, enhancing customer experience. The migration resulted in a 25 percent cost reduction and ensured compliance with regulatory requirements.

Tech Optimizer

July 21, 2026

I Built My Second ETL Pipeline. This Time, I Started Thinking Like a Data Engineer

The author transitioned from a data analyst role to a data engineer, creating a 12-month self-study roadmap focused on learning by building projects. The first project was a GitHub ETL pipeline, which evolved from a simple Python script to a more complex system using SQLite and GitHub Actions for automation. The author realized that the challenges of data engineering lay in system design and orchestration rather than just writing ETL logic. For the second project, the author built an automated RSS ingestion pipeline to explore engineering decisions in creating a reliable data pipeline. The project emphasized the importance of separating application responsibilities from orchestration tasks, leading to the use of Docker for consistent execution environments and Kestra for orchestration. The author validated each component of the project incrementally: first the Python ETL, then PostgreSQL, followed by Docker, and finally Kestra. This approach ensured that each layer functioned correctly before adding complexity. The final architecture included distinct responsibilities for each component: Python for data processing, PostgreSQL for data storage, Docker for execution, and Kestra for orchestration. The author learned that effective engineering involves considering system reliability, error handling, and observability, shifting the focus from merely writing code to designing entire systems. The experience transformed the author's mindset, emphasizing the importance of incremental building and the separation of execution and orchestration responsibilities.

AppWizard

July 21, 2026

X finally ships its rebuilt Android app

X has launched a revamped version of its Android app, a project that began nearly a year ago in response to user feedback about bugs and performance issues. The initiative was first mentioned in August 2025 when Nikita Bier, the Head of Product, sought to create the "Android Dream Team." On July 20, Bier announced the completion of the rebuild, describing it as one of the largest engineering efforts in the company's history. The new app is faster, smoother, and more reliable, with a modernized foundation that will facilitate quicker feature rollouts in the future. Although the update does not introduce new user-facing features, it focuses on performance enhancements, including improvements to scrolling, loading, and notifications. Future updates are promised to include additional functionalities, such as better support for hosting Spaces and improved performance on older devices.

AppWizard

July 21, 2026

X Announces Completion Of Year-Long Android App Rebuild

X has completed a year-long rebuild of its Android app, described by head of product Nikita Bier as one of the largest engineering projects since Elon Musk's acquisition of Twitter in 2022. The app was developed from scratch to improve the user experience for Android mobile users, with plans to roll out new features more quickly. The engineering team is still working on features like hosting Spaces and optimizing performance for older devices. The rebuild was prompted by a surge in Android app downloads last year and aligns with Musk's vision of transforming X into an "everything app." The launch comes amid challenges such as reduced content moderation, an advertiser boycott, and user attrition. X has also introduced X Chat, a private messaging service, and X Money, a digital payments platform, while implementing measures to promote original content. The rebuilt Android app is now available for download on the Google Play Store.

AppWizard

July 17, 2026

RPCS3 Emulator Now Plays 75% of PS3 Game Library on PC

The RPCS3 emulator for PlayStation 3 can now run 75% of the PS3 game library, which is 2,681 out of 3,559 titles. No games are rated with zero compatibility, with 0.06% classified as "Loadable," 1.69% as "Ingame," and 22.93% as playable to some extent. Some popular titles like Grand Theft Auto IV and the Assassin's Creed series are still "Ingame," while Battlefield 1943 is at the "Intro" stage.

AppWizard

July 16, 2026

Google to open Android to third-party app stores in US on July 22

Beginning July 22, Google will allow third-party app stores in the United States to access its Play Store catalog through the Play Catalog Access Program. App listings submitted to these third-party platforms will be accessible, but downloads will still require completion via Google Play, with standard service fees applying. This initiative follows a settlement with Epic Games, which involved adjustments to a court order. Third-party app stores must pay a ,000 upfront service fee for a security review and an annual fee of ,000 to maintain access to the Play catalog. Additionally, Google has reduced its commission on app purchases from 30% to 10% and allowed external billing options as part of the settlement.

AppWizard

July 16, 2026

Denshattack! (PC) Review

Denshattack! is a cel-shaded trick-based 3D platformer developed by the indie studio Undercoders in Barcelona, Spain. The game features a protagonist named Emi Araki, a 19-year-old ramen delivery driver in Beppu, Japan, who dreams of riding the VACTRAIN, an underground train. The narrative involves Emi leaving her hometown to confront the mega-corporation Miraidō, which governs the state and operates the VACTRAIN. Players engage in gameplay inspired by classic titles, performing stunts and achieving high scores across 60 levels in eight regions. The game includes boss battles, a scoring system, and a vibrant visual style complemented by a notable soundtrack featuring guest composers. Despite some navigation challenges and minor imperfections, Denshattack! has been well-received for its engaging gameplay and artistic presentation.

AppWizard

July 13, 2026

Super Mario 64’s superior version is finally getting a PC port

Super Mario 64 is considered one of Nintendo's best games and is essential for Nintendo 64 owners. It was reimagined for the Nintendo DS, which introduced new playable characters (Yoshi, Luigi, and Wario) and levels, as well as multiplayer experiences. However, the DS version has drawbacks, including graphics that may not perform well on larger screens and controls that are less effective for a 3D platformer. A PC decompilation project led by tangosdev aims to improve these issues, potentially combining features from both the original and DS versions. Progress is ongoing, and while completion is not imminent, it may resolve the debate over which version is superior.