NewApp Digest
search bot

Docker

Gold Lapel launches PostgreSQL proxy to tune queries
Tech Optimizer
March 24, 2026

Gold Lapel launches PostgreSQL proxy to tune queries

Gold Lapel has introduced a PostgreSQL proxy that enhances database query performance by acting as an intermediary between applications and PostgreSQL databases. The proxy monitors live queries, identifies issues, and implements optimizations such as creating materialised views, introducing various index types, and rewriting queries. It supports over ten optimization strategies, seven programming languages, four frameworks, and three ORMs, and is available for Linux, macOS, Windows, and Docker. The software includes features like prepared statement caching, in-memory result caching, connection pooling, automatic read replica routing, and security measures including TLS. An observability layer provides a live web dashboard and audit timeline. The pricing model is USD 9 per month per instance, with a site license available for unlimited instances. Gold Lapel has also released a 19-chapter technical book on PostgreSQL performance optimization. The company was founded by Stephen Gibson and is based in San Francisco.
От ffmpeg до торрентов для терминала: 7 новых TUI-инструментов, которые советуем
TrendTechie
February 24, 2026

От ffmpeg до торрентов для терминала: 7 новых TUI-инструментов, которые советуем

Many developers are turning to TUI (Text User Interface) tools for tasks traditionally done in GUI applications. MONICA is an interactive layer over ffmpeg that simplifies command usage, available on GitHub. The lic tool allows users to create a LICENSE file with a single terminal command by selecting a license from a TUI menu. It can be installed via Homebrew or pip and debuted in late December 2024, receiving 21 stars. PNANA is a TUI editor that combines the simplicity of nano with features from modern editors like Sublime, built with C++17 and FTXUI. Users need to compile it from source as no binary releases are available. CodeWeaver compiles a codebase into a single Markdown document, allowing for easy sharing and documentation. It can be installed via Go. Clox (version 1.3) introduces console clocks and calendars in the terminal, supporting various time zones and formats, and can be installed as a Python module. Torrra v2 is a TUI torrent client that allows users to search and download torrents directly from the console, enhancing UI speed and navigation. It can be installed via pipx or other package managers. A command for visualizing git history in the terminal is provided: `git log --graph --decorate --all --pretty=format:'%C(auto)%h%d %C(#888888)(%an; %ar)%Creset %s'`. An alias can be created for convenience. All tools aim to enhance productivity in the terminal and are actively evolving.
Contain your Windows apps inside Linux Windows
Winsage
February 16, 2026

Contain your Windows apps inside Linux Windows

WinApps and WinBoat are two solutions for running Windows applications on Linux. WinApps, developed since 2020 by Ben Curtis, allows users to run a genuine copy of Windows in a virtual machine (VM) and export individual applications to the Linux desktop using Microsoft's Remote Desktop Protocol (RDP). It supports various methods, including Docker, Podman, and KVM virtualization, with KVM offering extensive customization but requiring a more complex setup. WinBoat, a newer application at version 0.9.0, simplifies the user experience by automating much of the setup process and requires only Docker and FreeRDP to be installed. WinBoat is designed for ease of use, making it accessible for users less comfortable with technical configurations. Both tools allow users to run Windows software that may not work well under WINE, but running a full Windows OS in a VM involves licensing, maintenance, and resource considerations.
Creating a Data Pipeline to Monitor Local Crime Trends
Tech Optimizer
February 14, 2026

Creating a Data Pipeline to Monitor Local Crime Trends

The dataset utilized consists of police log entries from the Cambridge Police Department (CPD), which includes the date and time of incidents, type of incident, location, and a detailed description. The project follows a structured ETL process that involves extracting data via the Socrata Open Data API, validating the data for integrity, transforming it for optimal storage, and loading it into a PostgreSQL database. The extraction is performed using a Python client for the API, and validation checks ensure the presence of expected columns and the integrity of the data. The transformation process includes removing duplicates and splitting the datetime column into separate components. The data is then loaded into PostgreSQL, where a table is created to store the incidents. The entire ETL process is automated using Prefect, allowing for daily execution. Finally, the data is visualized using Metabase, which connects to the PostgreSQL database to create dashboards that display crime trends over time.
This third-party project is exactly the type of Copilot I'd want to use every day on my Windows 11 PC
Winsage
February 13, 2026

This third-party project is exactly the type of Copilot I’d want to use every day on my Windows 11 PC

Copilot is a prominent AI tool that users find overwhelming and intrusive, leading to a desire for a more streamlined experience. Hayden Barnes has developed a third-party tool that enhances GitHub Copilot's capabilities, allowing it to recognize Docker instances, interact with Windows Subsystem for Linux, and summarize text from images in File Explorer. This tool is designed to be an unobtrusive AI assistant on Windows 11 PCs, remaining discreet when not in use. The traditional Copilot app can be visually distracting, while Barnes' GitHub Copilot Taskbar GUI offers a minimalist interface that integrates seamlessly with the operating system. The tool is available for download on GitHub.
silver Android smartphone
Tech Optimizer
February 12, 2026

Constructive unveils secure-by-default Postgres platform

Constructive has launched a Postgres platform focused on security, implementing Row-Level Security (RLS) policies at table creation to prevent vulnerabilities from application-side configurations. The platform targets back-end development teams, particularly those using AI-assisted tools, and aims to enforce permissions and maintain data integrity directly at the database level. Constructive's open-source developer tools have surpassed 100 million downloads, including SQL parsers and migration systems. The platform allows teams to select access models and generates tables with embedded access rules, reducing the need for manual RLS configurations. It features a migration strategy ensuring reproducible security guarantees and validates RLS within CI/CD pipelines through automated checks. The serverless execution layer supports functions in multiple languages while adhering to the same permission model. Constructive's parsing technology is used in various Postgres-related platforms, and the company has filed provisional patents for its security compiler that transforms schemas into secure configurations. Constructive reports its tools are operational across over 10 million databases and is currently in a commercial private beta for enterprise teams.
Microsoft’s Quiet Exodus: Why Enterprise Developers Are Abandoning Windows for Linux Workstations
Winsage
January 29, 2026

Microsoft’s Quiet Exodus: Why Enterprise Developers Are Abandoning Windows for Linux Workstations

Microsoft developers and enterprise technology leaders are increasingly choosing Linux over Windows for development tasks, driven by performance concerns, workflow inefficiencies, and the rise of cloud-native development. The Windows Subsystem for Linux (WSL) has facilitated this shift by allowing developers to work in a Linux environment while still using Windows. Tools like Docker, Kubernetes, and Terraform, which are primarily designed for Linux, have led to a reevaluation of desktop strategies across various industries. Linux provides direct access to the same kernel and toolchain used in production, reducing discrepancies that can lead to bugs. It typically requires less memory at idle compared to Windows, making it more efficient for developers managing multiple containers or virtual machines. Microsoft has responded by investing in platform-agnostic tools like Visual Studio Code and embracing Linux on its Azure cloud platform, where over 50% of virtual machines run Linux. The introduction of WSL2 has improved compatibility and performance, but it has also highlighted Windows' limitations, leading to frustrations among developers. Security considerations favor Linux due to its open-source nature, allowing for greater customization and auditing. Financially, Linux can be more economical for enterprises due to lower licensing costs and reduced hardware requirements. Organizations that have switched to Linux report significant improvements in build times and overall developer experience. Hybrid strategies are emerging to accommodate developer preferences while ensuring security, with cloud-based development environments gaining traction. The trend toward Linux workstations reflects broader industry movements toward open source and platform independence, as companies adapt to attract and retain technical talent.
Search