Chris J Keen

React, GraphQL, Unit Tests, and Chrome Experiments are a few of my favorite things. I love all things front-end, especially making them faster and prettier.

[Chris J Keen @zedd45]

“The corollary of constant change is ignorance. This is not often talked about: we computer experts...” https://t.co/UsliEW4C0t

[impulsive @weezerOSINT]

meta gave their AI support agent the ability to modify your instagram account. no identity verification. people figured this out and accounts are being taken over right now

[Chris J Keen @zedd45]

🤣

[It's All Coming Together @All2getherNow]

Plenty of PERM market tests from Uber in the Bay area in last Sunday's print version of the Mercury News. Unfortunately 5 of the 13 apply links redirect you to a 404 page. Is this a good-faith effort to hire an American?

Sr Technical Program Manager $264,514 – $317,417 https://t.co/EeWbbTMXZs (page not found)

Software Engineer (BI) $264,514 – $317,417 https://t.co/uMIZSIIQnr (page not found)

Sr Software Engineer (Android Maps) $264,514 – $317,417 https://t.co/mxAQWp9yzn (page not found)

Software Engineer $189,000 – $204,000 https://t.co/Of4dI8s1VZ (page not found)

Software Engineer $226,138 – $271,356 https://t.co/MEGcKswod4

Manager, Engineering $388,918 – $466,702 https://t.co/WyNHcqdmfO

Manager II, Engineering $388,918 – $466,702 https://t.co/nRs2a9vKWp

Software Engineer $187,741 – $225,289 https://t.co/NTeIphkgzO (page not found)

Software Engineer $187,741 – $225,289 https://t.co/8HemjDltyY

Software Engineer $232,000 – $284,000 https://t.co/LNVCqpdAjf

Software Engineer $232,000 – $284,000 https://t.co/eHh2JdGNJj

Software Engineer I $150,000 – $166,000 https://t.co/mPfXKBiC7d

Sr Software Engineer (Advertising) $264,514 – $317,417 https://t.co/gstCQ2oglA

[Mark Gadala-Maria @markgadala]

This is why 64GB of RAM is $1000

https://t.co/2dwc0K20Pd

[lynk @lynk0x]

"I'm a crypto investor"

[Rothmus 🏴 @Rothmus]

God I hate this.

[Aɴᴛ @AntSpeaks]

British comedian Pat Smith brilliantly points out the hypocrisy surrounding the subject of mass migration in the UK.

[sachin. @sachinyadav699]

Hard times create strong men.
Strong men create C.
C creates good times.
Good times create Python programmers.
Python programmers create AI.
AI creates vibe coders.
Vibe coders create weak men.
Weak men create hard times.

[Dudley Newright @NewRightPoast]

https://t.co/wOPxZBvPgK

[Sassafrass84 @Sassafrass_84]

He got quiet real quick. Lol

[RogueCmdr | 🇺🇸 (US) @RogueCmdr]

@ScottAdamsSays

[Avi Chawla @_avichawla]

Big moment for Postgres!

AI coding tools have been surprisingly bad at writing Postgres code.

Not because the models are dumb, but because of how they learned SQL in the first place.

LLMs are trained on the internet, which is full of outdated Stack Overflow answers and quick-fix tutorials.

So when you ask an AI to generate a schema, it gives you something that technically runs but misses decades of Postgres evolution, like:

- No GENERATED ALWAYS AS IDENTITY (added in PG10)
- No expression or partial indexes
- No NULLS NOT DISTINCT (PG15)
- Missing CHECK constraints and proper foreign keys
- Generic naming that tells you nothing

But this is actually a solvable problem.

You can teach AI tools to write better Postgres by giving them access to the right documentation at inference time.

This exact solution is actually implemented in the newly released pg-aiguide by @TigerDatabase, which is an open-source MCP server that provides coding tools access to 35 years of Postgres expertise.

In a gist, the MCP server enables:

- Semantic search over the official PostgreSQL manual (version-aware, so it knows PG14 vs PG17 differences)
- Curated skills with opinionated best practices for schema design, indexing, and constraints.

I ran an experiment with Claude Code to see how well this works, and worked with the team to put this together.

Prompt: "Generate a schema for an e-commerce site twice, one with the MCP server disabled, one with it enabled. Finally, run an assessment to compare the generated schemas."

The run with the MCP server led to:

- 420% more indexes (including partial and expression indexes)
- 235% more constraints
- 60% more tables (proper normalization)
- 11 automation functions and triggers
- Modern PG17 patterns throughout

The MCP-assisted schema had proper data integrity, performance optimizations baked in, and followed naming conventions that actually make sense in production.

pg-aiguide works with Claude Code, Cursor, VS Code, and any MCP-compatible tool.

It's free and fully open source.

I have shared the repo in the replies!

[TONY™ @TONYxTWO]

“Government shuts down… and suddenly the 90s-style clouds from my childhood are back?

Coincidence? I think not. 👀”

[Amiri King @AmiriKing]

One of the most hard hitting videos you’ll ever see in your entire life. 🫡

[The Babylon Bee @TheBabylonBee]

Liberal Goes Back In Time To Kill Hitler

[Political Alchemist @PoliAlchemist]

@EdKrassen The voices on the Left who have been the bullhorn behind the battering ram are terrified now of what they have unleashed from a silent Right just trying to live their lives in peace with a bunch of unhinged lunatics who refused to let them.

[Political Alchemist @PoliAlchemist]

@___glove___ @RX4o0 @ianmiles Self-control, discipline, morals, courtesy. None of these cost a money to teach, learn, or apply to one's self.

[Steven Steele @MrStevenSteele]

@tylenol @Jen_in_TX Truly dizzying.

[ꪻꫝể ꪻꫝể @TheThe1776]

Wow! Watch this conformity experiment. Actors stand on a beep, pressuring an unwitting woman to follow. Alone, she continues, then influences newcomers. This shows how senseless rules spread like viruses. Think critically, don't be a sheep.

[Massimo @Rainmaker1973]

Redheads Festival, held annually in Ireland and the Netherlands.