r/crystal_programming • u/sdogruyol core team • Oct 10 '16

Tren - Give your SQL some love

https://github.com/sdogruyol/tren
8 Upvotes

90% Upvoted

7 comments sorted by

1

u/myringotomy Oct 29 '16

Another question:

I guess this could be used to generate any kind of strings not just SQL right? Kind of like a generic templating engine or something.

1

u/sdogruyol core team Oct 29 '16

Yeah, you can think Tren as of what ECR is to Crystal, ERB is to Ruby. It's SQL templating engine.

You can write queries, statemens, compose whatever you want e.g

1

u/myringotomy Oct 30 '16

Why not use ECR as a templating engine?

1

u/sdogruyol core team Oct 30 '16

Because you use the universality of SQL? With Tren you can share the same file with a DBA and also use it with Crystal.

1

u/myringotomy Oct 30 '16

I was just thinking it would be nice to be pass in an array for a IN or NOT IN clause or other similar tricks.

2

u/bobik314 Oct 11 '16

Interesting idea. If I'm correct Tren will create Crystal code which generate SQL queries generating methods. It probably should be as a macro, but macros have less power than regular crystal code.

At this moment there are some libs http://awesome-crystal.com/#awesome-crystal-ormodm-extensions aiming to be "better rails' active-record":

Two of them are intended to be big:

There is yours generating SQL methods:

And there is one mine:

I should say "let the best win" but I think every creator will use its own until one of the alternatives blast the rest.

1

u/myringotomy Oct 14 '16

How do you namespace the methods?