Macos

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

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

PowerShell Core 6 supports macOS 10.2 and beyond. There exist different ways to bring PowerShell to your system, the easiest setup is most likely to install it via homebrew, as most macOS users are using it as their favourite package manager. Once brew is installed, open a terminal window and run: brew cask install powershell This command will install the latest version of PowerShell on your Mac. You can run (now and in future) the following command to keep your installation up to date: ...

MkDocs is a fast, simple and downright gorgeous static site generator that’s geared towards building project documentation. Documentation source files are written in Markdown, and configured with a single YAML configuration file. The following guide is showing the installation under macOS. More information can be found at: https://www.mkdocs.org Paste the below code in a macOS terminal session: /usr/bin/ruby -e "$(curl -fsSL [https://raw.githubusercontent.com/Homebrew/install/master/install)](https://raw.githubusercontent.com/Homebrew/install/master/install%29) Installing pip If you’re using a recent version of Python, the Python package manager, pip, is most likely installed by default. However, you may need to upgrade pip to the lasted version: ...