I am trying to do some planning about report building and data analytics. When my notes started to look like Feature, has_many :kpis , I considered just making a rails project to keep track of things. I wondered if anyone could suggest more light weight ORMs or data modelling tools, that also allow data to be put into and queried from a DB that could be useful?
Why not use Rails? The book "Data Visualization Toolkit" [1] does exactly that: it uses Rails for AR's ease of use, not because they need a heavy server. If you need a UI instead of the CLI, you can use ActiveAdmin, or use Django which comes bundled with an admin interface. If neither of those fits your needs, if you can expand more on your requirements and why you want something light weight, I could have a few more suggestions, but they all mostly boil down to "use sqlite with an interactive UI".
Ok, that makes sense. I assume you have a good reason for avoiding WSL2, because with WSL2 I've had ok perf if psql was also running on wsl2. Otherwise, you can rent a cheap DO box, or even get one of the free Oracle Cloud ARM instances; you can ssh in, develop using VS Code/ RubyMine Remote, and it'll be reasonably fast.
1: https://www.amazon.com/Data-Visualization-Toolkit-Addison-We...