Dave Franco, Manny Jacinto, and Jenny Slate talk Forgotten Island

No more messy f-strings: Type-safe fluent SQL for ClickHouse.

No more messy f-strings: Type-safe fluent SQL for ClickHouse. Day 08 of the WClickHouse Open-Source Engineering Series. Building dynamic analytical queries by stitching f-strings together is an…

• Introduces QueryBuilder for type-safe, fluent SQL in ClickHouse
• Chained API methods (table(), select(), etc.) build queries naturally
• Automatic injection protection with escaped, validated parameters

1h ago ·dev.to

We checked 53,709 production resources for backups. 61% had none.

Disclosure: I work at Eon, on the content side. Our team ran these assessments and this is our data. I didn't write the queries, but I sat with the engineer who did, and the methodology below includes…

1h ago ·dev.to

Your Next.js API route is public—even if your UI isn’t.

Hiding a form behind a client-side condition doesn't make its API route private. Unless the route enforces its own checks, another client can call it directly.

• Public API routes in Next.js are accessible even if UI is not visible.
• Unauthorized data submission possible via direct URL access.
• FCaptcha provides server-side form verification solution.

1h ago ·dev.to

Basta de f-strings caóticos: SQL fluido y seguro para ClickHouse.

Basta de f-strings caóticos: SQL fluido y seguro para ClickHouse. Día 08 de la serie técnica WClickHouse Open Source. Construir queries analíticas dinámicas uniendo f-strings es un accidente esperando…

1h ago ·dev.to