@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 also strongly recommend a good understanding of SQL before picking up either an ORM or query builder.
February 27, 2025 at 9:12 PM
I also strongly recommend a good understanding of SQL before picking up either an ORM or query builder.
Some mistakenly think they need an ORM when they really just want type safety and the ability to abstract over SQL without manual string concat. A query builder is more suitable in that case.
February 27, 2025 at 9:12 PM
Some mistakenly think they need an ORM when they really just want type safety and the ability to abstract over SQL without manual string concat. A query builder is more suitable in that case.
I think first it's worth exploring what you need an ORM for. When you can specify those needs you'll have an easier time picking tools because it's more obvious when they fulfill the needs (or not).
February 27, 2025 at 9:12 PM
I think first it's worth exploring what you need an ORM for. When you can specify those needs you'll have an easier time picking tools because it's more obvious when they fulfill the needs (or not).
Idk of any bsky client that will actually render any arbitrary html (which could be disastrous if the previous poster left an unclosed tag in their post, the entire feed would be broken..)
But I think there are some 3rd party clients experimenting with markdown support
But I think there are some 3rd party clients experimenting with markdown support
January 27, 2025 at 3:38 PM
Idk of any bsky client that will actually render any arbitrary html (which could be disastrous if the previous poster left an unclosed tag in their post, the entire feed would be broken..)
But I think there are some 3rd party clients experimenting with markdown support
But I think there are some 3rd party clients experimenting with markdown support
Learning HTML is the easy part
Making it look pretty with CSS is where it gets tricky
Making it look pretty with CSS is where it gets tricky
January 19, 2025 at 10:01 PM
Learning HTML is the easy part
Making it look pretty with CSS is where it gets tricky
Making it look pretty with CSS is where it gets tricky
I remember trying to make a 3D game [many, many] years ago and finding and running a template that I could start with was a nightmare.
January 18, 2025 at 6:29 PM
I remember trying to make a 3D game [many, many] years ago and finding and running a template that I could start with was a nightmare.
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
Building Postgres.garden has been helpful for building itself
The database parts at least (which aren't wired up to the frontend yet)
The database parts at least (which aren't wired up to the frontend yet)
January 17, 2025 at 11:53 PM
Building Postgres.garden has been helpful for building itself
The database parts at least (which aren't wired up to the frontend yet)
The database parts at least (which aren't wired up to the frontend yet)
I built postgres.garden
I don't think there's any possible way for it to work without JavaScript
I don't think there's any possible way for it to work without JavaScript
January 16, 2025 at 10:41 PM
I built postgres.garden
I don't think there's any possible way for it to work without JavaScript
I don't think there's any possible way for it to work without JavaScript
The preview window is also one of the selling points, for example I could add `--preview='ls -lt {}'` and it would list recent files from each folder when you select it.. which I might now have to add
January 16, 2025 at 6:14 AM
The preview window is also one of the selling points, for example I could add `--preview='ls -lt {}'` and it would list recent files from each folder when you select it.. which I might now have to add
For whatever it's worth the difference between the zsh tab-complete picker and the fzf version is that the fzf version narrows the list while you type
January 16, 2025 at 6:05 AM
For whatever it's worth the difference between the zsh tab-complete picker and the fzf version is that the fzf version narrows the list while you type
The Router component still works, I'm pretty sure?
January 16, 2025 at 12:56 AM
The Router component still works, I'm pretty sure?
What issues did you have migrating? I've migrated a few apps successfully (though they were pretty simple)
January 16, 2025 at 12:35 AM
What issues did you have migrating? I've migrated a few apps successfully (though they were pretty simple)
I just realized you need my `has` function to use this as-is, which is really just an alias for `command -v` to see if a command exists, but I'll leave it to the reader to remove or adapt as needed 😅
January 15, 2025 at 9:37 PM
I just realized you need my `has` function to use this as-is, which is really just an alias for `command -v` to see if a command exists, but I'll leave it to the reader to remove or adapt as needed 😅
I really like fzf a lot for these small quality of life improvements, to be able to take a static list from any program and make it interactive by picking lines and executing commands with the output
github.com/junegunn/fzf
github.com/junegunn/fzf
GitHub - junegunn/fzf: :cherry_blossom: A command-line fuzzy finder
:cherry_blossom: A command-line fuzzy finder. Contribute to junegunn/fzf development by creating an account on GitHub.
github.com
January 15, 2025 at 9:30 PM
I really like fzf a lot for these small quality of life improvements, to be able to take a static list from any program and make it interactive by picking lines and executing commands with the output
github.com/junegunn/fzf
github.com/junegunn/fzf
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
Not really, in my opinion
Much better case for bun over npm
Much better case for bun over npm
January 15, 2025 at 1:52 PM
Not really, in my opinion
Much better case for bun over npm
Much better case for bun over npm
I really liked lazyvim for how accessible it made getting going up and running
I ended up going back to my own config in the end it's a great jump off point
I ended up going back to my own config in the end it's a great jump off point
January 15, 2025 at 1:24 AM
I really liked lazyvim for how accessible it made getting going up and running
I ended up going back to my own config in the end it's a great jump off point
I ended up going back to my own config in the end it's a great jump off point
Would you be willing to share your shell script? I'd love to fork it for my own use
January 14, 2025 at 8:46 PM
Would you be willing to share your shell script? I'd love to fork it for my own use
You should attach a link to the article
January 14, 2025 at 4:53 PM
You should attach a link to the article
Yeah I'm definitely in that camp myself
I'm happy that it's made so much progress but I've yet to come across anything that's made a compelling case to give it another shot.. but maybe one day
I'm happy that it's made so much progress but I've yet to come across anything that's made a compelling case to give it another shot.. but maybe one day
January 14, 2025 at 3:36 AM
Yeah I'm definitely in that camp myself
I'm happy that it's made so much progress but I've yet to come across anything that's made a compelling case to give it another shot.. but maybe one day
I'm happy that it's made so much progress but I've yet to come across anything that's made a compelling case to give it another shot.. but maybe one day
It's one of those things that seems daunting and overwhelming until you do it and then you realize it's not so bad
January 14, 2025 at 3:23 AM
It's one of those things that seems daunting and overwhelming until you do it and then you realize it's not so bad
That's not quite true
It's a data serialization format that allows two disparate programs to share data, borrowing a subset of the syntax used in JavaScript
You could use nested arrays to structure the data, but that would be a choice not a requirement
It's a data serialization format that allows two disparate programs to share data, borrowing a subset of the syntax used in JavaScript
You could use nested arrays to structure the data, but that would be a choice not a requirement
January 13, 2025 at 8:01 PM
That's not quite true
It's a data serialization format that allows two disparate programs to share data, borrowing a subset of the syntax used in JavaScript
You could use nested arrays to structure the data, but that would be a choice not a requirement
It's a data serialization format that allows two disparate programs to share data, borrowing a subset of the syntax used in JavaScript
You could use nested arrays to structure the data, but that would be a choice not a requirement