Shane da Silva pfp

Shane da Silva

@sds

538 Following
32944 Followers
Ashoat pfp
Ashoat
@ashoat.eth
Warpcast on mobile now auto-saves cast drafts! so if the app crashes, or eg. you open a notif and it navigates away from the cast composer, your draft should be preserved
5 replies
10 recasts
43 reactions
Shane da Silva pfp
Shane da Silva
@sds
They are getting more developer contributions now, so seems like a win. They also explain that the LOC increase is due to the formatter they were using. Some of the ported code was also a straight up translation rather than idiomatic Rust.
0 reply
0 recast
0 reaction
Shane da Silva pfp
Shane da Silva
@sds
This is why I’m super interested in the outcome of pg-nano. If defining+maintaining stored procedures can be done in aan ergonomic way, I think we’ll start to see more folks using them. https://warpcast.com/sds/0x8a761ddc
1 reply
0 recast
1 reaction
Shane da Silva pfp
Shane da Silva
@sds
Having looked into this long ago, my best summary is because of the overhead of storing tuple metadata for _each row_. It feels like it could have been avoided, but I suppose the implementation has not yet been optimized. That said, being able to define your own operator overloads (e.g. to error if you accidentally try to sum two currencies of differing denominations together) might be worth the storage cost for sake of DevEx.
1 reply
0 recast
1 reaction
Shane da Silva pfp
Shane da Silva
@sds
At a high level, my understanding is it allows you to execute code “closer” to your data. You get: - Query plan caching (database wide, not per connection like prepared statements) - Sessions don’t “pin” to a specific connection (unlike prepared statements), so it can work well with tools like PgBouncer - Fewer round trips (assuming your logic can’t be expressed as a single SQL statement, e.g. entirely different subqueries are executed depending on a condition) Similar reasons you might opt to use server-side Lua scripts with Redis. But yes, observability tooling isn’t as mature. You could write your routines in JavaScript/Rust/etc, but you lose query plan caching, which is a significant.
0 reply
0 recast
1 reaction
Shane da Silva pfp
Shane da Silva
@sds
I don’t typically execute shell commands from within vim—I would just open a separate tmux pane, which feels more natural to me. So I’m not the best person to ask about the shell integration quirks, if any.
0 reply
0 recast
0 reaction
Shane da Silva pfp
Shane da Silva
@sds
If you haven't already, it'll blow your mind when you see how large composite types are to store. It's baffling, especially when you consider how nice it would be to represent a currency as a composite type (value + denomination). You're better off just having two columns instead.
1 reply
0 recast
0 reaction
Shane da Silva pfp
Shane da Silva
@sds
Using stored procedures for complex query patterns makes sense, but I don't have an intuition for the kind of query complexity necessary before seeing tangible benefits switching from prepared statements. Glad someone is experimenting! https://github.com/pg-nano/pg-nano/
1 reply
55 recasts
129 reactions
Shane da Silva pfp
Shane da Silva
@sds
Fish just released their rewrite in Rust! A Herculean effort—very impressive. https://fishshell.com/blog/rustport/
3 replies
59 recasts
183 reactions
Shane da Silva pfp
Shane da Silva
@sds
That was fast
0 reply
0 recast
1 reaction
Shane da Silva pfp
Shane da Silva
@sds
Mine looks quite similar. Excited for you to get citizenship! (I still have to wait a couple more years)
0 reply
0 recast
0 reaction
Shane da Silva pfp
Shane da Silva
@sds
We've officially crossed the Rubicon.
0 reply
0 recast
0 reaction
Shane da Silva pfp
Shane da Silva
@sds
All the credit goes to @deodad and @horsefacts.eth who have been grinding to get this in developers' hands.
1 reply
0 recast
2 reactions
Shane da Silva pfp
Shane da Silva
@sds
That album is a masterpiece
0 reply
0 recast
1 reaction
Shane da Silva pfp
Shane da Silva
@sds
Good hostname
0 reply
0 recast
1 reaction
Shane da Silva pfp
Shane da Silva
@sds
Very cool. Would this work with orgs using SSO or passkeys for with? Not immediately clear from the docs but I likely missed something:
1 reply
0 recast
0 reaction
Shane da Silva pfp
Shane da Silva
@sds
It is very small/simple. Most of the project is just boilerplate for distribution via Homebrew or the curl+bash installer.
0 reply
0 recast
0 reaction
Shane da Silva pfp
Shane da Silva
@sds
We've released a simple tool for those running on AWS: https://github.com/warpcast/awsh The Snapchain team has been running a number performance tests to identify and eliminate bottlenecks in the Rust implementation. These tests run in our AWS environment because of the quick setup+teardown convenience. However, connecting to these instances and dealing with SSH keys in a security-conscious way has always been a pain, along with managing host key verification of a constantly revolving list of reused IP addresses. Why not get rid of the need for SSH client keys + host keys entirely? AWS EC2 Instance Connect has the tooling, but it doesn't work like the ssh executable does so it feels clumsy. We've merged the tools with a simple script to make it easy to hop on boxes in your environment.
2 replies
21 recasts
123 reactions
Shane da Silva pfp
Shane da Silva
@sds
I'm running an M4 Max (so perhaps not the best anecdata) but the load time is not discernible for me. It feels fast.
0 reply
0 recast
0 reaction
Shane da Silva pfp
Shane da Silva
@sds
Thanks for the detail! Always great to get the perspective of a convert. I definitely see the appeal for certain use cases—these videos will be a helpful way to get further acquainted.
0 reply
0 recast
1 reaction