< 1535760874 90833 :tsglove14!~tsglove@113.235.245.208 JOIN :#esoteric < 1535761102 262200 :Phantom_Hoover!~phantomho@unaffiliated/phantom-hoover QUIT :Read error: Connection reset by peer < 1535761146 835133 :arseniiv!~arseniiv@77.79.141.237.dynamic.ufanet.ru QUIT :Ping timeout: 252 seconds < 1535761157 909789 :tsglove14!~tsglove@113.235.245.208 QUIT :Remote host closed the connection < 1535761422 329520 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1535761667 275163 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Ping timeout: 240 seconds < 1535762118 608719 :MDude!~MDude@97-127-137-99.cdrr.qwest.net QUIT :Read error: No route to host < 1535762243 245986 :MDude!~MDude@97-127-137-99.cdrr.qwest.net JOIN :#esoteric < 1535762668 963550 :olspookishmagus2!~olspookis@201-212-176-20.net.prima.net.ar JOIN :#esoteric < 1535762705 337063 :olspookishmagus2!~olspookis@201-212-176-20.net.prima.net.ar QUIT :Remote host closed the connection < 1535765911 247072 :nfd9001!~nfd9001@c-73-157-90-101.hsd1.wa.comcast.net JOIN :#esoteric < 1535765919 506316 :xkapastel!uid17782@gateway/web/irccloud.com/x-opuipgaqovqxydgp QUIT :Quit: Connection closed for inactivity < 1535766653 319663 :sprocklem!~sprocklem@unaffiliated/sprocklem JOIN :#esoteric < 1535767028 621093 :joast!~rick@cpe-98-145-132-215.natnow.res.rr.com QUIT :Quit: Leaving. < 1535767061 279228 :joast!~rick@cpe-98-145-132-215.natnow.res.rr.com JOIN :#esoteric < 1535767135 162571 :S_Gautam!uid286066@gateway/web/irccloud.com/x-ubmaxvmnklkupfjx QUIT :Quit: Connection closed for inactivity < 1535767234 39680 :rdococ!rdococ@unaffiliated/rdococ QUIT :Quit: CHEAPIE! What did you do to the bouncer?! :P (jk) < 1535767380 563699 :rdococ!rdococ@cheapiesystems.com JOIN :#esoteric < 1535767546 781717 :rdococ!rdococ@cheapiesystems.com QUIT :Changing host < 1535767546 781766 :rdococ!rdococ@unaffiliated/rdococ JOIN :#esoteric < 1535769231 319733 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net JOIN :#esoteric < 1535769445 300852 :Dave10!~Dave@177.11.44.3 JOIN :#esoteric < 1535769737 245227 :Dave10!~Dave@177.11.44.3 QUIT :Remote host closed the connection < 1535770062 437228 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net QUIT :Ping timeout: 252 seconds < 1535770871 272766 :Sgeo!~Sgeo@ool-18b98dd9.dyn.optonline.net JOIN :#esoteric > 1535770968 155031 PRIVMSG #esoteric :14[[07Underload14]]4 10 02https://esolangs.org/w/index.php?diff=57499&oldid=55737 5* 03Ais523 5* (-17) 10/* Underload minimization */ golf the definition of ~ in terms of ()a!:*^ < 1535771003 304916 :Sgeo__!~Sgeo@ool-18b98dd9.dyn.optonline.net QUIT :Ping timeout: 245 seconds < 1535771046 722077 :Sgeo!~Sgeo@ool-18b98dd9.dyn.optonline.net PRIVMSG #esoteric :https://github.com/gergoerdi/brainfuck64 < 1535772428 258388 :Sgeo!~Sgeo@ool-18b98dd9.dyn.optonline.net QUIT :Ping timeout: 245 seconds < 1535772562 424570 :Sgeo!~Sgeo@ool-18b98dd9.dyn.optonline.net JOIN :#esoteric < 1535772806 830004 :APic!apic@chiptune.apic.name QUIT :Ping timeout: 255 seconds < 1535772881 230931 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net JOIN :#esoteric < 1535773196 859058 :APic!apic@chiptune.apic.name JOIN :#esoteric < 1535776965 988759 :oerjan!oerjan@hagbart.nvg.ntnu.no PRIVMSG #esoteric :^ul (x)(y)aaa(!)(aa(!))(*a*:*^!*^):*^SSS < 1535776966 76181 :fungot!~fungot@momus.zem.fi PRIVMSG #esoteric :xy ...out of stack! < 1535776973 648049 :oerjan!oerjan@hagbart.nvg.ntnu.no PRIVMSG #esoteric :fiendish < 1535777377 668846 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1535777614 634347 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Ping timeout: 240 seconds < 1535778727 123529 :oerjan!oerjan@hagbart.nvg.ntnu.no QUIT :Quit: Nite < 1535779563 375634 :nesthib14!~nesthib@201.146.92.162 JOIN :#esoteric < 1535779606 524881 :nesthib14!~nesthib@201.146.92.162 QUIT :Remote host closed the connection < 1535779732 848477 :imode!~imode@unaffiliated/imode QUIT :Ping timeout: 272 seconds < 1535780527 304429 :XorSwap!~XorSwap@wnpgmb016qw-ppp-103-253.dynamic.bellmts.net QUIT :Ping timeout: 240 seconds < 1535780542 367372 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1535780787 371724 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Ping timeout: 240 seconds < 1535781301 116505 :Zalabaslea!~Zalabasle@i125-205-220-78.s41.a034.ap.plala.or.jp JOIN :#esoteric < 1535781318 245825 :XorSwap!~XorSwap@kite.riseup.net JOIN :#esoteric < 1535781534 381966 :Zalabaslea!~Zalabasle@i125-205-220-78.s41.a034.ap.plala.or.jp QUIT :Killed (Sigyn (Spam is off topic on freenode.)) < 1535782479 951673 :acerbic17!~acerbic@197.46.54.123 JOIN :#esoteric < 1535782522 601334 :acerbic17!~acerbic@197.46.54.123 QUIT :Remote host closed the connection < 1535785347 427360 :SopaXorzTaker!~SopaXorzT@unaffiliated/sopaxorztaker JOIN :#esoteric < 1535786910 295247 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1535787153 260869 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Ping timeout: 245 seconds < 1535789532 744850 :mniip!mniip@freenode/staff/mniip QUIT :Ping timeout: 630 seconds < 1535790084 256638 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1535790205 308035 :XorSwap!~XorSwap@kite.riseup.net QUIT :Ping timeout: 246 seconds < 1535790259 950846 :mniip!mniip@freenode/staff/mniip JOIN :#esoteric < 1535791308 725367 :Silverlooks!~Android@185.40.211.129 JOIN :#esoteric < 1535791318 457887 :Silverlooks!~Android@185.40.211.129 PART :#esoteric < 1535791577 426041 :SopaXorzTaker!~SopaXorzT@unaffiliated/sopaxorztaker QUIT :Ping timeout: 244 seconds < 1535791721 239846 :LKoen!~LKoen@vbo91-6-78-245-243-132.fbx.proxad.net JOIN :#esoteric < 1535792006 277565 :erkin!~erkin@unaffiliated/erkin JOIN :#esoteric < 1535796249 972669 :copumpkin[m]!copumpkinm@gateway/shell/matrix.org/x-smizxkckfqurantk QUIT :Read error: Connection reset by peer < 1535796418 143474 :arseniiv!~arseniiv@77.79.141.237.dynamic.ufanet.ru JOIN :#esoteric < 1535796613 361401 :copumpkin[m]!copumpkinm@gateway/shell/matrix.org/x-ufsfivrrjftgodtf JOIN :#esoteric < 1535799651 849087 :Phantom_Hoover!~phantomho@2a02:c7d:485a:3300:fb8b:fb15:c1d3:a33a JOIN :#esoteric < 1535799651 936035 :Phantom_Hoover!~phantomho@2a02:c7d:485a:3300:fb8b:fb15:c1d3:a33a QUIT :Changing host < 1535799651 936077 :Phantom_Hoover!~phantomho@unaffiliated/phantom-hoover JOIN :#esoteric < 1535799712 860426 :xkapastel!uid17782@gateway/web/irccloud.com/x-xkuwdifgwlfcmvxe JOIN :#esoteric < 1535800841 983415 :S_Gautam!uid286066@gateway/web/irccloud.com/x-kwnrwzbcnvczntkr JOIN :#esoteric < 1535802791 536814 :moriarty!~u2ucc61f@unaffiliated/moriarty JOIN :#esoteric < 1535802941 287804 :moriarty!~u2ucc61f@unaffiliated/moriarty PART :#esoteric < 1535803528 305400 :GeekDude!~G33kDude@unaffiliated/g33kdude QUIT :Ping timeout: 245 seconds < 1535803838 994328 :GeekDude!~G33kDude@unaffiliated/g33kdude JOIN :#esoteric < 1535804093 286471 :ais523!~ais523@unaffiliated/ais523 JOIN :#esoteric < 1535804152 504639 :LKoen!~LKoen@vbo91-6-78-245-243-132.fbx.proxad.net QUIT :Remote host closed the connection < 1535804266 887240 :ais523!~ais523@unaffiliated/ais523 PRIVMSG #esoteric :@message oerjan the trick with the shorter Underload swap is to realise that ~ is really not the most fundamental primitive; the actual primitive here is ~a*^ (which I think of as _), and you can implement ~ as a_ < 1535804266 975971 :lambdabot!~lambdabot@haskell/bot/lambdabot PRIVMSG #esoteric :Maybe you meant: messages messages-loud messages? < 1535804267 28636 :ais523!~ais523@unaffiliated/ais523 QUIT :Remote host closed the connection < 1535804279 269812 :ais523!~ais523@unaffiliated/ais523 JOIN :#esoteric < 1535804285 268749 :ais523!~ais523@unaffiliated/ais523 PRIVMSG #esoteric :@tell oerjan the trick with the shorter Underload swap is to realise that ~ is really not the most fundamental primitive; the actual primitive here is ~a*^ (which I think of as _), and you can implement ~ as a_ < 1535804285 332678 :lambdabot!~lambdabot@haskell/bot/lambdabot PRIVMSG #esoteric :Consider it noted. < 1535804415 192587 :ais523!~ais523@unaffiliated/ais523 PRIVMSG #esoteric :@tell oerjan for any constant K, (K)_ can be written as aa(!)(K)*a*:*^!*^, so to implement _ on an element taken from the stack, we can use (aa(!))_ to push the aa(!) before the element in question, everything else is easy from there < 1535804415 280023 :lambdabot!~lambdabot@haskell/bot/lambdabot PRIVMSG #esoteric :Consider it noted. < 1535804691 477091 :LKoen!~LKoen@vbo91-6-78-245-243-132.fbx.proxad.net JOIN :#esoteric < 1535804979 206639 :LKoen!~LKoen@vbo91-6-78-245-243-132.fbx.proxad.net QUIT :Remote host closed the connection < 1535806005 193026 :xeroks7!~xeroks@220.73.52.54 JOIN :#esoteric < 1535806169 491970 :fini!~user@142.93.249.241 JOIN :#esoteric < 1535806173 491645 :fini!~user@142.93.249.241 QUIT :Remote host closed the connection < 1535806291 518058 :xeroks7!~xeroks@220.73.52.54 QUIT :Remote host closed the connection < 1535806930 216191 :red-00124!~red-001@p2747046-ipngn201310tokaisakaetozai.aichi.ocn.ne.jp JOIN :#esoteric < 1535807222 893679 :red-00124!~red-001@p2747046-ipngn201310tokaisakaetozai.aichi.ocn.ne.jp QUIT :Remote host closed the connection < 1535808465 959039 :Phantom_Hoover!~phantomho@unaffiliated/phantom-hoover QUIT :Remote host closed the connection < 1535809538 833434 :Phantom_Hoover!~phantomho@unaffiliated/phantom-hoover JOIN :#esoteric < 1535809966 271217 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net QUIT :Ping timeout: 246 seconds < 1535810486 262722 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Remote host closed the connection < 1535810696 339798 :ais523!~ais523@unaffiliated/ais523 QUIT :Quit: quit < 1535811539 470851 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1535812212 266553 :LKoen!~LKoen@vbo91-6-78-245-243-132.fbx.proxad.net JOIN :#esoteric < 1535812478 266186 :LKoen!~LKoen@vbo91-6-78-245-243-132.fbx.proxad.net QUIT :Ping timeout: 245 seconds < 1535812645 245152 :ep100!~max@197.89.38.153 JOIN :#esoteric < 1535812932 109113 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Remote host closed the connection < 1535813877 959443 :zz_ka6sox!~zz_ka6sox@116.111.78.187 JOIN :#esoteric < 1535814066 103859 :zz_ka6sox!~zz_ka6sox@116.111.78.187 QUIT :Remote host closed the connection < 1535814278 286779 :ep100!~max@197.89.38.153 QUIT :Ping timeout: 245 seconds < 1535815028 757589 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1535815338 713050 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Ping timeout: 272 seconds < 1535816804 655424 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net JOIN :#esoteric < 1535817085 222869 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net QUIT :Ping timeout: 246 seconds < 1535818024 720532 :ais523!~ais523@unaffiliated/ais523 JOIN :#esoteric < 1535818797 741434 :S_Gautam!uid286066@gateway/web/irccloud.com/x-kwnrwzbcnvczntkr QUIT :Quit: Connection closed for inactivity < 1535818938 414192 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net JOIN :#esoteric < 1535819007 697056 :pikhq!~pikhq@c-73-181-126-9.hsd1.co.comcast.net QUIT :Ping timeout: 240 seconds < 1535819187 372737 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net QUIT :Ping timeout: 240 seconds < 1535819433 676851 :LKoen!~LKoen@vbo91-6-78-245-243-132.fbx.proxad.net JOIN :#esoteric < 1535819450 373724 :pikhq!~pikhq@c-73-181-126-9.hsd1.co.comcast.net JOIN :#esoteric < 1535819465 711983 :LKoen!~LKoen@vbo91-6-78-245-243-132.fbx.proxad.net QUIT :Read error: Connection reset by peer < 1535819489 238835 :LKoen!~LKoen@vbo91-6-78-245-243-132.fbx.proxad.net JOIN :#esoteric < 1535819496 390056 :sprocklem!~sprocklem@unaffiliated/sprocklem QUIT :Ping timeout: 252 seconds < 1535819773 229919 :LKoen!~LKoen@vbo91-6-78-245-243-132.fbx.proxad.net QUIT :Ping timeout: 246 seconds < 1535819793 327217 :MDude!~MDude@97-127-137-99.cdrr.qwest.net QUIT :Ping timeout: 252 seconds < 1535819970 255300 :MDude!~MDude@97-127-137-99.cdrr.qwest.net JOIN :#esoteric < 1535821163 246259 :siso_!~siso_@190.112.186.129 JOIN :#esoteric < 1535821366 264885 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1535821449 239361 :siso_!~siso_@190.112.186.129 QUIT :Remote host closed the connection < 1535821641 395695 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Ping timeout: 252 seconds < 1535822014 687177 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :I added another file format decoder into Farbfeld Utilities, this time for MegaPaint format. < 1535823538 233001 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net JOIN :#esoteric < 1535823805 220175 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net QUIT :Ping timeout: 246 seconds < 1535823808 660790 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1535824054 640527 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Ping timeout: 240 seconds < 1535824420 375141 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1535824596 575947 :lifthrasiir!~lifthrasi@ec2-52-79-98-81.ap-northeast-2.compute.amazonaws.com QUIT :*.net *.split < 1535824596 576010 :incomprehensibly!sid3405@gateway/web/irccloud.com/x-bxahrhyjexjbbfbl QUIT :*.net *.split < 1535824644 610982 :incomprehensibly!sid3405@gateway/web/irccloud.com/x-kjuuhvhadmcowzhr JOIN :#esoteric < 1535824921 454850 :lifthrasiir!~lifthrasi@ec2-52-79-98-81.ap-northeast-2.compute.amazonaws.com JOIN :#esoteric < 1535825511 299718 :Randy11!~Randy@79-76-12-162.dynamic.dsl.as9105.com JOIN :#esoteric < 1535825698 886951 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Remote host closed the connection < 1535825718 267226 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1535825793 625757 :Randy11!~Randy@79-76-12-162.dynamic.dsl.as9105.com QUIT :Remote host closed the connection < 1535826681 364192 :ssbr3!~ssbr@41.237.191.208 JOIN :#esoteric < 1535827215 646793 :ssbr3!~ssbr@41.237.191.208 QUIT :Ping timeout: 250 seconds < 1535828087 232104 :Croepha23!~Croepha@185.204.33.63 JOIN :#esoteric < 1535828122 579305 :Croepha23!~Croepha@185.204.33.63 QUIT :Remote host closed the connection > 1535828256 140163 PRIVMSG #esoteric :14[[07Vrty14]]4 N10 02https://esolangs.org/w/index.php?oldid=57500 5* 03FAKE1007 5* (+1219) 10Created page with "'''Vrty''' is an esoteric programming language by ~~~. It is an attempt on a good programming language that you can write easy programs on. Made in 2018. By the way, the devel..." < 1535829487 193104 :copumpkin[m]!copumpkinm@gateway/shell/matrix.org/x-ufsfivrrjftgodtf QUIT :Read error: Connection reset by peer < 1535829909 157118 :copumpkin[m]!copumpkinm@gateway/shell/matrix.org/x-lcycnbvluidudlkf JOIN :#esoteric < 1535829939 385539 :copumpkin[m]!copumpkinm@gateway/shell/matrix.org/x-lcycnbvluidudlkf QUIT :Remote host closed the connection < 1535830040 362188 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net JOIN :#esoteric < 1535830320 398169 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net QUIT :Ping timeout: 252 seconds < 1535830566 456992 :copumpkin[m]!copumpkinm@gateway/shell/matrix.org/x-ovmkgmnwdqmkujoe JOIN :#esoteric < 1535832147 493023 :arseniiv!~arseniiv@77.79.141.237.dynamic.ufanet.ru PRIVMSG #esoteric :FAKE1007 is being boring((( < 1535832151 627174 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net JOIN :#esoteric < 1535832191 359149 :arseniiv!~arseniiv@77.79.141.237.dynamic.ufanet.ru PRIVMSG #esoteric :they don’t even hint what’s eso in that lang < 1535832424 655226 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net QUIT :Ping timeout: 240 seconds < 1535832567 253833 :Sgeo!~Sgeo@ool-18b98dd9.dyn.optonline.net PRIVMSG #esoteric :The author of TempleOS might be dead (not sure if confirmed yet) < 1535832704 846310 :int-e!~noone@int-e.eu PRIVMSG #esoteric :HolyC is a terrible pun < 1535833251 1680 :S_Gautam!uid286066@gateway/web/irccloud.com/x-tezfwxfunribgnmt JOIN :#esoteric < 1535836129 640301 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 JOIN :#esoteric < 1535836230 936054 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :hi guys. I got my second wisdom tooth extraction yesterday. it went much better than the first one seven years ago. I still have to be careful for a while with the wound in my mouth, but it was much better. < 1535836288 561371 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :The tooth came out quickly and unbroken, I only got one stitch, I didn't need to take any painkillers after, and my cheek doesn't look like I'm holding a tennis ball in my mouth at all. < 1535836376 747722 :john_metcalf!~digital_w@host86-133-49-189.range86-133.btcentralplus.com JOIN :#esoteric < 1535836478 166474 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :I will need a third wisdom tooth extracted, but that will likely be two months from now, to leave time for this to heal completely. < 1535836760 267881 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net JOIN :#esoteric < 1535836999 887496 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :Do you like sqlext_graph? < 1535837014 220694 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net QUIT :Ping timeout: 246 seconds < 1535837708 359375 :ais523!~ais523@unaffiliated/ais523 QUIT :Read error: Connection reset by peer < 1535837725 667208 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :zzo38: where are your sql extensions again? anyway, I don't see why I'd like to combine sqlite with drawing graphs. there are already standalone programs for drawing graphs, like gnuplot, and I can feed them a text file and give commands with a text file. I've written advanced programs controlling gnuplot. < 1535837749 681534 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :I think I could read from a database and write the data to a text file (or text pipe) and use gnuplot that way too. < 1535837841 405270 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Remote host closed the connection < 1535837944 387110 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :http://zzo38computer.org/sql/sqlite.txt < 1535837970 819729 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :ah, there's a zip! < 1535837974 737998 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :I didn't notice that somehow < 1535838056 118379 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :zzo38: have you tried Scryfall's API yet? you know, the M:tG database < 1535838196 199040 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :I have not, although I have looked at it, and sqlext_curl can be used to perform downloads from internet. I am not sure how to present the data by SQL tables, or what constraints to implement (some features of Scryfall would be difficult to implement in the SQLite virtual table mechanism). < 1535838270 314862 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :zzo38: I don't want a virtual table mechanism, I just want a way to scrape most of the text data about cards (not the images) and store it locally, in a way that I can easily repeat four times a year. < 1535838308 14470 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :You could just download the JSON then, I suppose, but then is not as good for querying the data. < 1535838355 748539 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :What I want is support for incremental updates, but it look Scryfall doesn't have that. < 1535838360 644756 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :zzo38: sure, I'll then parse the JSON (I have used a JSON parser before) and massage to some better format, possibly a database < 1535838386 333414 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :zzo38: downloading all the text data without the images every three months isn't too bad, so the incremental updates isn't important < 1535838395 873592 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :OK < 1535838412 362728 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :you'd need more frequently than that only if you wanted more up to date price data, but I don't think you need that < 1535838467 128001 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :I don't need price data, at least < 1535838765 596895 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :Do you like window functions? < 1535838791 671219 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1535838828 887116 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :zzo38: I still don't really understand how they work. I haven't dug through their docs yet. < 1535839773 96372 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :I think I know how they work, but I have not tried it. (I will try it once the next version of SQLite is released.) < 1535840581 643704 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net JOIN :#esoteric < 1535840649 776480 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :I sent a feature request to sqlite3. < 1535840695 268762 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :We'll find out later how they react. < 1535840713 633745 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :I'm requesting a new builtin function. < 1535840787 206239 :kashike2622!~kashike@179-199-103-254.user.veloxzone.com.br JOIN :#esoteric < 1535840940 648970 :LKoen!~LKoen@vbo91-6-78-245-243-132.fbx.proxad.net JOIN :#esoteric < 1535840942 209743 :kashike2622!~kashike@179-199-103-254.user.veloxzone.com.br QUIT :Remote host closed the connection < 1535840945 437969 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :What new builtin function? < 1535840969 636567 :bradcomp!~bradcomp@c-67-161-161-17.hsd1.ca.comcast.net QUIT :Ping timeout: 250 seconds < 1535841029 399058 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :zzo38: https://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/msg111795.html < 1535841160 741594 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :Yes, it is easier to make synonyms of the existing functions in the core rather than extensions. < 1535841231 848329 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :However, I looked at the Microsoft documentation linked; the WITHIN GROUP clause is something I would want for ordinary aggregate functions (currently only window functions can have their own ORDER BY clause; I wanted a ORDER BY clause for ordinary aggregate functions before, too, but did not know what syntax it should be). < 1535841369 12456 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :Still, I do not think it necessary to add another alias of an existing function there, but it might be worth while I don't know. < 1535841628 666575 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :PostgreSQL allows the ORDER BY clause inside of the argument list, which I think is probably better and what I thought of at first. < 1535841870 660239 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :zzo38: I think it might be better to have something that's like an ORDER BY clause for the SELECT query but that sorts the contents of each aggregate groups for all aggregate group (or all rows found if there's no GROUP BY) for aggregate functions iterating over the rows in that query. < 1535841938 627412 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :zzo38: so in a SELECT statement, HAVING filters whole aggregate groups, ORDER BY sorts whole aggregate groups, WHEN filters individual rows before they're aggregated, and there could be one to sort rows before they're aggregated. < 1535841989 668183 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :And then you could also add aggregate functions that take the value from the first row, the last row, or the nth row from the aggregate. < 1535842185 141012 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :There are already window functions for the first row, last row, etc, but these functions cannot be used as ordinary aggregate functions. < 1535842321 361439 :No!~No@119.192.123.219 JOIN :#esoteric < 1535842324 837242 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :zzo38: you could also define custom aggregate functions for selecting a value from the first row sorted on any number of an extra set of values, eg. first_by(x,y,z) would select the value of x from the row where (y,z) is the lexicographically smallest, and that would still be useful and you could use different orderings in the same query, < 1535842348 979500 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :except you can't make that use the string collation function of the y and z columns implicitly, but most of the time you don't care about that. < 1535842376 521716 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :You wouldn't need window functions for that. < 1535842400 865124 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :It gets ugly because you might want to sort DESC on some of the values, and it's harder to find a good syntax for that < 1535842426 330730 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :you'd probably need a version that takes an extra argument to tell which columns you want to sort DESC by < 1535842484 596860 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :Yes, that is why I think you should just use a ORDER BY clause in the argument list, with the words ORDER BY; even with GROUP_CONCAT function you might want ORDER BY < 1535842602 907704 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :The window function is "first_value" and if made a aggregate function to write for example: first_value(x ORDER BY y,z) < 1535842613 578819 :No!~No@119.192.123.219 QUIT :Remote host closed the connection < 1535842715 820695 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 QUIT :Quit: http://www.kiwiirc.com/ - A hand crafted IRC client < 1535842907 216691 :LKoen!~LKoen@vbo91-6-78-245-243-132.fbx.proxad.net QUIT :Quit: “It’s only logical. First you learn to talk, then you learn to think. Too bad it’s not the other way round.” > 1535843009 82965 PRIVMSG #esoteric :14[[07Vrty14]]4 10 02https://esolangs.org/w/index.php?diff=57501&oldid=57500 5* 03FAKE1007 5* (+2) 10 < 1535843174 388682 :imode!~imode@unaffiliated/imode JOIN :#esoteric < 1535844030 358169 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 JOIN :#esoteric < 1535844346 149751 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :zzo38: I see. Although on second thought, to get the first from a group like (SELECT t.u, first_value(t.x ORDER BY t.y, t.z) AS xf FROM mytable AS t GROUP BY t.u), < 1535844348 586106 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :you could currently use a subquery like (SELECT t.u, (SELECT i.x FROM mytable AS i WHERE i.u = t.u ORDER BY i.y, i.z) AS xf FROM t GROUP BY t.u) < 1535844563 519808 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :I think SQLite can optimize that pretty well if you add the right index, like CREATE INDEX ... ON t(u, y, z, x); < 1535844590 442126 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :no, that should be CREATE INDEX ... ON mytable(u, y, z, x); < 1535844619 278011 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :and the query with the subquery should be (SELECT t.u, (SELECT i.x FROM mytable AS i WHERE i.u = t.u ORDER BY i.y, i.z) AS xf FROM mytable AS t GROUP BY t.u) < 1535844680 823738 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Remote host closed the connection < 1535844683 373131 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 PRIVMSG #esoteric :and of course you can extend that with additional result columns, ORDER BY and HAVING and WHERE clauses etc, you just may have to repeat the HAVING for both the inner and outer query < 1535845124 60112 :wob_jonas!b03f1853@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.83 QUIT :Quit: http://www.kiwiirc.com/ - A hand crafted IRC client