NewApp Digest
search bot

running

What Is Serverless PostgreSQL?
Tech Optimizer
July 12, 2026

What Is Serverless PostgreSQL?

Serverless PostgreSQL is a fully managed cloud database model that separates compute and storage, allowing them to scale independently and automatically based on demand. It eliminates the need for manual infrastructure provisioning and capacity planning, charging only for active usage. Unlike traditional PostgreSQL setups, which require continuous resource allocation and manual scaling, serverless PostgreSQL provisions resources on demand and can scale down to zero during idle periods. Serverless PostgreSQL integrates with serverless compute platforms, enabling analytical queries to access the same data within a unified architecture. Key differences between traditional and serverless PostgreSQL include manual versus automatic provisioning and scaling, fixed versus usage-based billing, and high versus reduced operational overhead. Lakebase architecture is an emerging model that combines transactional databases with lakehouse foundations, allowing operational and analytical workloads to coexist on a single platform. This architecture minimizes data duplication and simplifies access, enhancing data management and analysis. Serverless PostgreSQL operates on a cloud-native architecture that enhances efficiency by allowing compute and storage to scale autonomously. It features scale-to-zero behavior, where compute resources are suspended when inactive and reactivated upon new queries. Major providers include Databricks Lakebase, Amazon Aurora Serverless v2, and Neon, each offering varying capabilities and integrations. Pricing for serverless PostgreSQL typically includes charges for compute resources, storage, and data transfer, with costs fluctuating based on workload activity. Cold start latency is a performance consideration, as reactivating compute resources can introduce delays. Strategies to mitigate this include keeping resources partially active or selecting providers with minimal cold start impacts. Serverless PostgreSQL is well-suited for OLTP workloads, while lakebase architecture is better for AI development, variable workloads, and environments requiring rapid iteration. Setting up serverless PostgreSQL involves choosing a provider, creating a database instance, and configuring access settings. It can also be used alongside serverless compute platforms for analytics, further extending its capabilities.
Weekend PC Game Deals: GTA, Borderlands, Kingdom Come, Stray and more
AppWizard
July 12, 2026

Weekend PC Game Deals: GTA, Borderlands, Kingdom Come, Stray and more

The Epic Games Store is offering two free titles this week: Nova Lands and Tattoo Tycoon, available until July 16, when Echo Generation and Luto will replace them. The July Humble Choice lineup includes eight games: Sea of Stars: Sunset Edition, TUNIC, Neon White, Police Simulator: Patrol Officers, Drop Duchy - Complete Edition, Sledders, Dicefolk, and Our Adventurer Guild, available for purchase until August 4. Additionally, Humble has released two game bundles: the Narrative Bundle, featuring 12 games, and the Squad Goals bundle, which includes cooperative titles. The GOG store has ended its DRM-free summer sale but continues with standard promotions. Availability and pricing may vary by region.
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.
AI Threat Forces Microsoft To Update Windows Patch Guidance
Winsage
July 11, 2026

AI Threat Forces Microsoft To Update Windows Patch Guidance

Microsoft is advocating for a reevaluation of Windows patch management practices due to the rapid evolution of artificial intelligence (AI) impacting cybersecurity. The company emphasizes that traditional timelines for patch deployment, typically spanning several weeks after the monthly Patch Tuesday, are inadequate against modern cyber threats. Microsoft recommends organizations shorten deployment windows to under three days for quality updates, with immediate installation deadlines and minimal user grace periods. To support these changes, Microsoft is enhancing Windows Autopatch with a new reporting dashboard for patch compliance and security insights. The company is promoting cloud-managed deployment through Microsoft Intune and Windows Autopatch while continuing to support legacy tools. Additionally, Microsoft is introducing Windows Hotpatch technology, allowing security updates to be installed without immediate reboots, and advocating for the use of identity-based access controls to isolate unpatched devices. The guidance reflects a shift from scheduled patching to continuous risk management, encouraging organizations to prioritize high-risk assets and automate update deployments. Microsoft is also investing in AI-assisted vulnerability discovery and automated code analysis to improve defensive capabilities. The overarching message is that enterprises must adapt their update strategies to address the accelerated pace of AI-driven exploitation.
Tiny Bookshop Simulator Released on iOS and Android
BetaBeacon
July 11, 2026

Tiny Bookshop Simulator Released on iOS and Android

Neoludic Studio has released their bookstore management simulator, Tiny Bookshop, on iOS and Android platforms after receiving positive reviews on Steam. Players can experience the first three in-game days for free before unlocking the full version for 590 rubles.
Assassin's Creed Black Flag Resynced слили на торренты до выхода
TrendTechie
July 11, 2026

Assassin’s Creed Black Flag Resynced слили на торренты до выхода

Assassin's Creed IV: Black Flag Resynced was leaked on torrent sites on July 8, shortly after the PC pre-load became available. The developers mistakenly released an unencrypted build, which was accessed by the piracy community using a hypervisor to bypass Denuvo's protections. The official PC launch is scheduled for the evening of July 9, while console players can access the game at midnight on July 9, local time. Running the pirated version may require disabling Windows security features, which could risk system integrity.
MS Office Pro Plus 2019 and Windows 11 Pro are now just $26
Winsage
July 10, 2026

MS Office Pro Plus 2019 and Windows 11 Pro are now just $26

The All-in-One Microsoft Office Pro 2019 for Windows: Lifetime License + Windows 11 Pro Bundle is priced at .99, reduced from its regular price of 9.99. It includes Microsoft Office Professional Plus 2019, which offers offline access to applications like Word, Excel, PowerPoint, Outlook, OneNote, Publisher, and Access, along with updates for improved functionality. The bundle also features Windows 11 Pro, which includes tools for multitasking and organization, as well as advanced options for business network management and device security.
Search