frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

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

https://github.com/enumura1/py-sql-cleaner
5•enumura•3h ago
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.

Claude Opus 4.8

https://www.anthropic.com/news/claude-opus-4-8
941•craigmart•4h ago•746 comments

Bricks and Minifigs Stole a Man's $200k Lego Collection

https://mybricklog.com/blog/bricks-minifigs-corporate-stole-old-mans-200000-lego-collection
212•philips•1h ago•61 comments

Just Use Postgres for Durable Workflows

https://www.dbos.dev/blog/postgres-is-all-you-need-for-durable-execution
163•KraftyOne•2h ago•55 comments

Social Animus

https://justine.lol/animus/
15•jart•41m ago•0 comments

Nitpicking the shell history scene in 'Tron: Legacy'

https://www.chiark.greenend.org.uk/~sgtatham/quasiblog/tron-legacy/
55•speckx•1h ago•7 comments

Caio, a cleaner search engine for 500k+ tech jobs

https://caio-jobs.com/
15•danicuki•56m ago•2 comments

I hated writing–until I learned there's a science to it(2024)

https://www.science.org/content/article/i-hated-writing-until-i-learned-there-s-science-it
66•o4c•3h ago•21 comments

Various LLM Smells

https://shvbsle.in/various-llm-smells/
26•speckx•1h ago•10 comments

Bitburner, programming-based incremental game

https://bitburner-official.github.io/
46•agmater•3h ago•5 comments

News about Raspberry Pi 6 and Microcontroller Development

https://www.jeffgeerling.com/blog/2026/news-about-raspberry-pi-6-and-microcontroller-development/
95•rbanffy•2d ago•61 comments

Show HN: Continue? Y/N: A 60-second game about AI agent permission fatigue

https://llmgame.scalex.dev
183•Wirbelwind•7h ago•90 comments

The Most Unlikely School Bag

https://www.carryology.com/insights/carry-culture/the-tale-of-the-worlds-most-unlikely-school-bag/
33•surprisetalk•3d ago•13 comments

The Permanent Upper Crow

https://permanent-upper-crow.jasonwu.ink/
116•whiteblossom•5h ago•40 comments

Separate the Cord from the Device

https://bookofjoe2.blogspot.com/2026/05/blog-post_27.html
12•bookofjoe•1h ago•10 comments

Indoor Wi-Fi Roaming with OpenWRT

https://taoofmac.com/space/blog/2026/05/26/1730
180•zdw•2d ago•88 comments

Show HN: Ktx – Open-source executable context layer for data agents

https://github.com/Kaelio/ktx
35•lucamrtl•5h ago•4 comments

Endive: A JVM native WebAssembly runtime

https://github.com/bytecodealliance/endive
32•theanonymousone•4h ago•9 comments

Sam Altman and Dario Amodei are both walking back AI jobs apocalypse predictions

https://fortune.com/2026/05/26/sam-altman-dario-amodei-walking-back-ai-jobs-apocalypse-prophecies...
63•ianrahman•1h ago•51 comments

The Lone Lisp Heap

https://www.matheusmoreira.com/articles/lone-lisp-heap
18•stevekemp•2h ago•6 comments

Ask HN: Entrepreneurs, how long did it take you to succeed?

12•asdev•16m ago•2 comments

Confidence Scores for Exam Questions

https://nomagicpill.substack.com/p/confidence-scores-for-exam-questions
4•surprisetalk•3d ago•2 comments

EU fines Temu €200M for allowing sale of illegal products

https://www.bbc.co.uk/news/articles/c1k2ydn1rz8o
264•jjp•6h ago•188 comments

Show HN: Hallucinate – Massively Multiplayer Online Rave

https://hallucinate.site
390•stagas•17h ago•173 comments

Using Tailscale with an OrbStack VM on macOS

https://github.com/highpost/tailscale-macos-vm
38•highpost•2d ago•8 comments

Legislation Killed Would Have Effectively Blocked Police LPR, Including Flock

https://ipvm.com/reports/bipartisan-alpr-amendment-killed
64•jhonovich•3h ago•41 comments

Dynamic Workflows in Claude Code

https://claude.com/blog/introducing-dynamic-workflows-in-claude-code
117•mil22•4h ago•92 comments

Trivial Pursuits

https://www.lrb.co.uk/the-paper/v48/n10/david-runciman/trivial-pursuits
17•diodorus•4h ago•6 comments

Anthropic raises $65B in Series H funding at $965B post-money valuation

https://www.anthropic.com/news/series-h
164•meetpateltech•2h ago•144 comments

YouTube to automatically label AI-generated videos

https://blog.youtube/news-and-events/improving-ai-labels-viewers-creators/
1250•nopg•1d ago•745 comments

Show HN: Open-Source AI Racing Harness

https://www.elodin.systems/post/elodin-ai-grand-prix-race-sim-harness
59•danAtElodin•1d ago•6 comments