freenode/#lisp - IRC Chatlog
Search
19:01:04
shka_
Demosthenex: anyway, good luck, obviously don't hesitate to ask your other questions here
19:03:55
AeroNotix
jackdaniel: it used to be much friendler in here. Noticed a spike in flaming since I last was more active.
19:08:35
Demosthenex
either way i appreciate it ;] i'm really enjoying using CL to parse this mishmash of data... it's much more flexible than something like static coding in python would be
19:08:50
Demosthenex
now if i can get a few million league matches loaded in my db, i'll be really excited
19:11:10
Demosthenex
meh, i have to make a call at a time to get the data, there's no bulk loading here with the rate limiter
19:11:42
Demosthenex
so i did enjoy prototyping the DB using the json support in postgres, which worked great in postmodern
19:12:45
Demosthenex
though it had nothing on transactions, but that was documented in the postmodern code base
19:13:15
Demosthenex
so i had GIN indexes on json data, and views into deep structures in this multilevel data... and it was ok for a few thousand records
19:13:35
Demosthenex
but i noticed that integer operations were really slow, so i think if i'm not indexing a field it has to parse integers from string in the json data every time.
19:14:03
Demosthenex
so summing or sorting on an embedded field was hugely slow compared to a native integer column
19:14:38
sabrac
working on transactions documentation. Also adding isolation level support, but probably not interesting to you
19:15:09
Demosthenex
yeah my transaction is simply wrapping all the parts for a single data object across tables. if one fails all should fail. it's read only data for reporting
19:15:34
sabrac
At some point I want to add more support for json, but it is complicated because there are so many different cl libraries for json
19:37:08
Demosthenex
ugh, i think my only complain atm is how sluggish emacs gets when long lines of json print into the comint buffer
19:43:10
aeth
Accidentally print a line a million times? Oops, but emacs is okay. Accidentally print something ending in a space instead of a newline? Time to kill the SLIME REPL buffer.
19:46:24
otwieracz
Because emacs with any autocompletion is totally uncapable of any reasonibly-sized buffers.
19:57:53
otwieracz
Really, I can't number all the times when emacs must have scanned my whole hard drive looking for this non-existant closing paren
21:56:57
dim
Demosthenex: have a read of https://tapoueh.org/blog/2017/09/on-json-and-sql/ to see how to normalize JSON data in SQL directly
22:55:22
Demosthenex
dim: and i saw that. i even considered using a virtual copy from my views into tables, but i thought i'd do it in lisp first instead of leaning on the DB
22:59:14
Demosthenex
dim: in the case of numbers, i still had to type cast text to int for comparison constantly, and that was slow.
0:11:33
AeroNotix
Is there anything in commonqt like the C++/python tools that will convert the .ui files into proper clos classes?
0:13:56
AeroNotix
seems like: https://en.wikipedia.org/wiki/List_of_language_bindings_for_Qt_4 the answer is no
0:14:46
AeroNotix
haha omg, seems like I made a vague attempt at this years ago though: https://github.com/AeroNotix/cluic
6:01:34
Shinmera
AeroNotix: When I was more active doing Qtools stuff I thought about doing that, but then I remembered that I hated UI designers with a raging passion so I dropped it.
6:02:39
smokeink
question for the web experts: https://github.com/fukamachi/myway/blob/master/src/mapper.lisp if there is an "add-route" function, shouldn't there also be a "del-route" counterpart?
6:05:04
smokeink
so I went along trying to patch one in.. but I was surprised to find that for some reason the authors chose to use collectors instead of lists. And you can't delete stuff from collectors
6:08:04
Shinmera
Not to be a downer, but fukamachi code often has decisions I don't quite understand.
6:10:46
smokeink
it happens to many of us.. no prob, I'll just fork his proj and hack the guts out of it until it works as I want it to. Just wanted to make sure it's not me who's missing something obvious.
6:12:39
Shinmera
No, seriously though, even if you don't use Radiance, I assume there's other libraries that provide routing for Clack
6:18:44
jackdaniel
smokeink: collectors manage a simple list. removing thing from such collector is no more than a list operation. if you want to pop from it you'll have a little harder time though
6:20:39
jackdaniel
something like (rplaca (col) (cadr (col)) (rplacd (col) (cddr (col))) ; need to be testedâ„¢
6:23:54
smokeink
Shinmera: okay. Radiance is good when one wants a full-stack solution . Ningle is minimal, I tried it after tried a few other more complex alternatives and after Someone had told me that he just uses hunchentoot + his own macros, so I wanted to try such an approach. This approach suits me and is quite cool, you can implement on top of ningle's routing just what you need , and you don't clutter the app with stuff that you might never use, (or in the case
6:23:54
smokeink
of RESTAS , stuff which don't really work as you would want and are hard to be modified)
6:29:21
Shinmera
Well the thing with Radiance is that it isn't a full stack if you don't need it to be.
6:30:51
Shinmera
But you are right in the sense that the advantages it offers are likely not going to benefit every kind of project.