Hasty Briefsbeta

Bilingual

Generate QR Codes with Pure SQL in PostgreSQL

4 months ago
  • #QR-code
  • #SQL
  • #PostgreSQL
  • Author created a QR-code generator for PostgreSQL using a single pure SQL statement.
  • The generator doesn't require external libraries or Postgres extensions.
  • Two versions are available: basic (pqr.sql) and a safer version (pqrsafe.sql) that checks payload length.
  • PostgreSQL 17 showed better performance than version 16 in initial tests.
  • The project was completed in an hour using OpenAI Codex, contrasting with a manual utility written 20 years ago.