@dfg.codes
programmer
musician
currently building: https://postgres.garden
blog: https://dfg.codes
github: https://github.com/DanielFGray
musician
currently building: https://postgres.garden
blog: https://dfg.codes
github: https://github.com/DanielFGray
Pinned
dfg.codes
@dfg.codes
· Nov 21
I'm going to be posting here about projects I build
One of them is postgres.garden a browser-based #postgresql IDE built on vscode
It's all built with typescript, the backend is bun+Elysia
I have a bunch of plans for it and it's all on github.com/DanielFGray/Postgres-Playground
One of them is postgres.garden a browser-based #postgresql IDE built on vscode
It's all built with typescript, the backend is bun+Elysia
I have a bunch of plans for it and it's all on github.com/DanielFGray/Postgres-Playground
TIL in postgres you can omit columns from jsonb blobs by subtracting the column name from the blob
select
posts.*,
to_jsonb(user.*) - 'password' as user
from posts join users using user_id
select
posts.*,
to_jsonb(user.*) - 'password' as user
from posts join users using user_id
October 2, 2025 at 3:49 AM
TIL in postgres you can omit columns from jsonb blobs by subtracting the column name from the blob
select
posts.*,
to_jsonb(user.*) - 'password' as user
from posts join users using user_id
select
posts.*,
to_jsonb(user.*) - 'password' as user
from posts join users using user_id
I started dipping my toes into #gamedev this week, tinkering with Unity.
It's pretty wild how easy it is to get up and running with a 3D game now, today within 30 minutes I had a player that can move around and jump on things thanks to the Unity asset store
It's pretty wild how easy it is to get up and running with a 3D game now, today within 30 minutes I had a player that can move around and jump on things thanks to the Unity asset store
January 18, 2025 at 6:29 PM
I started dipping my toes into #gamedev this week, tinkering with Unity.
It's pretty wild how easy it is to get up and running with a 3D game now, today within 30 minutes I had a player that can move around and jump on things thanks to the Unity asset store
It's pretty wild how easy it is to get up and running with a 3D game now, today within 30 minutes I had a player that can move around and jump on things thanks to the Unity asset store
here's a bit from my #dotfiles using #fzf over the z directory picker for #zsh
this wraps github.com/agkozak/zsh-z to show an interactive list of directories you can jump to sorted by frecency (frequency+recently)
at least, if you dont give it any arguments, or it's bypassed to regular z
this wraps github.com/agkozak/zsh-z to show an interactive list of directories you can jump to sorted by frecency (frequency+recently)
at least, if you dont give it any arguments, or it's bypassed to regular z
![if has zshz; then
unalias z
function z {
local dir="$*"
if [[ -z $dir ]]; then
dir=$(
zshz |
sed "s|$HOME|~|" |
fzf --with-nth=2.. --tac |
awk '{print $2}'
)
fi
zshz "$dir" 2>&1
}
fi](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:euvnnrjnuk7dh3xayzboohbj/bafkreibhvgpswooztxfplfscjggbetrgej5piny7i3k6ncl472fuzu7qiy@jpeg)
January 15, 2025 at 9:13 PM
here's a bit from my #dotfiles using #fzf over the z directory picker for #zsh
this wraps github.com/agkozak/zsh-z to show an interactive list of directories you can jump to sorted by frecency (frequency+recently)
at least, if you dont give it any arguments, or it's bypassed to regular z
this wraps github.com/agkozak/zsh-z to show an interactive list of directories you can jump to sorted by frecency (frequency+recently)
at least, if you dont give it any arguments, or it's bypassed to regular z
Reposted
Working on a TypeScript+Postgres starter kit that comes batteries included with all the authentication bells and whistles:
Login with username/email and password
Oauth login with GitHub
Forgot/reset/change password management
Add/verify/delete multiple emails
What features am I missing?
Login with username/email and password
Oauth login with GitHub
Forgot/reset/change password management
Add/verify/delete multiple emails
What features am I missing?
GitHub - DanielFGray/node-pg-template
Contribute to DanielFGray/node-pg-template development by creating an account on GitHub.
github.com
December 8, 2024 at 2:39 AM
Working on a TypeScript+Postgres starter kit that comes batteries included with all the authentication bells and whistles:
Login with username/email and password
Oauth login with GitHub
Forgot/reset/change password management
Add/verify/delete multiple emails
What features am I missing?
Login with username/email and password
Oauth login with GitHub
Forgot/reset/change password management
Add/verify/delete multiple emails
What features am I missing?
Working on a TypeScript+Postgres starter kit that comes batteries included with all the authentication bells and whistles:
Login with username/email and password
Oauth login with GitHub
Forgot/reset/change password management
Add/verify/delete multiple emails
What features am I missing?
Login with username/email and password
Oauth login with GitHub
Forgot/reset/change password management
Add/verify/delete multiple emails
What features am I missing?
GitHub - DanielFGray/node-pg-template
Contribute to DanielFGray/node-pg-template development by creating an account on GitHub.
github.com
December 8, 2024 at 2:39 AM
Working on a TypeScript+Postgres starter kit that comes batteries included with all the authentication bells and whistles:
Login with username/email and password
Oauth login with GitHub
Forgot/reset/change password management
Add/verify/delete multiple emails
What features am I missing?
Login with username/email and password
Oauth login with GitHub
Forgot/reset/change password management
Add/verify/delete multiple emails
What features am I missing?
one of the reasons I love zsh is because I can do
< file.txt | less
< file.txt | less
November 23, 2024 at 4:24 PM
one of the reasons I love zsh is because I can do
< file.txt | less
< file.txt | less
working with a #database in #vim or #neovim can be tricky!
tpope's vim-dadbod plugin is great, you may also be using it with kristijanhusak/vim-dadbod-ui
but you there's one more piece that I think you need for these to actually be simple and easy to use:
1/
tpope's vim-dadbod plugin is great, you may also be using it with kristijanhusak/vim-dadbod-ui
but you there's one more piece that I think you need for these to actually be simple and easy to use:
1/
GitHub - tpope/vim-dotenv: dotenv.vim: Basic support for .env and Procfile
dotenv.vim: Basic support for .env and Procfile. Contribute to tpope/vim-dotenv development by creating an account on GitHub.
github.com
November 22, 2024 at 8:03 PM
I'm going to be posting here about projects I build
One of them is postgres.garden a browser-based #postgresql IDE built on vscode
It's all built with typescript, the backend is bun+Elysia
I have a bunch of plans for it and it's all on github.com/DanielFGray/Postgres-Playground
One of them is postgres.garden a browser-based #postgresql IDE built on vscode
It's all built with typescript, the backend is bun+Elysia
I have a bunch of plans for it and it's all on github.com/DanielFGray/Postgres-Playground
November 21, 2024 at 7:43 PM
I'm going to be posting here about projects I build
One of them is postgres.garden a browser-based #postgresql IDE built on vscode
It's all built with typescript, the backend is bun+Elysia
I have a bunch of plans for it and it's all on github.com/DanielFGray/Postgres-Playground
One of them is postgres.garden a browser-based #postgresql IDE built on vscode
It's all built with typescript, the backend is bun+Elysia
I have a bunch of plans for it and it's all on github.com/DanielFGray/Postgres-Playground
One of the features I'm most proud of in postgres.garden is the ERD diagrams that update when you run DDL commands
November 18, 2024 at 5:23 AM
One of the features I'm most proud of in postgres.garden is the ERD diagrams that update when you run DDL commands
Why do we feel the need to standardize on verbage?
I'm just going to call it reading the clouds in the Sky
and putting my thoughts into the Sky, y'alll can figure it out later
I'm just going to call it reading the clouds in the Sky
and putting my thoughts into the Sky, y'alll can figure it out later
I really love Bluesky, but I’m not crazy about calling posts here “skeets.” I just looked up the word, and skeet is apparently slang for ejaculation.
We can do better than that, folks! Since Elon coldly spurned the word “tweet” on X, I guess we could use that. Or maybe “blues”?
Any other ideas?
We can do better than that, folks! Since Elon coldly spurned the word “tweet” on X, I guess we could use that. Or maybe “blues”?
Any other ideas?
November 13, 2024 at 3:50 PM
Why do we feel the need to standardize on verbage?
I'm just going to call it reading the clouds in the Sky
and putting my thoughts into the Sky, y'alll can figure it out later
I'm just going to call it reading the clouds in the Sky
and putting my thoughts into the Sky, y'alll can figure it out later
Reposted
Made a tip sheet on "How to Bluesky"
Highlights: Mute, Block, Requiring Alt Text, Moderation lists, Labels, Badges, Feeds, Starter Packs, etc.
Hopefully it makes the experience of getting started here a little bit easier. Feedback welcomed.
docs.google.com/document/d/1...
Highlights: Mute, Block, Requiring Alt Text, Moderation lists, Labels, Badges, Feeds, Starter Packs, etc.
Hopefully it makes the experience of getting started here a little bit easier. Feedback welcomed.
docs.google.com/document/d/1...
How To Bluesky
How To Bluesky Ver 0.7 2025 Nov 05 By @ctsinclair.bsky.social Introduction Welcome to Bluesky! I am glad you are finding your way here. If you are used to Twitter (aka X), this is a brief guide to ...
docs.google.com
November 7, 2024 at 5:15 AM
Made a tip sheet on "How to Bluesky"
Highlights: Mute, Block, Requiring Alt Text, Moderation lists, Labels, Badges, Feeds, Starter Packs, etc.
Hopefully it makes the experience of getting started here a little bit easier. Feedback welcomed.
docs.google.com/document/d/1...
Highlights: Mute, Block, Requiring Alt Text, Moderation lists, Labels, Badges, Feeds, Starter Packs, etc.
Hopefully it makes the experience of getting started here a little bit easier. Feedback welcomed.
docs.google.com/document/d/1...
Reposted
if you’re new here please add your pronouns. follow @pronouns.adorable.mom and then like their post that matches your pronouns.
November 8, 2024 at 2:56 AM
if you’re new here please add your pronouns. follow @pronouns.adorable.mom and then like their post that matches your pronouns.
Reposted
Starting a thread of blocklists to share (feel free to reply with your favorites)
November 10, 2024 at 4:50 PM
Starting a thread of blocklists to share (feel free to reply with your favorites)
It's getting harder to tell how much is genuine vs bot driven on X and Threads
Looking forward to seeing how bsky moderation deals with gpt bots and state agents
Looking forward to seeing how bsky moderation deals with gpt bots and state agents
November 10, 2024 at 2:10 AM
It's getting harder to tell how much is genuine vs bot driven on X and Threads
Looking forward to seeing how bsky moderation deals with gpt bots and state agents
Looking forward to seeing how bsky moderation deals with gpt bots and state agents