Vik Fearing

@makeupaguy.bsky.social

“I will do it tomorrow,” said Toad. “Today I will take life easy.”

Marquis Grissom followed immediately by Barry Bonds, 2003-07-07 San Francisco.

Virtual 6NF Decomposing any database into minimal elements

Exploring the 6th Normal Form. #SQL
minimalmodeling.substack.com/p/virtual-6nf

Even better: get it for free when taking a training course from the author @winand.at.

What went wrong?

🙀PostgreSQL 😼

Pelo menos eu to animada pra aprender SQL isso já é um salto

I counted them as four quincunxes and then removed the middle column that was counted twice. 🤷

separator?

Personally (reminder: I am a postgres person), I love the DROP IF EXISTS feature but I hate CREATE IF NOT EXISTS with a passion.

If the table I want to create has the same name as another table but an entirely different definition, my script is broken. I have no idea what the actual table is!

Love the T-shirt!

Cartoon by Maria Scrivan: Benefits of Books, with a graphic of a book and its benefits: no glare, no battery, dog ears, probably won't get stolen at the beach, smells good, no pop up ads

Why read books? Because books are still the most powerful, reliable, transportive & magical storytelling technology we've invented - and all they need to work is YOUR OWN IMAGINATION! #booksky

(Cartoon by @mariascrivan.bsky.social)

No.

Last I heard, plv8 is dying the death. #PostgreSQL

If this is an entry level job, where are the candidates supposed to get those 4+ years experience?

What’s the use case? #SQL

Writing the 4 basic SQL Queries 1. SELECT Say we have a simple table where we need to select certain cells (*** in the...

Writing the 4 basic SQL Queries https://cstu.io/7f88ac #india #love #python

It's all about using the right tool for the job.

#PostgreSQL is often the right tool.

I use SQL as a calculator all the time!

I actually quite like SQL.
Nice language to express things in.
Though how different versions of the same query will perform is mysterious

This gets easier in #PostgreSQL 18 since NOT NULL is an actual constraint, so no more need for the CHECK workaround.

The "SET NOT NULL" Downtime Trap in PostgreSQL It's necessary to validate existing data when trying to set a column to "not null." The validation...

The "SET NOT NULL" Downtime Trap in PostgreSQL dev.to/andrewpsy/th...

生SQLでこね回せば無理やり直せるんじゃね？

I know I would have a hard time transferring to MS SQL Server. Too much functionality is missing.

Please do not use Venn diagrams for joins. For example, show me the diagram for a cross join and tell me how it differs from a full outer join.

Venn diagrams are for sets, and joins are not sets.

Matrix.org Matrix, the open protocol for secure decentralised communications

How we discovered, and recovered from, Postgres corruption on the matrix.org homeserver matrix.org/blog/2025/07...

The fact that a good number of people who are semi literate in programming are afraid of SQL will never cease to amaze me.