#alethepedia | 2021-05-06

12:02

thimbronion

billymg: ok. postgres it is then.

12:10

billymg

thimbronion: what are you making?

~ 3 hours 32 minutes ~

15:42

thimbronion

billymg: I'm going to try to move Alethepedia to my server here.

15:47

thimbronion

Or at least create a mirror.

~ 23 minutes ~

16:10

billymg

thimbronion: ah, i see. i wasn't sure because i knew alethepedia ran on mp-wp. i can only hope this means you want to dive in a write a patch to switch mp-wp's backing db to postgres

16:12

billymg

but i'm also not completely delusional, so... i don't expect that's anything you (or anyone) actually wants to do

16:14

thimbronion

billymg: Looks like there's a plugin: https://wordpress.org/plugins/postgresql-for-wordpress/

16:14

thimbronion

If that works I could create a vpatch that includes the plugin.

16:18

billymg

based on the description, "rewriting SQL queries on the fly when needed", and the limits of plugins, i'm guessing this thing leaves all the MySQL garbage in wordpress and just translates as queries happen

16:19

billymg

so as far as including in the mp-wp trunk i wouldn't want to go that route, but... they might have useful code to study in the places where they actually do the query translation

16:22

thimbronion

Hrm yeah just read it myself

16:22

billymg

but it could very likely work as a stopgap, if it ends up being compatible with mp-wp (might have to dig through their old releases, their latest says it requires 2.9.2 or higher and mp-wp is forked off 2.7 iirc)

16:29

thimbronion

Looks like there aren't that many distinct functions with 'mysql' in the name.

~ 50 minutes ~

17:20

billymg

thimbronion: good to know, the eventual switch might not be so bad then

~ 21 minutes ~

17:41

shinohai

I have question as to why comment system is needed in an encyclopedia.

17:54