Two posts push compute into PostgreSQL: tanelpoder shows generating QR codes with pure SQL, and pghashlib delivers open-source stable hash functions right inside PostgreSQL [1][2].
QR codes in SQL — The tanelpoder post demonstrates generating QR codes using SQL alone in PostgreSQL [1]. That approach keeps the pipeline inside the database and reduces reliance on external libraries, a theme many developers consider for simpler deployments.
pghashlib — Open-source stable hash functions for PostgreSQL. pghashlib brings stable hash functions into the database, per the post [2]. That can cut down on external hashing tools and simplify deployments, at least in theory.
What this means for developers:
- Fewer external dependencies — both approaches hint at keeping more logic inside the database, reducing the need for external QR libs or hashing tools [1][2].
- Simplified deployments — fewer moving parts can streamline setup and upgrades [1][2].
- Performance considerations — moving compute into the database can shift CPU load and affect query planning; careful testing is wise.
Keep an eye on how in-database compute evolves as PostgreSQL ecosystems experiment with pure SQL UI and in-DB libraries.
References
Generate QR Codes with Pure SQL in PostgreSQL
PostgreSQL article showing QR code generation using pure SQL, avoiding external dependencies or procedural language extensions
View sourceShow HN: Pghashlib – open-source stable hash functions for PostgresSQL
Show HN introducing pghashlib, an open-source, stable hash function library for PostgreSQL, enabling reliable hashing within databases.
View source