mostlylucid.net - Scott Galloway's Developer Blog
author

Hi, I'm Scott Galloway — I'm a consulting web / internet / systems / full-cycle, full-stack developer (it's complicated 🤓) specializing in bringing 'AI' to the masses, .NET Core, full-stack development, cloud, and search technologies. Former Microsoft ASP.NET Program Manager with 30+ years building web applications for Fortune 500 companies and startups. I share my work in progress (PERSONAL!) projects and how I build them. Available for contract, full-time, or consultancy work — get in touch. Code on GitHub | Feedback on Mastodon

Trending:
Simple OCR and NER Feature Extraction in C# with ONNX
Jan 21 AI CSharp Docker NER OCR ONNX Tutorial
Clear All
Page 6 of 79 (Total items: 782)
Cooking with DiSE (Part 4): Building Systems That Learn, Adapt, and Evolve
Most software architectures assume the system is static. DiSE assumes the system is alive. Note: This is Part 4 in the "Cooking with DiSE" series. See Part 1, Part 2: Graduated Apprenticeships, and...

Monday, 08 December 2025 12:00

//

15 minute read

StyloBot: Fighting Back Against Scrapers (Part 1)
Scrapers are about to start using AI to mimic real users - so I built a bot detector that learns, adapts, and fights back. Read Part 2: How Bots Got Smarter - The New Frontier in Bot Detection 👉 See...

Monday, 08 December 2025 07:00

//

17 minute read

Thinking in Systems: A Retrospective on a Life Spent Trying to Understand How Things Fit Together
By someone who can't stop analysing patterns, even their own. As the category says, this is a far more personal essay than my usual work. I don't mind if you skip it...but if it resonates leave a...

Sunday, 07 December 2025 12:00

//

10 minute read

Data Hierarchies Part 1.5: PostgreSQL ltree with EF Core
PostgreSQL's ltree extension gives you materialised paths with database-native superpowers: GiST indexes, specialised operators like @> and <@, and powerful pattern matching. If you're committed to...

Saturday, 06 December 2025 09:50

//

15 minute read

Data Hierarchies Part 1.4: Nested Sets with EF Core
Nested sets encode the entire tree structure into just two integers per node - Left and Right boundaries from a depth-first walk. Finding all descendants becomes a simple range query, and ORDER BY...

Saturday, 06 December 2025 09:40

//

16 minute read

Data Hierarchies Part 1.3: Materialised Path with EF Core
Materialised paths store the complete ancestry as a delimited string - like /1/3/7/ - making ancestors instantly readable without any joins. Perfect for breadcrumb generation and human-readable...

Saturday, 06 December 2025 09:30

//

14 minute read

Data Hierarchies Part 1.2: Closure Table with EF Core
Closure tables precompute and store every ancestor-descendant relationship, trading storage space for blazing-fast reads. This is the approach this blog uses for its comment system - when reads vastly...

Saturday, 06 December 2025 09:20

//

16 minute read

Data Hierarchies Part 1.1: Adjacency List with EF Core
The adjacency list is the simplest and most intuitive approach to storing hierarchical data - each row just points to its parent. It's what most developers reach for first, and for shallow trees with...

Saturday, 06 December 2025 09:10

//

11 minute read

Data Hierarchies: Managing Hierarchical Data with EF Core and PostgreSQL (Overview)
Hierarchical data is everywhere in software development: threaded comments, organisational charts, file systems, product categories, and forum discussions. The eternal question of "how do I store a...

Saturday, 06 December 2025 09:00

//

8 minute read

No we're likely not reaching AGI anytime soon: The Behaviourist Fallacy in AI Subsystem Development
Here's an uncomfortable truth that nobody in the AI hype machine wants to discuss: We still don't know what intelligence actually is. Not in humans. Not in animals. And certainly not in machines. This...

Friday, 05 December 2025 14:30

//

21 minute read

Page 6 of 79 (Total items: 782)
logo

© 2026 Scott Galloway — Unlicense — All content and source code on this site is free to use, copy, modify, and sell.