aarondf

19 ms·

211.
by aarondf 4y ago
Given that Heroku is killing their free tier because of "fraud and abuse" I'm pretty ok with Fly requiring a CC for their free tier. Requiring a legit CC has to cut that by a substantial amount, I'd think.
212.
by aarondf 4y ago
Fly.io has a dedicated process for moving off of Heroku. Auth via Heroku and they'll launch your app onto Fly. They also have a free tier. The process: https://fly.io/launch/heroku The docs: https://fly
213.
by aarondf 4y ago
I have tried it and found it to be really really good. It's a little more DIY than Heroku, but not by too much. They are moving really fast too, hiring people to focus on specific use cases (Laravel, Rails, etc.) If you're making
214.
Twitter is overrun by lookalike threads(twitter.com)
3 points by aarondf 4y ago|0 comments
215.
MySQL's count(*) is optimized to be fast(aaronfrancis.com)
2 points by aarondf 4y ago|0 comments
216.
by aarondf 4y ago
Hey this is a great explanation. Most people just say "this makes no sense, can never work"
217.
by aarondf 4y ago
There are ways to mitigate the (although not eliminate) the slowing down of offset/limit pagination in later pages. The technique is called a "deferred join" and it is most effective in MySQL. The basic idea is to paginate as
218.
by aarondf 4y ago
Mmm yeah, that's clever! I like it. I think for my package (the Laravel one) I'll have to hold off on that because CTEs only work with MySQL 8.0 and up. Also the Laravel query builder doesn't have methods to add CTEs, unfortu
219.
by aarondf 4y ago
Not sure what you mean by simple pagination. If you mean simple as in "only shows prev/next links" then no, it shows knows the count of pages. It supports length aware and simple.
220.
by aarondf 4y ago
Yeah that's a bit confusing. The deferred join in the book does indeed use an inner join but my package (and PlanetScale's) both use a "deconstructed subquery." I made that choice for mine because I didn't want to p
221.
by aarondf 4y ago
MySQL often doesn't support limit in subqueries, hence the roundtrip. > ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' See https://dev.m
222.
by aarondf 4y ago
For those interested in the performance of this deferred join technique, here are some real results from the Laravel package: - https://twitter.com/mdavis1982/status/1482429071288066054 - https://twitte
223.
by aarondf 4y ago
The PlanetScale team puts out incredible engineering content. Congrats on the release! If you're using Laravel, there's a package that you can use to achieve the same effect: https://github.com/hammerstonedev/
224.
Breaking Apart the maintainer Monolith (By Swyx)(github.com)
15 points by aarondf 4y ago|1 comments
225.
Count(*) vs. COUNT(id) in MySQL(aaronfrancis.com)
6 points by aarondf 4y ago|1 comments
226.
Marketing for Maintainers(github.blog)
1 points by aarondf 4y ago|0 comments
227.
by aarondf 4y ago
Correct, no API gateway. > Not sure how useful this is since that is the entry point for all the lambda functions. Well that's just not accurate! You can also call them via API. Which is what Sidecar does. > I just don't see
228.
by aarondf 4y ago
> IMHO, AWS Chalice remains the goto method to generate REST API serverless manner Sidecar (my library) provides no REST API. You just... call the function from PHP. So you'd call it like <?php MyNeatServerlessFunctio
229.
by aarondf 4y ago
I wrote a library [1] for Laravel that lets you put a kind of "microservice" inside of your monolith. It lets you develop, deploy, and execute AWS Lambda functions from your Laravel application. The theory here is that sometimes
230.
Faster offset / limit pagination for Laravel(github.com)
1 points by aarondf 4y ago|0 comments
231.
Send an OSS dev on an all-expenses paid vacation(twitter.com)
2 points by aarondf 4y ago|0 comments
232.
by aarondf 4y ago
Seconded! Alex DeBrie is a great teacher.
233.
by aarondf 4y ago
Possibly because the Twitter website loads, but all the requests to get the actual data are failing. I wonder if Down for Everyone views that as a 200 and moves along
234.
Be Kind (2015)(boz.com)
1 points by aarondf 4y ago|0 comments
235.
Amazon Web Services in Plain English(expeditedsecurity.com)
3 points by aarondf 4y ago|0 comments
236.
by aarondf 4y ago
I think the first mention of the concept was on a podcast called TechZing. The author later wrote it down on his blog (referenced in the article) https://www.codusoperandi.com/posts/increasing-your-luck-sur...
237.
by aarondf 4y ago
I often listen to the same song on repeat for days in a row during periods of intense work. Usually "Djohariah" by Sufjan Stevens. It helps that it's like 17 minutes long. But I also listen to "Saturn" by the same a
238.
by aarondf 4y ago
I was careful not to say that this is a surefire path to success. My whole point is that publishing increases your odds. If you're writing blogs, streaming, posting videos, and publishing software my position is that you have a better
239.
by aarondf 4y ago
Haha np I read your original comment in a lighthearted way! And thank you, I love working in here :D
240.
by aarondf 4y ago
(Author here) The path I took was to write libraries for a large ecosystem (Laravel) to solve gnarly problems I was having. The gnarlier the better. Pick the thing that nobody else wants to do and solve it. That's what I did, no guaran

More ›