Question 1

How do I set up specql with my PostgreSQL database?

Accepted Answer

Define a database connection using make-my-db, then use define-tables to introspect and generate specs for tables. The README shows an example with :employee/employees and columns like :employee/id for type-safe queries.

Question 2

Can specql handle complex joins or should I write raw SQL?

Accepted Answer

Specql is designed for common CRUD operations; for complex joins or reporting, it encourages using raw SQL or libraries like Yesql, as stated in the README's philosophy section. You can use views as a workaround.

Question 3

Specql vs HugSQL for Clojure database access?

Accepted Answer

Specql automates CRUD with type safety using clojure.spec and compile-time introspection, while HugSQL focuses on writing SQL in separate files. Choose specql for boilerplate reduction in CRUD, HugSQL for complex SQL flexibility.

Question 4

How to transform database enums to keywords in specql?

Accepted Answer

Use custom column transformations provided by specql, such as the to-keyword transform mentioned in the README, which can be applied to columns to automatically convert enum values to Clojure keywords.

Question 5

Does specql support materialized views?

Accepted Answer

Yes, specql supports materialized views just like tables, and includes a refresh! function to update them, as noted in the changelog for version 0.7.0-alpha18.

Question 6

What happens if my database schema changes with specql?

Accepted Answer

You need to re-run define-tables to introspect the new schema at compile time, which can be managed via caching in EDN files, but it adds overhead compared to runtime adaptation libraries.

specql

What is specql?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions