Question 1

How do I execute a SwifQL query in a Vapor application?

Accepted Answer

Use the Bridges library integration: after building a query with SwifQL, call .execute(on: conn) with a database connection from Vapor, then decode results with methods like .all(decoding: Model.self). The README provides examples for both application and request contexts.

Question 2

SwifQL vs Fluent: which should I use for Vapor projects?

Accepted Answer

SwifQL is better for complex, type-safe SQL queries and full control over SQL, while Fluent is an ORM ideal for simple CRUD and rapid development. SwifQL integrates with Vapor via Bridges but requires more setup and explicit query building.

Question 3

Does SwifQL support SQLite databases?

Accepted Answer

Not out-of-the-box; SwifQL natively supports PostgreSQL and MySQL. Adding SQLite requires creating a custom dialect by implementing the SwifQL dialect system, as mentioned in the README's flexibility notes.

Question 4

Can SwifQL handle complex nested queries with subqueries?

Accepted Answer

Yes, SwifQL supports complex nesting and parentheses using operators like | for brackets, and it includes examples for subqueries, such as building JSON arrays from related tables in the README.

Question 5

How does SwifQL prevent SQL injection?

Accepted Answer

It uses type-safe key paths and SwifQLPartUnsafeValue for values, which are parameterized in queries, ensuring that user inputs are escaped and not directly interpolated into SQL strings.

Question 6

What's the performance impact of using SwifQL compared to raw SQL?

Accepted Answer

The README claims no significant overhead, as queries are built at compile-time with Swift operators, but there might be minimal runtime cost for DSL parsing, though it's optimized for speed.

Question 7

Is SwifQL compatible with Swift's async/await?

Accepted Answer

Yes, since it integrates with Vapor and uses SwiftNIO, SwifQL can work with async/await patterns in modern Swift, especially through the Bridges library and database drivers that support concurrency.

SwifQL

What is SwifQL?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions