libera/#commonlisp - IRC Chatlog

20:55:18 prxq any mito users here?

20:56:06 prxq I'm wondering how to deal with the connection. ORMs in other languages have "sessions", which reconnect when the server times out. Mito does not seem to have something like it.

21:24:39 pjb Then you'd need to implement such session layer. That said, with modern network hardware, TCP is usually stable, it's rare that you get disconnected.

21:43:01 prxq pjb: mysql actually times out.

21:43:09 prxq pjb: ok

22:14:15 prxq i'm having trouble searching in tables for items having NULL values. Basically, SELECT column_names FROM table_name WHERE column_name IS NULL; Anyone knows how to specify this?

22:14:52 prxq It sucks also that I can't see the sql :-) somehow it's not printing it.

22:48:28 prxq so no, you can't search for elements having a null field. That sucks. Very disappointing.

22:51:24 bitspook[m] prxq: Is it not possible to use sxql to create mito objects?

22:52:22 prxq bitspook[m]: yeah but even there I'm not so sure. How'd you write a sxql search for a row with a null value?

22:54:30 bitspook[m] I suppose so. I haven't had a problem with building an SQL query with sxql so far; if worse comes to worse, you can write raw SQL.

22:55:18 prxq https://pastebin.com/crGK7pyp

22:56:24 prxq bitspook[m]: should produce 'where ... age is NULL'

22:56:32 prxq or in some incantation.

22:58:01 bitspook[m] https://pastebin.com/rMsCuUWM

22:59:36 pjb prxq: my advice would be to drop mysql and to use a real RDBMS. Try Postgres.

22:59:56 prxq pjb: this has nothing to do with that.

23:00:17 prxq would be the exact same problem on postgres or sqlite.

23:00:19 bitspook[m] prxq: Above is one way to do it without fighting sxql/mito too much. I am not sure what you're trying to do, but maybetry `(:raw "PART OF QUERY IN RAW SQL")`

23:00:20 pjb selecting null columns should work.

23:01:00 prxq bitspook[m]: thanks, that looks good!

23:01:47 prxq pjb: the problem is getting the right sql query out of the orm, Once the sql is correct, it finds them just fine

0:53:33 Guest8096 ** NICK Sauvin