Re: There is no reason not to choose Postgres
"Excel is a shit database." No, it's not. Excel is not a database.
15 publicly visible posts • joined 7 Aug 2017
May I copy a comment I made in Quora a little while ago.
The question was, "What are some of the uses of Microsoft Access?"
The only real-life development using Microsoft Access I’ve seen was a complex booking system for patient therapy appointments at a small charity I used to volunteer at. It was “cleverly” written by a non-professional developer, and it used common shared variables instead of explicit parameters, which made it a nightmare to debug.
Because Access is designed for a single user and has no built-in locking, the development had to go through hoops to stop multiple concurrent users trying to update the same data (effectively inventing his own locking system). Because Access lumps everything (data tables and code) in a single module, it was very fragile and often fell over.
Access should be OK for a single user system (this is what it’s designed for) but for the type of system I’ve described I would run a mile from it.
We took the Scrabster-Stromness ferry last June (and Hatston-Aberdeen on the way back). Disappointed in a sort of perverse way that the sea for both crossings was like glass.
Orkney was glorious in the sunshine we had all week, but I'd love to go back and see it in more typical conditions.
By the way, is there any more evocative name for a railway than the Far North Line?: