We’re launching Lyria 3.5 in Google Flow Music, with advances across musicality, lyrics, vocals, and creative control
deepmind.google·6d ago
AI Engineering
Hacker News·Jun 23·5 min read
Show HN: Bun-sqlgen – Type-safe raw SQL for Bun, no ORM
TL;DR
Software engineers often face challenges with type safety and error handling when using Object-Relational Mappers (ORMs) for SQL queries. Bun-sqlgen is a tool that allows developers to write type-safe raw SQL queries directly in Bun, ensuring that queries are checked against the actual database schema.
✦ Why It Matters
Engineers can now write safer SQL queries without the overhead of ORMs, improving code reliability.
Key Takeaways
- Use Bun-sqlgen for type-safe SQL queries in Bun.
- Eliminate runtime errors by catching SQL issues during build.
- Leverage live checks against actual database schemas.
- Access comprehensive documentation for advanced features.
Full Summary
Many developers rely on Object-Relational Mappers (ORMs) to interact with databases, but these can introduce type safety issues and runtime errors. Bun-sqlgen is a new tool that enables type-safe raw SQL queries in Bun, a JavaScript runtime.
It allows developers to tag queries with names, ensuring that the resulting data structures are fully typed and null-safe at the call site. The tool performs live checks against a real Postgres or SQLite database, eliminating the need for Docker and ensuring that any SQL errors are caught during the build phase.
This results in faster development cycles, as queries can be re-evaluated on every save. Bun-sqlgen is published as @ilbertt/bun-sqlgen, with comprehensive documentation covering various features like nullability overrides and transaction support.
This innovation provides a more reliable and efficient way for engineers to manage database interactions.