Smart Tech Academy

Moving from MS Access to MySQL is an important step for anyone who wants to build real web applications, backend APIs, tracking systems, dashboards, or AI-powered projects. In this beginner-friendly tutorial, I will show how I use MySQL Workbench to create a database, write SQL queries, create a table, insert sample tracking data, and save SQL scripts for future use. Moving to the Big Leagues: A Beginner’s Guide to MySQL Workbench In my previous tutorials, we explored MS Access for local data management. MS Access is useful for learning tables, forms, queries, and relationships. But if we want to build a web application that can connect to a backend server, mobile app, dashboard, or cloud database, it needs to step into the world of MySQL . MySQL is widely used for web applications because it is reliable, structured, and supported by many programming languages such as PHP, Python, Node.js, Java, and Go. To manage MySQL more easily, I use MySQL Wo...

Firebase Hosting is one of the fastest ways to publish a Vue.js frontend online. With a few commands, we can build our Vue app, upload the production files, get a secure HTTPS URL, and optionally connect a custom domain or GitHub Actions workflow for automatic deployment. How to Deploy a Vue.js Project on Firebase Hosting: Step-by-Step Guide Vue.js + Firebase Hosting is a beginner-friendly way to publish modern frontend apps with HTTPS and global delivery. Introduction We have known that Vue.js is a popular JavaScript framework for building interactive web applications. Firebase Hosting is a production-grade hosting service from Google that can serve static websites and single-page applications through a secure, fast, globally distributed infrastructure. If we build the Vue app using Vite or Vue CLI, the final production output is usually a folder named dist . Firebase Hosting takes that folder and publishes it online as a websit...

FastAPI is a modern Python framework for building APIs, and Google Cloud Run is a serverless platform for running containers without managing servers. In this tutorial, we will deploy a FastAPI application to Cloud Run using two practical methods: deploy directly from source code and deploy with Docker plus Artifact Registry. How to Deploy FastAPI on Google Cloud Run: Step-by-Step Beginner Guide FastAPI + Cloud Run is a practical stack for deploying scalable Python APIs. Introduction Deploying a Python API is much easier today than before. Instead of buying a server, configuring Linux manually, installing a process manager, and maintaining infrastructure, it can package  application and deploy it to a managed service such as Google Cloud Run. FastAPI is useful for building fast, clean, and well-documented APIs in Python. Cloud Run is useful because it runs containers, scales automatically, and can scale down when not in use. Simple definition: Google Cloud Run lets us run co...