The King of Cups expects a picnic. But this is not his birthday!

Drusilla ,'Conversations with Dead People'


Buffistas Building a Better Board ++

Do you have problems, concerns, or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.


javachik - Jun 26, 2018 2:06:08 pm PDT #4107 of 4671
Our wings are not tired.

Thank you so much for all of your hard work and effort on this, Gud!


Tom Scola - Jun 26, 2018 2:36:44 pm PDT #4108 of 4671
Mr. Scola’s wardrobe by Botany 500

I have access to the current database. I was trying to figure out how to upload stuff into the new database.


Gudanov - Jun 26, 2018 2:46:54 pm PDT #4109 of 4671
Coding and Sleeping

Might have to load the current data into a offline database and write some ruby code to suck in the old data and transform it into active record seed scripts.


Tom Scola - Jun 26, 2018 2:54:32 pm PDT #4110 of 4671
Mr. Scola’s wardrobe by Botany 500

Can't I just send you a whole bunch of SQL?


Gudanov - Jun 26, 2018 4:08:13 pm PDT #4111 of 4671
Coding and Sleeping

That will work just fine.


Gudanov - Jun 28, 2018 6:48:01 am PDT #4112 of 4671
Coding and Sleeping

When you are ready with the SQL I can give you an private upload location on my private cloud if you want. Though just checking in on a branch would probably be fine. Once compressed they shouldn't be too huge.


Gudanov - Jun 28, 2018 6:50:59 am PDT #4113 of 4671
Coding and Sleeping

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.


Tom Scola - Jun 28, 2018 3:49:51 pm PDT #4114 of 4671
Mr. Scola’s wardrobe by Botany 500

Besides the single posts table, is there any significant difference between the two database schema I should be aware of?


Gudanov - Jun 28, 2018 4:37:09 pm PDT #4115 of 4671
Coding and Sleeping

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.


Tom Scola - Jun 29, 2018 5:07:47 pm PDT #4116 of 4671
Mr. Scola’s wardrobe by Botany 500

In the new board, you can't easily hotlink to a particular post, the way you can click on a post number over here.