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 |