Jamie Gaskins

@jgaskins
9 Followers
119 Following
232 Posts
I build distributed systems and try to make life better for the folks around me.
Pronounshe/him/his
Jamie GaskinsNov 4, 2022
NolanApr 3, 2017
As you settle into Mastodon, be sure to learn the lingo:
- "toot": a tweet
- "tusking": starting a pointless fight with another user
- "woolly": going viral, as in "wow, that toot really went woolly"
- "extinction event": when a whole instance goes down
Show threadJamie GaskinsNov 4, 2022
I spun up a server @ https://zomglol.wtf that I might transfer over to. I'm still figuring out what I'd like to do.
zomglol

We’re all just trying to find a place to post the memes

Mastodon hosted on zomglol.wtf
Show threadJamie GaskinsNov 4, 2022
The performance of .social got much better (I saw 200ms per request last night) but this morning it's back to being almost 10 seconds to load my home timeline. 😕
Jamie GaskinsNov 1, 2022
I should try moving to a different Mastodon instance because .social gets *extremely* overloaded.
Jamie GaskinsOct 28, 2022
rstevens 🐳💨✅Oct 28, 2022
this is becoming a tradition
Jamie GaskinsJul 23, 2022
Elizafox, online friendJul 20, 2022
VLC has quit unexpectedly
Show threadJamie GaskinsMay 28, 2022

Found this out because I have an API that lets you do `where(key: value).update(key2: value2)`, but in SQL the WHERE clause comes *after* the SET clause.

With Postgres, this is fine because the numbers on the placeholders have meaning. Unfortunately with SQLite they don't so it just fails silently.

Show threadJamie GaskinsMay 28, 2022
TIL SQLite accepts Postgres-style prepared statements (with $1, $2, etc instead of ? placeholders), but it ignores the placeholder index. They'll be evaluated as if they were written in numerical order, even if they're not. So that's a thing. 😕
Show threadJamie GaskinsMay 23, 2022
I was considering using Redis w/ RedisJSON and RediSearch for this little project because I’ve built support for them into my Redis client (https://jgaskins.dev/redis/), but I’m gonna give SQLite a shot.
redis 0.4.0

Jamie GaskinsMay 23, 2022
I’ve always been dismissive toward SQLite but it turns out it’s a *lot* more powerful than I expected. Has support for JSON and full-text search w/ stemming. 🤯