# A code to remember

Notes on Python, Linux, CI/CD, containers, databases and web development.

## Pages

- [2018](<https://copdips.com/archive/2018.md>)
- [2018](<https://copdips.com/archive/2018/page/2.md>)
- [2018](<https://copdips.com/archive/2018/page/3.md>)
- [2019](<https://copdips.com/archive/2019.md>)
- [2019](<https://copdips.com/archive/2019/page/2.md>)
- [2020](<https://copdips.com/archive/2020.md>)
- [2021](<https://copdips.com/archive/2021.md>)
- [2022](<https://copdips.com/archive/2022.md>)
- [2022](<https://copdips.com/archive/2022/page/2.md>)
- [2023](<https://copdips.com/archive/2023.md>)
- [2023](<https://copdips.com/archive/2023/page/2.md>)
- [2023](<https://copdips.com/archive/2023/page/3.md>)
- [2024](<https://copdips.com/archive/2024.md>)
- [2024](<https://copdips.com/archive/2024/page/2.md>)
- [2024](<https://copdips.com/archive/2024/page/3.md>)
- [2025](<https://copdips.com/archive/2025.md>)
- [2025](<https://copdips.com/archive/2025/page/2.md>)
- [2026](<https://copdips.com/archive/2026.md>)
- [ai-coding](<https://copdips.com/category/ai-coding.md>)
- [ai](<https://copdips.com/category/ai.md>)
- [algo](<https://copdips.com/category/algo.md>)
- [api](<https://copdips.com/category/api.md>)
- [ast](<https://copdips.com/category/ast.md>)
- [async](<https://copdips.com/category/async.md>)
- [auth](<https://copdips.com/category/auth.md>)
- [azure](<https://copdips.com/category/azure.md>)
- [azure](<https://copdips.com/category/azure/page/2.md>)
- [azure](<https://copdips.com/category/azure/page/3.md>)
- [backup](<https://copdips.com/category/backup.md>)
- [cache](<https://copdips.com/category/cache.md>)
- [certificate](<https://copdips.com/category/certificate.md>)
- [cicd](<https://copdips.com/category/cicd.md>)
- [cicd](<https://copdips.com/category/cicd/page/2.md>)
- [cicd](<https://copdips.com/category/cicd/page/3.md>)
- [cicd](<https://copdips.com/category/cicd/page/4.md>)
- [container](<https://copdips.com/category/container.md>)
- [database](<https://copdips.com/category/database.md>)
- [databricks](<https://copdips.com/category/databricks.md>)
- [datetime](<https://copdips.com/category/datetime.md>)
- [debug](<https://copdips.com/category/debug.md>)
- [docker](<https://copdips.com/category/docker.md>)
- [elastic](<https://copdips.com/category/elastic.md>)
- [email](<https://copdips.com/category/email.md>)
- [encoding](<https://copdips.com/category/encoding.md>)
- [file](<https://copdips.com/category/file.md>)
- [flask](<https://copdips.com/category/flask.md>)
- [frontend](<https://copdips.com/category/frontend.md>)
- [git](<https://copdips.com/category/git.md>)
- [github](<https://copdips.com/category/github.md>)
- [github](<https://copdips.com/category/github/page/2.md>)
- [gitlab](<https://copdips.com/category/gitlab.md>)
- [jekyll](<https://copdips.com/category/jekyll.md>)
- [linter](<https://copdips.com/category/linter.md>)
- [linux](<https://copdips.com/category/linux.md>)
- [markdown](<https://copdips.com/category/markdown.md>)
- [mcp](<https://copdips.com/category/mcp.md>)
- [messaging](<https://copdips.com/category/messaging.md>)
- [migration](<https://copdips.com/category/migration.md>)
- [mkdocs](<https://copdips.com/category/mkdocs.md>)
- [multiprocessing](<https://copdips.com/category/multiprocessing.md>)
- [multithreading](<https://copdips.com/category/multithreading.md>)
- [network](<https://copdips.com/category/network.md>)
- [ollama](<https://copdips.com/category/ollama.md>)
- [package](<https://copdips.com/category/package.md>)
- [pandas](<https://copdips.com/category/pandas.md>)
- [pip](<https://copdips.com/category/pip.md>)
- [powershell](<https://copdips.com/category/powershell.md>)
- [powershell](<https://copdips.com/category/powershell/page/2.md>)
- [process](<https://copdips.com/category/process.md>)
- [proxy](<https://copdips.com/category/proxy.md>)
- [python](<https://copdips.com/category/python.md>)
- [python](<https://copdips.com/category/python/page/2.md>)
- [python](<https://copdips.com/category/python/page/3.md>)
- [python](<https://copdips.com/category/python/page/4.md>)
- [python](<https://copdips.com/category/python/page/5.md>)
- [python](<https://copdips.com/category/python/page/6.md>)
- [quart](<https://copdips.com/category/quart.md>)
- [redis](<https://copdips.com/category/redis.md>)
- [scheduling](<https://copdips.com/category/scheduling.md>)
- [shell](<https://copdips.com/category/shell.md>)
- [sonar](<https://copdips.com/category/sonar.md>)
- [spark](<https://copdips.com/category/spark.md>)
- [sqlalchemy](<https://copdips.com/category/sqlalchemy.md>)
- [ssh](<https://copdips.com/category/ssh.md>)
- [storage](<https://copdips.com/category/storage.md>)
- [ubuntu](<https://copdips.com/category/ubuntu.md>)
- [unittest](<https://copdips.com/category/unittest.md>)
- [vault](<https://copdips.com/category/vault.md>)
- [video](<https://copdips.com/category/video.md>)
- [vmware](<https://copdips.com/category/vmware.md>)
- [vscode](<https://copdips.com/category/vscode.md>)
- [web](<https://copdips.com/category/web.md>)
- [Blog](<https://copdips.com/index.md>)
- [Blog](<https://copdips.com/page/10/index.md>)
- [Blog](<https://copdips.com/page/11/index.md>)
- [Blog](<https://copdips.com/page/12/index.md>)
- [Blog](<https://copdips.com/page/13/index.md>)
- [Blog](<https://copdips.com/page/2/index.md>)
- [Blog](<https://copdips.com/page/3/index.md>)
- [Blog](<https://copdips.com/page/4/index.md>)
- [Blog](<https://copdips.com/page/5/index.md>)
- [Blog](<https://copdips.com/page/6/index.md>)
- [Blog](<https://copdips.com/page/7/index.md>)
- [Blog](<https://copdips.com/page/8/index.md>)
- [Blog](<https://copdips.com/page/9/index.md>)
- [Setting up Github Pages With custom domain over HTTPS](<https://copdips.com/2018/05/setting-up-github-pages-with-custom-domain-over-https.md>)
- [Setting Up Powershell gallery And Nuget gallery](<https://copdips.com/2018/05/setting-up-powershell-gallery-and-nuget-gallery-for-powershell.md>)
- [Powershell stop-parsing (--%)](<https://copdips.com/2018/05/powershell-stop-parsing.md>)
- [Setting up Jekyll with Minimal Mistakes theme on Windows](<https://copdips.com/2018/05/setting-up-jekyll-with-minimal-mistakes-theme-on-windows.md>)
- [Using Readline In Python REPL On Windows With PyReadline and PtPython](<https://copdips.com/2018/05/using-readline-in-python-repl-on-windows-with-pyreadline-and-ptpython.md>)
- [Select-ColorString : A Unix's grep-like Powershell Cmdlet Based On Select-String With Color](<https://copdips.com/2018/05/select-colorstring--a-unixs-grep-like-powershell-cmdlet-based-on-select-string-with-color.md>)
- [Converting Python json dict list to csv file in 2 lines of code by pandas](<https://copdips.com/2018/06/converting-python-json-dict-list-to-csv-file-in-2-lines-of-code-by-pandas.md>)
- [Import Python module with sys.path variable when without \_\_init\_\_ file](<https://copdips.com/2018/06/import-python-module-with-syspath-variable-when-without-__init__-file.md>)
- [Git untrack submodule from git status](<https://copdips.com/2018/06/git-untrack-submodule-from-git-status.md>)
- [Install Python on Windows with Powershell without administrator privileges](<https://copdips.com/2018/06/install-python-on-windows-with-powershell-without-administrator-privileges.md>)
- [Use pyVmomi EventHistoryCollector to get all the vCenter events](<https://copdips.com/2018/07/use-pyvmomi-EventHistoryCollector-to-get-all-the-vcenter-events.md>)
- [Use python tabulate module to create tables](<https://copdips.com/2018/07/use-python-tabulate-module-to-create-tables.md>)
- [Convert markdown or rst to Atlassian Confluance documentation format](<https://copdips.com/2018/07/convert-markdown-or-rst-to-atlassian-confluance-documentation-format.md>)
- [Use Powershell to manage Windows Scheduled Task](<https://copdips.com/2018/09/use-powershell-to-manage-windows-scheduled-task.md>)
- [Install Gitlab-CE in Docker on Ubuntu](<https://copdips.com/2018/09/install-gitlab-ce-in-docker-on-ubuntu.md>)
- [Setup HTTPS for Gitlab](<https://copdips.com/2018/09/setup-https-for-gitlab.md>)
- [Install Gitlab Runner on Windows by Powershell PsRemoting](<https://copdips.com/2018/09/install-gitlab-runner-on-windows-by-powershell-psremoting.md>)
- [Backup and restore Gitlab in docker](<https://copdips.com/2018/09/backup-and-restore-gitlab-in-docker.md>)
- [Terminate Powershell script or session](<https://copdips.com/2018/09/terminate-powershell-script-or-session.md>)
- [Update Gitlab in docker](<https://copdips.com/2018/10/update-gitlab-in-docker.md>)
- [Migrate Gitlab in docker](<https://copdips.com/2018/10/migrate-gitlab-in-docker.md>)
- [Using Gitlab integrated CICD for Python project on Windows](<https://copdips.com/2018/10/using-gitlab-integrated-cicd-for-python-project-on-windows.md>)
- [Setting Pwsh Invoke-WebRequest Proxy](<https://copdips.com/2018/11/setting-pwsh-invoke-webrequest-proxy.md>)
- [Creating Multiple Redis Instance Services On Windows](<https://copdips.com/2018/11/creating-multiple-redis-instance-services-on-windows.md>)
- [Creating Custom Python Request Auth Class](<https://copdips.com/2019/04/creating-custom-python-request-auth-class.md>)
- [Using Python SQLAlchemy session in concurrent threads or tasks](<https://copdips.com/2019/05/using-python-sqlalchemy-session-in-concurrent-threads-or-tasks.md>)
- [Git Cheat Sheet](<https://copdips.com/2019/06/git-cheat-sheet.md>)
- [Filtering In Pandas Dataframe](<https://copdips.com/2019/07/filtering-in-pandas-dataframe.md>)
- [Troubleshooting Python Twine Cannot Upload Package On Windows](<https://copdips.com/2019/07/troubleshooting-python-twine-cannot-upload-package-on-windows.md>)
- [Fast TCP port check in Powershell](<https://copdips.com/2019/09/fast-tcp-port-check-in-powershell.md>)
- [SQLAlchemy mixin in method](<https://copdips.com/2019/09/sqlalchemy-mixin-in-method.md>)
- [Install Python3 on Ubuntu](<https://copdips.com/2019/10/install-python3-on-ubuntu.md>)
- [Elastic Painless Scripted Field On Null/Missing Value](<https://copdips.com/2019/12/elastic-painless-scripted-field-on-nullmissing-value.md>)
- [Using Powershell To Retrieve Latest Package Url From Github Releases](<https://copdips.com/2019/12/Using-Powershell-to-retrieve-latest-package-url-from-github-releases.md>)
- [Using Scoop On Windows](<https://copdips.com/2019/12/using-scoop-on-windows.md>)
- [Setting up WSL](<https://copdips.com/2020/02/setting-up-wsl.md>)
- [Flattening nested dict in Python](<https://copdips.com/2020/03/flattening-nested-dict-in-python.md>)
- [Fixing an ipython Windows ConEmu only bug on 'MouseEventType.MOUSE\_DOWN'](<https://copdips.com/2020/04/fixing-an-ipython-windows-conemu-only-bug-on-mouseeventtypemouse_down.md>)
- [Making isort compatible with black](<https://copdips.com/2020/04/making-isort-compatible-with-black.md>)
- [Using Python Contextmanager To Create A Timer Decorator](<https://copdips.com/2020/05/using-python-contextmanager-to-create-a-timer-decorator.md>)
- [Compiling SQLAlchemy query to nearly real raw sql query](<https://copdips.com/2020/06/compiling-sqlalchemy-query-to-nearly-real-raw-sql-query.md>)
- [Rolling back from flask-restplus reqparse to native flask request to parse inputs](<https://copdips.com/2020/07/rolling-back-from-flask-restplus-reqparse-to-native-flask-request-to-parse-inputs.md>)
- [My Powerline setup and configuration](<https://copdips.com/2020/11/my-powerline-setup-and-configuration.md>)
- [Python Lint And Format](<https://copdips.com/2021/01/python-lint-and-format.md>)
- [Python Requests With Retry](<https://copdips.com/2021/01/python-requests-with-retry.md>)
- [Trying Python pipreqs and pip-tools](<https://copdips.com/2021/03/trying-python-pipreqs-and-pip-tools.md>)
- [Python Unittest Cheat Sheet](<https://copdips.com/2021/06/python-unittest-cheat-sheet.md>)
- [Python datetime utcnow](<https://copdips.com/2021/06/python-datetime-utcnow.md>)
- [Azure pipeline predefined variables](<https://copdips.com/2022/01/azure-pipeline-predefined-variables.md>)
- [Azure pipeline reuse variables in template from another repository](<https://copdips.com/2022/02/azure-pipeline-reuse-variables-in-template-from-another-repository.md>)
- [Azure pipeline checkout repository from another project](<https://copdips.com/2022/02/azure-pipeline-checkout-repository-from-another-project.md>)
- [Azure pipeline variables and parameters](<https://copdips.com/2022/03/azure-pipeline-variables-and-parameters.md>)
- [Manage Azure Databricks Service Principal](<https://copdips.com/2022/03/manage-azure-databricks-service-principal.md>)
- [Azure Pipeline Checkout Multiple Repositories](<https://copdips.com/2022/04/azure-pipeline-checkout-multiple-repositories.md>)
- [Using Databricks Connect inside a container](<https://copdips.com/2022/06/using-databricks-connect-inside-a-container.md>)
- [Azure pipeline conditions](<https://copdips.com/2022/07/azure-pipeline-conditions.md>)
- [Databricks job/task context](<https://copdips.com/2022/07/databricks-jobtask-context.md>)
- [Azure pipeline jobs](<https://copdips.com/2022/08/azure-pipeline-jobs.md>)
- [Azure pipeline System.AccessToken in shared pipeline](<https://copdips.com/2022/09/azure-pipeline-systemaccesstoken-in-shared-pipeline.md>)
- [Adding data files to Python package with setup.py](<https://copdips.com/2022/09/adding-data-files-to-python-package-with-setuppy.md>)
- [Databricks cluster access mode](<https://copdips.com/2022/09/databricks-cluster-access-mode.md>)
- [Azure pipeline delete blobs from blob storage](<https://copdips.com/2022/11/azure-pipeline-delete-blobs-from-blob-storage.md>)
- [Azure pipeline Windows agent UnicodeEncodeError](<https://copdips.com/2022/11/azure-pipeline-windows-agent-unicodeencodeerror.md>)
- [Using ast and cst to change Python code](<https://copdips.com/2022/11/using-ast-and-cst-to-change-python-code.md>)
- [Python difference on subprocess run(), call(), check\_call(), check\_output()](<https://copdips.com/2022/12/python-difference-on-subprocess-run-call-check_call-check_output.md>)
- [Syncing repository from github to gitee](<https://copdips.com/2022/12/syncing-repository-from-github-to-gitee.md>)
- [Python aiohttp rate limit](<https://copdips.com/2023/01/python-aiohttp-rate-limit.md>)
- [Calling Azure REST API](<https://copdips.com/2023/01/calling-azure-rest-api.md>)
- [Sonarcloud Github Action](<https://copdips.com/2023/01/sonarcloud-github-action.md>)
- [Python Asyncio Unittest](<https://copdips.com/2023/07/python-asyncio-unittest.md>)
- [Different ssh keys for different github.com accounts](<https://copdips.com/2023/09/different-ssh-keys-for-different-githubcom-accounts.md>)
- [Python Asyncio](<https://copdips.com/2023/09/python-asyncio.md>)
- [Github Actions: Cache](<https://copdips.com/2023/09/github-actions-cache.md>)
- [Github Actions: Custom Actions](<https://copdips.com/2023/09/github-actions-custom-actions.md>)
- [Github Actions: Environment](<https://copdips.com/2023/09/github-actions-environment.md>)
- [Github Actions: Variables](<https://copdips.com/2023/09/github-actions-variables.md>)
- [Github Actions : Error handling](<https://copdips.com/2023/09/github-actions--error-handling.md>)
- [Github Actions: Workflows](<https://copdips.com/2023/09/github-actions-workflows.md>)
- [Databricks Python pip authentication](<https://copdips.com/2023/09/databricks-python-pip-authentication.md>)
- [Github Actions: Python](<https://copdips.com/2023/09/github-actions-python.md>)
- [Github Actions: copdips/get-azure-keyvault-secrets-action](<https://copdips.com/2023/10/github-actions-copdipsget-azure-keyvault-secrets-action.md>)
- [Hashing files](<https://copdips.com/2023/10/hashing-files.md>)
- [Github Actions: Bash shell -e -o pipefail](<https://copdips.com/2023/11/github-actions-bash-shell--e--o-pipefail.md>)
- [Some nice cicd bash common scripts](<https://copdips.com/2023/11/some-nice-cicd-bash-common-scripts.md>)
- [Github actions: deploy static files to azure web app](<https://copdips.com/2023/11/github-actions-deploy-static-files-to-azure-web-app.md>)
- [Migrating my blog from Jekyll Minimal Mistakes to Mkdocs Material](<https://copdips.com/2023/12/migrating-my-blog-from-jekyll-minimal-mistakes-to-mkdocs-material.md>)
- [Python local version identifiers](<https://copdips.com/2023/12/python-local-version-identifiers.md>)
- [Rendering CSV as Markdown table in Mkdocs Material](<https://copdips.com/2023/12/rendering-csv-as-markdown-table-in-mkdocs-material.md>)
- [bash-git-prompt tweaks](<https://copdips.com/2024/01/bash-git-prompt-tweaks.md>)
- [Python packaging with Flit](<https://copdips.com/2024/01/python-packaging-with-flit.md>)
- [Scripts to delete outlook emails](<https://copdips.com/2024/01/scripts-to-delete-outlook-emails.md>)
- [Debugging in vscode](<https://copdips.com/2024/02/debugging-in-vscode.md>)
- [Debugging in Python](<https://copdips.com/2024/02/debugging-in-python.md>)
- [Getting all users from MS Graph API in few seconds](<https://copdips.com/2024/02/getting-all-users-from-ms-graph-api-in-few-seconds.md>)
- [Azure Messaging Service](<https://copdips.com/2024/03/azure-messaging-service.md>)
- [First try on Quart an asyncio re-implementation of Flask](<https://copdips.com/2024/03/first-try-on-quart-an-asyncio-re-implementation-of-flask.md>)
- [Sqlalchemy eager loading](<https://copdips.com/2024/03/sqlalchemy-eager-loading.md>)
- [Dockerfile with secrets](<https://copdips.com/2024/04/dockerfile-with-secrets.md>)
- [Convert json to parquet and send to Azure Blob Storage](<https://copdips.com/2024/05/convert-json-to-parquet-and-send-to-azure-blob-storage.md>)
- [Running asyncio task in Databricks](<https://copdips.com/2024/06/running-asyncio-task-in-databricks.md>)
- [Profiling Python code](<https://copdips.com/2024/06/profiling-python-code.md>)
- [Azure Data Factory - ForEach Activity](<https://copdips.com/2024/08/azure-data-factory---foreach-activity.md>)
- [Generating ERD from sqlalchemy](<https://copdips.com/2024/08/generating-erd-from-sqlalchemy.md>)
- [Generating .env file](<https://copdips.com/2024/09/generating-env-file.md>)
- [Python thread safe operations](<https://copdips.com/2024/10/python-thread-safe-operations.md>)
- [Python adding version info to docstrings](<https://copdips.com/2024/11/python-adding-version-info-to-docstrings.md>)
- [Generating Azure OAuth2 Access Token By Python](<https://copdips.com/2024/11/generating-azure-oauth2-access-token-by-python.md>)
- [Databricks Connect](<https://copdips.com/2024/11/databricks-connect.md>)
- [Downloading online videos by ffmpeg](<https://copdips.com/2024/11/downloading-online-videos-by-ffmpeg.md>)
- [PySpark database connectors](<https://copdips.com/2025/02/pyspark-database-connectors.md>)
- [Python Type Hints](<https://copdips.com/2025/02/python-type-hints.md>)
- [Process, port, and file usages in Linux](<https://copdips.com/2025/02/process-port-and-file-usages-in-linux.md>)
- [Installing Ollama without root](<https://copdips.com/2025/03/installing-ollama-without-root.md>)
- [Using Pageant with VSCode Remote SSH](<https://copdips.com/2025/03/using-pageant-with-vscode-remote-ssh.md>)
- [Python uv cheat sheet](<https://copdips.com/2025/08/python-uv-cheat-sheet.md>)
- [AI Coding Playbook](<https://copdips.com/2025/08/ai-coding-playbook.md>)
- [Google Chrome DevTools MCP](<https://copdips.com/2025/11/google-chrome-devtools-mcp.md>)
- [OIDC (OpenID Connect)](<https://copdips.com/2025/11/oidc-openid-connect.md>)
- [Running Multiple Apps Under a Single Domain with Vercel](<https://copdips.com/2025/12/running-multiple-apps-under-a-single-domain-with-vercel.md>)
- [SQLAlchemy cheat-sheet](<https://copdips.com/2025/12/sqlalchemy-cheat-sheet.md>)
- [Windows 11 WSL2 DNS and OpenVPN Split Tunnel](<https://copdips.com/2026/03/windows-11-wsl2-dns-and-openvpn-split-tunnel.md>)
- [Merkle Trees (Hash Trees)](<https://copdips.com/2026/05/merkle-trees-hash-trees.md>)
- [Consistent Hashing](<https://copdips.com/2026/05/consistent-hashing.md>)
- [chezmoi Workflow: Edit, Diff, Apply](<https://copdips.com/2026/11/chezmoi-workflow-edit-diff-apply.md>)