23.2 Database connection ¶

This is a useful feature to use when you connect to a database. The shortcut provides a way to interact with the raw connection. The connection is fetched from the connection pool, which is created at GNU Artanis’s start up.

;; config
#:conn #t

;; apply
(:conn <route-context> [sql])

• The second argument is optional, if it’s missing, then :conn will return the raw connection after applying (:conn rc).
  • NOTE: If you haven’t set #:conn #t, and applied (:conn rc), then (rc-conn rc) will return #f. This is why you shouldn’t use low-level (rc-conn rc).
• If you pass a second argument, it should be a valid SQL query string. The returned value is described in DB connection pool.
  • You can create the SQL query string with SSQL.