Tuesday, April 15, 2025

Traveller System Generator Part 2 (of hopefully many more again)

Added the atmosphere stuff (editors and all that) and realize I have an issue with my schema already: I was using the primary key to ID to data, but a lot of DBs do not like 0 as the primary key, plus you may not always enter things in the proper order. 

I'll have to add a Traveller Code to the tables. That also may take care of the hex coding, but then we really need to get the order correct for the dropdowns.

But: we can do dropdowns now, and validation is in place. What should have taken me just a few minutes too more than an hour as I was fighting Docker. Decided I did not need to really use Docker so switched to the local Kestral web server. Then found the real issue was I really needed to clean the project. But lessons learned!



My next step will be to update the tables (and verify the migrations work). I also use another tool to look at the SQLite DB and that is useful to look at the actual data. Which is always an option for anyone who actually uses this. If anyone other than myself :)

As a 3-day weekend is coming up, I am hoping to get the rest of the basic CRUD (Create, Read, Update, Delete) stuff sone as that is mostly letting the scaffolding tool do its thing, then start in the actual service to create a planet from scratch. And a menu as right now I have to manually type the controller in. 

But this should come together pretty quickly to be honest. I know I've tried this earlier but as I now do it for work, and got paid to figure it out and had a consultant help with some, and all the useful knowledge people are willing to share, and the advances in tooling and AI, well, it is just a lot faster!


No comments: