MarquinSmith

Analytical – Honest – Passionate

  • Home
  • Services
  • Mini Projects
    • Data Analytics Helper Tools
    • Bitcoin Price Dashboard
    • Journey to data engineering
    • Tarantino Film Dashboard
    • Woolworths stock price tracker
    • How to reason and argue
  • Reference
    • The BookShelf
    • SQL Cheat Sheet
    • Dockerfile Cheat Sheet
  • Health, fitness and wellbeing
    • Crossfit Workouts
    • Gymnastics
    • Strength and fitness masterclass
    • Nutrition Course
    • Workout Stats
    • Physical Activity Stats
    • 6 week pre season soccer fitness plan
  • About

Tag: python

Automation

Running SQL Queries on a schedule in BigQuery | Part 2b: Cloud Functions

4th February 20254th February 2025 M SmithLeave a comment

In this part of the series we will walkthrough how to set up a query to run at a regular interval using Python and Cloud Functions. This is useful particularly …

Read More ›
Automation

A Dockerfile to create a docker image to run a python file

10th January 202510th January 2025 M SmithLeave a comment

Use this Dockerfile as a template to be able to create docker images that will execute a python script once the container is run. This can be very useful if …

Read More ›
Data Analysis

A personal health tracking tool

6th December 20246th December 2024 M SmithLeave a comment

For a little while now I have been using a personal health tracking tool to monitor my progress in various areas such as strength exercises, weight management and mental hygiene …

Read More ›
Python

Retrieving an image (BLOB) from a SQLite database

27th November 202427th November 2024 M SmithLeave a comment
Read More ›
Python

Saving images to SQLite database

27th November 202427th November 2024 M SmithLeave a comment
Read More ›
Data Analysis

Execute queries in BigQuery in parallel using python

10th August 202410th August 2024 M SmithLeave a comment

An example of how to run multiple queries in parallel.

Read More ›
Data Analysis

Simple logging to SQLite database from python

5th July 20245th July 2024 M SmithLeave a comment

A lightweight example of saving some logs to an SQLite database in a python script.

Read More ›
Python

Adding user login to Streamlit apps

5th July 20245th July 2024 M SmithLeave a comment

A short guide to adding user authentication to Streamlit apps. So you’ve created a beautiful Streamlit app which your users love, but only certain people should be able to access …

Read More ›
Data Analysis

Getting started with Streamlit

1st September 20234th July 2024 M Smith1 Comment

Video Tutorials 30 days of Streamlit Build a different Streamlit app each day for 30 days https://blog.streamlit.io/30-days-of-streamlit/ Streamlit documentation Offical Streamlit documentation. Very user friendly and accessible reference materials. https://docs.streamlit.io/library/get-started …

Read More ›
Data Analysis

How to host a Streamlit app on Google Cloud Run

26th August 202316th September 2023 M SmithLeave a comment

A short guide for deploying a Streamlit app to Cloud Run on Google Cloud platform. Google Cloud Run is a managed platform for hosting and running docker containers. So once …

Read More ›

Posts pagination

1 2 3

Recent Posts

  • A command line tool to compare 2 different csv files – sweetviz edition
  • Bots arrive on marquinsmith.com
  • Physical Health Tracker – October 2025
  • Jeff Booth conversation on Simply Bitcoin
  • A `.sqlfluff` settings file I like

Categories

  • Automation
  • Business
  • cybersecurity
  • Data Analysis
  • Finance
  • Personal Development
  • Python
  • Uncategorised
  • Web Analytics

Archives

Copyright © 2025 MarquinSmith.
Theme Easthill by ThemeMunk. Powered by WordPress.