Install
SQL, Shell & Data Science
SQL, Bash/PowerShell, and scientific computing languages for analysis and ops.
- 8 Tracked terms
- Last 30 days Feed window
What this topic collects on
An article joins this feed when it matches these terms. Each one is also a search of its own.
Related topics
Latest in SQL, Shell & Data Science
PowerShell Set-Content: Write Text to Files Fast
48+ min ago (256+ words) The PowerShell Set-Content cmdlet writes text into a file. It is the clear, readable way to create a new file or replace what is already there — cleaner than juggling > redirects when you want intentional writes in scripts. For the official…...
PowerShell Add-Content: Append Text to Files Fast
48+ min ago (236+ words) The PowerShell Add-Content cmdlet appends text to a file. Use it when you want to keep existing lines and add more — the opposite of Set-Content, which replaces the whole file. For the official reference, see Microsoft Learn’s Add-Content. Want to…...
PowerShell Clear-Content: Empty Files Without Deleting Them
48+ min ago (327+ words) The PowerShell Clear-Content cmdlet empties a file’s contents but keeps the file itself. The path stays; the bytes go. That is the opposite of deleting the file, and different from rewriting it with new text. For the official reference, see…...
PowerShell Measure-Object: Count Lines and Sum Folder Sizes in One Line
48+ min ago (356+ words) The PowerShell Measure-Object cmdlet turns a pile of output into a number. How many lines are in this log? How much disk does this folder eat? What's the average order total in this CSV? Instead of opening Excel or writing…...
PowerShell Test-Path: Check a Path Exists Before You Act
48+ min ago (270+ words) The PowerShell Test-Path cmdlet answers one question: does this path exist? Use it before you read, write, delete, or create — so your script fails early with a clear message instead of throwing midway through a longer job. For the official…...
PowerShell Select-String: Find Text in Files Fast
49+ min ago (345+ words) The PowerShell Select-String cmdlet finds text inside files — the same job grep does on Linux/macOS and findstr does in classic CMD. When you are hunting for an error code in logs, checking whether a config key exists, or scanning…...
UUIDv4 vs UUIDv7 vs ULID vs Snowflake in Spring Boot 4: Which ID to Use, Measured on Postgres 18
1+ hour, 8+ min ago (147+ words) All four are unique enough. They differ in where their bits come from, and each source sends a bill later: 59% more WAL, an index two-thirds full, a JavaScript client that rounds your IDs. Here are four IDs for the same…...
Node.js 24 Built-In SQLite: Replacing better-sqlite3 in Scripts and Edge Workers Without a Native Module
2+ hour, 6+ min ago (1235+ words) This article was written with the assistance of AI, under human supervision and review. Most SQLite integration problems in Node.js stem from the gap between needing a simple embedded database and the friction of compiling native modules. Teams reach…...
Your tracking integration needs a date sanity check
3+ hour, 48+ min ago (667+ words) Every tracking integration I have seen trusts one thing it should not: that the newest event attached to a tracking number describes the shipment you are looking at. Most of the time it does. Then a support ticket arrives saying…...
SQLite WAL Does Not Mean Unlimited Writers: A Practical Python Playbook
4+ hour, 1+ min ago (1303+ words) A small service can run happily on SQLite for months, then begin throwing database is locked as soon as two background workers start processing jobs. Switching to Write-Ahead Logging (WAL) often improves the situation, but it does not turn SQLite…...