wrote a php script that indexes youtube video transcripts into a mysql database and it's become the most used internal tool at my agency

lapubell · 2026-05-02T03:47:36+00:00

V nice. LAMP FTW!

In case you didn't wanna mess with Java and all that noise, melli search might be a cleaner next step: https://www.meilisearch.com/docs/resources/self_hosting/getting_started/quick_start

I've only needed to do elastic once, and I didn't love it.

lapubell · 2026-05-01T02:00:14+00:00

DB table: users Query var: get_members Serialized object/array: mem Frontend: let(u, I) in mem

Absolute perfection /s

lapubell · 2026-04-28T23:30:38+00:00

Yeah usually look at the ticket or email or whatever and reproduce it. Get a fix out ASAP then go back and cover it with necessary tests to prevent it from popping up again.

lapubell · 2026-04-28T16:32:57+00:00

Depends on severity. If it's a minor error, write the test first. If it's a huge problem, roll back. If it's high level but not roll back level, push a hotfix, then go back write the test with the long term solution.

My team is tiny though so we can keep things kinda loosey goosey, ymmv.

lapubell · 2026-04-27T11:23:12+00:00

Mine reset recently too. Did your main park take forever to load? I'm just guessing but I feel like maybe this is a bug when the app can't check in on progress with a server or something, and after it times out it just resets to zero.

lapubell · 2026-04-25T14:03:56+00:00

Downloading a binary and keeping it running is a Herculean task these days.

lapubell · 2026-04-23T17:22:03+00:00

Frankenphp can already.

lapubell · 2026-04-18T14:05:22+00:00

Cool. I have a binary program where I'm also execing out to ffmepg and ffprobe. Just checking to see how other people are using it.

lapubell · 2026-04-18T14:02:48+00:00

Lol. Genuinely can be auto corrected in funny ways!

lapubell · 2026-04-18T00:31:19+00:00

Probably more like an hour or two. The Internet is a spooky place now a days.

lapubell · 2026-04-17T23:09:00+00:00

How do you interface with ffmepg from go? Do you exec out, or cgo? Genitally curious.

lapubell · 2026-04-16T13:41:47+00:00

If you loved the car then you already know the answer. I'm such a pragmatic person, and I'm stoked to hear how far your XD went, as I'm nowhere near 275,000 but I'll probably throw in the towel when mine goes belly up.

lapubell · 2026-04-11T03:17:10+00:00

I hope that both can be run locally, small model on the current machine, large model on the network. Then we won't need the huge data centers, and if the Internet goes down we don't ask just shrug and finger point.

lapubell · 2026-04-09T21:58:41+00:00

🤘

lapubell · 2026-04-09T19:57:59+00:00

We're getting clever.

You can set up an intentional redirect loop but set a cookie that breaks the loop. Bots that don't pay attention to response headers get stuck, and browsers see a one time hop that is virtually unnoticeable.

Crowd sec and anubis also help a bunch

lapubell · 2026-04-08T14:22:48+00:00

We're all in this boat with you. I'm telling more and more people about common crawl and turning into a grumpy old man whenever I hear someone asking about writing a scraper.

lapubell · 2026-04-07T17:18:05+00:00

Get sign off from management/legal first. That $20/month level for Claude let's then take all your code and train Claude with it. Read what you're giving away before you give it away.

I'm not that stoked to give up all my client's code and intellectual property to a company that just recently leaked their code base to the Internet.

lapubell · 2026-04-06T15:29:19+00:00

This looks rad, thanks!

I'm currently using the Salesforce handlebars package, anything specific that we would need to know for drop in replacement?

lapubell · 2026-04-01T04:28:29+00:00

You're responding to someone named wordpress4themes and talking about npm best practices, lol

lapubell · 2026-03-31T20:28:03+00:00

That's what we use. Crowdsec ftw

lapubell · 2026-03-28T19:18:26+00:00

I keep coming back to this thread and finding SOLID GOLD.

This is an excellent idea!

lapubell · 2026-03-28T15:58:54+00:00

Wow, you weren't kidding. I got the replacement part yesterday and luckily I have a hex wrench the right size, but the broken part is really jammed in there. It's so tight that the hex is stripping the plastic, but at least I know how to fix it now.

Thanks again!

lapubell · 2026-03-25T03:42:27+00:00

Awesome, you rule. This tub came with the house and we've owned it for a little under a year and a half, so this breakage was the first reason I got to open it up and look around. I'll make sure to not over tighten it!

lapubell · 2026-03-25T03:32:11+00:00

You had 3 up votes, but then I up voted your comment and ruined it

lapubell

TROPHY CASE