Database

I think I’ve never developed any Xojo App w/o database access, and Postgres is my favourite. Usually, I use an SSH connection to a Linux server to use a Postgres DB on a remote server, as I have described in this article: But of course, I’m running as well as a Postgres instance locally on my mac. (compared to the past, installing Postgres on macOS is relatively straightforward today: https://www.postgresql.org/download/macosx/). I’m usually not a big fan of macOS preference pane extensions, as I have seen many breaking my system in the past. But for six months now, I have been testing the below and free solution intensively, and I can recommend it. ...

Almost all of us are probably dealing with databases every day. What I am seeing all the time is that people are using keywords for their field names, for instance, “date.” Depending on the database brand you are using there are different kinds of reserved (or not reserved) keywords the database is using itself. Reserved once can technically not be used as a field name, the non-reserved once can be used (but are likely to cause challenges in more complex queries). ...