< 1537056026 838622 :Phantom_Hoover!~phantomho@unaffiliated/phantom-hoover QUIT :Remote host closed the connection < 1537057333 78953 :Essadon!~Essadon@81-225-32-185-no249.tbcn.telia.com QUIT :Quit: Qutting < 1537058202 497164 :defterade!~defterade@110.78.147.216 JOIN :#esoteric < 1537058505 953648 :defterade!~defterade@110.78.147.216 QUIT :Remote host closed the connection < 1537058767 902077 :atslash!~atslash@static.231.107.9.5.clients.your-server.de QUIT :Quit: This computer has gone to sleep < 1537059685 185577 :baggar113!~baggar11@2402:800:610b:5a42:9db8:fca1:316d:7799 JOIN :#esoteric < 1537059740 489739 :MDude!~MDude@c-73-187-225-46.hsd1.pa.comcast.net JOIN :#esoteric < 1537059851 605397 :baggar113!~baggar11@2402:800:610b:5a42:9db8:fca1:316d:7799 QUIT :Remote host closed the connection < 1537060154 64880 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :Oops I found another bug in SQLite that it segfaults if the argument to sqlite3_declare_vtab() specifies a "INTEGER PRIMARY KEY" column and also "WITHOUT ROWID". (Although, it is possible to work around by changing it to "INT PRIMARY KEY", but still it is a bug) < 1537060262 21777 :oerjan!oerjan@hagbart.nvg.ntnu.no JOIN :#esoteric < 1537062367 974880 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :Now I made a SQLite extension that for example you can write: create virtual table out using audiopipe('aplay -t raw -c 1 -f S32_LE -r 44100' signed integer mono); insert into out select value,sin(value*tau()*440/44100)*.9 from range(0,44099,1); and you can make the tone audible. < 1537062410 138414 :oerjan!oerjan@hagbart.nvg.ntnu.no PRIVMSG #esoteric : Are there any languages on the wiki with names like "User:Oerjan" or "Special: Search"? <-- i don't think the latter is possible to create under that article name < 1537062432 569889 :oerjan!oerjan@hagbart.nvg.ntnu.no PRIVMSG #esoteric :unless fizzie hacks something, i guess < 1537062435 355693 :shachaf!~shachaf@unaffiliated/shachaf PRIVMSG #esoteric :oerjan: I meant "Special:Search" but I was typing on my phone. < 1537062446 32651 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :(This assumes your computer is small-endian and "int" size is 32-bits) < 1537062450 303060 :oerjan!oerjan@hagbart.nvg.ntnu.no PRIVMSG #esoteric :well even worse < 1537062481 783148 :oerjan!oerjan@hagbart.nvg.ntnu.no PRIVMSG #esoteric :but Special: is special, so you cannot create ordinary articles there < 1537062490 113356 :oerjan!oerjan@hagbart.nvg.ntnu.no PRIVMSG #esoteric :(well, i assume) < 1537062566 376158 :oerjan!oerjan@hagbart.nvg.ntnu.no PRIVMSG #esoteric :hm was there an esolang in Talk: < 1537062652 327464 :oerjan!oerjan@hagbart.nvg.ntnu.no PRIVMSG #esoteric :hm maybe not, but there's https://esolangs.org/wiki/Talk_talk:Turing_tarpit < 1537062737 740095 :oerjan!oerjan@hagbart.nvg.ntnu.no PRIVMSG #esoteric :i guess : is allowed in article names when what's before isn't a namespace. < 1537062781 354276 :shachaf!~shachaf@unaffiliated/shachaf PRIVMSG #esoteric :i propose a Real Fast Nora's Hair Salon 3: namespace hth > 1537063012 417374 PRIVMSG #esoteric :14[[07Amycus14]]4 10 02https://esolangs.org/w/index.php?diff=57647&oldid=57644 5* 03Oerjan 5* (-96) 10/* Amycus Severus */ This seems to have been renamed > 1537063303 866117 PRIVMSG #esoteric :14[[07Talk:Amycus14]]4 10 02https://esolangs.org/w/index.php?diff=57648&oldid=57630 5* 03Zzo38 5* (+290) 10 > 1537063311 623346 PRIVMSG #esoteric :14[[07User talk:Star65114]]4 M10 02https://esolangs.org/w/index.php?diff=57649&oldid=57633 5* 03Oerjan 5* (+50) 10/* Um. */ Unsigned < 1537066185 677282 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net JOIN :#esoteric < 1537067117 88330 :rodgort!~rodgort@68.ip-149-56-14.net QUIT :Quit: Leaving < 1537067377 311010 :rodgort!~rodgort@68.ip-149-56-14.net JOIN :#esoteric < 1537068186 510349 :MDead!~MDude@c-73-187-225-46.hsd1.pa.comcast.net JOIN :#esoteric < 1537068228 493712 :MDude!~MDude@c-73-187-225-46.hsd1.pa.comcast.net QUIT :Ping timeout: 252 seconds < 1537068233 688899 :MDead!~MDude@c-73-187-225-46.hsd1.pa.comcast.net NICK :MDude < 1537069478 455610 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net QUIT :Ping timeout: 245 seconds < 1537072557 426225 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net JOIN :#esoteric < 1537074702 500193 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1537074947 331886 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Ping timeout: 240 seconds < 1537077979 372379 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1537078228 306026 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Ping timeout: 245 seconds < 1537080025 669336 :copumpkin!~copumpkin@haskell/developer/copumpkin QUIT :Quit: My MacBook Pro has gone to sleep. ZZZzzz… < 1537080547 493867 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1537080793 640882 :nisstyre25!~nisstyre@184.170.49.155 JOIN :#esoteric < 1537080801 495423 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Ping timeout: 252 seconds < 1537081084 968751 :nisstyre25!~nisstyre@184.170.49.155 QUIT :Remote host closed the connection > 1537081217 436969 PRIVMSG #esoteric :14[[07Shorten your Brainfuck code14]]4 10 02https://esolangs.org/w/index.php?diff=57650&oldid=56875 5* 03A 5* (+67) 10 > 1537081241 850386 PRIVMSG #esoteric :14[[07Shorten your Brainfuck code14]]4 10 02https://esolangs.org/w/index.php?diff=57651&oldid=57650 5* 03A 5* (+4) 10... > 1537081372 177903 PRIVMSG #esoteric :14[[07Shorten your Brainfuck code14]]4 10 02https://esolangs.org/w/index.php?diff=57652&oldid=57651 5* 03A 5* (+26) 10Title not good enough < 1537081556 951736 :xkapastel!uid17782@gateway/web/irccloud.com/x-rjgresggawoyszwe QUIT :Quit: Connection closed for inactivity > 1537081825 546181 PRIVMSG #esoteric :14[[07Shorten your Brainfuck code14]]4 10 02https://esolangs.org/w/index.php?diff=57653&oldid=57652 5* 03A 5* (+69) 10/* Big width loops(for easier byte printing) */ < 1537081948 176562 :oerjan!oerjan@hagbart.nvg.ntnu.no QUIT :Quit: Nite < 1537082066 910078 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1537082221 84556 :copumpkin!~copumpkin@haskell/developer/copumpkin JOIN :#esoteric < 1537082503 342245 :copumpkin!~copumpkin@haskell/developer/copumpkin QUIT :Ping timeout: 245 seconds > 1537082625 141082 PRIVMSG #esoteric :14[[07Shorten your Brainfuck code14]]4 10 02https://esolangs.org/w/index.php?diff=57654&oldid=57653 5* 03A 5* (+60) 10/* Big width loops(for easier byte printing) */ > 1537082645 139376 PRIVMSG #esoteric :14[[07Shorten your Brainfuck code14]]4 10 02https://esolangs.org/w/index.php?diff=57655&oldid=57654 5* 03A 5* (+2) 10/* Big width loops(for easier byte printing) */ > 1537082680 977969 PRIVMSG #esoteric :14[[07Shorten your Brainfuck code14]]4 10 02https://esolangs.org/w/index.php?diff=57656&oldid=57655 5* 03A 5* (+30) 10/* Big width loops(for easier byte printing) */ < 1537082944 494766 :MDude!~MDude@c-73-187-225-46.hsd1.pa.comcast.net QUIT :Ping timeout: 244 seconds > 1537082978 509402 PRIVMSG #esoteric :14[[07Shorten your Brainfuck code14]]4 10 02https://esolangs.org/w/index.php?diff=57657&oldid=57656 5* 03A 5* (+44) 10/* Big width loops(for easier byte printing) */ < 1537084183 850704 :moei!~moei@softbank221078042071.bbtec.net QUIT :Read error: Connection reset by peer < 1537084217 493084 :moei!~moei@softbank221078042071.bbtec.net JOIN :#esoteric < 1537084427 378571 :pikhq!~pikhq@c-73-181-126-9.hsd1.co.comcast.net QUIT :Ping timeout: 240 seconds < 1537085075 852345 :pikhq!~pikhq@c-73-181-126-9.hsd1.co.comcast.net JOIN :#esoteric < 1537089398 683366 :jakew!~jakew@ftth-169.30.dws.ne.jp JOIN :#esoteric < 1537089572 127568 :jakew!~jakew@ftth-169.30.dws.ne.jp QUIT :Remote host closed the connection < 1537090525 965432 :AnotherTest!~turingcom@ptr-82l26zdn9kx2rnn81vw.18120a2.ip6.access.telenet.be JOIN :#esoteric < 1537093317 9714 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net QUIT :Ping timeout: 272 seconds < 1537094310 883846 :Phantom_Hoover!~phantomho@unaffiliated/phantom-hoover JOIN :#esoteric < 1537095206 464265 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net JOIN :#esoteric < 1537095420 496590 :nfd9001!~nfd9001@c-73-157-90-101.hsd1.wa.comcast.net QUIT :Ping timeout: 252 seconds < 1537095447 493512 :nfd9001!~nfd9001@2601:602:8500:d0d1:eda6:ef4e:d55:e653 JOIN :#esoteric < 1537098139 376569 :Patzy17!~Patzy@187.111.215.89 JOIN :#esoteric < 1537098253 975779 :arseniiv_!~arseniiv@46.191.139.186 JOIN :#esoteric < 1537098642 390768 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net QUIT :Ping timeout: 252 seconds < 1537098678 366572 :Patzy17!~Patzy@187.111.215.89 QUIT :Ping timeout: 245 seconds < 1537100412 618377 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net JOIN :#esoteric < 1537100667 495842 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net QUIT :Ping timeout: 252 seconds < 1537101025 776398 :xkapastel!uid17782@gateway/web/irccloud.com/x-eglihkqllnuipvzo JOIN :#esoteric < 1537101142 253574 :wob_jonas!b03f1883@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.131 PRIVMSG #esoteric :zzo38: in Amycus,where you write succ(<<>: (succ → )>) = ;, does that mean succ(<<>: p>) = where = succ(p); ? < 1537101158 696238 :wob_jonas!b03f1883@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.131 PRIVMSG #esoteric :zzo38: because I think that's more easy to understand than the view pattern < 1537101865 525458 :wob_jonas!b03f1883@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.131 PRIVMSG #esoteric :shachaf: yes, but you can still try to give that name to a language, and document it under a different page name with a "technical reasons" hatnote. that's the usual workaround. < 1537101923 308255 :wob_jonas!b03f1883@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.131 PRIVMSG #esoteric :also, random tidbit, on en.wikipedia, we can't create page names starting with "M:tG" because "M:" is an interwiki prefix for meta.wikimedia.org < 1537102126 822520 :SopaXorzTaker!~SopaXorzT@unaffiliated/sopaxorztaker JOIN :#esoteric < 1537102225 595339 :FireFly!znc@freenode/staff/firefly PRIVMSG #esoteric :Heh < 1537102250 966475 :FireFly!znc@freenode/staff/firefly PRIVMSG #esoteric :Although it probably wouldn't be an appropriate page name either way (for policy reasons rather than technical ones, though) < 1537102814 972650 :wob_jonas!b03f1883@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.131 PRIVMSG #esoteric :FireFly: en.wikipedia has have lots of local redirects starting with "W:" or "T:" or a few other letters that aren't interwiki links actually < 1537102845 75960 :wob_jonas!b03f1883@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.131 PRIVMSG #esoteric :"W:" for abbreviated names in Project:, "T:" for abbreviated names in Template: etc < 1537102942 583437 :wob_jonas!b03f1883@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.131 PRIVMSG #esoteric :FireFly: certain two or three letter combos with colon are much riskier, because new languages of wikipedia get started all the time, and get two or three letter interwiki prefixes most of the time, whereas new one-letter abbreviations are rare < 1537102961 839808 :FireFly!znc@freenode/staff/firefly PRIVMSG #esoteric :*nod* < 1537102997 456797 :wob_jonas!b03f1883@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.131 PRIVMSG #esoteric :Though some of those shortcuts might predate interwikimedia links in en.wikipedia < 1537103582 495560 :fredrikh1!~fredrikh1@p508506E6.dip0.t-ipconnect.de JOIN :#esoteric < 1537103750 420062 :fredrikh1!~fredrikh1@p508506E6.dip0.t-ipconnect.de QUIT :Remote host closed the connection < 1537104318 332389 :atslash!~atslash@static.231.107.9.5.clients.your-server.de JOIN :#esoteric < 1537104405 78150 :wob_jonas!b03f1883@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.131 PRIVMSG #esoteric :In fact, I suspect Wiktionary didn't get a one-letter shortcut because they didn't want to disrupt all the existing "T:" links everywhere < 1537105033 569550 :wob_jonas!b03f1883@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.24.131 QUIT :Quit: http://www.kiwiirc.com/ - A hand crafted IRC client < 1537108306 785509 :arseniiv_!~arseniiv@46.191.139.186 PART :#esoteric < 1537108318 62044 :arseniiv!~arseniiv@46.191.139.186 JOIN :#esoteric < 1537108699 961614 :Sgeo_!~Sgeo@ool-18b98dd9.dyn.optonline.net JOIN :#esoteric < 1537108744 956056 :Sgeo!~Sgeo@ool-18b98dd9.dyn.optonline.net QUIT :Ping timeout: 272 seconds < 1537108947 936322 :LKoen!~LKoen@vbo91-6-78-245-243-132.fbx.proxad.net JOIN :#esoteric < 1537109205 131887 :atslash!~atslash@static.231.107.9.5.clients.your-server.de QUIT :Quit: This computer has gone to sleep < 1537109693 844724 :atslash!~atslash@static.231.107.9.5.clients.your-server.de JOIN :#esoteric < 1537110376 539441 :Essadon!~Essadon@81-225-32-185-no249.tbcn.telia.com JOIN :#esoteric < 1537110480 687975 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net JOIN :#esoteric < 1537110714 388544 :copumpkin!~copumpkin@haskell/developer/copumpkin JOIN :#esoteric < 1537110765 496872 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net QUIT :Ping timeout: 252 seconds < 1537111592 484868 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :It is what I mean; change it if you want to < 1537112276 599490 :TSS3000RO17!~TSS3000RO@134.236.138.48 JOIN :#esoteric < 1537112318 930384 :TSS3000RO17!~TSS3000RO@134.236.138.48 QUIT :Remote host closed the connection < 1537112500 527830 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net JOIN :#esoteric < 1537112747 425528 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net QUIT :Ping timeout: 240 seconds < 1537113050 718528 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net JOIN :#esoteric < 1537113324 459479 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net QUIT :Ping timeout: 244 seconds < 1537113758 813276 :SopaXorzTaker!~SopaXorzT@unaffiliated/sopaxorztaker QUIT :Quit: Leaving > 1537114283 403175 PRIVMSG #esoteric :14[[07Special:Log/newusers14]]4 create10 02 5* 03YouXplode 5* 10New user account > 1537114771 130267 PRIVMSG #esoteric :14[[07Esolang:Introduce yourself14]]4 M10 02https://esolangs.org/w/index.php?diff=57658&oldid=57543 5* 03YouXplode 5* (+170) 10Added introduction stuff > 1537114863 890203 PRIVMSG #esoteric :14[[07Flip14]]4 M10 02https://esolangs.org/w/index.php?diff=57659&oldid=34279 5* 03YouXplode 5* (+104) 10Added another external resource. > 1537114924 88318 PRIVMSG #esoteric :14[[07Flip14]]4 M10 02https://esolangs.org/w/index.php?diff=57660&oldid=57659 5* 03YouXplode 5* (+28) 10Messed up earlier < 1537115104 374603 :XorSwap!~XorSwap@wnpgmb016qw-ppp-103-253.dynamic.bellmts.net QUIT :Quit: the creeping crawling chaos will return. < 1537115139 88421 :S_Gautam!uid286066@gateway/web/irccloud.com/x-greustsgslagmjij JOIN :#esoteric < 1537115164 421620 :ATMunn!ATMunn@unaffiliated/atmunn QUIT :Quit: lol rip < 1537115258 712018 :ATMunn!ATMunn@unaffiliated/atmunn JOIN :#esoteric < 1537115754 690042 :ais523!~ais523@unaffiliated/ais523 JOIN :#esoteric < 1537115819 279288 :ais523!~ais523@unaffiliated/ais523 PRIVMSG #esoteric :@messages? < 1537115819 545168 :lambdabot!~lambdabot@haskell/bot/lambdabot PRIVMSG #esoteric :Sorry, no messages today. < 1537116091 400534 :ais523!~ais523@unaffiliated/ais523 PRIVMSG #esoteric :re: namespaces, it'd be nice if : was an escape character /everywhere/ < 1537116117 870135 :ais523!~ais523@unaffiliated/ais523 PRIVMSG #esoteric :e.g. you could put a colon at the start of any article name to put it into the main namespace < 1537116141 66935 :ais523!~ais523@unaffiliated/ais523 PRIVMSG #esoteric :although then you'd have to change the existing :Category: syntax for linking to a category without incoporating the article into the category < 1537116165 466517 :ais523!~ais523@unaffiliated/ais523 PRIVMSG #esoteric :(that said, the [[Category:Languages]] syntax is pretty nonorthogonal as it is) < 1537116928 495551 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net JOIN :#esoteric < 1537117188 337691 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net QUIT :Ping timeout: 252 seconds < 1537117342 831687 :Pilate29!~Pilate@138-204-70-203.wantel.net.br JOIN :#esoteric < 1537117464 414913 :Pilate29!~Pilate@138-204-70-203.wantel.net.br QUIT :Killed (Sigyn (Spam is off topic on freenode.)) < 1537118279 557600 :SopaXorzTaker!~SopaXorzT@unaffiliated/sopaxorztaker JOIN :#esoteric < 1537118286 672675 :SopaXorzTaker!~SopaXorzT@unaffiliated/sopaxorztaker QUIT :Remote host closed the connection < 1537118354 71478 :XorSwap!~XorSwap@wnpgmb016qw-ppp-103-253.dynamic.bellmts.net JOIN :#esoteric < 1537120557 329341 :wob_jonas!b03f1932@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.25.50 JOIN :#esoteric > 1537120654 829985 PRIVMSG #esoteric :14[[07Amycus14]]4 10 02https://esolangs.org/w/index.php?diff=57661&oldid=57647 5* 03B jonas 5* (+4) 10/* Implementing */ < 1537120837 593849 :wob_jonas!b03f1932@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.25.50 PRIVMSG #esoteric :ais523: [[:Category:foo]] is just one of the uses, there's also [[:File:foo]] to link instead of embed. what if you used the character < or > in double-bracket links instead of trying to change how : works? < 1537120868 195553 :ais523!~ais523@unaffiliated/ais523 PRIVMSG #esoteric :embedding of an image should be {{File:foo}} < 1537120874 193809 :ais523!~ais523@unaffiliated/ais523 PRIVMSG #esoteric :as that's pretty much just a transclusion < 1537120923 547009 :wob_jonas!b03f1932@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.25.50 PRIVMSG #esoteric :ais523: yes, but it's too late to change that in Mediawiki. {{File:Foo}} already transcludes the page for the media. < 1537120937 674487 :ais523!~ais523@unaffiliated/ais523 PRIVMSG #esoteric :it's too late to change most of htis < 1537120945 74691 :wob_jonas!b03f1932@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.25.50 PRIVMSG #esoteric :same for categories < 1537120948 315394 :ais523!~ais523@unaffiliated/ais523 PRIVMSG #esoteric :but you could probably do it correctly if you designed a wikimarkup syntax from scratch < 1537120973 116698 :ais523!~ais523@unaffiliated/ais523 PRIVMSG #esoteric :you should probably have different names for the image and the image description page… < 1537121051 931668 :wob_jonas!b03f1932@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.25.50 PRIVMSG #esoteric :the image isn't even a page. it's in a totally different dimension from the desc page. mediawiki actually allows you to create just the desc page in File: ns with no versions of the file uploaded (yet) < 1537122005 421201 :SopaXorzTaker!~SopaXorzT@unaffiliated/sopaxorztaker JOIN :#esoteric < 1537122456 969441 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :Is there a MediaWiki extension to embed SQL codes into a page? If no virtual tables are enabled then only the data specified by other SQL codes in that page or transcluded into that page are used, but some virtual tables may be enabled that can be used to access other stuff too such as other wiki pages and history and so on. You can then use the WIKI_TABLE aggregate function to make a table, and you can also specify queries that aren't included in < 1537122512 804822 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :Another extension I was interested in is a extension to use TeX codes without texvc, instead using a custom format file (that I wrote) to disable some functions (so that it cannot read or write any external files or use \special). < 1537122538 504755 :wob_jonas!b03f1932@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.25.50 PRIVMSG #esoteric :zzo38: dunno. look at what external stuff the lua extension can access. < 1537122650 693829 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :(I have not checked if the PHP interface for SQLite allows you to set an authorizer callback or set limits, or to load extensions or define your own virtual tables and aggregate functions.) < 1537122684 697336 :wob_jonas!b03f1932@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.25.50 PRIVMSG #esoteric :zzo38: why is SQLite relevant? is it even used anywhere in MediaWiki? < 1537122701 774867 :wob_jonas!b03f1932@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.25.50 PRIVMSG #esoteric :I think mediawiki uses some other database as its backend < 1537122724 263943 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :I think it supports SQLite as an option (I am not sure; I don't remember). < 1537122824 243101 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :I also don't know if the other database backends even have a authorizer callback or can create in memory databases or virtual tables (although if the same backend is used for the user SQL codes as the MediaWiki storage database then you might not need virtual tables). < 1537122862 325777 :wob_jonas!b03f1932@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.25.50 PRIVMSG #esoteric :many database backends have a users and permissions system instead of an authorizer callback < 1537122879 59764 :wob_jonas!b03f1932@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.25.50 PRIVMSG #esoteric :and you can add custom views and functions to add authorized things < 1537122910 137426 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :Yes, I knew about custom views < 1537122917 891566 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :And can you associate RDF data with a MediaWiki article with any extension? < 1537122929 191036 :wob_jonas!b03f1932@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.25.50 PRIVMSG #esoteric :I don't know < 1537122952 29045 :wob_jonas!b03f1932@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.25.50 PRIVMSG #esoteric :you can try one of https://meta.wikimedia.org/wiki/IRC_channels < 1537124177 514148 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net JOIN :#esoteric < 1537124198 282859 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :Do you think the window functions in SQLite is good? I think there is many use of it. But, you cannot nest window functions or use them in a aggregate query or in a UPDATE statement; although there are ways to work around all of these things (by using subqueries, or in the case of UPDATE, to use REPLACE INTO instead, if it is suitable to what you are making; to use this with virtual tables you must implement REPLACE for those virtual tables). < 1537124288 700523 :wob_jonas!b03f1932@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.25.50 PRIVMSG #esoteric :zzo38: I don't really know. it seems like a compatibility thing that one paying customer of sqlite3 required for porting scripts from some other database engine, because half of the docs is about crazy compatibility rules, not like any sane design sqlite would add on its own < 1537124329 226601 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :Maybe that is why they put it in; I don't know. < 1537124348 632782 :wob_jonas!b03f1932@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.25.50 PRIVMSG #esoteric :it can be both < 1537124353 991809 :SopaXorzTaker!~SopaXorzT@unaffiliated/sopaxorztaker QUIT :Remote host closed the connection < 1537124398 744893 :wob_jonas!b03f1932@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.25.50 PRIVMSG #esoteric :but https://sqlite.org/windowfunctions.html#history is straight about the comaptibility < 1537124428 409404 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net QUIT :Ping timeout: 245 seconds < 1537124576 934324 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :There is a few problem with the documentation, such as that there does not seem to be a link to that document from the documents about the SQL syntax. < 1537124719 145811 :S_Gautam!uid286066@gateway/web/irccloud.com/x-greustsgslagmjij QUIT :Quit: Connection closed for inactivity < 1537124777 746448 :wob_jonas!b03f1932@gateway/web/cgi-irc/kiwiirc.com/ip.176.63.25.50 QUIT :Quit: http://www.kiwiirc.com/ - A hand crafted IRC client < 1537125294 490655 :MDude!~MDude@c-73-187-225-46.hsd1.pa.comcast.net JOIN :#esoteric < 1537125344 131627 :moony!moony@unaffiliated/moonythedwarf PRIVMSG #esoteric :Designing a homebrew computer is fun < 1537125360 819985 :moony!moony@unaffiliated/moonythedwarf PRIVMSG #esoteric :maybe i should hook it up to IRC once i finally build it and it's functioning < 1537125374 726216 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :Yes, and I had some of my own ideas of designing a computer too (but have not implemented it, or even completed the design) < 1537125436 565609 :moony!moony@unaffiliated/moonythedwarf PRIVMSG #esoteric :i already decided the main CPU, a MC68030FE33C < 1537125447 920669 :moony!moony@unaffiliated/moonythedwarf PRIVMSG #esoteric :and am working on the DMA/Blitter device < 1537125471 343049 :moony!moony@unaffiliated/moonythedwarf PRIVMSG #esoteric :which will be mapped somewhere directly before RAM starts < 1537126161 897512 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :Do you know of input, and video modes, and audio? < 1537126328 758022 :Phantom_Hoover!~phantomho@unaffiliated/phantom-hoover QUIT :Remote host closed the connection < 1537126423 981207 :nfd!~nfd9001@c-73-157-90-101.hsd1.wa.comcast.net JOIN :#esoteric < 1537126638 494946 :nfd9001!~nfd9001@2601:602:8500:d0d1:eda6:ef4e:d55:e653 QUIT :Ping timeout: 252 seconds < 1537126718 958323 :nfd!~nfd9001@c-73-157-90-101.hsd1.wa.comcast.net QUIT :Ping timeout: 272 seconds < 1537127061 916849 :Phantom_Hoover!~phantomho@unaffiliated/phantom-hoover JOIN :#esoteric < 1537128537 816223 :Phantom_Hoover!~phantomho@unaffiliated/phantom-hoover QUIT :Read error: Connection reset by peer < 1537128725 704980 :Phantom_Hoover!~phantomho@2a02:c7d:485a:3300:fb8b:fb15:c1d3:a33a JOIN :#esoteric < 1537128725 839461 :Phantom_Hoover!~phantomho@2a02:c7d:485a:3300:fb8b:fb15:c1d3:a33a QUIT :Changing host < 1537128725 839513 :Phantom_Hoover!~phantomho@unaffiliated/phantom-hoover JOIN :#esoteric < 1537128900 952351 :zaiko11!~zaiko@186-92-80-141.genericrev.cantv.net JOIN :#esoteric < 1537129059 996104 :zaiko11!~zaiko@186-92-80-141.genericrev.cantv.net QUIT :Remote host closed the connection < 1537129646 969341 :pimlu!~pimlu@70-90-173-49-California.hfc.comcastbusiness.net JOIN :#esoteric < 1537129917 588524 :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.” < 1537134969 918682 :arseniiv!~arseniiv@46.191.139.186 QUIT :Ping timeout: 252 seconds < 1537135348 385746 :nfd9001!~nfd9001@c-73-157-90-101.hsd1.wa.comcast.net JOIN :#esoteric < 1537135728 923365 :AnotherTest!~turingcom@ptr-82l26zdn9kx2rnn81vw.18120a2.ip6.access.telenet.be QUIT :Ping timeout: 252 seconds < 1537135880 748003 :AnotherTest!~turingcom@d51A46C74.access.telenet.be JOIN :#esoteric < 1537136434 751436 :AnotherTest!~turingcom@d51A46C74.access.telenet.be QUIT :Ping timeout: 240 seconds < 1537137181 351324 :Lyka!~scat@unaffiliated/schrodingerscat JOIN :#esoteric < 1537137191 433197 :Lyka!~scat@unaffiliated/schrodingerscat PRIVMSG #esoteric :what do you think of this language? https://paste.ee/p/Z929D < 1537137265 405313 :Lyka!~scat@unaffiliated/schrodingerscat PRIVMSG #esoteric :this is the only place i know to ask < 1537137290 336956 :Lyka!~scat@unaffiliated/schrodingerscat PRIVMSG #esoteric :and i have been greeted with unjust hostility about it < 1537137402 781106 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :I suppose it look like OK < 1537137455 370392 :Lyka!~scat@unaffiliated/schrodingerscat PRIVMSG #esoteric :i was wondering if it qualified as esoteric < 1537137504 347199 :Lyka!~scat@unaffiliated/schrodingerscat PRIVMSG #esoteric :so i could discuss it here < 1537137566 801158 :zzo38!~zzo38@24-207-47-161.eastlink.ca PRIVMSG #esoteric :I don't know, but maybe there should be added notation for labels and for comments. < 1537137715 311679 :Lyka!~scat@unaffiliated/schrodingerscat PRIVMSG #esoteric :good point < 1537137745 460009 :Lyka!~scat@unaffiliated/schrodingerscat PRIVMSG #esoteric :have a pre-pre-parser remove them < 1537137858 307835 :Lyka!~scat@unaffiliated/schrodingerscat PRIVMSG #esoteric :(it's complicated to run) < 1537138779 559143 :Phantom_Hoover!~phantomho@unaffiliated/phantom-hoover QUIT :Remote host closed the connection < 1537138802 992133 :danieljabailey!~danieljab@cpc75709-york6-2-0-cust725.7-1.cable.virginm.net QUIT :Quit: ZNC 1.6.5+deb2build2 - http://znc.in < 1537138817 414976 :danieljabailey!~danieljab@cpc75709-york6-2-0-cust725.7-1.cable.virginm.net JOIN :#esoteric < 1537140216 307058 :Lyka!~scat@unaffiliated/schrodingerscat PART #esoteric :"ByrdIRC" < 1537140800 433164 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Remote host closed the connection < 1537141740 458285 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net JOIN :#esoteric < 1537141987 399497 :tromp!~tromp@ip-217-103-3-94.ip.prioritytelecom.net QUIT :Ping timeout: 240 seconds