< 1677723600 792454 :Lord_of_Life!~Lord@user/lord-of-life/x-2819915 QUIT :Ping timeout: 255 seconds < 1677723629 808888 :Lord_of_Life!~Lord@user/lord-of-life/x-2819915 JOIN #esolangs Lord_of_Life :Lord < 1677724504 110584 :razetime!~Thunderbi@117.193.7.114 JOIN #esolangs razetime :razetime < 1677728735 948947 :razetime!~Thunderbi@117.193.7.114 QUIT :Ping timeout: 248 seconds > 1677731040 960500 PRIVMSG #esolangs :14[[07User:Vandlen't14]]4 10 02https://esolangs.org/w/index.php?diff=107207&oldid=107189 5* 03Vandlen't 5* (+81) 10Changed page source. > 1677731117 690799 PRIVMSG #esolangs :14[[07Vandalang14]]4 10 02https://esolangs.org/w/index.php?diff=107208&oldid=107190 5* 03SpaceByte 5* (+7) 10 > 1677731180 746990 PRIVMSG #esolangs :14[[07Vandalang14]]4 10 02https://esolangs.org/w/index.php?diff=107209&oldid=107208 5* 03SpaceByte 5* (-7) 10 > 1677731319 626423 PRIVMSG #esolangs :14[[07User:Vandlen't14]]4 10 02https://esolangs.org/w/index.php?diff=107210&oldid=107207 5* 03Vandlen't 5* (+81) 10Changed page source. > 1677731325 573326 PRIVMSG #esolangs :14[[07Vandalang14]]4 10 02https://esolangs.org/w/index.php?diff=107211&oldid=107209 5* 03SpaceByte 5* (+7) 10 > 1677731394 22579 PRIVMSG #esolangs :14[[07Vandalang14]]4 10 02https://esolangs.org/w/index.php?diff=107212&oldid=107211 5* 03SpaceByte 5* (-7) 10 < 1677732112 983483 :razetime!~Thunderbi@117.193.7.114 JOIN #esolangs razetime :razetime < 1677733625 257714 :ais523!~ais523@31.94.27.30 QUIT :Quit: quit < 1677734748 947423 :razetime!~Thunderbi@117.193.7.114 QUIT :Ping timeout: 268 seconds < 1677734939 830680 :fungot!~fungot@2a01:4b00:82bb:1341::a QUIT :Ping timeout: 264 seconds < 1677735678 823321 :razetime!~Thunderbi@117.193.7.114 JOIN #esolangs razetime :razetime < 1677735827 319054 :slavfox!~slavfox@93.158.232.111 QUIT :Quit: ZNC 1.8.2 - https://znc.in < 1677735857 515448 :chiselfuse!~chiselfus@user/chiselfuse QUIT :Ping timeout: 255 seconds < 1677735992 532025 :chiselfuse!~chiselfus@user/chiselfuse JOIN #esolangs chiselfuse :chiselfuse < 1677736161 819813 :slavfox!~slavfox@93.158.232.111 JOIN #esolangs slavfox :slavfox < 1677739058 973538 :bgs!~bgs@212-85-160-171.dynamic.telemach.net JOIN #esolangs bgs :bgs < 1677740406 484865 :tromp!~textual@92-110-219-57.cable.dynamic.v4.ziggo.nl JOIN #esolangs * :Textual User < 1677744101 600910 :tromp!~textual@92-110-219-57.cable.dynamic.v4.ziggo.nl QUIT :Quit: My iMac has gone to sleep. ZZZzzz… < 1677744323 803612 :razetime!~Thunderbi@117.193.7.114 QUIT :Ping timeout: 260 seconds < 1677744491 765752 :Sgeo!~Sgeo@user/sgeo QUIT :Read error: Connection reset by peer < 1677744574 427471 :tromp!~textual@92-110-219-57.cable.dynamic.v4.ziggo.nl JOIN #esolangs * :Textual User < 1677745890 35215 :razetime!~Thunderbi@117.193.7.114 JOIN #esolangs razetime :razetime < 1677748950 930333 :razetime1!~Thunderbi@117.254.35.192 JOIN #esolangs razetime :razetime < 1677749000 969922 :razetime!~Thunderbi@117.193.7.114 QUIT :Ping timeout: 255 seconds < 1677749001 590176 :razetime1!~Thunderbi@117.254.35.192 NICK :razetime < 1677750112 779104 :razetime1!~Thunderbi@117.193.3.202 JOIN #esolangs razetime :razetime < 1677750177 929694 :razetime!~Thunderbi@117.254.35.192 QUIT :Ping timeout: 268 seconds < 1677750178 471210 :razetime1!~Thunderbi@117.193.3.202 NICK :razetime < 1677753330 247767 :razetime!~Thunderbi@117.193.3.202 QUIT :Remote host closed the connection < 1677754189 988204 :__monty__!~toonn@user/toonn JOIN #esolangs toonn :Unknown < 1677760093 857716 :tromp!~textual@92-110-219-57.cable.dynamic.v4.ziggo.nl QUIT :Quit: My iMac has gone to sleep. ZZZzzz… < 1677764705 153303 :tromp!~textual@92-110-219-57.cable.dynamic.v4.ziggo.nl JOIN #esolangs * :Textual User > 1677769428 810050 PRIVMSG #esolangs :14[[07LaserFuck14]]4 10 02https://esolangs.org/w/index.php?diff=107213&oldid=98292 5* 03Joaozin003 5* (-8) 10 < 1677769779 142275 :wib_jonas!~wib_jonas@business-37-191-60-209.business.broadband.hu JOIN #esolangs b_jonas :[https://web.libera.chat] wib_jonas < 1677769965 41488 :wib_jonas!~wib_jonas@business-37-191-60-209.business.broadband.hu PRIVMSG #esolangs :TIL in SQL syntax that "LIMIT 50", to restrict a select statement to return only the first 50 rows in the order give by its ORDER BY, is spelled in MS SQL as "OFFSET 0 ROW FETCH NEXT 50 ROW ONLY". It seems like none of the words or parts of that spelling is optional, so I'm not just cheating by adding extra nop words. < 1677770081 136239 :wib_jonas!~wib_jonas@business-37-191-60-209.business.broadband.hu PRIVMSG #esolangs :There's also an alternate MS SQL syntax "TOP 50", but you put that after "SELECT and before the list of columns to be selected, with no separator, so you have two expressions adjacent to each other with no separator, which is error-prone and will make it even harder than usual in MS SQL to find out what the syntax error in your query is, so I don't < 1677770081 635483 :wib_jonas!~wib_jonas@business-37-191-60-209.business.broadband.hu PRIVMSG #esolangs :think I'll use it. And no, you can't just write "TOP 50 ROWS" to have a separator. < 1677770120 274664 :wib_jonas!~wib_jonas@business-37-191-60-209.business.broadband.hu PRIVMSG #esolangs :Also while DO is a keyword in some SQLs, PLEASE apparently isn't yet. < 1677770425 143815 :wib_jonas!~wib_jonas@business-37-191-60-209.business.broadband.hu PRIVMSG #esolangs :they should have required "OFFSET 0 ROW BUT PLEASE FETCH NEXT 50 ROW ONLY SO USERS PAGE THROUGH UNNECESSARILY SHORT WINDOWS OF DATA ON MY WEBPAGE TO SERVE MORE ADS" as the syntax so that SQL is readable < 1677770439 329339 :fizzie!irc@selene.zem.fi PRIVMSG #esolangs :That sounds a little like one of those window definitions. < 1677770453 250618 :fizzie!irc@selene.zem.fi PRIVMSG #esolangs :ROWS BETWEEN UNBOUNDED PRECEDING AND 5 FOLLOWING EXCLUDE CURRENT ROW and so on. < 1677770657 271356 :wib_jonas!~wib_jonas@business-37-191-60-209.business.broadband.hu PRIVMSG #esolangs :in a saner version of SQL, most of those words would be optional, like [OFFSET 0 [ROW|ROWS]] FETCH [NEXT|FIRST] 50 [ROW|ROWS] [ONLY]. MS SQL allows the alternate keywords, but not omitting any of them. < 1677770765 716311 :wib_jonas!~wib_jonas@business-37-191-60-209.business.broadband.hu PRIVMSG #esolangs :(they should have added more synonyms, so SEEK 0 ROWS ACQUIRE FIRST 50 ROWS MERELY works too)\ < 1677770787 957154 :Sgeo!~Sgeo@user/sgeo JOIN #esolangs Sgeo :realname < 1677771333 191268 :wib_jonas!~wib_jonas@business-37-191-60-209.business.broadband.hu PRIVMSG #esolangs :SQL should gain some Intercal features, they're a good combination in syntax and arcanness of rules. REINSTATE UPDATING for example, but more importantly randomization percentages so you can make constraints that are enforced only 90% of the time, or triggers that trigger only 10% of the time. < 1677771574 181608 :wib_jonas!~wib_jonas@business-37-191-60-209.business.broadband.hu PRIVMSG #esolangs :also new conflict handling strategies: INSERT OR FORGET and INSERT OR RESUME < 1677772043 686052 :wib_jonas!~wib_jonas@business-37-191-60-209.business.broadband.hu PRIVMSG #esolangs :by the way, where's fungot? < 1677772311 885831 :int-e!~noone@int-e.eu PRIVMSG #esolangs :Well I hope they're having fun. < 1677772502 679842 :tromp!~textual@92-110-219-57.cable.dynamic.v4.ziggo.nl QUIT :Quit: My iMac has gone to sleep. ZZZzzz… < 1677772601 885277 :FireFly!~firefly@glowbum/gluehwuermchen/firefly PRIVMSG #esolangs :wib_jonas: "select top x ..." is what I've heard of/seen done before, at least < 1677772618 877933 :FireFly!~firefly@glowbum/gluehwuermchen/firefly PRIVMSG #esolangs :for MSSQL limits < 1677772632 569623 :FireFly!~firefly@glowbum/gluehwuermchen/firefly PRIVMSG #esolangs :SQL is possibly the one spec that is even less standardised than IRC lol < 1677772651 611530 :FireFly!~firefly@glowbum/gluehwuermchen/firefly PRIVMSG #esolangs :in that there is a standard and everyone promptly ignores it and reality doesn't match it very well < 1677773170 98126 :tromp!~textual@92-110-219-57.cable.dynamic.v4.ziggo.nl JOIN #esolangs * :Textual User < 1677773394 270566 :wib_jonas!~wib_jonas@business-37-191-60-209.business.broadband.hu PRIVMSG #esolangs :FireFly: as far as I understand there's a standard and implementations mostly follow it, but the standard specifies so few features that everyone needs to use lots of extensions. Imagine if you wish the C standard with its standard library, plus a thousand vendor libraries. < 1677773496 602552 :FireFly!~firefly@glowbum/gluehwuermchen/firefly PRIVMSG #esolangs :I guess something like that, though I think there's also spec things that some implementations just diverged on early and now that ecosystem is set in its ways < 1677773507 692412 :wib_jonas!~wib_jonas@business-37-191-60-209.business.broadband.hu PRIVMSG #esolangs :sure < 1677773522 533547 :FireFly!~firefly@glowbum/gluehwuermchen/firefly PRIVMSG #esolangs :I guess there's less of like, "library code useful between implementations" compared to conventional programming languages < 1677773570 493598 :wib_jonas!~wib_jonas@business-37-191-60-209.business.broadband.hu PRIVMSG #esolangs :and then https://xkcd.com/927/ I guess < 1677773619 102963 :FireFly!~firefly@glowbum/gluehwuermchen/firefly PRIVMSG #esolangs :yeah > 1677773788 394668 PRIVMSG #esolangs :14[[07User:CappyIsCrappy14]]4 10 02https://esolangs.org/w/index.php?diff=107214&oldid=97395 5* 03Joaozin003 5* (+34) 10 > 1677773849 723437 PRIVMSG #esolangs :14[[07User:Joaozin00314]]4 10 02https://esolangs.org/w/index.php?diff=107215&oldid=107041 5* 03Joaozin003 5* (+40) 10/* Links */ < 1677774671 851453 :razetime!~Thunderbi@117.193.3.202 JOIN #esolangs razetime :razetime < 1677775436 41537 :wib_jonas!~wib_jonas@business-37-191-60-209.business.broadband.hu QUIT :Quit: Client closed > 1677776409 140914 PRIVMSG #esolangs :14[[07Trainfck14]]4 10 02https://esolangs.org/w/index.php?diff=107216&oldid=107003 5* 03Mujk 5* (+64) 10/* language */ > 1677776558 824546 PRIVMSG #esolangs :14[[07Multidodecagony14]]4 10 02https://esolangs.org/w/index.php?diff=107217&oldid=106061 5* 03Joaozin003 5* (+0) 10/* I/O commands */ > 1677776585 902736 PRIVMSG #esolangs :14[[07Multidodecagony14]]4 10 02https://esolangs.org/w/index.php?diff=107218&oldid=107217 5* 03Joaozin003 5* (+27) 10 > 1677777625 227908 PRIVMSG #esolangs :14[[07Talk:Snowflake14]]4 10 02https://esolangs.org/w/index.php?diff=107219&oldid=76041 5* 03Joaozin003 5* (+96) 10/* Is there a version of this without interpreter-self-modification? */ new section < 1677778934 991772 :razetime!~Thunderbi@117.193.3.202 QUIT :Remote host closed the connection < 1677780371 838209 :perlbot!~perlbot@perlbot/bot/simcop2387/perlbot QUIT :Ping timeout: 264 seconds < 1677780381 767510 :simcop2387!~simcop238@perlbot/patrician/simcop2387 QUIT :Ping timeout: 255 seconds < 1677780910 956405 :simcop2387!~simcop238@perlbot/patrician/simcop2387 JOIN #esolangs simcop2387 :ZNC - https://znc.in < 1677781062 727756 :perlbot!~perlbot@perlbot/bot/simcop2387/perlbot JOIN #esolangs perlbot :ZNC - https://znc.in < 1677781838 841819 :tromp!~textual@92-110-219-57.cable.dynamic.v4.ziggo.nl QUIT :Quit: My iMac has gone to sleep. ZZZzzz… < 1677784183 440605 :tromp!~textual@92-110-219-57.cable.dynamic.v4.ziggo.nl JOIN #esolangs * :Textual User > 1677787095 196095 PRIVMSG #esolangs :14[[07XY problem14]]4 M10 02https://esolangs.org/w/index.php?diff=107220&oldid=107203 5* 03Hakerh400 5* (-948) 10 < 1677787300 301437 :zzo38!~zzo38@host-24-207-14-22.public.eastlink.ca PRIVMSG #esolangs :I think that they should allow to abbreviate "ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING" as "ALL ROWS", but they don't. > 1677788867 828958 PRIVMSG #esolangs :14[[07SideStacks14]]4 M10 02https://esolangs.org/w/index.php?diff=107221&oldid=105175 5* 03Myoitzi 5* (+0) 10 > 1677791127 747212 PRIVMSG #esolangs :14[[07Shader state14]]4 10 02https://esolangs.org/w/index.php?diff=107222&oldid=101103 5* 03Joaozin003 5* (+8) 10Added WIP template < 1677794060 24976 :zzo38!~zzo38@host-24-207-14-22.public.eastlink.ca PRIVMSG #esolangs :You can make triggers that only trigger 10% of the time in SQL if you use WHEN RANDOM(). However, being able to ABSTAIN and REINSTATE might sometimes be useful, including to prevent all triggers from firing; being able to specify this as a part of the statement causing the triggers to fire (so that it doesn't fire) might be the way to be done. < 1677794843 887940 :m5zs7k!aquares@web10.mydevil.net QUIT :Ping timeout: 264 seconds < 1677794867 276010 :m5zs7k!aquares@web10.mydevil.net JOIN #esolangs m5zs7k :m5zs7k < 1677795008 864052 :tromp!~textual@92-110-219-57.cable.dynamic.v4.ziggo.nl QUIT :Quit: My iMac has gone to sleep. ZZZzzz… < 1677796013 512413 :chiselfuse!~chiselfus@user/chiselfuse QUIT :Ping timeout: 255 seconds < 1677796129 528161 :chiselfuse!~chiselfus@user/chiselfuse JOIN #esolangs chiselfuse :chiselfuse < 1677796330 750504 :__monty__!~toonn@user/toonn QUIT :Quit: leaving < 1677796364 900899 :tromp!~textual@92-110-219-57.cable.dynamic.v4.ziggo.nl JOIN #esolangs * :Textual User < 1677801251 537848 :chiselfuse!~chiselfus@user/chiselfuse QUIT :Ping timeout: 255 seconds < 1677801360 538828 :chiselfuse!~chiselfus@user/chiselfuse JOIN #esolangs chiselfuse :chiselfuse < 1677801365 802287 :tromp!~textual@92-110-219-57.cable.dynamic.v4.ziggo.nl QUIT :Quit: My iMac has gone to sleep. ZZZzzz…