bunx

func Close ¶

func Close(db *bun.DB) error

Close closes the database connection

func NewDB ¶

func NewDB(dsn string) (*bun.DB, error)

NewDB creates a new Bun database instance for PostgreSQL or SQLite based on DSN

func NewUUIDv7 ¶

func NewUUIDv7() string

NewUUIDv7 generates a time-ordered UUIDv7 string for database primary keys.

UUIDv7 provides:

• Time-ordered sortability for better database index performance
• Compatibility with both PostgreSQL and SQLite (no gen_random_uuid() dependency)
• Monotonic ordering within the same millisecond

This function panics if UUID generation fails, which only occurs on catastrophic system failures (e.g., entropy source exhaustion). This is acceptable because:

• UUID generation failure means the system cannot operate safely
• All database ID generation would fail anyway
• Explicit error handling adds complexity without practical benefit

Use this for all model ID fields instead of uuid.NewString() (UUIDv4).