Question 1

How do I build a conditional WHERE clause with Sqrl?

Accepted Answer

Use the Where method with condition checks, like in the README example: if len(q) > 0 { users = users.Where("name LIKE ?", q) }. This allows dynamic query building based on runtime logic.

Question 2

Is Sqrl thread-safe for web servers?

Accepted Answer

No, Sqrl is explicitly non-thread-safe, so you should not share builder instances across goroutines. For concurrent use, create separate builders or synchronize access to avoid race conditions.

Question 3

Sqrl vs Squirrel: which should I use?

Accepted Answer

Choose Sqrl if you need better performance and don't require thread safety, as it's a drop-in replacement with reduced overhead. Stick with Squirrel for immutable, thread-safe builders in highly concurrent environments.

Question 4

Can Sqrl handle PostgreSQL JSONB columns?

Accepted Answer

Yes, via the pg package, which provides functions like pg.JSONB to serialize values, as shown in the README example for inserting JSON data into PostgreSQL tables.

Question 5

How do I execute a query directly without manual SQL strings?

Accepted Answer

Use the RunWith(db) method on a builder, like three_stooges.RunWith(db).Query(), which executes the query against the database driver without assembling SQL strings manually.

Question 6

Does Sqrl support transactions?

Accepted Answer

Sqrl doesn't have built-in transaction management; it relies on Go's database/sql for transactions. You can use RunWith with a transaction object to execute queries within a transaction context.

sqrl

What is sqrl?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions