discussion Archives

Tech Optimizer

July 9, 2025

Query Amazon Aurora PostgreSQL using Amazon Bedrock Knowledge Bases structured data

Amazon Bedrock Knowledge Bases has introduced a fully managed Retrieval Augmented Generation (RAG) feature that connects large language models (LLMs) with internal data sources, enhancing the relevance and accuracy of responses by integrating contextual information from private datasets. During AWS re:Invent 2024, it was announced that this feature now supports natural language querying for structured data retrieval from Amazon Redshift and Amazon SageMaker Lakehouse, allowing generative AI applications to access both structured and unstructured data sources. The system converts user queries into SQL queries using natural language processing, enabling data retrieval without requiring users to know SQL syntax. Amazon Bedrock Knowledge Bases currently supports structured data retrieval from Amazon Redshift and SageMaker Lakehouse. Although direct support for Aurora PostgreSQL-Compatible is not available, users can utilize zero-ETL integration between Aurora PostgreSQL-Compatible and Amazon Redshift to make their data accessible. This integration replicates Aurora PostgreSQL tables to Amazon Redshift in near real-time, simplifying data management. To enable natural language querying of structured application data stored in Aurora, organizations can set up an Aurora PostgreSQL database, create a schema with interconnected tables (products, customers, and orders), and populate these tables with sample data while maintaining referential integrity. Subsequently, they can establish zero-ETL integration with Amazon Redshift, which involves creating a Redshift Serverless workgroup and mapping the database for synchronization. Once the zero-ETL integration is verified, organizations can create an Amazon Bedrock knowledge base for natural language querying. This requires granting appropriate permissions to the Amazon Bedrock Knowledge Bases AWS Identity and Access Management (IAM) role and ensuring the knowledge base is synchronized with Amazon Redshift. After setting up the knowledge base, users can execute natural language queries, which are translated into SQL and processed to generate human-readable responses. Examples of queries include counting unique customers and identifying customers who have purchased the most products. Finally, it is recommended to clean up resources after use to avoid ongoing charges.

AppWizard

July 8, 2025

‘bitchat’ Jack Dorsey’s New Side Project Is A Bluetooth Messenger App; The Internet Begs ‘No More Chatting Apps’

Jack Dorsey, former CEO and co-founder of Twitter, is developing a Bluetooth-based messaging application called Bitchat, which enables communication without internet connectivity, Wi-Fi, or cellular service, using peer-to-peer connections over distances up to 300 meters. The app is currently in the testing phase on TestFlight, which has reached its capacity of 10,000 users. Dorsey has expressed interest in learning about Bluetooth mesh networks and related technologies through this project. The app has sparked discussions about mesh networks and resilient communication, but it has also received mixed reactions, with some users expressing skepticism and concerns about potential misuse.

Winsage

July 8, 2025

Windows 11 Hits 50 Percent Market Share … Almost Four Years After It’s Release

Windows 11 has achieved a market share of 50.24%, while Windows 10's market share has declined to 46.84%. The end-of-life date for Windows 10 is October 14, prompting many corporate clients to transition to Windows 11 or Windows 365, which offers complimentary access to extended security updates. Companies are weighing the costs of extended security updates against upgrading hardware. Retail vendors are facing challenges with an oversupply of computers, as consumers are hesitant to invest in new AI-enhanced models.

AppWizard

July 8, 2025

Bitchat Is a New Messaging App Which Works Without Phone Numbers

Jack Dorsey has introduced Bitchat, a decentralized messaging application that operates using Bluetooth Low Energy (BLE) mesh networks for peer-to-peer messaging without traditional internet connectivity. Bitchat features end-to-end encryption for security, operates independently of the internet, and allows users to send messages over a range of more than 300 meters. Each device functions as both a client and server, enabling multi-hop message delivery. Messages are ephemeral by default, with a caching feature for recipients who are temporarily unavailable. Regular messages last 12 hours, while favorites are retained indefinitely. Bitchat does not require phone numbers or email addresses, enhancing user privacy, and includes features such as mentions and topic-based discussion rooms that can be password-protected. The app is currently in beta testing via Apple's TestFlight program.

AppWizard

July 7, 2025

Google Gemini app gains automatic Android access to phone and messaging data

On July 7, 2025, Google Gemini app users experienced automatic activation of permissions for accessing phone calls, messaging services, WhatsApp, and system utilities on Android devices, following a privacy policy update on June 11, 2025. This change affects millions of users globally and allows user data to be reviewed by humans for AI training. Users can disable these permissions through the app's settings, but the option to opt-out is criticized for being difficult to find. Legal experts have raised concerns about compliance with GDPR regulations due to the lack of explicit user consent for these changes. The data collected supports machine-learning development and may be retained for up to three years, even after users delete their activity.

Tech Optimizer

July 7, 2025

Percona offers clear view into Transparent Data Encryption

Percona has launched its Transparent Data Encryption (TDE) extension for PostgreSQL, designed to secure sensitive data at rest without licensing fees or usage restrictions. TDE automatically encrypts and decrypts data at the database layer, protecting backups and transaction logs, with encryption keys stored separately. The pg_tde extension supports compliance with regulations like GDPR, HIPAA, SOX, and PCI DSS v4.0, and allows users to encrypt all database files, apply encryption at the table level, and maintain control over their encryption strategies. It integrates with Key Management Services (KMS) providers and requires a patched PostgreSQL server to function. Percona aims to extend pg_tde to Community PostgreSQL, with some code already contributed for review. The extension is included in the Percona Distribution for PostgreSQL, which also offers support and consulting services for TDE setup and configuration.

AppWizard

July 5, 2025

RoboCop: Rogue City’s expansion will let you play as ED-209, but I’m more excited about having some guns I might use instead of the Auto 9

RoboCop: Rogue City, a first-person shooter developed by Teyon, was released in 2023 and is noted for its reliance on RoboCop's Auto 9 weapon, which overshadowed other firearms. An upcoming expansion titled Unfinished Business will introduce new weapons, including a minigun and an experimental cryo-cannon, and will allow players to control various characters, including ED-209 and flashbacks of Murphy as a police officer. The expansion is set to release on July 17.

Winsage

July 4, 2025

I don’t care that Microsoft is extending Windows 10’s support, I’m still moving to Linux

Microsoft has announced free options for Windows 10 users to extend support, initially expected to require an annual fee. However, many users are still planning to transition away from Windows. Microsoft will eventually phase out Windows 10, pushing users towards Windows 11. The company aims to encourage upgrades to new hardware and software, which may lead to increased advertisements within Windows 10. Users considering the free security extension have options like syncing settings to OneDrive or redeeming Microsoft Rewards points, but these may not appeal to those planning to switch to Linux. Linux Mint is presented as a more exciting alternative, offering continuous updates and a vibrant community, attracting users looking for a dynamic computing experience.

AppWizard

July 1, 2025

Austria wants to let police and prosecutors break into suspects’ messenger apps

Austrian authorities are planning to enhance surveillance capabilities, allowing prosecutors and police to monitor encrypted communications of suspects, primarily to combat terrorism. This initiative, proposed by Interior Minister Gerhard Karner, is supported by public prosecutors and the federal criminal police, following a school shooting in Graz that claimed ten lives. The proposal includes a "federal trojan" software tool for monitoring social media and messaging platforms. However, it has faced opposition from NGOs and political parties, particularly regarding the expansion of surveillance beyond terrorism to include ordinary crimes. Justice Minister Anna Sporrer stated there are no immediate plans for such an expansion, but future discussions may occur after a trial phase. Opposition figures have criticized the proposal as a significant shift in surveillance policy.

Tech Optimizer

July 1, 2025

Industry Exchange Data 2025: EDB’s Jeremy Wilson on how to secure your data (Psst: Secure your database)

All software is susceptible to security vulnerabilities, but open-source solutions can enhance defenses against cyber threats, according to Jeremy Wilson, CTO for the North America public sector at EDB. He noted that the global community continuously inspects open-source code, leading to fewer issues and quicker resolutions. EDB's PostgreSQL database product is designed for online transaction systems, data warehousing, and analytics, incorporating security enhancements and performance improvements. EDB synchronizes its release cycles with the open-source community and aims to meet regulatory requirements, including obtaining FedRAMP High certification. EDB collaborates with Red Hat to implement security controls and has integrated features like transparent data encryption and APIs to support zero trust cybersecurity initiatives. Wilson acknowledged challenges agencies face when transitioning to open-source solutions, including legacy systems and regulatory compliance hurdles. EDB aims to provide a turnkey enterprise database that simplifies the migration of applications, ensuring compliance with FIPS 140-3 and DISA STIGs.