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

Favicons are cached quite heavily by browsers. So, in addition to a possible caching from a used CDN, you may need to clear the caches on the local browsers as well. Not every customer understands that if the Favicon is displayed correctly in an incognito window, a missing updated icon can only be due to the caches. On Chrome, this cache file can easily grow up to several hundreds of megabytes, so a regular cleansing doesn’t do any harm. ...

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

I have to build a list box for one customer app showing the version history of their app. The easiest way is obviously to first upload the git log into a database, but the standard log looks like this: Command: Output: Beautiful, but not what I needed. I wanted a CSV format for easy upload to my database and obviously, the date should be in SQL format. The following code will help you with this. Just run it in the root folder of your GIT-enabled project in a terminal window on your macOS. ...

Now that you have built your secure Linux Server for Xojo Web 2, you might run into issues around 90 days latest! Introduction Why? Because your certificates will expire. We installed let’s encrypt free of cost certificates. They are a tremendous relief, but they need renewal every 89 days latest. On a side note: I got some replies that I’m not profoundly diving into the certificate’s topic or how to use an editor on Linux (yes, “vim” is not the easiest one — try “nano” for instance). The above article proved to work for a couple of people without any issues, which was the purpose. Of course, you have to do your homework, and for a deep dive into some topics, you have to learn those skills. ...

What is fail2ban all about? Fail2ban determines the IP addresses in the server’s log files that are noticeable due to unusual behaviour, such as repeatedly trying to log in with an incorrect password. When a certain number of unsuccessful attempts happened, fail2ban will automatically ensure that the IP address is banned or blocked for a predetermined time. The administrator can also configure Fail2ban so that a suspicious IP address is first reported to him by email. You have many options here. ...

With Xojo Web 2, it becomes relatively easy to set up a Server and run your first App. You would not even need your own webserver as a Xojo Web 2 App has built-in its own. But in today’s world, running a Web app is one thing; running it securely is a different story. This beginner’s guide aims to enable you to run your first App in no time. What we will achieve in this tutorial: ...

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

Well, there are many reasons why it is cool having the possibility to connect remotely to another server. You’ll need such an option for a secure connection to your remote server to upload files and make changes on your server. But perhaps you are running a remote Database on an external server, and then again, an SSH connection is a must (at least if you want to run things securely). ...

It sounds trivial (and it is), but in the old days, you need to use some commands (depending on the used macOS version) in your terminal to either switch on or off the typical Apple Chime sound at reboot, as described here. I don’t like the sound, especially not when your mac crashes at night time and I welcomed it when Apple switched it off by default. Now with Big Sur, it is again enabled by default. ...