Parrot – type-safe SQL in Gleam, supports SQlite, PostgreSQL and MySQL

Summary

🦜 Parrot / type-safe SQL in gleam 🚨 Exciting News Parrot got listed a community project on the sqlc website! 🦜🎉 Check it out here: https://docs.sqlc.dev/en/latest/reference/language-support.html Table of Contents Table of contents generated with markdown-toc Features Most of the heavy lifting features are provided by / built into sqlc, I do not aim to take credit for them. ☑️ Supports SQlite, PostgreSQL and MySQL. ☑️ Multiple queries per file. ☑️ Database client agnostic. ☑️ Utility wrappers for popular gleam database libraries (lpil/sqlight, lpil/pog). ☑️ Automatically pulls the schema of your database. ☑️ Automatically downloads sqlc binary. ☑️ Named parameters.*1 *1: Meaning that it infers the names of the parameters from your sql queries in the gleam function you call. for example for a query called FindUser , defined as SELECT * FROM user WHERE username = $1 , parrot will produce a function where the arguments match those column names: pub fn find_user(username: String) { ... } . If you have multiple parameters of the same data types this can avoid confusion and bugs. Usage / Getting Started Installation $ gleam add parrot Define your Queries Parrot will look for all *.sql files in any sql directory under your project's src directory. Each *.sql file can contain as many SQL queries as you want. All of the queries will compile into a single src/[project name]/sql.gleam module. Here are some links to help you start out, if you are unfamiliar with the sqlc annotation syntax: Here is an example of the file structure: ├── gleam.toml ├── README.md ├── src │ ├── app.gleam │ └── sql │ ├── auth.sql │ └── posts.sql └── test └── app_test.gleam Code Generation # automatically detects database & engine from env (DATABASE_URL by default) $ gleam run -m parrot # provide connection string from different environment variable $ gleam run -m parrot -- -e PG_DATABASE_URL # specify sqlite file $ gleam run -m parrot -- --sqlite < file_path > # see all options $ gleam run -m parrot h...