02:29 <Sankalp> Awesome! 🎉

11:08 <Elouin> Hi, is there an orm for sqlite that works with 1.4?

13:40 <FromGitter> <Blacksmoke16> Elouin: Depending your needs, it might be enough to just leverage https://crystal-lang.github.io/crystal-db/api/0.11.0/DB/Serializable.html. Tho you need to handle insert/updates yourself

15:44 <Elouin> Blacksmoke16: Thanks for the tip. Good to know that this exists. Though I want an ORM so I don't have to to inserts and updates myself.

15:44 <FromGitter> <Blacksmoke16> fair enough

15:45 <Elouin> Mainly because I don't want to fiddle with escaping and normalizing what the user is providing.

15:46 <FromGitter> <Blacksmoke16> fwiw, it would just be like `db.exec "insert into contacts values (?, ?)", "John Doe", 30`

15:46 <FromGitter> <Blacksmoke16> long as you use parameterized statements, it handles that for you

15:47 <Elouin> Thats injection safe?

15:47 <FromGitter> <Blacksmoke16> yea

15:47 <FromGitter> <Blacksmoke16> https://crystal-lang.org/reference/1.4/database/index.html#exec

15:49 <Elouin> Thanks a lot. Thats super nice and good to know.

15:50 <Elouin> There are only examples for mysql and postures. Would that work on SQLite too?

15:50 <FromGitter> <Blacksmoke16> yup

15:51 <FromGitter> <Blacksmoke16> https://github.com/crystal-lang/crystal-sqlite3

15:54 <Elouin> Ahh, OK. So the MySQL like syntax. Thanks. :)

15:54 <FromGitter> <Blacksmoke16> np

15:55 <FromGitter> <Blacksmoke16> works quite well. e.g. can do like `id = db.exec "insert into users (name, email) returning id", "Bob", "example@gmail.com", as: Int64`

15:55 <FromGitter> <Blacksmoke16> oops ⏎ ⏎ `id = db.exec "insert into users (name, email) values (?, ?) returning id", "Bob", "example@gmail.com", as: Int64`

15:56 <FromGitter> <Blacksmoke16> throw that in some module and is pretty easy to do like `SomeModule.save user`