Xreal announced the launch of its Aura smart glasses with Google's Android XR and Qualcomm's Snapdragon Reality Elite, featuring a 70-degree FOV, hand-tracking, and strong multimodal AI.
The Commodore Callback 8020 flip phone features essential tools like WhatsApp, Google Maps, Spotify, and a camera app, but lacks a web browser and social media applications. It has a 1,550 mAh removable battery, a 3.5 mm headphone jack, a 3.25-inch display with touch input disabled by default, a MediaTek Helio G81 processor, 4 GB of RAM, and 64 GB of expandable internal storage. The main camera is 48 megapixels, and it includes an LTE modem. Pre-orders start on June 30, with prices set at for classic models, 9 for the blue or Starlight Edition, and 9 for the gold Founders Edition. Prices may incur additional fees, and delivery is expected in the fourth quarter of 2026.
Meta AI is integrated into WhatsApp, Instagram, Facebook, and Messenger, providing functionalities like chat, search, image generation, and automated customer support through the Meta Business Agent. Its availability varies by country, account type, app version, and language. Users should be aware that seeing a colleague's blue Meta AI ring in WhatsApp while they do not may indicate a rollout flag on Meta's end rather than an app malfunction.
Meta AI can answer queries, suggest ideas, generate images from prompts, clarify messages, assist with searches, and support customer interactions for business accounts. It is linked to the Llama model family, including Llama 2 and Llama 3.
To use Meta AI on WhatsApp, users need to update the app and can start a chat by locating the Meta AI button or circle. They can ask practical questions, request image generation, and utilize it in group chats. On Instagram, it enhances DMs and search functions, allowing users to create AI chats for content ideas and captions. In Messenger, there is an "Ask Meta AI" bar for direct interactions. Users can also utilize Meta AI on Facebook for search and content discovery.
The Meta Business Agent is a version of Meta AI for businesses, providing 24/7 responses to customer inquiries. It can be set up in Meta Business Suite or WhatsApp Business. Privacy measures should be considered, as users cannot entirely disable Meta AI and should avoid sharing sensitive information in chats.
For better responses, users should provide context and constraints in their prompts and consider training in prompt design and AI risk management for professional use.
CEO Asha Sharma discussed Project Helix, the upcoming Xbox console, emphasizing a focus on affordability and flexibility amidst rising component costs, which have increased nearly threefold. Xbox Chief Strategy Officer Matthew Ball highlighted the team's commitment to rethinking every aspect of Helix while addressing challenges in hardware production due to the current economic landscape.
Asha Sharma, CEO of Xbox, discussed Project Helix, the next-generation console, during a conversation at Fortune Conversations. Matthew Ball, Xbox Chief Strategy Officer, indicated a reevaluation of the console's direction, emphasizing a commitment to innovation and affordability. Sharma described Project Helix as a "top-tier premium offering" that will support PC gaming, feature backward compatibility, and deliver high performance, while also addressing challenges related to rising component costs. The gaming community is actively discussing these developments on Reddit.
The Gothic Remake offers a deeper gaming experience but has received criticism for its lockpicking system, which players find tedious. Alkimia Interactive is aware of the feedback and notes that investing skill points can improve the experience. Mods like "Unlock All Chests and Doors" and "Lockpick Settings" are available to help players manage the lockpicking mechanic. Players are also using mods to enhance performance and identify interactable objects in the game. Installing these mods requires downloading files into the game’s directory and launching the game with administrative privileges.
An enthusiast began collecting video game and anime soundtrack vinyl with a four-disc box set of Sekiro: Shadows Die Twice, which featured both music and stunning interior artwork. The collection expanded to include soundtracks from titles like Dark Souls 3, Bloodborne, Demon's Souls Remake, Total War: Three Kingdoms, The Banner Saga, Outer Wilds, Hollow Knight, Baldur's Gate 3, Dishonored, and Persona 5. The collector values the ritual of listening to vinyl, which offers a mindful experience compared to streaming music. They browse sites like Black Screen Records and iam8bit for new releases while being mindful of shipping costs. The collector transitioned from an Audio Technica turntable to a portable Sound Burger for added fun and functionality. Common mistakes include buying soundtracks for games played extensively, which can diminish enjoyment. Storage solutions vary, with some using stylish crates or portable cases. Limited pressings make many soundtracks coveted collector's items, and the collector regrets missing Supergiant's 10th anniversary collection. They hope for future releases, particularly for Silksong.
pg_dump is a utility for exporting a PostgreSQL database into a file, which can be restored on the same or different servers. It exports a single database's tables, views, sequences, functions, indexes, triggers, and in-database grants but does not include roles, tablespaces, or server-level configurations. To capture global objects, pg_dumpall --globals-only should be executed prior to the per-database dump. pg_dump requires CONNECT and SELECT privileges on all tables and sequences within the target database, and a dedicated backup role is sufficient for single-database dumps, while superuser access is needed for global objects.
pg_dump supports various output formats: plain SQL (.sql), custom binary (.dump), directory of files, and tar archive (.tar), each with different capabilities for restoration and compression. The custom format allows for selective and parallel restoration. For non-interactive use, credentials can be stored in a .pgpass file or passed via the PGPASSWORD environment variable.
Restoration methods depend on the dump format: psql is used for plain SQL files, while pg_restore is used for custom and directory formats. The restoration process requires the target database to be created beforehand. Version mismatches between pg_dump and pg_restore can lead to failures, so it's essential to ensure that the binaries are version-matched.
In Docker, pg_dump and pg_restore can be executed within containers, but care must be taken to manage credentials and ensure version compatibility. Exit codes from pg_dump should be checked to confirm successful operations.
PostgreSQL has become the most utilized database for developers for two consecutive years as of 2026, while SQL Server has introduced native AI capabilities and vector search functionalities in its latest release. PostgreSQL is favored for new projects due to its permissive licensing, cross-platform operation, and extensive ecosystem of extensions, whereas SQL Server is preferred by organizations already using Microsoft products for its robust tooling and enterprise support.
As of June 2026, SQL Server ranks third in the DB-Engines popularity ranking with a score of 698, while PostgreSQL ranks fourth with a score of 688. Developer adoption trends show that 49% of respondents in the Stack Overflow 2024 Developer Survey use PostgreSQL, compared to 27% for SQL Server.
The latest stable version of PostgreSQL is 18.4, released on May 14, 2026, while SQL Server 2025 (version 17.x) became generally available on November 18, 2025. PostgreSQL is free under a permissive license, while SQL Server's Enterprise Edition can cost upwards of ,123 per two-core pack, with an eight-core minimum.
PostgreSQL supports various operating systems, including Linux, Windows, macOS, and BSD, while SQL Server operates on Windows and Linux. PostgreSQL uses PL/pgSQL as its primary procedural language, allowing for multiple procedural languages, whereas SQL Server uses T-SQL. PostgreSQL's JSONB type offers rich indexing, while SQL Server added native JSON support in its 2025 release.
Both databases are capable of handling high transaction volumes, but PostgreSQL excels in read-heavy scenarios due to its multi-version concurrency control, while SQL Server's columnstore indexes provide advantages for analytical workloads. PostgreSQL supports tables up to 32 TB, while SQL Server can handle a maximum database size of 524 PB.
SQL Server's high availability technology includes Always On Availability Groups, while PostgreSQL offers built-in streaming and logical replication. The security features of both databases meet enterprise standards, with PostgreSQL providing a transparent patching process and SQL Server integrating with Microsoft tools.
Real-world usage examples include Stack Overflow using SQL Server, while Instagram and Reddit utilize PostgreSQL. Developer sentiment increasingly favors PostgreSQL for new projects, emphasizing flexibility and open-source solutions.
For new startups or greenfield projects, PostgreSQL is recommended due to its zero license cost and compatibility. Existing Microsoft enterprises are advised to stick with SQL Server for its integration benefits. Migration from SQL Server to PostgreSQL is becoming common, with a structured approach required for successful transitions.
A vulnerability in several Microsoft 365 Android applications, identified as FlagLeft, was caused by a development flag left enabled in production builds, which disabled checks meant to restrict account-token sharing to trusted applications. This flaw affected applications such as Word, PowerPoint, Excel, Microsoft 365 Copilot, Microsoft Loop, and OneNote, allowing unauthorized apps to request and obtain user tokens without permission. Microsoft Teams was unaffected. The vulnerability was demonstrated by Enclave, allowing access to user emails through an unverified app. On May 12, Microsoft issued four CVEs for the affected applications, categorized under improper access control. The patched version of Word for Android is 16.0.19822.20190, and users are advised to update their applications. The patch does not invalidate already compromised tokens, so users should revoke these tokens and sign in again.
