Archiving Jobs to mySQL


  • Coder

    Chime has archiving jobs to phpBB here: https://github.com/lashtear/jobs-archive

    But she says to me, "Theno, PHP needs to be set on fire, and I don't want that on my server anymore. You can't use my code."

    So I said, "Okay," because what can you say to someone giving you space for free? You can say: Let's do it without phpBB.

    https://github.com/thenomain/Mu--Support-Systems/blob/master/SQL Job Archives.txt

    Right now this is strictly a back-end. There is so far no way to pull the information in a familiar (i.e., +jobs) format. And yet, all your jobs can be stored here for now. If anyone wants to help with this project, I will be more than happy to fold in the additions.

    Don't forget to back up the new tables.


  • Coder

    This is probably the purest way to do backups, and what I always wanted to set up for Jobs on HM but never had the time for. My long term goal was to move the entire Database into MySQL and skip the stupid Objects thing. Then the concept of "archival" would be "is the job in a visible status" or "is the job in an archived status" and we wouldn't need these silly post-hook triggers which are prone to failure.


  • Coder

    This is a really good point.

    @Thenomain, once your jobs-to-sql code has a straightforward mapping of the job objects... you can just (haha, just) use those instead of the objects. It's a nice incremental way to destroy all civilization move to a sql-based database for unlimited job management.


  • Coder

    Yup. That's the plan. First, though, it needs anything resembling a front end to the stored data.


  • Coder

    I am interested in this project, and might be willing to make some pull requests to it. I'll poke my nose at it when I have some free time and inspiration. I desperately want to never use Anomaly Jobs in Object form again.


  • Coder

    I'd also like to get Myrd's bboards off local objects and into the database, not to mention channel logging, and, and ...

    What's interesting is that Peverel and his coder did a grotesque amount of this work over eight years ago, or whenever his San Fransisco game was around. All bboards were readable from a web page interface. Huh.


  • Coder

    @Thenomain I got Myrd's BB into MySQL. Let me see if I can dig it back up and put it somewhere. HM's bboards were not stored on objects. :)


  • Coder

    @Loki
    That would be great, and interesting.



  • I wish I could do these things. I would just break my game if I tried.


  • Coder

    @Thenomain Found it. Will publish to GitHub after I've cleaned it up and retested it. Should be tomorrow or Sunday. Note that there's one small piece of Myrddin's that I never did quite get right related to board locks. There's some room for improvement, there.


  • Coder

    @icanbeyourmuse said:

    I wish I could do these things. I would just break my game if I tried.

    That's why we do it and package the installer.



  • An alternative approach that doesn't require MySQL is to have an external bot that can log in, do the decompiles, and save the output somewhere. I have a bot written in Go for this saving to an sqlite3 database. It does require softcode support. I'm using it to currently archive Jobs and Characters+Sheets. I plan to adapt it to grab +bb and census data as well.

    Full Disclosure: I'm an open RDBMS disliker and MySQL hater.



  • @Thenomain said:

    @icanbeyourmuse said:

    I wish I could do these things. I would just break my game if I tried.

    That's why we do it and package the installer.

    Will it break easily if I try by myself?


  • Coder

    @icanbeyourmuse said:

    @Thenomain said:

    @icanbeyourmuse said:

    I wish I could do these things. I would just break my game if I tried.

    That's why we do it and package the installer.

    Will it break easily if I try by myself?

    An interesting question. We will have to see.


 

Looks like your connection to MU Soapbox was lost, please wait while we try to reconnect.