Question 1

How do I install and set up Granite ORM in Crystal?

Accepted Answer

Add Granite as a dependency in your shard.yml file, run `shards install`, and configure the database adapter in your project settings. The README provides examples for PostgreSQL, MySQL, and SQLite setups.

Question 2

Does Granite have built-in migration tools?

Accepted Answer

No, Granite does not include migration tools; you need to manage schema changes manually or use external scripts, which can be a drawback for projects with evolving database structures.

Question 3

Granite ORM vs using raw SQL in Crystal – which should I choose?

Accepted Answer

Granite offers type safety and abstraction for cleaner code, but raw SQL gives better performance and control for complex queries. For simple apps, Granite is convenient; for high-performance needs, consider raw SQL.

Question 4

How to handle model relationships like has_many in Granite?

Accepted Answer

Define associations using Granite's macros in your models, similar to other ORMs. Check the documentation for specific syntax examples, as it might require manual configuration for joins and queries.

Question 5

Is Granite still actively maintained in 2023?

Accepted Answer

The README states Granite is looking for maintainers, so while it's functional, active development and support may be limited. Consider this for long-term projects needing reliable updates.

Question 6

Can I use Granite with SQLite for a small personal project?

Accepted Answer

Yes, Granite supports SQLite via its adapter, making it suitable for small projects or prototyping. Ensure your use case doesn't require advanced features missing in Granite.

granite

What is granite?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions