Hacker News

Article URL: https://darekkay.com/blog/video-subtitles-closed-captions-audio-descriptions-transcripts/

Comments URL: https://news.ycombinator.com/item?id=42182445

Points: 1

# Comments: 0

Article URL: https://developer.arm.com/documentation/den0151/a

Comments URL: https://news.ycombinator.com/item?id=42182442

Points: 2

# Comments: 0

Hey HN, as an email marketer for the past 4 years, I’ve built sequences that reach millions of inboxes every month. But whenever I start a new project—or when a company reaches out for help—it was always almost back to square one: researching from scratch, especially when entering an unfamiliar industry.

Really Good Emails and similar resources are awesome, and I use some of them every now and then. But to me, they lack that strategic part of email marketing.

So, a couple of months ago, I started building a database of email sequences, which now has examples from 80+ companies and over 330+ categorized and sequenced emails. It’s designed to help non-marketers, solo founders, and busy teams create better email campaigns without starting from scratch.

I’d love to hear your thoughts or any suggestions for improvement. Thanks for taking a look!

Comments URL: https://news.ycombinator.com/item?id=42182432

Points: 6

# Comments: 2

Article URL: https://lnginnorthernbc.ca/2024/11/19/pf-seeks-5-for-alleged-plan-to-kill-lula-and-alckmin-at-the-end-of-2022/

Comments URL: https://news.ycombinator.com/item?id=42182417

Points: 1

# Comments: 0

Hi HN,

Today I wrote a simple tool to visualize the log probabilities of OpenAI GPT completions.

It's designed for debugging and understanding GPT's behavior by showing the probability of each candidates, with which you can know when GPT is hesitating and when it is confident of what it's talking about.

Basically it's a remake of the OpenAI Playground but with all the models and all the API parameters available.

I would recommend forking the repo and check the code before inputing your credentials if you do not trust the version hosted by others.

Thanks for checking it out!

Comments URL: https://news.ycombinator.com/item?id=42182409

Points: 1

# Comments: 1

Article URL: https://www.youtube.com/watch?v=wU4yPEFXzo0

Comments URL: https://news.ycombinator.com/item?id=42182407

Points: 1

# Comments: 0

Article URL: https://artofproblemsolving.com/blog/articles/avoid-the-calculus-trap

Comments URL: https://news.ycombinator.com/item?id=42182398

Points: 2

# Comments: 0

Article URL: https://chinesecookingdemystified.substack.com/p/63-chinese-cuisines-the-complete

Comments URL: https://news.ycombinator.com/item?id=42182384

Points: 1

# Comments: 0

As an applicant, I've personally had a mixed experience with take-homes. We're designing the technical interviews right now, and I thought I'd ask for some stories on exciting take-home tasks. We're looking for something that resembles the actual job, so we'll allow any tool (including AI and debuggers).

Also curious to hear about any bad ones you've done.

Comments URL: https://news.ycombinator.com/item?id=42182365

Points: 2

# Comments: 0

Article URL: https://www.youtube.com/watch?v=GZ5XN_mJE8Y

Comments URL: https://news.ycombinator.com/item?id=42182201

Points: 1

# Comments: 0

Article URL: https://www.theregister.com/2024/11/18/infosys_workaholic_founder/

Comments URL: https://news.ycombinator.com/item?id=42182184

Points: 2

# Comments: 0

Article URL: https://www.prisma.io/docs/orm/overview/introduction/should-you-use-prisma

Comments URL: https://news.ycombinator.com/item?id=42182162

Points: 3

# Comments: 0

Article URL: https://paragraph.xyz/@rm/from-identity-to-identifying

Comments URL: https://news.ycombinator.com/item?id=42182156

Points: 1

# Comments: 0

Article URL: https://twitter.com/eyeslasho/status/1857853402308337719

Comments URL: https://news.ycombinator.com/item?id=42182149

Points: 1

# Comments: 1

pglite-fusion is a PostgreSQL extension that allows you to embed SQLite databases into your PostgreSQL tables by enabling the creation of columns with the `SQLITE` type. This means every row in the table can have an embedded SQLite database.

In addition to the PostgreSQL `SQLITE` type, pglite-fusion provides the `query_sqlite`` function for querying SQLite databases and the `execute_sqlite` function for updating them. Additional functions are listed in the project’s README.

The pglite-fusion extension is written in Rust using the pgrx framework [1].

----

Implementation Details

The PostgreSQL `SQLITE` type is stored as a CBOR-encoded `Vec`. When a query is made, this `Vec` is written to a random file in the `/tmp` directory. SQLite then loads the file, performs the query, and returns the result as a table containing a single row with an array of JSON-encoded values.

The `execute_sqlite` function follows a similar process. However, instead of returning query results, it returns the contents of the SQLite file (stored in `/tmp`) as a new `SQLITE` instance.

[1] https://github.com/pgcentralfoundation/pgrx

Comments URL: https://news.ycombinator.com/item?id=42182146

Points: 1

# Comments: 0

Article URL: https://futo.org/blog/the_future_of_software_distribution/

Comments URL: https://news.ycombinator.com/item?id=42182138

Points: 1

# Comments: 0

Article URL: https://en.wikipedia.org/wiki/Bursera_graveolens

Comments URL: https://news.ycombinator.com/item?id=42182134

Points: 1

# Comments: 0

Article URL: https://www.bbc.com/news/articles/c1wj43vqdlpo

Comments URL: https://news.ycombinator.com/item?id=42182127

Points: 1

# Comments: 0

Article URL: https://offsec.tools/tool/reverse-shell-generator

Comments URL: https://news.ycombinator.com/item?id=42182116

Points: 1

# Comments: 0

Article URL: https://jennyjams.net/blog/cpp-mixin/

Comments URL: https://news.ycombinator.com/item?id=42182113

Points: 1

# Comments: 0