crystal-pg

Uses Crystal's fiber-based concurrency for efficient, non-blocking database operations, ideal for high-performance concurrent applications as highlighted in the README.

Supports advanced PostgreSQL capabilities like LISTEN/NOTIFY and specialized data types such as geometric types and intervals, going beyond the standard crystal-db API.

Disables cleartext authentication by default to prevent downgrade attacks, with configurable methods like scram-sha-256 and md5 for flexibility while maintaining security.

Maps PostgreSQL types like JSONB, UUID, and arrays to Crystal types with precision preservation, though numeric and interval types require additional handling.