data storage Archives

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.

Tech Optimizer

June 25, 2026

The database storage problem is solved. Here’s what comes next.

Postgres has been a reliable transactional database for three decades, used for managing customer records and financial transactions. Innovations in the Postgres ecosystem are now focused on minimizing data movement rather than just data storage. The challenge of interoperability is becoming crucial, as organizations seek to share operational data seamlessly across various systems without creating additional copies or pipelines. Many organizations are spending as much effort on data movement as on data storage. Postgres is increasingly viewed as the authoritative system for critical information, and its role is evolving to facilitate better interaction with operational data. Technologies like logical replication and change data capture are enhancing Postgres's integration within data ecosystems. The rise of AI has highlighted the need for real-time access to operational data and has prompted organizations to reconsider the necessity of maintaining multiple copies of the same data. The database industry is shifting focus from optimizing storage to enabling effortless data sharing across systems. Postgres continues to adapt to new workloads and architectural patterns, maintaining its reputation as a stable foundation for operational data while expanding its capabilities through innovative extensions.

Tech Optimizer

June 22, 2026

The database that refused to die: How Postgres survived its own creators

Postgres, originally developed by Michael Stonebraker in the early 1980s, is an open-source database system that evolved from Ingres. It was designed to handle complex data types and introduced user-defined data types, operators, and functions, leading to the support for abstract data types (ADTs). The initial commercialization of Postgres occurred through a startup named Illustra, later acquired by Informix. In 1995, graduate students Andrew Yu and Jolly Chen revived Postgres, transitioning it from QUEL to SQL, resulting in Postgre95, which evolved into PostgreSQL. Today, Postgres is one of the most popular database systems globally, known for its extensibility and high code quality. However, it currently lacks features like file-level encryption (TDE), which are standard in commercial systems, relying instead on the operating system for encryption. Efforts to implement TDE have faced challenges due to the complexity of required code changes.

AppWizard

June 21, 2026

The Useful Privacy Feature That Isn’t Enabled By Default On Your Android Phone

Private Space is a privacy feature available on Pixel and select Android devices, while Secure Folder is exclusive to Samsung devices. Both create a secure area within the smartphone for sensitive applications and data storage, operating independently from the primary user profile. Users can install apps and store files in these secure spaces without compromising their main profile's integrity. To activate Private Space, users navigate to Settings > Security and Privacy > Private Space, requiring a Google Account sign-in and a unique lock. For Samsung devices, the path is Settings > Security and Privacy > More Security Settings > Secure Folder, requiring a Samsung account. Private Space cannot be used on managed devices or with supervised accounts, and only the primary user can manage these secure areas. The Private Space or Secure Folder icon can be hidden for added security. The private area is distinctly separated from the core user profile, preventing open communication between the two spaces to safeguard against data harvesting. Android allows granular control over app permissions, and users are advised to isolate questionable apps within Private Space or Secure Folder to protect sensitive information.

Tech Optimizer

May 25, 2026

How to create a Metabase dashboard with Docker

Creating a self-hosted analytics dashboard using Metabase and Docker involves deploying the Metabase container, which integrates with PostgreSQL for data storage. The prerequisites include a server or local machine with Docker, terminal access, an available port (typically 3000), a PostgreSQL database, and connection details for the business database. The installation steps are as follows: 1. Pull the Metabase Docker image using `docker pull metabase/metabase:latest`. 2. Run the Metabase container with `docker run -d -p 3000:3000 --name metabase metabase/metabase`. 3. Verify the container operation using `docker ps` and check logs with `docker logs -f metabase`. 4. Access the Metabase setup wizard at `http://localhost:3000` or `http://your-server-ip:3000`. 5. Manage the Metabase container using `docker stop metabase`, `docker start metabase`, and `docker restart metabase`. For a production setup, it is recommended to integrate PostgreSQL for persistent storage. Steps include creating a project directory, a Docker Compose file, launching both Metabase and PostgreSQL containers, monitoring logs, accessing Metabase, managing the deployment with Docker Compose commands, and updating Metabase by pulling the latest image. To create a business intelligence dashboard, connect your business data source by selecting the database type and entering connection details. Create questions using the visual query builder or SQL, choose suitable visualizations, compile saved questions into dashboards, add filters for interactivity, and share the dashboard with stakeholders while managing permissions.

Tech Optimizer

May 22, 2026

AI Data Platform Modernization in Financial Services | Microsoft Azure PostgreSQL | The Microsoft Cloud Blog

Financial service institutions are increasingly exploring AI applications to alleviate operational burdens and gain a competitive edge, but face challenges with legacy data infrastructures that may not meet modern demands. The need for continuous availability and compliance is critical, as even brief downtime can have catastrophic consequences. Aging databases struggle with high-volume transactions and real-time analytics, prompting a focus on predictive maintenance and infrastructure automation. Microsoft Azure's PostgreSQL managed services, including Azure Database for PostgreSQL, address these challenges by providing flexible performance scaling and ensuring high availability. The service can trigger automatic failover within 60 to 120 seconds during outages, guaranteeing up to a 99.99% availability SLA. It supports read replicas for offloading analytics without impacting primary database performance and offers layered security controls, including encryption at rest and network isolation. Azure Database for PostgreSQL simplifies compliance with standards such as PCI DSS and SOC by enabling centralized identity and access management through Microsoft Entra ID authentication. It integrates seamlessly with the Microsoft ecosystem, allowing organizations to connect data to analytics and AI services without complex ETL processes. BNY Mellon successfully modernized its data platform by migrating to Azure Database for PostgreSQL in nine months, achieving improved resilience and allowing engineering teams to focus on innovation. The platform supports high availability, backup capabilities, and extensibility, empowering financial institutions to remain innovative in the era of AI.

Tech Optimizer

May 16, 2026

Chamber Perk: O’Brien Technologies Emphasizes Education and Protection

O’Brien Technologies has launched a program called “Educate and Protect” to improve cybersecurity for businesses by addressing the human factor in breaches. They highlight that many cyber threats arise from human errors, such as clicking phishing links or misunderstanding data storage protocols. The company points out that cloud services do not automatically protect files without robust backup systems and that small businesses are often more vulnerable due to a lack of comprehensive security measures. They stress the inadequacy of relying solely on outdated tools like firewalls and antivirus software and advocate for a multi-layered cybersecurity approach. O’Brien Technologies recommends regular employee training, staying informed about threats, and ongoing commitment to cybersecurity. They offer tailored guidance for businesses looking to enhance their cybersecurity. Interested parties can contact them at 661-432-1301 or visit obrienmsp.com.

AppWizard

May 7, 2026

Local Data Security with Android Keystore

Threema, a secure messaging application, prioritizes user privacy by avoiding server-side storage and ensuring that message content remains on users' devices. On Android, it utilizes the Keystore for secure cryptographic key management, storing data in an app-specific directory to isolate it from other applications. All stored data is encrypted, making it unreadable without the appropriate key. The Android Keystore allows for key generation without direct access to raw data, enhancing security by performing cryptographic operations internally. Modern devices with dedicated security chips provide hardware-backed security, while older devices rely on a software-backed Keystore, which is more vulnerable. Threema offers users the option to set a passphrase, adding an extra layer of protection by encrypting data before it is stored in the Keystore. This multi-layered security strategy adapts to the device's capabilities.

Tech Optimizer

May 7, 2026

What Is Endpoint Detection and Response?

Traditional endpoint security measures, such as antivirus software and firewalls, are increasingly ineffective against sophisticated cyberattacks, which can bypass these defenses. Endpoint Detection and Response (EDR) is a solution that emphasizes rapid detection and containment of threats, continuously monitoring endpoint activity and identifying suspicious behavior in real time. EDR platforms gather data from all connected endpoints and utilize AI-driven analytics to detect both known and unknown threats. In 2024, over 97 billion exploitation attempts were recorded, underscoring the need for robust endpoint protection. EDR tools operate in four stages: detection, containment, investigation, and elimination of threats. They collect telemetry data from endpoints to establish a baseline of normal activity, enabling the identification of anomalies that may indicate a threat. EDR can automatically isolate affected endpoints, terminate malicious processes, and execute remediation actions. EDR employs two methods for threat detection: comparing endpoint activity against indicators of compromise for known threats and using behavioral detection models for unknown threats. The system can generate reports on threat activity and response effectiveness, aiding compliance and operational decision-making. The telemetry data collected is stored in a centralized repository, supporting threat-hunting initiatives. Organizations that deployed EDR in 2024 experienced an average breach cost that was significantly lower than those that did not. EDR minimizes security blind spots, reduces the attack surface by identifying vulnerabilities, speeds up investigations and responses, blocks new threats through behavioral analysis, and strengthens other security measures when integrated with existing tools. Challenges in EDR implementation include alert fatigue, integration complexity, resource constraints, and limited scope. When choosing an EDR solution, organizations should prioritize features such as real-time threat detection, automated response capabilities, behavioral analysis, offline protection, low performance impact, and integration with existing tools. EDR functions effectively as part of a layered security strategy, complementing other tools like Endpoint Protection Platforms (EPP) and Extended Detection and Response (XDR). EDR focuses on endpoint activity, while EPP serves as a first line of defense against common threats, and XDR broadens the scope to include network traffic and cloud workloads. VPNs encrypt network traffic, providing an additional layer of protection for data in transit.

Tech Optimizer

April 17, 2026

Why Postgres wants NVMe on the hot path, and S3 everywhere else

Efforts to merge storage roles into a single solution are ongoing, particularly with Amazon S3's durability and cost-effectiveness. In PostgreSQL, achieving a durable commit requires flushing the Write-Ahead Log (WAL) before signaling transaction completion, which can take tens of microseconds on high-performance NVMe drives but extend to milliseconds on slower storage. This latency impacts Online Transaction Processing (OLTP) systems and user response times. Benchmark studies show that systems with faster local storage outperform those with slower alternatives as workloads exceed memory capacity. The fsync operation in PostgreSQL is a commitment rather than a simple write, with enterprise-grade SSDs performing better due to power-loss protection. Read operations also face challenges, as PostgreSQL's need for small, latency-sensitive reads conflicts with S3's design for larger, higher-latency requests. As the working set exceeds memory, storage latency becomes a critical performance factor. Modern managed PostgreSQL systems typically do not place object storage in the critical commit path, instead maintaining a fast log or cache close to the database while relegating colder data to remote storage. Recent PostgreSQL developments, such as asynchronous I/O support in version 18, aim to leverage fast storage more effectively. S3 is valuable for tasks like WAL archiving and backups, but these should be kept separate from the commit path to avoid resource contention. The solution involves using both NVMe and S3, with fast storage managing commits and cache misses, while object storage handles archives and backups. PostgreSQL performs best when hot and cold storage functions are clearly delineated.