I'd like to build a small CLI app in Golang that provides basic CRUD operations on SQL databases. I'll use note taking as the starting point, as it is generic, contains one-to-many and many-to-many relations between data models, and can serve as the basis for other
In an earlier post I did a quick exercise on setting up a git server using SSH. While using GitHub private repos is convenient for many cases. When it comes to owning data and/or code, we should also consider adding some self-hosted git servers in the mix. Here I
I installed Uptime Kuma and Beszel previously. They are running well. Here I am going to try a suite of tools for logs and metrics monitoring. For logging I'll use Promtail, Loki, and Grafana. For metrics, I'll try both the NodeExporter/Prometheus and Telegraf/InfluxDB suites
In the process of building up my home lab and writing posts at the same time, I also use this blog site for quick note taking. It is time to check out what's out there that can help me keep notes and ideas, and access them from different
I have spent time setting up HA PostgreSQL databases. The main goal is to prevent service data loss due to machine failure. But for a home lab there are other valuable data that needs to be saved safely. Most of these data are stored as files or folders. I'
Now that I have a "prototype" of PostgreSQL cluster with automatic failover using repmgr. I need to know how to access the database from an app, in particular, a Python webapp with SQLAlchemy. I'd like to explore the use of PgBouncer with repmgr for this. My
As mentioned previously, I'd like to setup a database with high availability for a webapp. I will try PostgreSQL first, based on the Nebula overlay network I just set up. Search "PostgreSQL", "HA" and "automatic failover" and browse through the abundant results.
To run applications on top of databases, it is crucial to consider high availability, even though for a self-hosted home lab. It is not that useful if the replica servers are all in the same place too. So I am looking for a secure (mesh) VPN that can span across
In the CRUD webapp example I built previously, SQLAlchemy is used to interact with a SQLite database. Here I want to see how to make the app work with both PostgreSQL and MySQL without too much trouble. PostgreSQL Searching the web using "SQLAlchemy" and "PostgreSQL", we
I just created a simple CRUD webapp using Flask. It has form validation, but the data is in memory. I'd like to proceed with adding database support, in particular, using SQLAlchemy, so that I can do more experiments on SQLite, MySQL, and PostgreSQL. I'd like to
Even though there are already countless examples out there, I still have to do this exercise here. I need to use this as the basis for later posts. Objective If you search the web for CRUD examples, you will still have to sieve through the results and find the ones
This is a frequently asked question. We can see the answers or propositions grouped into certain categories and sliced in different ways from different perspectives. Giving a comprehensive survey and reasonings is beyond my capability, so I will just give some highlights that occur to me from long time ago