Guides 11795 Published by Philipp Esselbach 0

This guide walks you through installing MariaDB 10.9 on Ubuntu 22.04 LTS, explaining why the newer version offers thread‑pooling and improved JSON handling over the default 10.3 that ships in the official repositories. It begins by purging any lingering MySQL or MariaDB packages so a clean install can proceed without conflicting libraries, then adds MariaDB’s own repository using a script that also imports the proper GPG key. After updating the package cache you install the server, run `mysql_secure_installation` to lock it down, and optionally enable thread pooling by editing `/etc/mysql/mariadb.conf.d/99-threadpool.cnf` before restarting the service. Finally, the article shows how to verify the installation with a quick query, lists common pitfalls such as missing updates or stray binaries, and reminds you to adjust bind‑address settings if remote access is needed.

Guides 11795 Published by Philipp Esselbach 0

The guide takes you step‑by‑step through installing Sublime Merge on Ubuntu 22.04 LTS, starting with a system update and then downloading the official Debian package from Sublime’s download page. It shows how to install that .deb file with dpkg, run “apt‑get install –f” if dependencies are missing, and then confirm the binary is in /usr/bin/sublime_merge. After verifying the executable you can set Sublime Text as Git’s default editor, create a test repository, and launch Merge to see the commit history pop up instantly. The article rounds out with a handy troubleshooting table for common Qt plugin or library errors on minimal installs, highlighting why avoiding Snap’s bundled approach is worthwhile.

Guides 11795 Published by Philipp Esselbach 0

The guide walks readers through checking their current SQLite version, enabling CentOS 9 Stream’s AppStream and BaseOS repositories, and installing the stable sqlite package via dnf. It explains that the default dnf install pulls both runtime binaries and development headers so users can immediately compile projects in Python, PHP or C. For those needing a newer patch not yet in the repo, the article offers step‑by‑step instructions to download, build from source and adjust system paths, while warning that manual builds mean you must handle future updates yourself. Finally it lists common pitfalls—such as disabled repos, missing devel packages or path confusion—and reminds readers to double‑check the repository list first before troubleshooting.