NewApp Digest
search bot

time zone

Aurora PostgreSQL 13 Deadline: Four Upgrade Paths to Beat February Cutoff
Tech Optimizer
January 29, 2026

Aurora PostgreSQL 13 Deadline: Four Upgrade Paths to Beat February Cutoff

Standard support for Amazon Aurora PostgreSQL-Compatible Edition and Amazon RDS for PostgreSQL version 13 will end on February 28, 2026. PostgreSQL 13 will be deprecated by the community in November 2025, ceasing to receive bug fixes or security patches. AWS recommends upgrading to newer versions, such as 16 or 17, which offer significant performance enhancements and improved security. PostgreSQL 17 can achieve up to twice the write throughput and consumes 20 times less memory during vacuum operations. Version 16 introduces pg_stat_io for detailed I/O statistics, while version 14 includes a vacuum emergency mode. Aurora-specific enhancements in version 14.9 and later can lead to faster query latency and reduced costs. Version 14 introduces new roles for access control, and version 15 revokes certain permissions. Major upgrades in logical replication include automatic slot synchronization in version 17 and support for parallel apply in version 16. Transitioning between major versions requires careful examination of catalog changes, as some views and configuration parameters will evolve. Extensions must be verified, as most do not auto-upgrade. An in-place major version upgrade can be performed via the AWS Console or CLI, with downtime varying based on database size. AWS recommends snapshot-based testing beforehand. The CLI command can check valid upgrade targets, leading from version 13 to 14, 15, 16, or 17. Preparation involves validating instance classes and dropping replication slots. Amazon RDS Blue/Green deployments allow for near-zero downtime by synchronizing production with a staging environment, enabling application testing before traffic switching. This feature is supported from Aurora PostgreSQL version 13.12 onward. Logical replication through pglogical offers flexibility for minimal downtime, while AWS DMS supports homogeneous migration with Change Data Capture. Extended Support is available for a fee, providing up to three years of security patches. Best practices include replicating production environments in staging, conducting load tests, and validating queries against new catalogs. Recent minor releases, including Aurora PostgreSQL 17.6 and 16.10, showcase ongoing improvements. Engaging AWS Support is advisable for complex setups to ensure seamless transitions before the deadline.
Strategies for upgrading Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL from version 13
Tech Optimizer
January 28, 2026

Strategies for upgrading Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL from version 13

Standard support for PostgreSQL version 13 will end on February 28, 2026. Upgrading to newer PostgreSQL versions can enhance database performance and introduce new features. Notable enhancements in recent versions include: - Vacuum emergency mode (v14+) to manage old row versions. - Improved I/O performance (v17) with better write throughput. - Enhanced query optimization (v17+) for IN clauses and parallel BRIN index builds. - Memory efficiency improvements (v17) reducing vacuum memory usage. - Advanced monitoring features like pg_stat_io (v16+) and pg_wait_events (v17+). - Logical replication improvements such as failover support and slot migration (v17+). - Developer experience enhancements including JSONB subscripting (v14+) and SQL/JSON JSON_TABLE (v17+). - Security enhancements with new roles for access control (v14+) and maintenance tasks (v17+). For Amazon Aurora PostgreSQL-Compatible, upgrading to versions v14.9+, v15.4+, v16.1+, and higher can yield performance optimizations, including faster query latency and cost savings. Changes in system catalog views and configuration parameters have occurred in PostgreSQL versions 14 to 17, impacting application compatibility. Upgrade strategies include in-place upgrades, blue/green deployments, logical replication, and using AWS Database Migration Service (AWS DMS). If an immediate upgrade is not possible, Amazon RDS Extended Support offers up to three years of continued security patches and bug fixes beyond the standard support end date.
The Midnight Walkers launch time and release date
AppWizard
January 28, 2026

The Midnight Walkers launch time and release date

The Midnight Walkers launches at the following times across different time zones: - Los Angeles: 6 pm PST on Wednesday, January 28 - New York: 9 pm PST on Wednesday, January 28 - Nuuk: 12 am WGT on Thursday, January 29 - London: 2 am GMT on Thursday, January 29 - Berlin: 3 am CET on Thursday, January 29 - Sydney: 1 pm AEDT on Thursday, January 29 - Auckland: 3 pm NZDT on Thursday, January 29 - Tokyo: 11 am JST on Thursday, January 29 Preloading is not available for The Midnight Walkers; all early access participants will gain access simultaneously.
Why High-Performance Android Apps Require More Than Just Kotlin and Jetpack
AppWizard
January 28, 2026

Why High-Performance Android Apps Require More Than Just Kotlin and Jetpack

Smartphone users expect immediate feedback and seamless experiences from applications, which requires a holistic approach to mobile development that integrates user interface design with robust server-side capabilities. Challenges in app architecture and backend integration can hinder performance, particularly for high-level applications. Developers often focus on frontend aspects, neglecting the importance of backend processes, which can lead to issues such as inefficient API payloads and data fetching latency. Architectural bottlenecks, like excessive data retrieval, can waste bandwidth and battery life. A well-structured Android architecture can separate UI from data management complexities, aiding scalability. Modern tools like Jetpack Compose enhance UI development but can introduce performance issues if backend state delivery is inconsistent. Collaborating with specialized nearshore mobile app development teams can help US-based companies address these challenges effectively, benefiting from time zone alignment and cost-effective solutions while maintaining engineering expertise.
More bad news for PC gamers as AMD CPU prices could soon soar
AppWizard
December 3, 2025

More bad news for PC gamers as AMD CPU prices could soon soar

AMD is rumored to be planning a price increase for its Ryzen CPUs, with changes expected to take effect at midnight on December 1, 2025. This increase is said to be related to AMD's suppliers and may not immediately affect retail prices. The Ryzen 9000 series and some older AMD CPUs are expected to be impacted. Current prices for models like the Ryzen 7 9800X3D remain low, and consumers are advised to take advantage of existing deals before potential price hikes occur.
5 Secret Windows 11 Features Everyone Should Be Using By Now
Winsage
December 2, 2025

5 Secret Windows 11 Features Everyone Should Be Using By Now

Windows 11 includes features for photo editing, advanced calculations, text extraction from screenshots, timezone management, and enhanced text formatting in Notepad. The Photos app allows users to remove objects and backgrounds from images using AI-powered editing tools. Users can erase objects by selecting the Erase option, adjusting the brush size, and brushing over the object. To remove backgrounds, users choose the Background option and use the Background brush tool. The Windows Calculator offers various modes for complex calculations, including Standard, Scientific, Graphing, Programmer, Date calculation, and Converter options. Users can switch modes via the hamburger icon and keep the Calculator window on top of other applications. The Snipping Tool enables users to copy text from screenshots. Users can take a screenshot with Win + Shift + S, open the Snipping Tool editor, select the Text actions icon, highlight the desired text, and choose to copy it. Windows 11 allows users to add multiple time zones in the Notification Center by accessing the Settings app, selecting Time & language, and navigating to Date & time to set additional clocks. Notepad has been updated to include basic text formatting options. Users can toggle on Formatting in Settings, adjust text size, create lists, and apply bold and italic styles, saving their work as Markdown files.
Here's the Battlefield 6 release time for your region
AppWizard
October 9, 2025

Here’s the Battlefield 6 release time for your region

Battlefield 6 is set to launch on October 10. There will be no early access, even for the deluxe edition. Pre-ordering the game grants the Tombstone Pack, which includes an exclusive skin. Players can preload Battlefield 6 now, and it requires approximately 80 GB of available storage space.
Search