Postgres

If you are using Datagrip from Jetbrains to manage your Postgres database, you might have bumped into difficulties in how to dump (or how to restore) a Postgres SQL dump. The menus are showing the “commands” but without the binaries, you can’t “run” those. I can’t remember how to install the binaries on a new machine and then I’m searching the net for information, only to usually read articles of frustrated users. On macOS, it is quite easy. All you need to do is to install “libpq”, which can be done via homebrew. ...

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). ...