In my previous article I introduced how to build a sql chatbot with langchain and streamlit. I was then thinking if I can use streamlit to manage my image gallery on cloudflare. I found it was as easy as I thought, of course with a bit help of chatgpt..

Why I need this

I have been using cloudflare images service for a while and satisfied with its speed. However, it doesn’t have a good UI tool. It’s OK to login to cloudflare and upload images, but lazy as me I want to do it in a more convenient way. So I thought I could use its API to build a tool to do uploading and manangement. The solutions for this could be a web app or a desktop app. I prefer the former one because I can use it anywhere as long as I have a browser.
To build a web app, you can use framworks like react or vue, but I am not sure if I can build it in a short time. So I turned to streamlit again. It allows you to build a web app with only python and have a decent amount of built-in components.

I have just built a sql chatbot for local data using langchain and streamlit. I found the whole process surprisingly smooth with these two great tools, I put here how I built this and some thoughts alongside.

In case you don’t know what langchain and streamlit are, here is a brief introduction. Langchain in my mind is a tool to connect to all kinds of language models(e.g. openai) and provide interfaces to easily using them. Streamlit is a tool that allows you to write UI included apps with only python. so langchain+streamlit means you can build UI included llm apps with only python.