NewApp Digest
search bot

guard

Running pgvector in production on Amazon Aurora PostgreSQL
Tech Optimizer
July 12, 2026

Running pgvector in production on Amazon Aurora PostgreSQL

Running pgvector on Amazon Aurora PostgreSQL-Compatible Edition offers a vector store with operational capabilities, high availability, and scalability. It is favored for Retrieval Augmented Generation (RAG) workloads transitioning to production, but increased traffic introduces challenges like query latency and memory management. Key operational practices for pgvector workloads include selecting the appropriate index type (HNSW or IVFFlat), establishing a baseline schema, choosing a suitable distance operator, scaling the index through quantization and partitioning, and preparing for churn and observability. The prerequisites for using pgvector include an Aurora PostgreSQL-Compatible cluster with specific PostgreSQL versions and the vector extension enabled. The embedding model used in examples is Amazon Titan Text Embeddings V2, which produces 1024-dimensional embeddings. pgvector supports two Approximate Nearest Neighbor (ANN) index types: HNSW, which is efficient for querying and allows for incremental insertions, and IVFFlat, which is less resource-intensive but requires rebuilding if data changes. There are scenarios where forgoing an index is beneficial, such as small datasets or partitioned datasets requiring 100% recall. A baseline schema for a multi-tenant document store includes creating a table for documents with an embedding vector and establishing indexes for tenant IDs and embeddings using HNSW. The recommended parameters for HNSW include m = 16 and ef_construction = 128. Scaling to millions of vectors involves quantization, tuning HNSW parameters, and partitioning. Aurora Optimized Reads can extend effective cache capacity, and managing index churn is crucial for maintaining performance. Observability metrics include query-level statistics, instance-level metrics, and custom application-defined metrics. To clean up after testing, it is advisable to drop the created indexes and tables, and delete the Aurora PostgreSQL-Compatible cluster and any manual snapshots taken during testing.
GigaWiper: Anatomy of a destructive backdoor assembled from multiple malware
Tech Optimizer
July 10, 2026

GigaWiper: Anatomy of a destructive backdoor assembled from multiple malware

Microsoft Threat Intelligence has identified the GigaWiper malware, which has been detected in compromised environments since October 2025. This malware has destructive capabilities and comes in two forms: standalone wiper binaries and larger binaries with backdoor functionalities, both developed in Golang. The standalone wiper operates at the physical disk level, overwriting disk content and removing partition references. The backdoor variant includes the same wiper functionality and adds persistence through a registry key and scheduled tasks, along with command and control communication via RabbitMQ and Redis. GigaWiper can execute various commands, including wiping drives, triggering a Blue Screen of Death (BSOD), file encryption that mimics ransomware behavior, and managing system elements. The malware integrates components from multiple malware families, including wipers and ransomware mechanisms, and has been linked to a previous malware known as FlockWiper. To defend against GigaWiper, organizations are advised to implement security measures such as tamper protection, blocking access to known C2 infrastructure, and utilizing endpoint detection and response solutions. Microsoft Defender provides detections for GigaWiper and related malware, and threat intelligence reports are available for customers to stay informed about threats. Indicators of compromise include specific SHA-256 hashes and IP addresses associated with GigaWiper.
PostgreSQL Extensions Are an Architecture Decision, Not an Afterthought
Tech Optimizer
July 8, 2026

PostgreSQL Extensions Are an Architecture Decision, Not an Afterthought

A common issue in database migrations is the unplanned accumulation of extensions in PostgreSQL, leading to extension sprawl. Teams often install extensions without documenting the rationale, resulting in a complex web of dependencies that complicates future upgrades and removals. The installation process involves PostgreSQL accessing a control file that details the extension's version and dependencies, which can lead to multiple extensions being installed unintentionally. Upgrading and removing extensions are often neglected, causing risks such as the loss of dependent objects. Extensions typically default to the public schema, which can become cluttered; relocating them to dedicated schemas can improve organization. Trusted Language Extensions (TLE) allow non-privileged users to utilize procedural languages in managed databases without needing superuser access. Key extensions recommended for use include pg_stat_statements, pg_trgm, hstore, citext, and PostGIS, each serving specific use cases. Proper governance is essential for managing extensions, including documenting their purpose, ownership, and dependencies, to prevent operational surprises.
Chat Control 1.0: EU Council forces messenger scans via fast-track
AppWizard
July 7, 2026

Chat Control 1.0: EU Council forces messenger scans via fast-track

Member states of the European Union are seeking to reinstate a previously expired regulation concerning the monitoring of encrypted communications, known as Chat Control 2.0, which mandates suspicionless scanning of encrypted messages. The Council of Ministers has proposed to reactivate a transitional regulation that allowed voluntary monitoring by technology companies, which lapsed on April 3. This move aims to close a legal gap and pressure Members of the European Parliament (MEPs) to act quickly. The expiration of the previous regulation is viewed as untenable, as it is deemed crucial for identifying at-risk children and combating illegal content online. Critics argue that the approach undermines democratic oversight and lacks transparency. The draft regulation is set to be discussed as an urgent matter just before the summer recess, with potential voting occurring when many MEPs may be absent. The regulation requires that any processed content and traffic data be deleted within twelve months unless a specific suspicion is confirmed.
Do you still need third-party antivirus on your Windows PC?
Winsage
July 1, 2026

Do you still need third-party antivirus on your Windows PC?

In April, a statement on the Windows Learning Center claimed that Microsoft Defender Antivirus is sufficient for many Windows 11 users, leading to brief attention before the article was removed a month later without explanation. The link now redirects to the homepage, but the content is still accessible via the Internet Archive. Microsoft has not clarified the removal, and speculation suggests backlash from the third-party security industry may have influenced this decision. Research indicates that the infection rate for consumer PCs in 2023-2024 was 3.07%, lower than the 2.39% for business PCs, suggesting that risks may not be as widespread as often claimed. The 2025 Cybersecurity Threat Report noted that 56% of consumer endpoints that faced an infection in 2024 experienced subsequent infections, with user behavior playing a significant role. A survey found that 54% of Americans rely on default device protection, while 46% use third-party antivirus solutions. Modern antivirus solutions, including Microsoft Defender, achieve protection rates of 99% or higher, with Defender specifically reaching a 99.0% protection rate without false positives. This performance indicates that Defender is adequate for most consumers. Default security measures on platforms are generally effective, with modern antivirus applications blocking 99.2% of threats that bypass other protections. Consequently, 97% of PCs remain free from malware infections, suggesting that improving user training may be more beneficial than investing in superior software. In contrast, businesses face different challenges, as attacks are often executed by sophisticated criminal organizations targeting vulnerabilities in third-party software. Enterprise administrators typically use specialized endpoint security products for centralized management and continuous monitoring, which are essential for protecting business environments.
Despite having no clue when GTA 6 is coming to PC, 39% of you are more than happy to wait for it
AppWizard
June 29, 2026

Despite having no clue when GTA 6 is coming to PC, 39% of you are more than happy to wait for it

Rockstar Games has opened pre-orders for Grand Theft Auto 6, offering two versions priced at and 0, but the latter has not generated much enthusiasm. The game will not be available on PC at launch, leading to speculation about its release date for that platform. A poll revealed that 39% of respondents prefer to wait for the PC version, 28% expressed no interest in the game, 16% plan to purchase it on console, and 8% would buy it on console if they owned one. Another 8% are undecided and will wait until release to make a decision.
silver Android smartphone
AppWizard
June 28, 2026

The Steam client was hurting PC gaming on Android — Valve’s VR headset accidentally solved it

Playing Windows games on Android has become feasible due to Winlator and open-source technologies like Wine, Box64, and DXVK. User-friendly applications such as GameHub and GameNative have emerged, enhancing mobile gaming experiences to rival dedicated handheld consoles. A major challenge was the reliance on the x86 Windows Steam client, which was resource-intensive on mobile devices. GameNative 1.0 introduced an experimental feature that eliminates the need for the desktop Steam client by using Valve's native Android libraries, improving the gaming experience significantly. Valve released Steamworks SDK version 1.63 in November 2025, which included native ARM64 libraries for Android, allowing for essential Steam functionalities without a translation layer. GameNative integrated these libraries, replacing the desktop client with a more efficient "bionic" Steam client that operates without a user interface, streamlining DRM and matchmaking processes. GameNative now supports Steam Guard TOTP sign-in, enabling smooth authentication and access to the user's Steam library. It downloads games natively, supports cloud saves, and is compatible with most single-player games with Steam DRM. The application boasts a high compatibility rate, with 221 out of 241 games in one user's library showing as compatible. GameNative 1.0 has improved performance with a Vulkan renderer and reworked controller stack. Despite its success, GameNative is not yet available on the Play Store, with nearly a million users sideloading the application. Developers aim to create a Play Store version that complies with Google's policies for easier installation.
Bitdefender vs Norton vs McAfee 2026: 2 Win Gold, 1 Bronze
Tech Optimizer
June 26, 2026

Bitdefender vs Norton vs McAfee 2026: 2 Win Gold, 1 Bronze

In 2026, Bitdefender, Norton 360, and McAfee each achieved a perfect score of 18 out of 18 in AV-TEST’s April evaluation. Bitdefender excels in protection technology and has the lightest footprint among paid tiers. Norton 360 offers an unlimited VPN, substantial cloud backup, and LifeLock identity theft protection, achieving the best real-world protection score in 2025. McAfee is strong in identity protection and unlimited-device pricing but falls short in core malware engine performance. Bitdefender is noted for its advanced threat detection and has a low entry price of .99 for its Antivirus Plus. Norton 360 includes an unlimited VPN and up to 250 GB cloud backup, while McAfee+ Ultimate provides identity theft coverage and three-bureau credit monitoring. All three products received perfect scores in AV-TEST’s April evaluation, but independent lab results from AV-Comparatives showed Norton and Bitdefender as Top-Rated Products, while McAfee did not achieve this status. The specifications comparison reveals that Bitdefender supports up to 25 devices, Norton 360 offers unlimited devices, and McAfee also supports unlimited devices. Bitdefender employs Advanced Threat Defense, Norton uses SONAR and Intrusion Prevention, and McAfee utilizes Real Protect. Norton and McAfee received AV-Comparatives Performance awards in 2025 for their light system impact, while Bitdefender did not receive such recognition. Pricing strategies include significant renewal increases after steep first-year discounts. Customer support varies, with Norton and McAfee providing extensive 24/7 support, while Bitdefender offers limited phone support. The ownership structures differ, with Norton under Gen Digital, McAfee as a private entity, and Bitdefender remaining independent. Real-world scenarios suggest Bitdefender is best for single users, Norton 360 or McAfee+ for families, McAfee+ Ultimate or Norton for identity theft concerns, and Norton 360 for privacy-focused users.
Are Antivirus Subscriptions Essential Protection Or Clever Marketing?
Tech Optimizer
June 25, 2026

Are Antivirus Subscriptions Essential Protection Or Clever Marketing?

Many individuals question the value of their antivirus subscriptions, especially as free protection options have improved and the features of paid services may not be necessary for everyone. Modern antivirus solutions now include features like VPNs, password managers, parental controls, identity theft protection, and dark web monitoring, which may go unused by some users. Those with modern devices may already have built-in security measures, such as Microsoft Defender for Windows users and similar protections for Mac users, making paid subscriptions potentially unnecessary for those practicing safe online behaviors. Paid antivirus may be worthwhile for individuals managing multiple devices or users, or if the bundled features are more economical than purchasing them separately. Auto-renewal can lead to unexpected charges and upselling tactics, emphasizing the importance of reviewing subscriptions regularly. Ultimately, the decision to pay for antivirus depends on individual circumstances and comfort with technology. Disabling auto-renewal is recommended to allow for annual evaluations of needs and competitive offers.
Search