application

Tech Optimizer
June 20, 2026
PostgreSQL version 18 has deprecated MD5 password authentication in favor of SCRAM-SHA-256, with a new parameter, md5_password_warnings, enabled by default to log deprecation warnings. It has enhanced monitoring capabilities by adding columns to pg_stat_database and pg_stat_statements to track parallel worker activity, with the default max_parallel_workers_per_gather set to 0 in Aurora PostgreSQL. The pg_stat_subscription_stats view now includes new columns for tracking conflict types in logical replication. Optimizer statistics are automatically transferred during upgrades, while uuidv7() generates timestamp-ordered UUIDs. The default streaming option for CREATE SUBSCRIPTION has changed to parallel, and the idle_replication_slot_timeout parameter automatically invalidates inactive replication slots. Enhancements to the COPY command include REJECT_LIMIT for error tolerance and a silent LOG_VERBOSITY level. OLD and NEW aliases have been introduced in RETURNING clauses for various DML commands.
Winsage
June 20, 2026
Microsoft has introduced two versions of Outlook in Windows 11: Outlook Classic (a Win32 desktop application) and the New Outlook. Users have reported significant performance issues with the New Outlook, noting a lag of approximately 10 seconds for tasks that Outlook Classic performs instantly. The New Outlook operates on WebView2, which involves multiple processes and higher memory consumption, while Outlook Classic runs as a single process. Microsoft is aware of these performance challenges and is testing a new API called 'Delayed Message Timing' to address them. Users find Outlook Classic to be more reliable and faster, particularly for businesses that need efficient notification processing.
AppWizard
June 20, 2026
Samsung has redesigned its health tracking application, Samsung Health, coinciding with the launch of the Galaxy Watch 9 and One UI 9. The new interface features a vibrant color palette that some users find overwhelming, as colors no longer correspond to specific health metrics. The app includes a new top shortcuts bar for easier navigation to core health aspects like Activity, Sleep, Vitals, Mindfulness, and Nutrition, and allows customization of the dashboard. Graphs have been improved with pinch-to-zoom functionality, but this feature is inconsistently applied across different metrics. The app lacks a comprehensive graph page for comparing multiple metrics and may present unsupported features for users of older devices like the Galaxy Watch 4.
Tech Optimizer
June 20, 2026
NordVPN has introduced a revamped application, new subscription plans, and an antivirus upgrade called Threat Protection Pro, which detects 96% of phishing attempts according to AV-Comparatives. The Complete plan has a price drop of 75%, now costing .49 per month with three complimentary months, allowing users to secure up to ten devices. Key features of NordVPN Complete include ID theft protection, scam call protection, malware protection, a password manager (NordPass), and 1 TB of cloud storage (NordLocker). All plans come with a 30-day money-back guarantee. Threat Protection Pro achieved a 99% score in an independent test by Turtlecute, effectively blocking trackers and detecting malware. Not all plans include antivirus protection; the Basic plan offers VPN access without additional features, while NordVPN Prime provides enhanced ID protection through Coveron.
Tech Optimizer
June 20, 2026
pgEdge ColdFront is a data tiering solution for PostgreSQL that allows seamless access to hot and cold storage without changing application code, reducing storage costs by up to 90%. The cold tier is writable, enabling operations like UPDATE and DELETE on archived rows using standard SQL commands. ColdFront automatically migrates older data to Apache Iceberg in Parquet format, compatible with S3-compatible object stores, while maintaining full accessibility through a single Postgres table name. It enhances performance with the DuckDB vectorized columnar engine, achieving 10-100x faster analytical performance on cold data. ColdFront simplifies data management by automating the movement of cold data to cost-effective storage, addressing challenges like increased storage costs and operational complexities. It allows for compliance tasks, such as GDPR deletion requests, to be executed with a single SQL statement. Key features include a directly writable cold tier, no application changes required, open-source operation, automated partition lifecycle management, cost-effective operations, and distributed access in multi-master clusters. ColdFront is beneficial for sectors like SaaS, IoT, and regulated industries, and is currently available as a production-grade beta, set to be integrated into pgEdge Cloud in the second half of 2026.
Tech Optimizer
June 20, 2026
The dashboard operates on a Django monolith with PostgreSQL and is transitioning to ClickHouse for denormalization. The initial p50 metric was 0.7 seconds, but the p95 was 8 seconds, which was reduced to 1 second. Observability tools were established to monitor performance, and slow HTTP requests were identified using OpenTelemetry traces. Optimization techniques included late joining, asynchronous counting, creating a PostgreSQL replica for read operations, and improving full-text search. Denormalization was explored to enhance filtering performance by creating composite indexes. The production stack was upgraded to PostgreSQL 18, which provided incremental performance improvements. The final p95 value achieved was 1 second, below the target of 3 seconds.
Tech Optimizer
June 20, 2026
Inference is becoming crucial in enterprise AI, presenting challenges in data transport to compute environments, which can increase costs and security risks. Enterprises aim to maintain data integrity and avoid multiple copies. Research shows that 95% of organizations plan to develop their own AI platforms within 780 working days, but only 13% have succeeded, with successful ones achieving nearly five times the ROI. Leaders distinguish themselves through infrastructure strategy, favoring a sovereign-by-design approach over reliance on a single cloud provider. Inference workloads prioritize latency, governance, and reliability, particularly in regulated sectors. Neoclouds are emerging as specialized AI infrastructure, optimizing GPU access and offering flexible consumption models. Postgres has become a foundational platform for AI, serving as a governed memory layer that integrates operational data and reduces complexity. Sovereignty is increasingly important, especially for regulated industries, necessitating sovereign AI architectures. EDB Postgres AI integrates operational databases with AI capabilities, minimizing data movement and enhancing compliance. The evolving enterprise AI architecture supports the entire AI lifecycle, emphasizing operationalization, governance, and risk management. Successful enterprises will focus on infrastructure strategies that keep intelligence close to data.
Tech Optimizer
June 19, 2026
Postgres has introduced new functionalities, including UPDATE and DELETE FOR PORTION OF, enhancing temporal use cases. The expansion of RANDOM() temporal functions is attributed to Paul Ramsey and Greg Sabino Mullane. Version 19 includes performance improvements in the planner and executor components, with contributions from Tom Lane. Key enhancements include refinements in anti-joins and semi-joins, constant folding optimizations, incremental sorting with append paths, enhanced aggregate processing prior to joins, improved join selectivity computation, and more comprehensive function statistics. These changes allow Postgres to better understand query structures, reducing unnecessary processing. The visibility of memoization in EXPLAIN has improved, sort performance has benefited from radix sort, and foreign key constraint checks have become faster. The COPY FROM command can now utilize SIMD instructions. Postgres 19 offers a range of improvements for application developers, operators, performance enthusiasts, and those building on Postgres, including enhanced graph queries, refined SQL syntax, improved window functions, better upsert behavior, REPACK CONCURRENTLY, advancements in autovacuum, improved monitoring capabilities, and new hooks. The release is still in beta, providing an opportunity for testing applications, migration, extensions, execution plans, and maintenance workflows.
AppWizard
June 19, 2026
A straightforward application for tracking cryptocurrency purchases using a dollar-cost averaging (DCA) strategy is being developed. Users can log trades, which allows the app to calculate the average entry price for each asset. 1. The app is built using Google AI Studio, where users select the “Build an Android app” option and provide a detailed description of the task. 2. The app allows users to add purchase entries with asset ticker, amount spent in USD, price per coin at purchase, and date, storing all entries locally. It displays total invested, total coins accumulated, average entry price, and includes a summary card with overall portfolio cost, a delete option for each entry, and filtering by asset. 3. AI Studio offers several design options, including Clean Minimalism and Elegant Dark, which can be selected or skipped. 4. The Gemini model generates a project with approximately ten Kotlin files and launches the app in an emulator, initially displaying “Total Invested: [openai_gpt model="gpt-4o-mini" prompt="Summarize the content and extract only the fact described in the text bellow. The summary shall NOT include a title, introduction and conclusion. Text: Step-by-Step App Build To illustrate the app development process, we will create a straightforward application designed for tracking cryptocurrency purchases using a dollar-cost averaging (DCA) strategy. This app will enable users to log their trades, allowing it to calculate the average entry price for each asset effortlessly. Step 1. Choose the mode and describe the app Begin by launching Google AI Studio, navigating to the Build tab, and selecting the “Build an Android app” option. In the designated input field, provide a detailed description of the task at hand. Prompt Build a native Android app for tracking dollar-cost averaging (DCA) crypto purchases. Let the user add a purchase entry with: asset ticker (e.g. BTC, ETH), amount spent in USD, price per coin at purchase, and date. Store all entries locally on the device. For each asset, show the total invested, total coins accumulated, and the average entry price. Add a summary card at the top with the overall portfolio cost. Include a delete option for each entry and the ability to filter by asset. Source: Incrypted. Step 2. Choosing a design Prior to generating the code, AI Studio presents a selection of visual style options for the app, including Clean Minimalism, Elegant Dark, Professional Polish, Vibrant Palette, and Sleek Interface. You can choose your preferred design by clicking “Select this design” or opt to skip this step by selecting “Skip.” Source: Incrypted. Step 3. Generation and first build The Gemini model will then create a project, typically comprising around ten Kotlin files, and launch the app in the built-in emulator. Upon initial launch, the screen will appear empty, displaying “Total Invested: [cyberseo_openai model="gpt-4o-mini" prompt="Rewrite a news story for a business publication, in a calm style with creativity and flair based on text below, making sure it reads like human-written text in a natural way. The article shall NOT include a title, introduction and conclusion. The article shall NOT start from a title. Response language English. Generate HTML-formatted content using tag for a sub-heading. You can use only , , , , and HTML tags if necessary. Text: Step-by-Step App Build Let’s break down the process using a simple app for tracking crypto buys with a dollar-cost averaging (DCA) strategy. The user logs their trades, and the app calculates the average entry price for each asset. Step 1. Choose the mode and describe the app Open Google AI Studio, go to the Build tab, and select the “Build an Android app” option. In the input field, describe the task.  Prompt Copy Build a native Android app for tracking dollar-cost averaging (DCA) crypto purchases. Let the user add a purchase entry with: asset ticker (e.g. BTC, ETH), amount spent in USD, price per coin at purchase, and date. Store all entries locally on the device. For each asset, show the total invested, total coins accumulated, and the average entry price. Add a summary card at the top with the overall portfolio cost. Include a delete option for each entry and the ability to filter by asset. Source: Incrypted. Step 2. Choosing a design Before generating the code, AI Studio offers several app visual style options — for example, Clean Minimalism, Elegant Dark, Professional Polish, Vibrant Palette, and Sleek Interface. You can pick the option you like under “Select this design” or skip the step by clicking “Skip.” Source: Incrypted. Step 3. Generation and first build The Gemini model creates a project — in our case, about ten Kotlin files — and launches the app in the built-in emulator. At launch, the screen is empty: the portfolio counter shows “Total Invested: $0.00,” and the purchases list is empty.  Source: Incrypted. Step 4. Fixing errors  If a message saying “1 error running the code” appears at the bottom of the panel, click Fix. The model finds the cause — in this example, it was an initialization error on startup — and fixes the code. After that, the app launches correctly. Step 5. Testing Click the plus button in the bottom-right corner. The “Add Purchase” window will open with the fields Ticker, Amount USD, and Price Per Coin. Enter the trade details and click Add. Add a few purchases — the “Total Invested” counter at the top will sum up your invested funds. Data: Incrypted. Data: Incrypted. Step 6. Refining the feature with a prompt To have the app group purchases by asset and calculate the average entry price, уточните задачу следующим промптом. Prompt Copy Group the purchases by ticker and, for each asset, add a summary card above its entries showing: total invested, total coins accumulated, and the average entry price. Calculate the average entry price as total invested divided by total coins for that asset. Display it clearly, for example u0022Avg entry: $2071.67u0022. Keep the existing per-purchase list below each summary. After the refinement, each asset gets its own card with the total amount, the number of coins, and the average entry price, and below it — a list of specific trades. Data: Incrypted. After testing in the emulator, you can install the app on a smartphone via ADB using a USB cable or publish it to Google Play’s internal testing track — these options are available from the same interface." temperature="0.3" top_p="1.0" best_of="1" presence_penalty="0.1" ].00” alongside an empty purchases list. Source: Incrypted. Step 4. Fixing errors If an error message appears stating “1 error running the code,” simply click Fix. The model will identify the issue—such as an initialization error on startup—and rectify the code accordingly. Following this correction, the app should launch without further issues. Step 5. Testing To test the app, click the plus button located in the bottom-right corner. This action will open the “Add Purchase” window, prompting you to fill in the fields for Ticker, Amount USD, and Price Per Coin. After entering the trade details, click Add. As you input several purchases, the “Total Invested” counter at the top will dynamically sum your invested funds. Data: Incrypted. Data: Incrypted. Step 6. Refining the feature with a prompt To enhance the app's functionality by grouping purchases by asset and calculating the average entry price, refine your task with the following prompt. Prompt Group the purchases by ticker and, for each asset, add a summary card above its entries showing: total invested, total coins accumulated, and the average entry price. Calculate the average entry price as total invested divided by total coins for that asset. Display it clearly, for example "Avg entry: 71.67". Keep the existing per-purchase list below each summary. Data: Incrypted. After implementing these refinements, each asset will feature its own summary card displaying the total amount invested, the number of coins accumulated, and the average entry price, with a detailed list of specific trades below. Once testing in the emulator is complete, you can install the app on a smartphone via ADB using a USB cable or publish it to Google Play’s internal testing track—both options are conveniently accessible from the same interface." max_tokens="3500" temperature="0.3" top_p="1.0" best_of="1" presence_penalty="0.1" frequency_penalty="frequency_penalty"].00” and an empty purchases list. 5. If an error occurs during code execution, clicking "Fix" allows the model to identify and correct the issue, enabling the app to launch correctly. 6. The app is tested by adding purchase details through an “Add Purchase” window, which updates the “Total Invested” counter. 7. To enhance functionality, the app can be refined to group purchases by asset, displaying a summary card for each asset that includes total invested, total coins accumulated, and average entry price, while maintaining a list of specific trades below each summary. 8. After testing, the app can be installed on a smartphone via ADB or published to Google Play’s internal testing track.
Search