View Single Post
Old 01-31-2022 | 02:08 PM
  #16  
rickair7777's Avatar
rickair7777
Prime Minister/Moderator
Veteran: Navy
 
Joined: Jan 2006
Posts: 44,908
Likes: 694
From: Engines Turn or People Swim
Default

Originally Posted by fadec
The best way IMHO. Though spreadsheets are a hot cup of ****. Use postresql and with sufficient constraints and indices to satisfy your perfectionism and write a web frontend. The trick is not going crazy on the frontend. Make it stupid and ugly, just the bare minimum, if you value your time. Like rails scaffold ugly if not worse. So ugly that you could delete the whole thing and rebuild it in half a day. Realize the value is in the database and the one single pretty print of it. This is for YOU, not some mouth breathing dip****. It should be hard to use but have one single beautiful output. I'm not kidding VERY HARD TO USE is best. No matter what it will be easier than a spreadsheet. You literally have to work to make something suck more than a spreadsheet. But DIY for sure. It's best.
That's what I did for my checkbook, using MS access. It's ugly, but ergonomic... the forms tab in a logical (to me) order and auto-populate when it makes sense.
Reply