In this database I need to keep track of what is the name and end date of the currently active semester. It's the same for all users and needs to be remembered. I also keep track of when imports last happened and such.
What I do now is I have a "Settings" table with a field called "Number1" which is just the number one. I then join that to my login screen like this "Settings_Number1 ≠ JoinTable_PrimaryKey".
On startup I turn these into variables which I use to filter portal rows and run SQL commands and such.
It feels messy, is there a smarter/more standard way?
Is there a better way?