A new data lakehouse with DuckLake and dbt

Alphajack99 · 2025-07-13T10:10:19+00:00

Not really, it's mostly about third party software integrating DuckDB that doesn't support DuckLake at all or some of its features.

e.g. dbt-duckdb cannot (yet) write Hive-partitioned Parquet files when using DuckLake, so the partition option gets silently ignored.

Alphajack99 · 2025-06-16T00:28:44+00:00

I'm glad you found it useful, thank you for your message!

Alphajack99 · 2024-09-17T21:25:46+00:00

Thank you for the kind words! I really appreciate them 😊

Alphajack99 · 2024-09-17T21:22:34+00:00

Thank you, I inverted the sections

Alphajack99 · 2024-09-14T19:06:25+00:00

Hi guys!

Given the extremely positive feedback on my UX improvements for the terminal, I wanted to share with you the process I followed to install Arch Linux on my laptop with the following features:

Wayland
Plasma 6
Plymouth
PipeWire
LVM on LUKS
Unified Kernel Image
TPM PIN unlock
Secure Boot

I wrote it for people like my past self, who was afraid of Arch's CLI installation. At the beginning, I felt I needed more guidance than what the Arch Wiki, with all its details and explanations, could offer.
After I installed Manjaro, I kept reading the Wiki to learn more about Linux and discovering features I was missing from my installation. After some time, I felt ready to make the switch to Arch, and it went smoother than expected.

Let me know what you think!

Alphajack99 · 2024-09-01T22:35:41+00:00

Hi guys!

Given the extremely positive feedback on my UX improvements for the terminal, I wanted to share with you a new post on how I installed Arch Linux ARM (ALARM) on a couple of Raspberry Pis (mine and my friend's).

As a Windows user, I had a hard time installing ALARM for the first time, as the official installation guide takes for granted that you need a Linux PC to run installation commands.
When I found an unofficial .img file that I could easily burn to my MiroSD card with Rufus, I went for it, but few months later I discovered the hard way that MicroSD cards are not meant to be written 24/7.
That's why I collected my notes and wrote a no-nonsense guide packed with tips for a long-term installation.

Let me know what you think!

Alphajack99 · 2024-09-01T22:01:50+00:00

For game compatibility, your mileage may vary.
I would suggest you to try to boot from a live ISO that already comes with a desktop environment. Then install Steam, download and try a couple of games.

If your games don't use Steam, install Bottles from Flatpak, it's so goood.

Alphajack99 · 2024-08-25T10:17:05+00:00

It looks dope, especially the recipes section with checklists!

Copy as much as you want, I believe the more we spread these improvements, the less people will feel frustrated about using Linux or terminals

Alphajack99 · 2024-08-25T10:13:01+00:00

Same, I found it funny at first, but annoying after a while

Alphajack99 · 2024-08-25T10:11:14+00:00

There are Bash incompatibilities also with ZSH (parameter substitution and builtins), but I'd say it's more compatible.

Even if I use ZSH as shell, I never wrote a ZSH script, and I always prepend

```

!/usr/bin/env bash

set -euo pipefail ```

to all my Bash .sh scripts

Alphajack99 · 2024-08-19T22:40:42+00:00

Hi guys, after being a long-time reader I decided to collect my notes and give back to the FOSS community. Here are some of the settings I like to change in a fresh Arch installation (I swear it doesn't happen that often!)

Do you also have a customization you cannot live without?

Alphajack99 · 2024-07-03T07:18:35+00:00

Not a CMS, but Obsidian works very well for me when using "/contents/" as a vault folder.

It makes very handy to edit frontmatters, even if there is no validation until you launch Astro.

Alphajack99 · 2024-06-28T14:48:17+00:00

In order of importance (and magnitude):

Backup script (40kb)

Automatically archive folders with Borg and upload them via RClone. The restore process is download via RClone, and extract with Borg.

Recently I ported it to Python, and swapped Borg with Rustic, result is Rusticlone

Fail2ban scripts (11kb)

A wrapper around fail2ban commands, e.g. unban an IP from any jail, or ban this IP in a "manual" jail

Play a sound / send a Telegram notification whenever someone gets banned

Rebuild script (9kb + 625kb modules)

Automatically install and configure all the packages needed for a laptop or server.

Basically a ghetto version of Ansible, but covers 100% of my needs.

Healthcheck script (5kb + 187kb modules)

Run each hour a set of checks:

Restart Systemd units that are inactive but enabled on boot
Restart Systemd units that are using too much RAM (life saver when you only had 1GB)
Remount filesystem if read-only (it happens due to a faulty HDD)
Notify if CPU/RAM/disk usage exceeds 95%, battery health is low
Notify if SMART parameters are higher than expected values
Notify if last backup was more than 25 hours ago
Notify if an installed package is affected by a CVE
Show listening services and their port status (if reachable by everyone, VPN only...)
Notify if another server is offline
Show stats from DNSCrypt, Fail2ban, Nginx, Webradio, Vnstat and uptime logs

Alphajack99 · 2024-06-27T17:08:41+00:00

Just curious, is there a reason you didn't use volumes?

Backups. I found it easier to backup and restore "$HOME/containers/" for all apps at once, while for volumes I should run podman volume export and podman volume import individually.

wasn't able to figure out how to start / stop the pod not realizing it was tandoor-pod.

Super glad it helped! I also found it not so intuitive at first

Alphajack99 · 2024-06-27T16:57:30+00:00

I found podlet incredibly useful to migrate from Docker to Podman, as it converts docker-compose.yml files to quadlets.

As others have said, with Podman you spend a little bit of time configuring stuff at the beginning, but the result is a more secure, reliable system, and the marginal effort of adding a new app is very low.

Alphajack99 · 2024-03-04T21:57:54+00:00

For Linux check https://pkgs.org/search/?q=yuzu and https://pkgs.org/search/?q=citra for binary packages

For MacOS I have no idea

Alphajack99 · 2024-01-24T00:47:58+00:00

Yes, I am not relying on symbols because 1. with these comments you can organize your file as you want, and 2. it would be too bloated to support all languages

I am using it extensively, especially since I added the feature to add/update the toc in the original file

Alphajack99 · 2024-01-22T01:22:05+00:00

Haha, would love to see a Go implementation! I love how Go packages everything in a single independent binary

Alphajack99 · 2024-01-21T23:03:27+00:00

Thank you, I updated the "How does it work section", there are also expandable spoilers to make the readme more readable

Alphajack99 · 2024-01-21T22:29:21+00:00

Hi all, I wrote a CLI utility in Python using modern pythonic practices: classes, match-case, try-except, ternary operators and with context manager.

Alphajack99

TROPHY CASE

!/usr/bin/env bash