![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
For the third week in a row, I spent an evening at Lambert House (actially St. Mark's, but only for six more weeks) working on moving their database out of Microsoft Access 2010. (Ptui!) The first step in this project is exporting the database into something newer. This involved writing and generating a lot of SQL, then running it against my DB engine of choice, in this case SQLite.
Populating the DB took 80 seconds on my 2023 Macbook. And that was after I abandoned my first attempt, which tried to write the new DB to the networked drive where it has to live. It took ninety minutes on the director's PC, which someone donated to the house at least ten years ago. I hope old, cheap-ass hardware and network file access don't doom this entire project. If any of you Seattle-area queers or freaks want to donate a Windows (Ptui!) machine to a worthy org, you could do worse than Lambert House.
I'm really glad to have Juneteenth off, even though I plan to spend the day cleaning house. Let me just leave it at that.
Populating the DB took 80 seconds on my 2023 Macbook. And that was after I abandoned my first attempt, which tried to write the new DB to the networked drive where it has to live. It took ninety minutes on the director's PC, which someone donated to the house at least ten years ago. I hope old, cheap-ass hardware and network file access don't doom this entire project. If any of you Seattle-area queers or freaks want to donate a Windows (Ptui!) machine to a worthy org, you could do worse than Lambert House.
I'm really glad to have Juneteenth off, even though I plan to spend the day cleaning house. Let me just leave it at that.
