It took a bit but basically had to get the most current version of various code things. Bleeding edge is not for production use, but great for personal projects. But - I got the migration to get created but then it broke doing the actual migration. I gave it a few days and got back to it today and found two things. For SQLite (the DB in use, which I think I've mentioned has a really interesting history), the .NET 10 adds a lock table. Since I stopped processing the DB without letting the framework clear that lock, once I figured out the other part, the application just froze, waiting for that lock file. Deleting it works fine. The other thing I found was that because the migration process checks across all models, it saw some foreign key references in other models so added indices to help speed things up when reading data. Unfortunately, those are optional related records so the keys may be null. As this database is so tiny indexing really does not matter a great deal, I just commented those out.
I do need to correct the titles, but now we have the captured and empty planets table. I'll note that though I am copying the data from Book 6, there is no reason to do so and the way I look up the tables if it is a random die roll is to get the minimum and maximum die and roll on that. If you want a d4 table, it will work. A d20 table, it will work. Though now that I type that, I will have to verify if you've skipped a die that we go up to the next available one or something.
I'll also note that I actually switched to a fiber internet connection, though the coax is still attached as well. But I can get the same speed but symmetrical (download and upload about the same speed) for less than half of what I was paying. When I went to disconnect my previous service, they suddenly found they could undercut the price, and I could pay even less (but lacking symmetrical speeds as coax does not work the same as fiber). In theory I could have kept both services and still paid less than I did, but as I am not a data center I really do not need that level of redundancy. Anyway, I now have a 2nd connection, which 2 weeks later they finally buried the cable. And I can unwrap that coax that wraps around my basement as the terminal is at the opposite side of the basement as my office space is. The install guy put the box right outside so there is only about q 10' cable between where it comes in. But the old cable is still there, and who knows, they may try to get me back for even less. Competition is a good thing!
Plus, I had to move the not-used-in-10-years treadmill so the installation tech could get access to that area. It is now in the garage. I've added a shelf where the treadmill was, and so a chunk of my Lego that I really do plan on selling is now off the floor. Next step is to take that treadmill either to the used sports place or the dump. We did use it a lot back when we were running marathons. And yes, I did run marathons, my wife has actually run 50 miles. She is crazy (a requirement being married to me!
So perhaps tomorrow I'll clean up the titles and continue on with the system creation. I can run it for my new title :)


No comments:
Post a Comment