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

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.

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

Learning HTML is the easy part
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.

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

Building Postgres.garden has been helpful for building itself
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

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

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)

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 😅

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.

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

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

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

Not really, in my opinion
Much better case for bun over npm

Have you considered MDX?

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

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

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

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

Clickbait title aside, having a different build tool for dev and prod has caused problems for many folks

Learn testing sooner, it'll save a lot of time

Intl.ListFormat - JavaScript | MDN The Intl.ListFormat object enables language-sensitive list formatting.

Does this not cover it?

developer.mozilla.org/en-US/docs/W...

A raspberry pi will not in any way help with a custom handle
You can host a PDS on it, but those are different things

Despite all the cutesy uwu shenanigans, Elysia really has the nicest API of any js/TS backed