data transfer Archives

Tech Optimizer

May 13, 2026

Databricks Syncs Postgres to Lakehouse Natively

Databricks has introduced Native Lakehouse Sync, currently in public preview, which enables direct replication of data from Lakebase Postgres into Unity Catalog managed tables, simplifying data transfer without traditional pipeline complexities. This feature operates natively within Lakebase, utilizing its Write-Ahead-Log (WAL) and requiring minimal setup time. It does not negatively impact Postgres performance or incur additional costs, and schema changes are automatically propagated. Native Lakehouse Sync supports agent-first development by scaling down when idle and integrating monitoring functions. Data transferred to Unity Catalog is immediately accessible for AI-native analytics and benefits from unified governance features. Every data operation is captured as SCD Type 2 history by default, facilitating compliance and audit processes. The setup of Lakebase and activation of sync is quick, allowing existing and future tables to be available in Unity Catalog within a minute.

Tech Optimizer

April 27, 2026

Bitdefender Total Security review: Tried and tested by an antivirus expert

Modern antivirus solutions have integrated various tools into a single interface, with Bitdefender exemplifying this trend. It features a dashboard for system scans, recommendations, and account management. The “Protection” section includes antivirus settings, online threat defense, and firewall options. Users can enable an anti-spam service for email applications like Outlook and Thunderbird. The privacy tab offers an anti-tracker browser plugin and a limited free VPN. Additional privacy features include video and audio protection to manage webcam and microphone access, and Safepay for secure online banking. Bitdefender also provides a desktop widget for protection status, secure file shredding, and remote device management options. In terms of performance, Bitdefender operates efficiently, using less than 100MB of RAM for its main interface, but can spike during full system scans. It successfully detected a trojan during a scan of a linked Google Drive account. Bitdefender effectively identified all test files in antivirus testing and enhances browser security by intervening when users ignore warnings. The application is easy to install, with a compact file size, and offers a Quick Scan feature that allows users to scan only applications after a thorough initial scan.

Winsage

April 16, 2026

Windows 11’s Recall tool has been cracked open again, and Microsoft doesn’t see that as a problem

Alexander Hagenah has developed a tool called TotalRecall Reloaded that exploits a vulnerability in Microsoft's AI feature, Recall, which manages data. Recall was designed to store AI-generated insights but was found to potentially store sensitive information in plain text, prompting Microsoft to delay its rollout. The vulnerability lies in AIXHost.exe, which lacks essential security measures, allowing unauthorized processes to extract sensitive data, such as decrypted screenshots and metadata, after user authentication via Windows Hello. Microsoft has downplayed the risks, asserting that existing security controls mitigate unauthorized access. TotalRecall Reloaded is available on GitHub for further exploration.

Tech Optimizer

April 15, 2026

Postgres to Iceberg in 13 minutes: How Supermetal compares to Flink, Kafka Connect, and Spark

Supermetal introduced Iceberg sink support, allowing for data transfer from Postgres to Iceberg. In a performance comparison, Supermetal completed snapshotting in 13 minutes, while Flink took 90 to 116 minutes, Kafka Connect required 120 minutes, and Spark exceeded 3 hours. The tests focused on throughput during the snapshotting phase rather than latency. The setup used the TPC-H dataset with a scale factor of 50 and involved AWS infrastructure. Supermetal operates independently of Kafka, enabling direct data delivery from source to sink. It utilizes a JSON configuration file for deployment, supporting various catalogs and advanced configuration options. Supermetal's Iceberg writer can adjust settings based on the CDC source phase. Throughout the tests, Supermetal maintained low CPU and memory usage, while other tools faced challenges with performance and resource management. Data synchronization was validated across all tools, with Supermetal achieving at least 7x faster snapshotting performance without tuning.

Tech Optimizer

April 8, 2026

PostgreSQL logical replication: How to replicate only the data that you need

Many organizations using PostgreSQL face challenges in replicating data across different logical databases while controlling shared information. PostgreSQL 15 introduces native logical replication with column-level and row-level filtering within publications, allowing precise control over data transfer between PostgreSQL databases. Logical replication operates on a publish-subscribe model, where the source database logs changes to the Write-Ahead Log (WAL) and applies publication filters to transmit only the relevant data to the target database. Two filtering modes are available: column-level filtering allows users to specify which columns to replicate, while row-level filtering uses WHERE clauses to determine which rows to include. Both filtering modes can be combined in a single publication. The SQL syntax for creating publications and subscriptions is consistent across various PostgreSQL environments, with specific configurations required for enabling logical replication. Use cases for logical replication include multi-tenant SaaS data isolation, regional data distribution for ecommerce, PCI DSS compliance in financial services, development and testing environments, and retail inventory management. Prerequisites for implementing logical replication include using PostgreSQL 15 or later, ensuring network connectivity, having a user with replication privileges, enabling logical replication on the source instance, and monitoring WAL retention. Logical replication has limitations, such as the need for a replica identity for UPDATE and DELETE operations, the non-replication of DDL changes and sequences, and potential performance overhead during initial synchronization and ongoing replication. After testing, it is advisable to clean up by removing replication resources to prevent unnecessary costs.

AppWizard

March 24, 2026

Evernote is getting even more expensive, so I’m ditching it and moving to this note-taking app

The author experienced frustration with Evernote due to unnecessary AI features, stability issues, and unreliable syncing after over a decade of use. A price hike in 2026 prompted a search for alternatives. The author found Notesnook to be a suitable replacement after resolving a previous issue with its search function, allowing for seamless data transfer from Evernote. Notesnook offers automatic syncing across devices, a user-friendly interface, robust security, and an open-source foundation. It has a free tier with limitations, an Essential tier at .99 monthly or .99 annually, and a Pro tier at .99 monthly or .99 annually, all featuring end-to-end encryption. Notesnook's pricing is considered reasonable compared to Evernote's higher fees.

AppWizard

March 12, 2026

This small change makes transferring data to your new Android phone a lot easier

The Android data transfer feature allows users to migrate data from an old device to a new one, taking under an hour for setup. Google introduced enhancements, including a QR code for sharing network details and a percentage indicator for data transfer progress. Recently, a user experienced a 20-minute estimated transfer time, with the transfer showing 54% completion after some time. A USB-C to USB-C cable is recommended for reliable connections, though wireless data migration is also effective. Android's data transfer may not be as fast as some Chinese manufacturers' tools, but it provides consistency across global smartphones.

Tech Optimizer

February 27, 2026

Replicate spatial data using AWS DMS and Amazon RDS for PostgreSQL

The process of migrating spatial data from self-managed PostgreSQL, Amazon RDS for PostgreSQL, or Amazon Aurora PostgreSQL-Compatible Edition to Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition using AWS Database Migration Service (AWS DMS) is outlined. Spatial data includes points, lines, polygons, and collections of these features, which are essential for applications like mapping and asset tracking. AWS DMS treats spatial columns as large objects (LOBs) and requires proper configuration for LOB handling and PostGIS support to avoid migration failures. PostGIS is an extension for PostgreSQL that manages geospatial data types and functions, enabling operations such as radius searches and distance calculations. Amazon RDS for PostgreSQL fully integrates with PostGIS, making it suitable for geospatial applications. The migration solution involves ensuring compatibility of PostGIS versions between source and target databases, configuring AWS DMS, and validating the migration. Prerequisites include having an AWS account, RDS instances for source and target, a DMS replication instance, and the PostGIS extension installed on both databases. Tables must have primary or unique key constraints, and geometry columns must be nullable for LOB handling. Best practices for configuring PostGIS include validating version compatibility, monitoring resource usage, and establishing backup strategies. Implementation steps involve creating a spatial table in the source database, preparing the target database, configuring the AWS DMS task with specific settings, and monitoring the migration process through CloudWatch logs. Common errors during replication may relate to LOB handling or PostGIS data types. Post-migration validation includes comparing row counts, verifying geometry data types, and ensuring the functionality of PostGIS spatial functions. Finally, it is recommended to clean up all resources post-migration to avoid ongoing charges.

Tech Optimizer

February 24, 2026

Hackers Are Using Fake Invitations to Take Over Your PC

Cybercriminals are sending counterfeit email invitations that, when clicked, install a backdoor on the victim's computer, allowing hackers full control. The scam often involves downloading a file named “invites.msi,” which is a Windows Installer package. This file can install ScreenConnect, a legitimate remote support tool that can be exploited by attackers to monitor screens, access files, and deploy additional malware. Many security engines fail to flag this software as malicious, making it difficult to detect. If someone suspects they have fallen victim to this scam, they should disconnect from the internet, check for and uninstall any remote management software, run a comprehensive antivirus scan, change passwords for critical accounts, enable two-factor authentication, inform their IT department if applicable, and consider performing a full Windows reset. The scam originated from a compromised email account, which was used to send the malicious link to contacts. Implementing two-factor authentication and using a password manager can help prevent such incidents. Users should be cautious of any email invitations that require downloading and running installer files.

Tech Optimizer

February 14, 2026

PostgreSQL vs MySQL: Which Database is Better in 2026?

PostgreSQL 17 introduces significant enhancements, including refined memory management in VACUUM processes, improved SQL/JSON capabilities with features like JSON_TABLE(), advancements in logical replication and parallel processing, and overall increased efficiency for handling complex queries and large datasets. MySQL, under Oracle's stewardship, focuses on performance, reliability, and cloud integration, with updates unveiled at the HeatWave Summit in 2025 that support both transactional and analytical workloads in a unified system, enabling real-time analytics without data transfer to separate tools.