NewApp Digest
search bot

data management

They might have grown up online — but Gen Z are apparently far less likely to use antivirus, study finds
Tech Optimizer
July 29, 2026

They might have grown up online — but Gen Z are apparently far less likely to use antivirus, study finds

A recent survey by Kaspersky involving 7,200 respondents from 18 countries found that only 27% of Generation Z use antivirus software on their mobile devices. Additionally, 57% of Gen Z spend more time online than offline, yet many lack awareness of online safety principles. Alarmingly, 52% reported experiencing attacks on their devices or accounts, but few take necessary precautions. Only 28% regularly back up important personal data on their phones, and many neglect changing passwords. To address these issues, Kaspersky launched "Case 404," a cyber-detective adventure game aimed at improving cybersecurity awareness among Gen Z.
'PGSimCity' shows how the PostgreSQL database actually works internally in a SimCity-like 3D environment.
Tech Optimizer
July 28, 2026

‘PGSimCity’ shows how the PostgreSQL database actually works internally in a SimCity-like 3D environment.

PGSimCity is a web application that provides a 3D visualization of PostgreSQL's architecture, allowing users to explore its internal operations during SQL query execution. The application features an interactive interface that guides users through the connection process to PostgreSQL, illustrating how client connections reach the Postmaster and backend processes. It highlights the significance of connection pooling and the impact of increasing connections on backend processes. In the 'Query Lab' section, SQL statements are transformed into execution plans, showcasing processes like Parser, Rewriter, Planner, and Executor, along with execution paths such as Seq Scan and Index Scan. The shared_buffers area represents PostgreSQL's buffer cache, optimizing performance by reading data in 8KiB pages. Visualizations depict data pages stored on disk, with pathways showing the movement of pages to shared_buffers. The Write-Ahead Log (WAL) mechanism records changes for recovery, and transaction commits wait for WAL records to be flushed. Checkpointing writes dirty pages to storage in batches, which can cause latency spikes. PostgreSQL uses Multi-Version Concurrency Control (MVCC) to manage updated rows and dead tuples, which are cleaned up by autovacuum processes. The application also illustrates replication, where WAL from the primary server is sent to the standby server to maintain data consistency. Overall, PGSimCity provides a comprehensive view of PostgreSQL's components and potential performance issues related to caching, WAL management, checkpointing, vacuuming, and replication.
Your free VPN on Android often offers less protection than you might think
AppWizard
July 12, 2026

Your free VPN on Android often offers less protection than you might think

The MVPNalyzer Study conducted by researchers at the University of Michigan analyzed various VPN services, focusing on their performance metrics, data privacy practices, and effectiveness in bypassing geographical restrictions. The study revealed that some VPNs excel in speed while others prioritize security features, and not all services provide the same level of data protection, with certain logging practices raising concerns. The findings encourage users to closely examine VPN services regarding speed, privacy policies, and data management, while urging VPN providers to improve transparency and invest in user security technologies.
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.
Why most AI projects fail: It’s infrastructure and people
Tech Optimizer
July 6, 2026

Why most AI projects fail: It’s infrastructure and people

AI technology faces significant criticism for its low success rates in delivering business results, with studies indicating a 95% failure rate for enterprise AI solutions and only 9% of organizations in Europe, the Middle East, and Africa achieving measurable outcomes from AI initiatives. Four main shortcomings hinder the transition of AI prototypes to production: 1. Deployment Flexibility: Prototyping environments often lack the necessary flexibility for large-scale production deployment, particularly in regulated sectors. 2. Data Sovereignty: Production transitions can complicate data sovereignty at enterprise and regional levels. 3. Reliability: High availability is crucial for production environments, but vendor-managed platforms may not guarantee seamless upgrades or hardware swaps without downtime. 4. Disconnect in Tool Selection: Developers often choose tools for prototyping without considering production implications, leading to difficulties in scaling. The shortage of database administrators (DBAs) is exacerbated by the increasing use of AI tools, with 84% of developers utilizing them according to a 2025 survey. To address these challenges, Merrick suggests leveraging AI DBA agents to support human DBAs and improve database management efficiency. He emphasizes the need for both robust data infrastructure and enhanced operational support to improve the success rates of AI prototypes.
All Android users just got an important backup feature
AppWizard
July 2, 2026

All Android users just got an important backup feature

Google is introducing a selective backup feature for Android users, allowing granular control over app data management. This update is initially rolling out to Pixel devices and users of Google Play Services version 26.24. Users can now selectively manage backups for each app, which helps conserve cloud storage space. The feature is available for those using Android 16 and Android 17, with other manufacturers expected to adopt it soon. Once activated, data is securely backed up to the cloud, but users should be aware that disabling backup for an app will permanently delete its previously backed-up data. To manage backups, users can go to their device’s settings under Google Services > Backup > Backup details. The rollout is gradual, primarily targeting Google Pixel smartphones. Most users will receive the update automatically, and they can check their version of Google Play Services in the settings.
EDB named Forrester Leader in multimodel data platforms
Tech Optimizer
July 2, 2026

EDB named Forrester Leader in multimodel data platforms

EDB has been recognized as a Leader in Forrester's Multimodel Data Platforms evaluation for Q2 2026 for its EDB Postgres AI platform, receiving the highest scores in Vision, Innovation, Roadmap, and Partner Ecosystem. The platform is designed to manage mixed translytical and AI workload demands, offering flexibility in deployment across on-premises, hybrid, and multi-cloud environments. EDB's recent product update introduced agentic database and converged analytics functionalities, reportedly accelerating database tuning by up to tenfold and reducing analytics ownership costs by as much as 58%. The platform is supported by a partner ecosystem that includes Dell, IBM, NVIDIA, Red Hat, and Supermicro, which plays a crucial role in influencing database purchasing decisions. EDB's roadmap focuses on advancements in GPU-accelerated workloads, semantic intelligence, governance, and knowledge graph functionalities. The emphasis on sovereign deployment aligns with organizations' needs for control over sensitive data amidst stricter regulations.
Google Is Finally Giving Android Users The Backup Settings They Should Have Always Had
AppWizard
July 1, 2026

Google Is Finally Giving Android Users The Backup Settings They Should Have Always Had

Google is rolling out a per-app backup feature for Pixel devices, allowing users to control which specific apps are backed up to the cloud. This feature can be accessed through Settings > Accounts and backup > Google Backup > Other device data, where users can see the top three apps consuming space and toggle backups on or off for each app. Users can also view the backup size for each app and manage apps that currently have no data backed up. This update aims to give users clearer visibility and control over their Google cloud storage.
Search