Vik Fearing

vik.thegresqlpost.org

Member of the ISO/IEC working group for SQL. Performance is an implementation detail. HUGE fan of MLB and WFTDA, and pretty much not interested in any other sport. he/him by default; but will happily answer to anything.

Joined October 2023

Posts Replies Media Original posts Likes

Vik Fearing vik.thegresqlpost.org · 2h
BEGIN; ALTER TABLE responses ADD COLUMN filled_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT '-infinity'; ALTER TABLE responses ALTER COLUMN filled_at SET DEFAULT CURRENT_TIMESTAMP; COMMIT; #PostgreSQL duckrabbit.tech/articles/pg-...
Good enough ten-second sum types for Postgres — Duckrabbit Solutions

duckrabbit.tech

View on Bluesky Show all post labels

Reposted by Vik Fearing
aranyaadheu aranyaadheu.bsky.social · 7h
[Not loaded yet]

View on Bluesky Show all post labels

Vik Fearing vik.thegresqlpost.org · May 13
It’s farmers air gun season again, which is super great for people with #ptsd.

View on Bluesky Show all post labels

Reposted by Vik Fearing
pgDay Paris pgday.paris · May 13
[Not loaded yet]

View on Bluesky Show all post labels

Reposted by Vik Fearing
JA Westenberg joanwestenberg.com · May 11
[Not loaded yet]

View on Bluesky Show all post labels

Vik Fearing vik.thegresqlpost.org · May 11
When should one use “it isn’t” versus “it’s not”? Maybe @merriam-webster.com has an opinion?

View on Bluesky Show all post labels

Vik Fearing vik.thegresqlpost.org · May 9
I ate all of my cheese except for the @pavlocheese.com

View on Bluesky Download image Show all post labels

Reposted by Vik Fearing
Frog and Toad Bot frogandtoadbot.bsky.social · May 9
[Not loaded yet]

View on Bluesky Show all post labels

Reposted by Vik Fearing
Frog and Toad Bot frogandtoadbot.bsky.social · May 9
[Not loaded yet]

View on Bluesky Show all post labels

Reposted by Vik Fearing
Sean MacRae handle.invalid · May 8
[Not loaded yet]

View on Bluesky Show all post labels

Vik Fearing vik.thegresqlpost.org · May 7
I just got some spam with the subject "How to CRUSH your next SQL interview". #ChallengeAccepted

View on Bluesky Show all post labels

Vik Fearing vik.thegresqlpost.org · May 7
"Why asynchronous I/O matters" in #PostgreSQL 18, by Lukas Fittl. pganalyze.com/blog/postgre...
Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

Postgres 18 introduces Asynchronous I/O (AIO) that can dramatically improve read performance, especially in the cloud. Learn how these changes and the new io_method setting work and see why our benchm...

pganalyze.com

View on Bluesky Show all post labels

Vik Fearing vik.thegresqlpost.org · May 7
Who of my followers has advice for an SQL newbie?
- itsfreginjenni itsfreginjenni.bsky.social · May 7
  Starting to learn SQL tonight… what are your tips and tricks? #SQL
View on Bluesky Show all post labels

Reposted by Vik Fearing
itsfreginjenni itsfreginjenni.bsky.social · May 7
Starting to learn SQL tonight… what are your tips and tricks? #SQL

View on Bluesky Download image Show all post labels

Vik Fearing vik.thegresqlpost.org · May 7
MySQL specific, but still good general knowledge.
- undercode undercode.bsky.social · May 7
  Top 50 SQL Interview Questions with Answers Here are some of the most frequently asked SQL interview questions along with their solutions: SQL Query Examples: Fetch "FIRST_NAME" from Worker table with alias "WORKER_NAME": SELECT FIRST_NAME AS WORKER_NAME FROM Worker; 2. Fetch "FIRST_NAME" in…
  Top 50 SQL Interview Questions with Answers
  
  Here are some of the most frequently asked SQL interview questions along with their solutions: SQL Query Examples: Fetch "FIRST_NAME" from Worker table with alias "WORKER_NAME": SELECT FIRST_NAME AS WORKER_NAME FROM Worker; 2. Fetch "FIRST_NAME" in uppercase: SELECT UPPER(FIRST_NAME) FROM Worker; 3. Fetch unique DEPARTMENT values: SELECT DISTINCT DEPARTMENT FROM Worker; 4. Print first three characters of FIRST_NAME: SELECT SUBSTRING(FIRST_NAME, 1, 3) FROM Worker;
  
  undercodetesting.com
View on Bluesky Show all post labels

Vik Fearing vik.thegresqlpost.org · May 4
I just heard the best reason for top posting vs inline posting: In the olden days, one answered a letter with a letter. It is correspondence, not a chat. I still hate top posting.

View on Bluesky Show all post labels

Reposted by Vik Fearing
Frog and Toad Bot frogandtoadbot.bsky.social · May 3
[Not loaded yet]

View on Bluesky Show all post labels

Vik Fearing vik.thegresqlpost.org · May 3
Hi @1password.bsky.social, Is there a way to tell the Firefox plugin that I never want it to suggest saving credentials for a certain site? In this particular case, the site I never want 1password to remember is 127.0.0.1:8000

View on Bluesky Show all post labels

Reposted by Vik Fearing
European Commission ec.europa.eu · May 2
[Not loaded yet]

View on Bluesky Show all post labels

Vik Fearing vik.thegresqlpost.org · Apr 30
I am an #intropreneur.

View on Bluesky Show all post labels

Vik Fearing vik.thegresqlpost.org · Apr 30
Don’t forget to thank god for fixing Sam’s mum’s cataracts. @timminchin.bsky.social
- Based Sonic the Hedgehog sonic.bsky.social · Apr 30
  [Not loaded yet]
View on Bluesky Show all post labels

Reposted by Vik Fearing
Carl Sagan sagan.bsky.social · Apr 30
This is from The Tonight Show with Johnny Carson aired on May 20th, 1977. Carl Sagan says something very important, a strong message that didn't lose any validity since then.

View on Bluesky Download video Show all post labels

Vik Fearing vik.thegresqlpost.org · Apr 30
I'm thinking... what is the worst thing that could happen to me if I don't do the ättestup? I'm just going to skip the whole thing. #norsemen #ättestupa #RidiculousHRRequests

View on Bluesky Download image Show all post labels

Reposted by Vik Fearing
sqldaily sqldaily.bsky.social · Apr 28
[Not loaded yet]

View on Bluesky Show all post labels

Reposted by Vik Fearing
Frog and Toad Bot frogandtoadbot.bsky.social · Apr 26
[This post could not be retrieved]

View on Bluesky Show all post labels

Reposted by Vik Fearing
brian brian@famichiki.jp · Apr 25
[Not loaded yet]

View on Bluesky Show all post labels

Reposted by Vik Fearing
Gwen Shapira handle.invalid · Apr 24
[Not loaded yet]

View on Bluesky Show all post labels

Vik Fearing vik.thegresqlpost.org · Apr 23
And people argue when I say that Excel is a database. #SQL
- daveondata daveondata.bsky.social · Apr 23
  [Not loaded yet]
View on Bluesky Show all post labels

Vik Fearing

Good enough ten-second sum types for Postgres — Duckrabbit Solutions

Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

Top 50 SQL Interview Questions with Answers