Query SQLite databases on pods directly

If you work with SQLite databases in Kubernetes or OpenShift, you’re probably familiar with using the remote shell (rsh) feature to access the database and run queries on the pod directly. The remote shell is great for one-off tasks with a table or exploratory work, but it will break your workflow and chain of thought when working with automation or running tasks on your local system. But you can use the exec command in oc and kubectl to query the database and return results directly int to your local environment, making tasks faster, easier, and more fluid....

May 13, 2023 · 7 min