NewApp Digest
search bot

Python

От 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.
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.
Run PostgreSQL in Python
Tech Optimizer
February 12, 2026

Run PostgreSQL in Python

The pgserver library allows developers to create a no-maintenance, self-contained instance of PostgreSQL within a Python virtual environment, simplifying the integration of PostgreSQL as a data layer and reducing the need for manual database setup. This tool enhances productivity and streamlines the development process for Python developers.
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.
Expired Oracle Patent Clears Path For Faster Sorting In MySQL And PostgreSQL - Open Source For You
Tech Optimizer
January 27, 2026

Expired Oracle Patent Clears Path For Faster Sorting In MySQL And PostgreSQL – Open Source For You

The expiration of Oracle's patent US7680791B2 has made the Orasort sorting algorithm, which offers a claimed 5× performance improvement, available in the public domain for open-source databases like MySQL and PostgreSQL. Developed by Mark Callaghan, Orasort enhances sorting workloads with similar keys and incorporates optimizations such as skipping repeated comparisons, adaptively switching sorting methods, caching key substrings, prefetching data, and producing partial results. The algorithm has shown to be approximately five times faster than previous sorting methods used by Oracle. The open-source community is actively exploring its integration into various database engines, with early experimentation underway using programming languages like Python, C, and C++.
Someone recreated the Windows 8 Start menu in Linux for some reason
Winsage
January 9, 2026

Someone recreated the Windows 8 Start menu in Linux for some reason

A developer has recreated the Windows 8.1 tiled Start menu for Linux, which is a Python-based application that supports flatpaks, Steam, and native apps. The tiles are movable and customizable in color. The project requires PyQt6 6.10.1 and pynput 1.8.1 to run and has been shared on Pastebin. It aims to replicate about 80% of the original Windows 8 Start menu's functionality, excluding search mode and larger tiles. The menu can be activated with the "super+p" command and remains in the system tray until then. The project has received significant interest, amassing 627 upvotes on a subreddit post.
Faster Is Not Always Better: Choosing the Right PostgreSQL Insert Strategy in Python (+Benchmarks)
Tech Optimizer
January 8, 2026

Faster Is Not Always Better: Choosing the Right PostgreSQL Insert Strategy in Python (+Benchmarks)

Inserting 2 million records per second into Postgres is achievable. The analysis explores five methods for inserting data into Postgres using Python, focusing on trade-offs in abstraction, safety, convenience, and performance rather than just speed. High-volume insert workloads are common in scenarios like loading records, syncing data, backfilling analytics tables, and ingesting events. Minor inefficiencies can lead to significant performance impacts. To interact with Postgres, the psycopg3 driver is used alongside SQLAlchemy, which provides two layers: Core and ORM. Psycopg3 is a low-level driver requiring manual SQL management, while SQLAlchemy Core offers a SQL abstraction, and the ORM maps Python classes to database tables, enhancing productivity but introducing overhead. Benchmarking involves measuring only the time spent transferring data from Python to Postgres, ensuring a fair comparison among methods. The fastest method may not always be the best due to maintenance costs, correctness guarantees, and cognitive load. The right insertion strategy depends on the existing data structure rather than just row count. The ORM is suited for CRUD-heavy applications, Core for data ingestion and analytics, and the Driver for maximum throughput in extensive writes. Performance issues can arise from mismatching abstractions, and reverting to a lower level may enhance performance. A guideline for choosing methods is: - Use ORM for applications prioritizing correctness and productivity. - Use Core for data movement or transformation balancing safety and speed. - Use Driver for pushing performance limits with raw power and full responsibility.
Search