Hacker News

Subscribe to Hacker News feed
Hacker News RSS
Updated: 28 min 50 sec ago

Show HN: Py-SQL-cleaner – format SQL embedded in Python strings

Thu, 05/28/2026 - 1:30pm

Hi HN, I built py-sql-cleaner, a CLI for formatting SQL embedded in Python files.

Python formatters handle Python syntax. They do not format SQL written inside Python code. On the other hand, SQL formatters usually target SQL files or raw SQL text, not SQL embedded inside a Python file.

Still, I think it is not uncommon to find long SQL queries inside Python codebases.

py-sql-cleaner detects embedded SQL inside Python files and works only on that SQL. The main things it can do are: find the SQL, format it in place, or extract it into a .sql file.

It avoids rewriting SQL that depends on runtime values or template expansion. For example, SQL containing parameters like %s or :name, or Jinja-style template variables like {{ ds }}, is skipped by default.

Try it with:

uvx py-sql-cleaner list path/to/file.py uvx py-sql-cleaner format path/to/file.py --dry-run If you write Python, have run into this kind of SQL cleanup problem, or are just curious, I’d be happy if you take a look.

Comments URL: https://news.ycombinator.com/item?id=48312436

Points: 1

# Comments: 0

Categories: Hacker News

Ask HN: What Is an "AI Engineer"?

Thu, 05/28/2026 - 1:26pm

I'm seeing an enormous contingency of my LinkedIn connections change their titles to "AI Engineer." I know for a fact that they're not working on any models or even AI workflows, they're just building apps and backends using AI tools like Claude.

Is that what "AI Engineer" means nowadays? Is that what companies are looking for when they open recs for "AI Engineer"? Should I be marketing myself as an "AI Engineer" just because I'm very efficient using modern AI tooling to build good non-AI software?

Comments URL: https://news.ycombinator.com/item?id=48312377

Points: 2

# Comments: 1

Categories: Hacker News

Beyond the Prompt: Claude Code

Thu, 05/28/2026 - 12:49pm
Categories: Hacker News

Show HN: Timelocked – local, offline timed-release file encryption

Thu, 05/28/2026 - 12:48pm

This is a small Rust app for encrypting files that can only be unlocked after a chosen amount of time.

You can 'timelock' any file, the content is encrypted with a key and that key is then protected by a sequential time-lock puzzle (Rivest-Shamir-Wagner style). Unlocking requires non-parallelizable computation time rather than waiting for a server or trusting a third party.

Possible uses:

- Delayed release of important work, scientific results, or investigation proof before making the reports/papers/final touches

- Timelocking crypto currencies BIP-39 passphrases for added security against home invasion / kidnapping

- Self managed inheritance plan. Put your timelocked passwords or files in a USB drive (or printed for maximum shelf life) in a temper evident bag in your home safe. If the bag is opened too soon, you will have time to reset your passwords.

Comments URL: https://news.ycombinator.com/item?id=48311636

Points: 1

# Comments: 0

Categories: Hacker News

Chatbots' Downward Spiral

Thu, 05/28/2026 - 12:42pm
Categories: Hacker News

Who Makes the Makefiles?

Thu, 05/28/2026 - 12:40pm
Categories: Hacker News

Endive: A JVM native WebAssembly runtime

Thu, 05/28/2026 - 12:40pm
Categories: Hacker News

Pages