'Just Rewards (2)'
Do you have problems, concerns, or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.
Thank you so much for all of your hard work and effort on this, Gud!
Thanks! I hope people like the updated site once the transition happens. It should be much easier to read on mobile without breaking those who don't use javascript. Behind the scenes security holes will be fixed as well. Not that there there won't be work to be done afterwards as well.
Besides the single posts table, is there any significant difference between the two database schema I should be aware of?
The user table is pretty different mostly because of the way registration works. I'll need to do some custom work there anyhow to deal with using existing password hashes so that's not really a big deal. I think the bookmarks table carries a bit more data than the current one but that can be backfilled.
Just to note to other people reading this. Your passwords are not stored in the current database or the new database. So we're not passing around actual passwords at any point here, just hashes.
In the new board, you can't easily hotlink to a particular post, the way you can click on a post number over here.
Indeed. I'll fix that as soon as I get a chance. Thanks.
Fixed it.
Whatever you were testing, I hope it worked. And thank you for the lovely trip down memory lane. We've been funny people!
Looks like a missing feature for the new board.
So I just committed a perl script ('cause that's how I roll), that attempts to translate between the two databases, and clean up the data. The output is 210M compressed, which is smaller than I thought it would be.
As it is, it won't really work, because you define some fields to be non-NULL that don't exist in the old database.
So, anyway, take a look at the script. You could probably run it yourself, since mysql.buffistas.org doesn't seem to be firewalled. (I ran it several times during testing, so it wouldn't surprise me if we bump into some kind of provider database transfer limit, sorry!) Please check if the translation between the table names and field names looks OK, and anything else that you see needs to be fixed.