---
type: "blog_post_list"
url: "https://www.ytyng.com/en"
page: 5
per_page: 20
total: 344
lang: "en"
---

# Blog posts

- [Output and Clear Text in Terminal with Python](https://www.ytyng.com/en/blog/python-how-to-erase-printed-text)

  _2023-01-03T02:21:35Z / Python_

  Flash CircuitPython onto an ESP32 dev board (HW-394 / WROOM-32) and drive I/O in Python — bootloader mode and REPL connection.

- [Create URL Links in the Terminal](https://www.ytyng.com/en/blog/open-link-like-html-a-tag-in-terminal)

  _2022-12-27T12:16:32Z / Shellscript(Bash/Zsh)_

  With applications like iTerm2, you can make a link text open a different URL by Command + clicking, similar to how the a tag works in HTML.

- [View the Contents of Redis Directly from the Terminal in Django](https://www.ytyng.com/en/blog/django-redis-show-by-terminal-shell)

  _2022-12-27T10:15:38Z / Django_

  This article explains how to directly view the contents of Django Redis using the Django shell.

- [When Using Libraries Like Fabric and Paramiko, "Authentication (publickey) failed." Error Occurs During Server Login](https://www.ytyng.com/en/blog/python-paramiko-fabric-authentication-publickey-failed)

  _2022-12-02T09:02:19Z / Python_

  When connecting to an SSH server using Python libraries like Fabric or Paramiko, if the versions are outdated, you may encounter the error "Authentication (publickey) failed."

- [Shell Script to Rotate Backup Files Every Few Days](https://www.ytyng.com/en/blog/how-to-delete-old-backup-file-simply)

  _2022-11-27T15:03:04Z_

  I recently realized that I can rotate backup files (by deleting old files) every few days by sharding the sequential day numbers, which increase by one each day, using modulo 10. Here's the method I've been using lately.

- [How to Set Up API Proxy to Other Services in Nuxt3](https://www.ytyng.com/en/blog/nuxt3-how-to-proxy-outside-api-server)

  _2022-11-20T03:29:57Z / nuxt_

  Set up an HTTP proxy to another service's API in Nuxt 3 (Nitro) — the simple `routeRules.proxy` pattern.

- [Reading DB Settings from Django Configuration and Copying Data from Production to Staging with mysqldump](https://www.ytyng.com/en/blog/database-table-copy-from-production-to-devserver-via-python)

  _2022-11-18T10:16:57Z / Django_

  I usually write data copy scripts in bash, but I tried writing one in Python this time and decided to document it.

- [Exclude Users with is_active = False in Django Admin (Replacing the User Admin)](https://www.ytyng.com/en/blog/django-user-admin-show-is-active-only)

  _2022-11-16T00:19:10Z_

  Python script to copy AWS RDS MySQL data from production to a dev environment fast — table-level `mysqldump` + `mysql` piping.

- [Obtaining N Months Ago in Python's datetime Without Using dateutil](https://www.ytyng.com/en/blog/python-get-previous-month-without-dateutil)

  _2022-11-04T08:25:34Z_

  Here's an overview of the blog post in English:

---

This blog post introduces a function to obtain a datetime N months ago, without using the `dateutil` library.

The function was created because `dateutil` was not available in the Python Data Source for Re:dash.

---

- [Code to Display the Number of URLs in Django](https://www.ytyng.com/en/blog/count-and-display-django-urls)

  _2022-11-02T12:34:22Z / Django_

  During an IT audit, it was necessary to represent the scale of the application. To achieve this, I decided to consider the total number of URLs in Django as an indicator of the application's scale.

- [A Python Script to Automatically Update ChromeDriver](https://www.ytyng.com/en/blog/download-chromedriver-and-deploy-to-path)

  _2022-10-31T12:43:02Z / Python_

  I wrote a script to download the version of chromedriver that matches the currently installed version of Chrome.

- [Retrieve Google Spreadsheet Content as a List of Dictionaries using GAS](https://www.ytyng.com/en/blog/gas-get-spreadsheet-data-as-dictionary-list)

  _2022-10-25T00:04:56Z_

  Shell script to launch Chrome on macOS with a fixed window size from the command line — combine `--window-size` and `--window-position`.

- [Manually Creating a Password Reset URL in Django AllAuth](https://www.ytyng.com/en/blog/django-all-auth-password-reset-url)

  _2022-10-17T11:24:00Z / Django_

  Build a macOS Service (Quick Action) that sends `find` results to the clipboard via `pbcopy` — works back to Big Sur.

- [Template Code for Starting an App with Python Bottle (and Combining with Vue CDN)](https://www.ytyng.com/en/blog/python-bottle-template)

  _2022-10-10T01:47:11Z_

  Here is a template code for creating a simple HTML application using Bottle.

- [Code for Creating a Logger When Making Python Command Line Tools](https://www.ytyng.com/en/blog/python-create-logger-from-code)

  _2022-10-09T02:16:35Z / Python_

  Build an OpenVPN server that routes all clients in a segment through the VPN — from CA cert issuance to distributing `client.ovpn`.

- [Opening Slack Channel Links with Command Line, Raycast, and Alfred](https://www.ytyng.com/en/blog/slack-channel-open-command)

  _2022-09-30T00:50:07Z_

  Convert a Slack web URL into the slack:// scheme to open a specific channel directly from the command line, Raycast Quicklink, or Alfred.

- [Fixing the Issue of Separated Voiced Marks in Folder Names on Mac When Outputting from Python](https://www.ytyng.com/en/blog/mac-のフォルダ名を-python-から出力する時に濁点が分かれてしまうのを直す)

  _2022-09-19T07:31:07Z / Python_

  Debug and work around `multipart/form-data` boundary issues during file upload in macOS WebKit (WKWebView / Safari).

- [After Updating Django, Migration Fails for oauth2_provider](https://www.ytyng.com/en/blog/django-oauth2_provider-migration-failed-foreignkey)

  _2022-09-16T10:11:48Z / Django_

  Use `mkdir -p ... && cd $_` on macOS to chain create-and-enter reliably without race conditions.

- [Setting Up a Logger to Output Logs to the Console in Django](https://www.ytyng.com/en/blog/django-console-logging-settings)

  _2022-09-12T12:21:28Z / Django_

  Summary of the blog post in English:
"Django Logging Configuration: Output to Console Instead of File"

- [Tips for Solving the 2027 Malformed Packet Error in MySQL](https://www.ytyng.com/en/blog/django-mysql-client-2027-malformed-packet-error)

  _2022-09-11T09:58:30Z / Django, MySQL_

  Return a common post-login redirect target in Django Allauth without specifying a SocialAccount — how `LOGIN_REDIRECT_URL` behaves and how to override it.