00:17 <SamantazFox_> Hello! I don't understand how an Array is used along a prepared DB query, can someone tell me what's wrong?

00:17 <SamantazFox_> SELECT * FROM table WHERE id IN ($1)

00:19 <SamantazFox_> the Array passed in is an `Array(String)`

00:22 <FromGitter> <Blacksmoke16> i think it should just work

00:23 <FromGitter> <Blacksmoke16> can you share your code?

00:24 <SamantazFox_> https://bpa.st/PIQQ

00:24 <FromGitter> <Blacksmoke16> and does that produce an error or?

00:26 <SamantazFox_> with `(($1))` I'm getting no error. with `($1)` I'm getting `Unhandled exception: syntax error at or near "$1"`

00:26 <SamantazFox_> (before that, the old code was using `IN (($1),($2),($3),($4))`

00:27 <SamantazFox_> (extended to `$#(array.size}`)

00:29 <SamantazFox_> Okay, nevermind `WHERE id = ANY($1)` works

00:29 <FromGitter> <Blacksmoke16> what happens if you do like `PG_DB.query_all(request, args: ids, as: ChannelVideo)`

00:30 <FromGitter> <Blacksmoke16> https://github.com/crystal-lang/crystal-db/issues/100

00:30 <SamantazFox_> And to answer your question, using `args:` yields: `Unhandled exception: bind message supplies 4 parameters, but prepared statement "" requires 1`

00:31 <FromGitter> <Blacksmoke16> when using `WHERE id IN ($1)`

00:32 <SamantazFox_> yes

00:32 <FromGitter> <Blacksmoke16> about about that + `WHERE id IN ($1::text[])`

00:33 <SamantazFox_> gimme a sec

00:34 <SamantazFox_> `Unhandled exception: operator does not exist: text = text[]`

00:35 <SamantazFox_> trying without the parenthesis

00:35 <SamantazFox_> (and yes, I've removed `args:` from the `query_all` call)

00:36 <SamantazFox_> Nope, another error without parenthesis

00:36 <FromGitter> <Blacksmoke16> you need `args:`

00:36 <FromGitter> <Blacksmoke16> https://crystal-lang.github.io/crystal-db/api/0.10.1/DB/QueryMethods.html#query(query,*args_,args:Array?=nil)-instance-method, assuming this applies to the other methods as well

00:36 <SamantazFox_> args is used to pass an array of arguments, that are mapped to $1, $2 $3 and so on

00:37 <SamantazFox_> In my case, I want to provide the array directly

00:37 <FromGitter> <Blacksmoke16> yea you're right, not what you want

00:38 <FromGitter> <Blacksmoke16> im sure theres a way...

20:09 <FromGitter> <dscottboggs:matrix.org> is there an easy way to tell if an optional dependency (like GMP or regex) is installed in order to fall back on a different implementation?

20:10 <FromGitter> <Blacksmoke16> be easier to just say, hey go install this

20:15 <FromGitter> <RespiteSage> Yeah, I recall reading recently (maybe on the forum) about a way of doing that at runtime, but I think that's the hardest (followed by doing it at compile-time, then by just telling users to install something).

20:20 <FromGitter> <RespiteSage> Here it is: https://forum.crystal-lang.org/t/loading-so-files-at-runtime/4203

20:20 <FromGitter> <RespiteSage> Though that's about using `.so` files at runtime, so maybe there's an easier way of just checking if they're there.

20:23 <FromGitter> <RespiteSage> I guess if your executable has permissions to run `ldconfig`, you could just run that using `Process`.

23:23 <FromGitter> <moe:busyloop.net> yea, i would rather do that at compile time (and link statically if at all possible). runtime deps are nothing but pain. having random binaries break after an `apt upgrade` is no fun.