I've used Knex, ActiveRecord and many other ORM's and query builders. At some point, beyond basic queries you start wasting time coming up with SQL statements and then having to convert them to your ORM/builder's syntax. I've reached the point now where it's just easier to stick with writing SQL and having a library that removes the possibility of sql injections. My current stack is postgres.js and dbmate for migrations.
Readit Newspoxrud commented on Writing Composable SQL Using Knex and Pipelines lackofimagination.org/202... · Posted by u/tie-in
poxrud commented on Hacking Kia: Remotely controlling cars with just a license plate samcurry.net/hacking-kia... · Posted by u/speckx
Yeah for some reason I find it so creepy that Kia ties your license plate number to your car's functionality. I don't know why but I feel like those two things should operate exclusively.
That is incorrect, as per the article Kia ties the VIN number to the car’s functionality. The author used a 3rd party service to convert the license plate number to VIN.
poxrud commented on Supabase Storage now supports the S3 protocol supabase.com/blog/s3-comp... · Posted by u/inian
Do you support S3 event notifications?
It’s hard to communicate about this stuff. I think people hear ‘tools’ and ‘function calling’ and assume it provides an actual suite of tools or pre-made routines that it calls upon on the Anthropic backend. But nope. It’s just a way of generating a structured schema from a prompt. It’s really crucial work, but just funny how obscured the boring truth is. Also FWIW I experience a tonne more schema adherence if I use XML-like semantic tags rather than JSON. XML is so much more forgiving a format too.
It’s much more than just generating structured schema. It also understands user intent and assigns the correct functions to solve a query. So for example if we give it two functions getWeather(city) and getTime(city) and ask “what’s the weather in New York?” It will decide on the correct function to use. It will also know to use both functions if we ask it “what’s the time and weather in New York?”.
ATSC is a North American modulation standard for transmission of Transport Streams over RF signals. Transport streams can carry any kind of a payload, including data. When the spec came out it was mandatory to use mpeg-2 for video encoding because that was the popular codec at the time. However there is nothing in the spec preventing broadcasters using other video/audio codecs (many already do). This is what this tv station did. You have approximately 19mbps of bandwidth to pack in as much payload in there as you can fit. ATSC3 brings about other features such as higher bandwidth, improved RF signals transmission efficiency (lower costs), error correction, etc…
IAM is complicated but it doesn’t have to be, as long as you keep things organized.
- Use AWS Organizations to organize your teams into Organizational Units
- use SCP to limit permissions of the OUs.
- let the OUs create new aws accounts for every project/workload
- now you have permissions and costs organized per project/workload
Don’t be afraid to create many AWS accounts, this is encouraged and considered best practice.
https://docs.aws.amazon.com/systems-manager/latest/userguide...
aws ssm start-session --target $instance-idThis is the best way to connect to your instances. However you still need the SSM agent installed and the right IAM permissions.
What are /22 and ASN?
It’s a way to represent a range of IP addresses. Using CIDR notation. https://en.wikipedia.org/wiki/Classless_Inter-Domain_Routing
OP is saying that they have control of 1022 public IP addresses.
The basic use case here of making videos and transcripts more accessible is super valuable. Are LLMs better than full text search though?
For many cases yes. With llm based embeddings you get “semantic search”, so for example if someone searches for “pets” they will most likely get results that include “dogs” and “cats”. This is not the case for regular text search.
Put ESC key there instead and vim becomes wayyyyyyyy more ergonomic.