20:56:06prxqI'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:39pjbThen 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.
22:14:15prxqi'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:52prxqIt sucks also that I can't see the sql :-) somehow it's not printing it.
22:48:28prxqso no, you can't search for elements having a null field. That sucks. Very disappointing.
22:51:24bitspook[m]prxq: Is it not possible to use sxql to create mito objects?
22:52:22prxqbitspook[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:30bitspook[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:59:36pjbprxq: my advice would be to drop mysql and to use a real RDBMS. Try Postgres.
22:59:56prxqpjb: this has nothing to do with that.
23:00:17prxqwould be the exact same problem on postgres or sqlite.
23:00:19bitspook[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")`