50+ must-have free and open-source software for Linux in 2025!
From productivity tools to multimedia, development, and cloud apps – this list has something for everyone.
👉 https://t.co/5OvDZ4FhLK
Follow @tecmint for more #Linux tips and updates.
Using Postgres \copy but want to see a progress meter?
There’s a pg_stat_progress_copy - but that’s a view that has to be queried specifically.
If you’re looking for something inside the command line, mac and linux users can utilize the pv (pipe viewer) tool. This has to be installed separately . Using the \copy FROM PROGRAM you can call pv from inside \copy.
\copy obrc(station_name, measurement) FROM PROGRAM 'pv "/1br/measurements.txt"' WITH (FORMAT CSV, DELIMITER ';');
Working with foreign data wrappers in Postgres can be a game changer. FDW connects to other databases - of course other Postgres databases but other database formats too like Mongo, Oracle, or SQL Server. There's extensions for file connections to read flat files like CSV or JSON. Foreign data wrappers can open up connections to a lot of places and let you work with the data natively in Postgres.
Postgres has a couple levers to pull to help you get better performance out of the foreign data wrapper. For example, you can fetch more rows of data at a time:
ALTER SERVER remote_server OPTIONS (SET fetch_size '10000');
We have a blog that reviews the other performance improvements for FDWs.
https://t.co/NrP1yKoN1L
Deepseek R1 (3bit) running with @exolabs on 2 x M2 Ultra Mac Studios w/ 192GB RAM each, connected via Thunderbolt. 8.5tok/s average.
Shoutout to @alexocheema for getting on a live call with me to live-code some optimizations and get this working reliably!
Goodbye ChatGPT
Alibaba just dropped Qwen2.5-Max, and the World is already blown away by its potential.
13 WILD examples so far (Don't miss the 5th one)
Netscanner is a terminal-based network and diagnostics tool with modern TUI. It supports features like ICMP ping sweeps, TCP/UDP port scanning, and subnet scanning.
Available on #Linux, #macOS or #Windows (with npcap) #cybersecurity 😎👇
https://t.co/Kl2bu3vP1y