Show Idle (>14 d.) Chans


← 2022-11-29 | 2022-12-01 →
03:17 crtdaydreams signpost: AT automagically updated :D, have been on and off
03:21 crtdaydreams also; congratulations, a step closer to the superlative man!
~ 1 hours 17 minutes ~
04:38 crtdaydreams http://logs.bitdash.io/asciilifeform/2022-11-29#1114240 << bizzare. message virtually non-existant on bitdash logs
04:38 bitbot (asciilifeform) 2022-11-29 unpx: Looks like bitdash didn't catch up the logs... http://logs.nosuchlabs.com/log/asciilifeform/2022-11-25#1114231
04:38 dulapbot (asciilifeform) 2022-11-25 unpx: To my peers, hoping they will read this message. http://paste.deedbot.org/?id=BX0- http://paste.deedbot.org/?id=ZDRx http://paste.deedbot.org/?id=QMkw
04:42 crtdaydreams o/ hola unpx
04:43 crtdaydreams guessed which one first try :D
~ 4 hours 40 minutes ~
09:24 awt congrats signpost!
09:28 awt phf sure. will post peering info soon.
~ 1 hours 51 minutes ~
11:20 asciilifeform $ticker btc usd
11:20 busybot Current BTC price in USD: $16871.2
~ 1 hours 41 minutes ~
13:02 phf in totally random projects, i got mp-wp working with sqlite
13:05 phf well, "working". enough to do an install, click around dashboard, post an article, but lots of broken sql still
13:15 asciilifeform phf: interesting ( asciilifeform did not know that sqlite were to this degree incompat. )
13:16 * asciilifeform on the occasions where used it ( e.g. early phuctor ) was able to switch to postgres with minimal changes
~ 28 minutes ~
13:44 phf asciilifeform, sure, if all you do is selects and inserts. wp is full of custom mysql optimizations, hacks and functions
13:45 phf you wouldn't be able to trivially get it working with postgresql, or rather it'll require about as much changes as i've done so far
13:46 * asciilifeform believes
13:47 phf some you might be able to solve by providing a function shim with postgresql, but not with sqlite, because the later doesn't support function definitions
13:47 * asciilifeform was not among the folx fascinated with mpwp, as had own roughly equiv. (actually moar trimmed, killed errything to do with uploading/file management, as always did this over mc)
13:48 phf e.g. mysql has YEAR(date) MONTH(date) etc. which is not in postgresql. similar can be accomplished with strftime('%Y',date) in sqlite. etc.
13:48 phf asciilifeform, i don't think it's particularly important that it's mp-wp, i at some point did some work figuring out the diff against stock wp 2.7, and there's not much.
13:49 asciilifeform right, mostly the cuts iirc
13:49 asciilifeform (from asciilifeform's pov was a much less aggressive cut than ideal)
13:50 asciilifeform there was 1 pheature, where correctly displays pgp sigs; welded it onto mine with no problems
13:50 phf actually updating the code to php 82 or whatever i ran into pretty much every instance of mp code, because his shit always violates some restriction or another :>
13:50 asciilifeform lol
13:53 * asciilifeform is of the 'ideal amt of php is 0' school of thought, but doesn't expect to ever have time to recreate wp in cl or the like with own hands, so there it remains
13:57 phf oh, here's another mysql-ism, that's all over wp
13:59 phf if you do SELECT SQL_CALC_FOUND_ROWS ... LIMIT 10, you can then do SELECT FOUND_ROWS() and it'll tell you how many rows the first query had without the limit
14:10 phf basically you can avoid the overhead of second call with count(*) or haven to reconstruct that query or whatever. naturally it's a pain to fix
14:10 phf http://logs.bitdash.io/pest/2022-11-30#1017190 << it's about same level of trash as perl, python or javascript. i'm hacking it with intellij and php plugin and it's a very smooth experience. jump to definition, auto format, tons of refactoring features, etc.
14:10 bitbot Logged on 2022-11-30 13:53:05 asciilifeform[6]: is of the 'ideal amt of php is 0' school of thought, but doesn't expect to ever have time to recreate wp in cl or the like with own hands, so there it remains
14:10 phf hmm, and i lost a bunch of packets
14:11 * asciilifeform not tried intellij php, but many yrs ago did time in a saltmine with their java editor, was a++
14:12 asciilifeform iirc they also have python debugger
14:13 asciilifeform phf: loox like our peering not worx atm
~ 2 hours 23 minutes ~
16:37 crtdaydreams jonsykkel: "error: invalid speaker '' recieved from peer 'jonsykkel'"
16:38 jonsykkel test
16:39 jonsykkel yes i corupertd my db cuz runned out of space on vps
16:39 crtdaydreams oh rip
16:39 jonsykkel imo fixed now
16:39 crtdaydreams ye seems to be
16:39 jonsykkel nice
~ 2 hours 54 minutes ~
19:34 phf it is apparently possible to register php functions to as sqlite functions. e.g.
19:34 phf $db->createFunction('foo', function($s){return "i says, '$s'";});
19:35 phf var_dump($db->querySingle("SELECT foo('hello, world')")); ⇒ string(22) "i says, 'hello, world'"
19:35 phf
~ 1 hours 38 minutes ~
21:14 * asciilifeform wonders how precisely that worx
~ 25 minutes ~
21:39 phf mp-wp has an amusingly large number of hardcoded branding e.g. http://btcbase.org/patches/mp-wp_remove-all-javascript/tree/mp-wp/wp-includes/general-template.php#L1710
21:40 phf a special function to ensure you can brand any kind of content!
21:41 phf http://logs.bitdash.io/pest/2022-11-30#1017211 << sqlite is a library that you load into process memory, that knows how to safely edit a shared binary blob. a registered function is essentially ffi from sql to hosting environment, be that python or php.
21:41 bitbot Logged on 2022-11-30 21:14:01 asciilifeform[6]: wonders how precisely that worx
21:42 phf i'm sure it's not cheap, on large sql queries it's essentially an equivalent of a map over rows, except you're mapping an ffi function, so all the relevant boxing/unboxing/boundaries crossing
← 2022-11-29 | 2022-12-01 →