Skip to content
Ashton MacKenzie

Ashton MacKenzie

There is nothing old under the sun.

  • About / Work With Me
    • Shared Treats
  • Portfolio
    • Discogs Utility
    • The Guild of the Magi – Everything
      • The Guild of the Magi Demo
      • The Guild of the Magi – Pre Alpha
    • Zines
  • Reference Library
    • Reference Notes
    • Deploying a React Ruby app on Fly.io if you’ve never deployed a thing in your life
    • Introduction to Networks for Software Engineers
      • Handling Requests That Update Multiple Models in Ruby on Rails
      • DNS
      • Layer 1 – Media
      • Layer 2 – Link Layer (Part One)
    • Privacy Policy
  • Latest Posts
  • Friends

Tag: sql

  • Home
  • sql
Technology

You already use database normalization concepts to avoid food poisoning.

September 27, 2024April 21, 2025 A MacKenzie

I give you a pizza. It was properly normalized, because of that the selection was efficient and you can be sure it is free of allergens and compliant with your dietary restrictions.

Full Article
Reference Technology

Practicing SQL in leetcode – Game Play Analysis

November 27, 2023April 21, 2025 A MacKenzie

I think if you zoom in, you can see semicolons in my eyes

Full Article
a tangled mess of cables in a physical database location
Technology

Want to hear something about query languages that will make you actually appreciate callback functions and promises in programming languages?

October 11, 2023April 21, 2025 A MacKenzie

Thanks, I hate it

Full Article
Reference Technology

SQL Server Tips I Learned This week

August 11, 2023April 21, 2025 A MacKenzie

Always remember to name the SQL implementation when searching for how to write a query so that you can ask for how a thing you remember working in one implementation works for the one you’re landed with.

Full Article

Recent Posts

  • Mochiko Pão de Queijo
  • Manoomin Kitchari
  • March Zine – Vermont is my Home
  • February Zine – Food Exchange Group
  • Apple Crisp Pie

Categories

  • Art
  • Blog
  • Crafts
  • español
  • Food
  • Mac
  • Natural Materials
  • Portfolio
  • Reference
  • Technology
  • Upcycling
  • zine

Archives

  • May 2025
  • April 2025
  • March 2025
  • February 2025
  • January 2025
  • December 2024
  • November 2024
  • September 2024
  • November 2023
  • October 2023
  • August 2023
  • July 2023
  • June 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022

Connect with me!

  • LinkedIn
  • Mastodon
  • GitHub

All Rights Reserved 2024.
Proudly powered by WordPress | Theme: Fairy by Candid Themes.