Conversation

Notices

1. Embed this notice
   Eaton (eaton@phire.place)'s status on Tuesday, 16-Jul-2024 12:58:28 JST Eaton

   I wish I were kidding when I say that the easiest way to interrogate the contents of a large Wordpress site’s post_meta data is to export the whole site, individually unserialize each meta record, put them into a document database, and use it to query them.

   • Embed this notice
     Eaton (eaton@phire.place)'s status on Tuesday, 16-Jul-2024 14:37:12 JST Eaton

     in reply to

     • SKC

     @skc oh, don’t worry, half the plugins store THEIR serialized data as JSON in the same column as the ones that store theirs as serialized php :D

   • Embed this notice
     SKC (skc@scottodon.com)'s status on Tuesday, 16-Jul-2024 14:37:13 JST SKC

     in reply to

     @eaton it should have been JSON to begin with but decisions were made :(

   • Embed this notice
     Eaton (eaton@phire.place)'s status on Tuesday, 16-Jul-2024 14:38:37 JST Eaton

     in reply to

     • SKC

     @skc I know, I know, it’s an old gripe, it just kills me every time I go to do some spelunking, heh