I've never used MS SQL myself. One really random feature that I wish Postgres had, that MS SQL actually has, is "temporal tables". You can basically write a query and say "as of" a certain time, and the results will reflect what was in the database as of that time.
mssql at my 9-5 work, mongo and mysql for all others :)
I've never used MS SQL myself. One really random feature that I wish Postgres had, that MS SQL actually has, is "temporal tables". You can basically write a query and say "as of" a certain time, and the results will reflect what was in the database as of that time.
System time in SQL Server
your comment regarding temporal tables gave me an idea how to solve my issue at work 💡. thanks!