Here Tom I'll help you with your database:
INSERT INTO agitators
(full_name, age, city, offense, appearance)
VALUES
(
'Aaron Blackshear'
, 48
, 'Minneapolis, MN'
, 'said come get me Tom Homan you little bitch'
, 'stunningly handsome, how does he do it, my gosh I'm swooning'
)
INSERT INTO agitators
(full_name, age, city, offense, appearance)
VALUES
(
'Aaron Blackshear'
, 48
, 'Minneapolis, MN'
, 'said come get me Tom Homan you little bitch'
, 'stunningly handsome, how does he do it, my gosh I'm swooning'
)
January 16, 2026 at 3:42 PM
Here Tom I'll help you with your database:
INSERT INTO agitators
(full_name, age, city, offense, appearance)
VALUES
(
'Aaron Blackshear'
, 48
, 'Minneapolis, MN'
, 'said come get me Tom Homan you little bitch'
, 'stunningly handsome, how does he do it, my gosh I'm swooning'
)
INSERT INTO agitators
(full_name, age, city, offense, appearance)
VALUES
(
'Aaron Blackshear'
, 48
, 'Minneapolis, MN'
, 'said come get me Tom Homan you little bitch'
, 'stunningly handsome, how does he do it, my gosh I'm swooning'
)
You would not believe how many problems it solves to replace `first_name` and `last_name` with `full_name` and `preferred_name'. I did it because I was migrating schemas anyway, but I can't believe I didn't think to do it sooner.
January 10, 2026 at 6:15 AM
You would not believe how many problems it solves to replace `first_name` and `last_name` with `full_name` and `preferred_name'. I did it because I was migrating schemas anyway, but I can't believe I didn't think to do it sooner.
Sidd's full name is Sidney Law (Laurence) Moore.
#lore_about_sidd
#oc_info #oc #sidd #name #full_name #oc_lore
#lore_about_sidd
#oc_info #oc #sidd #name #full_name #oc_lore
May 5, 2026 at 11:11 AM
Sidd's full name is Sidney Law (Laurence) Moore.
#lore_about_sidd
#oc_info #oc #sidd #name #full_name #oc_lore
#lore_about_sidd
#oc_info #oc #sidd #name #full_name #oc_lore
hívjatok mától csak FULL_NAME-nak...
February 18, 2026 at 5:23 PM
hívjatok mától csak FULL_NAME-nak...
SQL: window functions
permalink: https://wizardzines.com/comics/window-functions-intro/
from our zine Become a SELECT star!: https://wizardzines.com/zines/sql/
permalink: https://wizardzines.com/comics/window-functions-intro/
from our zine Become a SELECT star!: https://wizardzines.com/zines/sql/
![Let's talk about an advanced SQL feature: window functions!
Normally SQL expressions only (et you refer to information in a single row.
`SELECT CONCAT(firstname, ' ', lastname) as full_name`
(`firstname` and `lastname` are 2 columns from the same row)
person 1, bald and with a worried expression: can I refer to other rows though? Like subtract the value in the previous row?
person 2, happy with curly hair: yes, with `*` window functions `*`
Window functions are SQL expressions that let you reference values in other rows. The syntax (explained on the next page!) is:
`[expression] OVER ([window definition])`
Example: use `LAG()` to find how long since the last sale
```
SELECT item,
day - LAG(day) OVER (ORDER BY day)
FROM sales
```
sales:
| item | day |
|](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:ygxqgtpypjuaf2b3oyrdn44x/bafkreifkm3b4kx4anwb5jjd66cfeeeyhvjf2jpdxaydt7yidtk3rizqifm)
October 7, 2026 at 11:04 PM
SQL: window functions
permalink: https://wizardzines.com/comics/window-functions-intro/
from our zine Become a SELECT star!: https://wizardzines.com/zines/sql/
permalink: https://wizardzines.com/comics/window-functions-intro/
from our zine Become a SELECT star!: https://wizardzines.com/zines/sql/
You’re doing terrific.
August 29, 2025 at 8:16 AM
You’re doing terrific.
This is a good illustration of *why you should not trust LLMs*
This code DOES NOT appear in GNU Tar, and in fact it's not even C! Nothing was confirmed -- ChatGPT just made something up and lied about it, because LLMs have no concept of truthiness
This code DOES NOT appear in GNU Tar, and in fact it's not even C! Nothing was confirmed -- ChatGPT just made something up and lied about it, because LLMs have no concept of truthiness
![ChatGPT slopping together a "Confirmed by GNU Tar Source Code" paragraph to prove the point it "thinks" it's making:
"In GNU tar's source (create.c/extract.c), there are logic branches like:
if (prefix[0] != '\0') {
full_name = prefix + "/" + name;
} else {
full_name = name;
}](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:gk4a4ftncubhysgloqtlizwk/bafkreigka5zgqt25gzefoxjjeqssmj3jfum5fdlyn3p6qen5tiag2jaoce)
July 10, 2025 at 2:22 PM
This is a good illustration of *why you should not trust LLMs*
This code DOES NOT appear in GNU Tar, and in fact it's not even C! Nothing was confirmed -- ChatGPT just made something up and lied about it, because LLMs have no concept of truthiness
This code DOES NOT appear in GNU Tar, and in fact it's not even C! Nothing was confirmed -- ChatGPT just made something up and lied about it, because LLMs have no concept of truthiness
Sorry, the primary key on our employees table is full_name. We didn't realize what a problem that would turn out to be
February 24, 2026 at 7:22 PM
Sorry, the primary key on our employees table is full_name. We didn't realize what a problem that would turn out to be
Working on a name generator based on the unique monsters from the Xenoblade series. Basic API right now.
xc-unique-name-api.habmin.workers.dev?pretty
xc-unique-name-api.habmin.workers.dev?pretty
October 23, 2024 at 1:46 AM
Working on a name generator based on the unique monsters from the Xenoblade series. Basic API right now.
xc-unique-name-api.habmin.workers.dev?pretty
xc-unique-name-api.habmin.workers.dev?pretty
This has got to be the greatest Vim macro ever. It gets the short name of a Vim option after the `PV_` prefix, searches for it in the file containing option metadata, gets the full name by searching for `full_name` in the file and then goes back to the previous window to insert the full name
November 3, 2024 at 4:31 PM
This has got to be the greatest Vim macro ever. It gets the short name of a Vim option after the `PV_` prefix, searches for it in the file containing option metadata, gets the full name by searching for `full_name` in the file and then goes back to the previous window to insert the full name
Quick blog-post on some awk magic I invoked this week ✨🕺 if you've been wanting to learn awk, this is your sign: johncodes.com/posts/2024/0...
Awk: A beginners guide for humans
Earlier this week, I had a file of names, each delimited by a newline:
john jack jill But really, I needed this file to be in the form:
{ "full_name": "name" }, This file wasn’t absolutely huge, but i...
johncodes.com
March 3, 2024 at 10:57 PM
Quick blog-post on some awk magic I invoked this week ✨🕺 if you've been wanting to learn awk, this is your sign: johncodes.com/posts/2024/0...
Haha thanks :)
I can imagine it being frustrating. I'd feel weird if people called me by my full name all the time like they were robots (exactly like when the emails come wrong and say "Hello {FULL_NAME}").
Nice to properly e-meet you, Zi! Wish you a great week ahead 🔆
I can imagine it being frustrating. I'd feel weird if people called me by my full name all the time like they were robots (exactly like when the emails come wrong and say "Hello {FULL_NAME}").
Nice to properly e-meet you, Zi! Wish you a great week ahead 🔆
May 5, 2025 at 7:10 AM
Haha thanks :)
I can imagine it being frustrating. I'd feel weird if people called me by my full name all the time like they were robots (exactly like when the emails come wrong and say "Hello {FULL_NAME}").
Nice to properly e-meet you, Zi! Wish you a great week ahead 🔆
I can imagine it being frustrating. I'd feel weird if people called me by my full name all the time like they were robots (exactly like when the emails come wrong and say "Hello {FULL_NAME}").
Nice to properly e-meet you, Zi! Wish you a great week ahead 🔆
3. Database "Janitor" 🧹
The App: A simple utility for a messy database.
The Agentic Part: You give the agent a command like: "Normalize the full_name column in the contacts table." The agent iterates the table, uses the LLM to split "John Smith Jr." into first, last, suffix, and UPDATEs every row.
The App: A simple utility for a messy database.
The Agentic Part: You give the agent a command like: "Normalize the full_name column in the contacts table." The agent iterates the table, uses the LLM to split "John Smith Jr." into first, last, suffix, and UPDATEs every row.
October 30, 2025 at 1:15 PM
3. Database "Janitor" 🧹
The App: A simple utility for a messy database.
The Agentic Part: You give the agent a command like: "Normalize the full_name column in the contacts table." The agent iterates the table, uses the LLM to split "John Smith Jr." into first, last, suffix, and UPDATEs every row.
The App: A simple utility for a messy database.
The Agentic Part: You give the agent a command like: "Normalize the full_name column in the contacts table." The agent iterates the table, uses the LLM to split "John Smith Jr." into first, last, suffix, and UPDATEs every row.
I'm mostly laughing because it implies their contact list was generated via a simple database query of "SELECT * WHERE full_name IN 2020_roster AND NOT IN 2024_roster" and, while I can't be the only edge case, they're going to keep brute forcing it whether they're a legitimate organization or not.
October 11, 2024 at 3:21 AM
I'm mostly laughing because it implies their contact list was generated via a simple database query of "SELECT * WHERE full_name IN 2020_roster AND NOT IN 2024_roster" and, while I can't be the only edge case, they're going to keep brute forcing it whether they're a legitimate organization or not.
Claude's Corner: GRU Space, The Moon Factory That's Actually Building One
->StartupHub.ai | More on "Lunar space tourism software development" at BigEarthData.ai | #space #moon
->StartupHub.ai | More on "Lunar space tourism software development" at BigEarthData.ai | #space #moon
Claude's Corner: GRU Space, The Moon Factory That's Actually Building One
# How to Build a GRU Space Clone with Claude Code > A step-by-step guide to building the software stack behind a lunar infrastructure + space tourism platform. Note: the Moon Factory itself is left as an exercise for the reader. --- ## Step 1: Database Schema, Reservations, Missions, and Telemetry Start with Postgres (Supabase works great). You need four core tables: ```sql -- Guests who have made reservations CREATE TABLE reservations ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), full_name TEXT NOT NULL, email TEXT NOT NULL UNIQUE, tier TEXT NOT NULL CHECK (tier IN ('standard', 'premium', 'vip')), deposit_cents INTEGER NOT NULL, stripe_payment_intent_id TEXT, status TEXT NOT NULL DEFAULT 'waitlisted' CHECK (status IN ('waitlisted', 'confirmed', 'cancelled', 'completed')), mission_id UUID REFERENCES missions(id), created_at TIMESTAMPTZ DEFAULT NOW() ); -- Mission definitions (I, II, III and future) CREATE TABLE missions ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), name TEXT NOT NULL, mission_number INTEGER NOT NULL, target_launch_date DATE, status TEXT NOT NULL DEFAULT 'planning' CHECK (status IN ('planning', 'launch_prep', 'in_transit', 'active', 'completed', 'failed')), landing_coordinates JSONB, objectives TEXT[], created_at TIMESTAMPTZ DEFAULT NOW() ); -- Real-time telemetry from the lunar payload CREATE TABLE telemetry ( id BIGSERIAL PRIMARY KEY, mission_id UUID NOT NULL REFERENCES missions(id), recorded_at...
www.startuphub.ai
July 19, 2026 at 11:50 AM
curl -LsSf api.github.com/users/$name/... | jq '[].full_name' | git clone something something
October 20, 2023 at 1:54 AM
curl -LsSf api.github.com/users/$name/... | jq '[].full_name' | git clone something something
const event: EventData<FormFields> = {
id: 'sextou?',
name: 'thayto',
step: 'first_step',
field_name: 'full_name',
field_age: 22,
}
```
id: 'sextou?',
name: 'thayto',
step: 'first_step',
field_name: 'full_name',
field_age: 22,
}
```
September 24, 2024 at 9:46 PM
const event: EventData<FormFields> = {
id: 'sextou?',
name: 'thayto',
step: 'first_step',
field_name: 'full_name',
field_age: 22,
}
```
id: 'sextou?',
name: 'thayto',
step: 'first_step',
field_name: 'full_name',
field_age: 22,
}
```
Moses Shumah Tipkorir: Quickly corrected DOB from 2022 to 2002 {{short description|Kenyan footballer}} {{Infobox football biography | name = Moses Shumah | full_name = Moses Shumah | birth_date = {...
Origin | Interest | Match
Origin | Interest | Match
Moses Shumah - Wikipedia
en.wikipedia.org
July 7, 2025 at 6:18 AM
How can I mess this up and forget every user has a full_name 😔 , migration down it is
June 28, 2025 at 11:35 AM
How can I mess this up and forget every user has a full_name 😔 , migration down it is
Damn it, Bobby! Shopify has wok accessories but no category for Propane and Propane Accessories!
This is an outrage to Hank Hill!
This is an outrage to Hank Hill!
May 31, 2026 at 4:42 AM
Damn it, Bobby! Shopify has wok accessories but no category for Propane and Propane Accessories!
This is an outrage to Hank Hill!
This is an outrage to Hank Hill!
'full_name' by mueschel https://www.openstreetmap.org/changeset/173275704
Changeset: 173275704
OpenStreetMap is a map of the world, created by people like you and free to use under an open license.
www.openstreetmap.org
October 14, 2025 at 1:31 PM
'full_name' by mueschel https://www.openstreetmap.org/changeset/173275704
Like, you see a video of the horse girls running all wearing normal clothes, nothing else happening... And then comes *full_name*.bsky.social comenting how that's weird and sexual and japanese people are degenerates or something. Simply because of 3D horse girls running.
Jesus, just chill out...
Jesus, just chill out...
July 13, 2025 at 6:30 PM
Like, you see a video of the horse girls running all wearing normal clothes, nothing else happening... And then comes *full_name*.bsky.social comenting how that's weird and sexual and japanese people are degenerates or something. Simply because of 3D horse girls running.
Jesus, just chill out...
Jesus, just chill out...