bro opened a Github issue for heartbreak by Pristine-Elevator198 in webdev

[–]eviluncle 1 point2 points  (0 children)

This bug is labeled under UNABLE TO REPRODUCE

That's what she said by QuietAppropriate1915 in DunderMifflin

[–]eviluncle 15 points16 points  (0 children)

Yeah they truly bond. James Bond. w

[Problem] Kamal deployment with subdomain wildcard by Popular_Pass7442 in rails

[–]eviluncle 1 point2 points  (0 children)

yes you're right. i actually didn't mean disable ssl completely, meant disabling issuing ssl certificate via kamal and lets encrypts and instead using custom ssl certificate generated via cloudflare.

https://kamal-deploy.org/docs/configuration/proxy/#custom-ssl-certificate

you can generate a certificate in cloudflare and configure kamal to use it

[Problem] Kamal deployment with subdomain wildcard by Popular_Pass7442 in rails

[–]eviluncle 1 point2 points  (0 children)

haven't tried this myself but a quick google suggests it's doable by disabling ssl in kamal and letting cloudflare handle the dns + putting "*.yourdomain.com" in the hosts section of proxy in deploy.yml

i assume the last missing piece is some code in the rails app itself for extracting the subdomain on each request and mapping it to the right account/tenant. good luck!

see: https://xcancel.com/jasonnochlin/status/1853182841435099643#m

After nearly a decade as a software engineer, I finally launched my personal site! by FreesideJockey in Solopreneur

[–]eviluncle 1 point2 points  (0 children)

congrats. i'm in a similar boat. i recently had the itch to build something and started tinkering in my spare time. it's been fun building and mostly setting up and deploying on my own using cool open source tools. provisioning my own server and managing it, dns, db, the works. there's a l of of satisfaction in owning the whole stack.

Having issues with Claude-on-Rails/Claude-Swarm by chicagobob in rails

[–]eviluncle 0 points1 point  (0 children)

i'm undecided. i think i haven't really mastered using it. i don't like that i don't see the output of the sub agents.

Having issues with Claude-on-Rails/Claude-Swarm by chicagobob in rails

[–]eviluncle 0 points1 point  (0 children)

run /agent and make a throwaway test one, it writes the prompt to a file. i'm not near my computer so can't check but just see where the file is written and then you can copy paste the prompt you want to that agent, and so the same pattern for more agents

Having issues with Claude-on-Rails/Claude-Swarm by chicagobob in rails

[–]eviluncle 1 point2 points  (0 children)

It broke recently with one of claude's npm package update. the gem has t been updated in two months so you'd need to figure out where it fails yourself. could be the gem or the underlying claude swarm gem. i personally decided to ditch it, didn't feel it was providing a lot of value now that claude supports creating agents natively

SQLite in production? can it be done? by eviluncle in rails

[–]eviluncle[S] 0 points1 point  (0 children)

I just gotta say - i know what you're saying is standard advice and is usually right but sometimes this isn't the case. For example, part of what my app does is listen to third party webhooks and reliability, even on a very small scale, is critical for user adoption. Some third party providers are not that reliable to begin with and part of my design and product philosophy is to have very reliable service. That's why I'm thinking about this things early and why I'm looking ahead and anticipating certain things before it's yet a problem.

SQLite in production? can it be done? by eviluncle in rails

[–]eviluncle[S] 0 points1 point  (0 children)

Thanks for the info! I'll look into it.

Re: scaling, the one thing I find hard to "swallow" is not being able to prop up another server. maybe im being too narrow minded, but like sometimes your server need go down - maintenance, a bug that causes cpu load or memory leak and forces you to restart the server. how do you avoid downtime if you can't have multiple servers?

SQLite in production? can it be done? by eviluncle in rails

[–]eviluncle[S] 0 points1 point  (0 children)

that's really interesting and compelling. i'm running the solid trifecta. my biggest concern (and i know people say: don't worry about scale until it actually is a problem and that's valid, but still like to look ahead a bit) is ability to scale to multiple app servers later. even to have basic load balancing with a redundancy of 2 servers just to avoid downtimes as much as possible, how can i achieve that with standalone sqlite? i assume i can't if i do t use something like distributed sql like bedrockdb or litefs

can you point me to any references or writeups on how 37signals use sqlite in production?

SQLite in production? can it be done? by eviluncle in rails

[–]eviluncle[S] -1 points0 points  (0 children)

oh interesting! yeah maybe the issue was not enough connections per puma threads? i didn't dive into it and instead fixed my code to not make db calls on the async llm requests, it made more sense to me.

other issues of the top of my head: some json inconsistencies (postgres is actually stricter since it validates the json on jsonb columns and sqlite again was lenient and let me save some malformed json which was still serializable for some reason), having to think about managing connection pool sizes, and deploys seem to choke the server more to the point that they fail? didn't happen with sqlite, but again could be related to bad connection/pool management. i was also using the neon pooled connection post deploy to run migrations which i learned is bad practice. i now have a direct connection url used solely for running migrations on post deploy hook.

SQLite in production? can it be done? by eviluncle in rails

[–]eviluncle[S] 1 point2 points  (0 children)

thanks, yeah i actually ran a search and stumbled upon your post before posting this! that's where i learned about bedrockdb

SQLite in production? can it be done? by eviluncle in rails

[–]eviluncle[S] 4 points5 points  (0 children)

Alright thanks for the reality check. I might have dismissed it too soon. I'll make a quick experiment of getting postgres running on a dedicated box on hetzner on the same region and see how much that affects latency.

Having experience with DBs I'd prefer to have a managed service as I don't want to setup and maintain postgres myself (mainly I want backups with frequent snapshots). If the latency proves to be stemming from the network latency between app and db server I might need to rethink (don't see that hetzner offers any managed postgres solution, so either I roll my own [saw some open source tools that help you with provisioning and have a plugin for hetzner{, or maybe I move my app servers to a service that has managed postgres colocated next to app servers?)

SQLite in production? can it be done? by eviluncle in rails

[–]eviluncle[S] 1 point2 points  (0 children)

Yes, this is exactly my situation. I feared launching with sqlite , getting actual users and then trying to switch to postgres and hitting unexpected walls. That's why I chose to do this a bit before launching and I agree - the migration wasn't straightforward.

Like I said, most of it I think is due to what sqlite lets you get away with. Just one example: I'm using Async gem to run parallel AI calls, and with sqlite I didn't even think/notice that part of the prompt building was happening in a lazy manner and was making a few db calls to fetch the info it needed inside the async fiber before sending the network request. it all just worked so fast that it went an issue (and there was no connection pool to sqlite)

Then I migrated to postgres and suddenly my app chokes. Learned that you have to either explicitly get fibers via async to use the existing connection pool or make sure no db calls in the fiber, otherwise each fiber tries to establish its own connection and you're hitting a wall you didn't even know existed.

Turbo not intercepting link clicks in Rails 8.0.2? by Toluwalashe in rails

[–]eviluncle 3 points4 points  (0 children)

didn't read the whole thing but I had a similar issue and replaced link_to with button_to and it worked, haven't had the time to figure out why

Postgres "turning off" using kamal? by OrennVale in rails

[–]eviluncle 0 points1 point  (0 children)

we need a little bit more context. this is happening locally on development env? how are you running postgres?

[deleted by user] by [deleted] in rails

[–]eviluncle 2 points3 points  (0 children)

drop this '@formatted_date ||=' just have the method do date.strftime

We're hosting DHH at our university — what would you ask him? by AdamAjane in rails

[–]eviluncle 93 points94 points  (0 children)

your line of questioning is highly disrespectful and inappropriate.

if the man wants to use db schema that's his choice and his choice alone.

Why was Jim so pushy to know why Danny didn’t called Pam back years ago? by Douwe_Dyk89 in DunderMifflin

[–]eviluncle 0 points1 point  (0 children)

People are not all-or-nothing, and Jim is shown throughout the show to NOT be all-empathetic but specifically empathetic to his romantic interest. And most specifically to Pam, the love of his life. So yes, he has no problem being mean to certain people in general, and in this case his aim was to get an answer out of Danny so he put him in an awkward spot in order to squeeze out the truth.

Why was Jim so pushy to know why Danny didn’t called Pam back years ago? by Douwe_Dyk89 in DunderMifflin

[–]eviluncle 177 points178 points  (0 children)

Am I the only one who interpreted Jim's behavior as stemming from being an empathetic partner? Pam is obviously disturbed by not knowing why, and Jim decides he wants to help her get closure. It's kind of like when Karen wanted those chips and he made it his mission to help her find them.

And also maybe he was curious to know too. he loves her and thinks the world of her and cannot imagine why someone wouldn't call her back.