Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
aarondf
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
25 ms
·
271.
▲
Adding a microservice to your monolith
(aaronfrancis.com)
3 points
by
aarondf
5y ago
|
0 comments
272.
▲
by
aarondf
5y ago
Where are the images stored in a setup like this?
273.
▲
by
aarondf
5y ago
More fun that the guy that asks what you do and then responds with "that sucks"!
274.
▲
by
aarondf
5y ago
That's kind of a mean thing to say. Maybe that's what your shrug meant?
275.
▲
by
aarondf
5y ago
I think one of the key things about Laravel is that the creator, Taylor Otwell, is only focused on Laravel. Imagine if DHH didn't ever have Basecamp (or 37 Signals) and only focused on Rails and the Rails ecosystem. The Laravel team no
276.
▲
by
aarondf
5y ago
Haha, hey Dave! In an even weirder twist of fate, I use your app (recut) to edit my other podcast!
277.
▲
Do things, tell people (2012)
(carl.flax.ie)
702 points
by
aarondf
5y ago
|
169 comments
278.
▲
Dice-O-Matic: Generating 1.3M dice rolls a day
(gamesbyemail.com)
2 points
by
aarondf
5y ago
|
0 comments
279.
▲
by
aarondf
5y ago
You're welcome! Thanks for reporting back.
280.
▲
by
aarondf
5y ago
When you use a cursor, the user has to pass a cursor back to the application to see the next page. So on the first page load, the server will send the records and a cursor that contains the info {'lastId': 32} and when the user
281.
▲
by
aarondf
5y ago
Usually a cursor holds some state about the last record shown to a user on a particular page. The next page should always start directly after the previous one, no matter how much time has elapsed. Most frameworks have some kind of cursor
282.
▲
Bitmasking in MySQL
(aaronfrancis.com)
1 points
by
aarondf
5y ago
|
0 comments
283.
▲
by
aarondf
5y ago
I actually agree completely with that!
284.
▲
by
aarondf
5y ago
Cursor based pagination has advantages. You can actually skip records for other pages and you won't miss or duplicate records between pages. But the drawback is you can't have directly addressable pages. So it's just a trad
285.
▲
by
aarondf
5y ago
For a little more context, from High Performance MySQL, 3rd Edition (2012) > This "deferred join" works because it lets the server examine as little data as possible in an index without accessing rows, and then, once the desi
286.
▲
by
aarondf
5y ago
It may not work in theory, but it works in practice! I also mention cursor pagination, but that's not always an option for every app.
287.
▲
by
aarondf
5y ago
I'm not sure if it's as much a bottleneck in Postgres as it is in MySQL, but I've just written a tome[1] on more effective offset/limit pagination by using something called a deferred join. The main problem with offset &
288.
▲
by
aarondf
5y ago
I use Google Photos and once a year I do a Google takeout to a hard drive and put that drive somewhere safe. I tweeted about this a while back and several people had good replies: https://twitter.com/aarondfrancis/statu
289.
▲
Efficient MySQL pagination using deferred joins
(aaronfrancis.com)
1 points
by
aarondf
5y ago
|
0 comments
290.
▲
Efficient Pagination Using Deferred Joins
(aaronfrancis.com)
70 points
by
aarondf
5y ago
|
32 comments
291.
▲
by
aarondf
5y ago
Very slick. Nice work! And y'all did this so quickly too
292.
▲
by
aarondf
5y ago
I saw that (thanks to this!) but I guess my question is why aren't more people freaking out about this? It seems like they should be.
293.
▲
by
aarondf
5y ago
How are you getting these results? I assume you're loading stuff from the EU and then doing some sort of tracing to see where it's being served from?
294.
▲
by
aarondf
5y ago
Um... Google analytics being ruled illegal seems like a pretty huge deal. How come we haven't heard more about this? Or have I just missed it?
295.
▲
by
aarondf
5y ago
The tweet poses the question and then links to this HN comment: https://news.ycombinator.com/item?id=29892950
296.
▲
If DHH focused on Rails exclusively, would it look more like Laravel?
(twitter.com)
1 points
by
aarondf
5y ago
|
1 comments
297.
▲
by
aarondf
5y ago
> Yeah, curiously, I think Laravel is just getting started in a way. That would be amazing. I agree, I think Taylor has good vision. His overriding principle seems to be "make people's lives easier," which makes for a pret
298.
▲
by
aarondf
5y ago
A lot of people here have mentioned Laravel. I think one of the key things about Laravel is that the creator, Taylor Otwell, is only focused on Laravel. Imagine if DHH didn't ever have Basecamp (or 37 Signals) and only focused on Rai
299.
▲
by
aarondf
5y ago
The code is also open source! https://github.com/christiangenco/wordlesolver
300.
▲
by
aarondf
5y ago
Whats the story with Progress Residential?
More ›