developers Archives

Tech Optimizer

October 11, 2026

A practical guide to cost optimization with Lakebase Postgres

Lakebase is a fully managed Postgres database designed for modern application development, featuring an architecture that separates storage and compute with a serverless compute layer. This design allows for cost efficiencies through various mechanisms: 1. **Branching**: Developers can create isolated environments for development, testing, or experimentation without duplicating storage costs, as branches share the same underlying storage. 2. **Autoscaling**: Lakebase adjusts compute resources based on activity levels, allowing users to pay only for the compute they use. It can scale down during low activity and can be suspended entirely after inactivity, reducing costs to zero. 3. **Read Replicas and High Availability**: The separation of storage and compute allows for adding read replicas and high availability without incurring additional storage costs, as these instances utilize the same storage layer. 4. **Synced Tables**: Integration with the Databricks Intelligence Platform enables efficient data syncing, allowing users to sync only the necessary working set of data, which helps avoid unnecessary storage and sync costs. 5. **Sync Modes**: There are three sync modes (Snapshot, Triggered, Continuous) for transferring data from the Lakehouse to Lakebase, each with different cost implications based on data freshness requirements. 6. **Right-sizing Compute**: Users can set the initial compute range during project provisioning to avoid over-provisioning and unnecessary costs. 7. **Monitoring and Metrics**: The Lakebase Metrics dashboard provides insights into working set size and cache utilization, helping users optimize their compute sizing and performance. 8. **Point-in-Time Restore (PITR) and Snapshots**: PITR maintains history for recovery within a configurable window, while snapshots offer discrete recovery points. Both are priced lower than standard storage, making them cost-effective options for data recovery. Lakebase costs are categorized into compute, storage, and serverless pipeline compute for syncing data. Compute is measured by CU usage, while storage includes branch storage, PITR history, and snapshot storage, all tracked separately. Users can access detailed usage and cost information through system billing tables.

Tech Optimizer

October 11, 2026

Amazon Aurora PostgreSQL now supports direct querying of Apache Iceberg and Parquet data in your data lake

Amazon has introduced a new capability for Amazon Aurora PostgreSQL that allows users to query operational data alongside data stored in data lakes formatted in Apache Iceberg and Apache Parquet. This feature enables direct access to Iceberg REST Catalog-compatible catalogs, eliminating the need for data duplication or relocation. The integration of DuckDB within Aurora PostgreSQL allows users to query live operational data, including uncommitted writes, alongside data from data lakes using standard PostgreSQL syntax. This capability is available on Aurora PostgreSQL versions 17 (starting with 17.11) and 18 (starting with 18.6). Users must create an Aurora PostgreSQL cluster, attach an IAM role with the AuroraAnalytics feature, and enable the aurora_analytics extension to utilize this feature. They can create foreign tables referencing Iceberg or Parquet data in the data lake, and query them using familiar PostgreSQL commands. Aurora optimizes query performance through techniques like predicate pushdown and column pruning, and users can monitor query behavior with metrics provided by aurora_analytics_stat_statements(). Direct querying of Apache Iceberg and Parquet data is available across all commercial AWS Regions and AWS GovCloud (US) Regions without additional charges, aside from incremental Aurora compute and Amazon S3 request costs.

Tech Optimizer

October 11, 2026

Query Plan Hints in PostgreSQL 19: A New Postgres Feature You Will Probably Never Need

PostgreSQL 19 features an advanced query planner that utilizes table statistics from pg_statistic, gathered during the ANALYZE process, to generate and evaluate potential query plans based on their costs. The planner assesses various configurations, especially in complex joins, to select the most efficient option. Instances of poor planning are treated as bugs and addressed promptly. To improve query performance, users are advised to refresh statistics with ANALYZE, use CREATE STATISTICS for column correlations, modify indexes, and adjust memory settings. In cases where the query cannot be altered, providing planner advice may be necessary, particularly when the planner misestimates the output of PL/pgSQL functions or other custom functions, leading to inefficient query execution.

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.

AppWizard

October 10, 2026

Why Alternative App Stores Are Gaining Popularity Among Android Power Users

An alternative app store allows users to access apps and games not available on official platforms like the Google Play Store, including older versions, regional apps, and open-source options. Types of alternative app stores include third-party Android stores, open-source platforms, modified APK stores, regional stores, free app stores, and game-focused stores. Users explore these stores for a broader selection of apps, including those restricted by geography. Alternative app stores can provide apps that Google Play does not, such as regional apps and modified applications. When choosing an alternative app store, users should consider the platform’s reputation, app descriptions, update frequency, security measures, and source verification. Alternative app stores differ from Google Play by offering more flexibility and access to unique content, though security and developer support may vary. Modified apps are altered versions that may offer enhanced features. Alternative app stores are important for overcoming regional barriers and providing ad-free experiences. They host a variety of apps, including multiple versions of a single application, and typically feature user-friendly search functionalities. Comprehensive app information is often available, including version data and permissions. Some stores focus on open-source and independent apps. The legality of using alternative app stores depends on licensing and local laws, and they often feature apps not found on Google Play. Many alternative stores provide multiple app versions, and only reliable ones may offer faster updates.

AppWizard

October 10, 2026

How to easily sideload Android apps on your new Googlebook

Chrome Unboxed offers support for independent tech journalism and provides an ad-free experience with membership benefits. Android gamers face challenges with popular titles like Call of Duty: Mobile, which are unavailable for installation on Googlebook via the Play Store. Users can sideload apps on Googlebook OS, built on Android 17, without the limitations of the Play Store. The sideloading process involves downloading an APK from a trusted source, allowing unknown apps in Chrome, and installing the app. Google Play Protect monitors installed applications for malicious activity, but users should still exercise caution when sideloading.

AppWizard

October 10, 2026

Asus Googlebook 14 Review: For Android, By Android

Googlebook 14 features Googlebook OS, which is based on Android and incorporates elements from ChromeOS, offering a familiar user experience for Android users. The interface resembles that of Android devices, with home screens, quick settings, and app access similar to smartphones. Integration with Android phones allows users to access apps, notifications, and files directly from the laptop. The "Continue On" feature enables users to pin phone apps to the Googlebook taskbar for easy transitions between devices. However, Googlebook OS lacks support for traditional desktop software, limiting the functionality of Android apps available through Google Play. Google is addressing compatibility issues by labeling apps for desktop use in the Play Store. New features like Magic Pointer, Proactive Suggestions, and Rambler are introduced, but the OS still requires significant improvements in app compatibility and desktop interface optimization. Google has faced challenges in developer support for optimizing applications for Googlebook OS.

Tech Optimizer

October 10, 2026

Supabase Announces $150M in New Funding and Turso Acquisition

Supabase has secured 0 million in funding led by GIC, with participation from Alphabet's CapitalG, IronArc, and SquarePeg. This follows a million Series F round four months earlier. Supabase has acquired Turso, a platform for managing databases for agentic workloads, to enhance its product development and provide liquidity for employees. The company is adding over 1 million users and 4 million databases monthly, with 70% created by AI-driven tools, reflecting a 600% year-over-year increase in databases. Turso's architecture allows for on-demand provisioning of databases in public cloud and BYOC setups. Glauber Costa, founder of Turso, will become Head of Agentic Services at Supabase. Supabase, established in 2020, supports over 13 million developers with a comprehensive backend solution.

AppWizard

October 10, 2026

Triple-A Minesweeper is a gleeful send-up of blockbuster gaming’s worst habits, from yellow paint to characters who talk too much

Triple-A Minesweeper is a parody game developed by Mike Lacher that critiques the excessive guidance in triple-A games. It begins with unskippable title cards featuring third-party software and developers, followed by an introduction to the character Sweeper and his predicament explained by Nora. The game features a yellow diamond marker that directs players where to click, satirizing modern gaming's overzealous assistance. The Sweeper vocalizes his thoughts during gameplay, adding humor. The game is designed to be completed in about five minutes and offers a light-hearted critique of gaming conventions.

AppWizard

October 10, 2026

Expect plenty more Silent Hill over the next few years, as Konami has plans for ‘second and third waves’ of new games in its revived horror series

Silent Hill has made a successful comeback after nearly ten years of inactivity, with three new titles released by Konami: Silent Hill 2 Remake, Silent Hill f, and Silent Hill: Townfall. These games have received positive reviews and are performing well in sales. Producer Motoi Okamoto expressed relief over the successful reception of these titles and highlighted the challenges faced in convincing Konami to approve new entries after the cancellation of Silent Hills in 2015. There is interest in remaking the original 1999 Silent Hill, and the involvement of NeoBards Entertainment and Screen Burn Interactive in future projects remains unconfirmed. Silent Hill f has been described as a "true return to form," and Screen Burn's work on Silent Hill: Townfall has been praised for capturing the essence of the franchise.