![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
I did indeed hit the Mercury for the second weekend in a row. M-the-artist, who is trans and whose work is in a show opening at Vermillion on Thursday for you locals, gave my face the stamp of approval. Gratifying.
I spent even more time this weekend doing stuff to move the Lambert House reception database away from Microsoft Access. (Ptui!) I did a complete data dump, but I didn't realize that the schema dump that I have is old and incomplete.
Mind you, "complete" in this case includes "features we no longer use or reimplemented". The sensible thing to do would be not to include those parts, but what I'm doing needs to be reproducible by someone who isn't me. As I sit here typing, I just realized that I can sort of have it both ways: tell my hapless successor to export the whole Access DB, but write my import script not to import certain tables. I should run this by the director first, natch.
Thank you all for being my rubber ducks.
Once I get the whole thing sucked into a SQLite DB, then comes the interesting part: seeing how long it takes to load into a modern browser. My guess is comfortably under five seconds based on a previous experiment with a much older version of the DB. Then the really fun part: writing the web pages.
I spent even more time this weekend doing stuff to move the Lambert House reception database away from Microsoft Access. (Ptui!) I did a complete data dump, but I didn't realize that the schema dump that I have is old and incomplete.
Mind you, "complete" in this case includes "features we no longer use or reimplemented". The sensible thing to do would be not to include those parts, but what I'm doing needs to be reproducible by someone who isn't me. As I sit here typing, I just realized that I can sort of have it both ways: tell my hapless successor to export the whole Access DB, but write my import script not to import certain tables. I should run this by the director first, natch.
Thank you all for being my rubber ducks.
Once I get the whole thing sucked into a SQLite DB, then comes the interesting part: seeing how long it takes to load into a modern browser. My guess is comfortably under five seconds based on a previous experiment with a much older version of the DB. Then the really fun part: writing the web pages.
