Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
aidos
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
65 ms
·
721.
▲
by
aidos
6y ago
We’re going through the transition at the moment - tried to find info online but decided the only route was to try it on a real machine to see what works / doesn’t work. Have built an Ubuntu 18 environment running through UTM ( https:&
722.
▲
by
aidos
6y ago
If you use iPython you can enable auto reloading for all your sessions. It works really well - I've been using it for years. You need to know the limitations, but on the whole it give huge performance gains when I'm coding. To ena
723.
▲
by
aidos
6y ago
That approach works well for regressions. I’ve used it myself to track down a bug in chrome and, as you say, having no idea how to fix it, I could direct it to the author via the bug tracker. In my case it was fixed within a couple of days.
724.
▲
by
aidos
6y ago
Ha, snap. Makes sense that it looks at the dirtiness of the visibility_map while planning.
725.
▲
by
aidos
6y ago
I believe it can speed it up by using index only scans along with the visibility_map which effectively tells it which entries are “current” in more broad strokes.
726.
▲
by
aidos
6y ago
The default limit on Postgres is 100, so you need to ask yourself why you’re exhausting all those connections. The issue isn’t the dB, it’s the code making the connections. Advice: don’t fret scaling issues, get your fundamentals right
727.
▲
by
aidos
6y ago
You can shift/cmd select a few pages and drop them out into finder as a new pdf too.
728.
▲
by
aidos
6y ago
In isolation, maybe it doesn’t, but reading through the comment history, the site will be better without these contributions.
729.
▲
by
aidos
6y ago
I’ve seen a few data disasters in my time but I think this takes the cake. It’s a good reminder of why you just need to prioritise the sort of work that has no immediate payoff.
730.
▲
by
aidos
6y ago
Sql queries never really adhere to that simple Big O analysis though. Sure, if you had zero indexes so every operation was nested sequential scans, then it’s Cartesian, but that’s never the case. Most often you get really fast index lookups
731.
▲
by
aidos
6y ago
Looks like it’s Postgres protocol compatible rather than running as a Postgres extension? I’ve been keeping an eye on work that’s been done to support this internally in Postgres. Looks like it’s still moving along. I guess it’s a pretty tr
732.
▲
by
aidos
6y ago
Could be that there’s some tell tale in the logs. We recently fixed a bug with incomplete requests by noticing in nginx logs that the size of the headers + the size of the body was the size of the buffer of a linux socket.
733.
▲
by
aidos
6y ago
The Bowline is definitely the only knot to learn if you have to choose just one. There are 3 (that I know of) different ways to tie it that are worth learning as a next step. One of them lets you prepare it so you can quickly tie it around
734.
▲
by
aidos
6y ago
I love this website. Having spent a bit of time on yachts I already had a reasonable grounding, but it’s easy to forget knots you’re not using. For a while I found the easiest way to get to sleep each night was to try to picture how to tie
735.
▲
by
aidos
6y ago
When you’re doing dynamic structure in relational dbs (traditionally) options include storing a wide row with all the data types and you choose which column to use, or storing as lowest common denominator (string) and casting in and out at
736.
▲
by
aidos
6y ago
I think we can both agree on that. People have reacted somewhat negatively to my original comment, but I suspect cookie banners have done more harm than good on balance. It’s one of those things where the spirit of the movement got lost. We
737.
▲
by
aidos
6y ago
I'm totally good with there being laws about this as I too want to see less tracking and data sharing. But the implementation is terrible and anybody who thinks that it's fixed anything at all is just kidding themselves. I would r
738.
▲
by
aidos
6y ago
Ha! Following your analogy ... then you just discover that everyone’s teeth are purple and you’re struggling to concentrate on what they’re saying because it’s distracting. Meanwhile, nobody’s teeth got any cleaner. It’s really just theatre
739.
▲
by
aidos
6y ago
Not that I voted for this, but what’s done is done. And now that it is, I’d personally like to take the wins where we can get them. Hoping we see the light, and the blight that is the cookie law goes the way of the dodos.
740.
▲
by
aidos
6y ago
The limitation with inline styles is that the moment you need a single variation (hover, responsive, dark mode) you’re forced to move the styles somewhere else. Tailwind solves that, and a bunch of other stuff.
741.
▲
by
aidos
6y ago
You can use their classes to build other class, yes.
742.
▲
by
aidos
6y ago
They had a fire.
743.
▲
by
aidos
6y ago
Still not sure I buy it. I can extract a document representation from my relational data that matches your document store at read time. I can effectively choose my schema when I read, there’s no need to rewrite it at the storage layer.
744.
▲
by
aidos
6y ago
That’s stored ptocedures you’re talking about - I think. We’re talking about prepared statements.
745.
▲
by
aidos
6y ago
Can you explain this more? I’d argue that if you don’t know the patterns you’ll use to access your data, relational is the way to go. That’s the point, no? Flexibility over how you access your data. With an object store you mostly have to h
746.
▲
by
aidos
6y ago
I was involved in those original discussions and it was just the standard “how to manipulate sql” discussion. Prepared statements don’t help you here, right? My understanding is that they’re purely for performance as the parser doesn’t need
747.
▲
by
aidos
6y ago
I’ve used it by running it memory from python as a temporary dB. In my case it was just for simple bounds checking queries but it worked incredibly well. I’m not sure about trying to get 30fps out of it though - might be a stretch!
748.
▲
by
aidos
6y ago
It’s the first Mac in years that’s got me wanting to replace my 2015 MacBook. Does anyone have experience of Pro vs Air as a dev machine. I’m assuming the pro is an around better machine, but that touchbar....
749.
▲
by
aidos
6y ago
Countfire | Senior or Mid-level Frontend Developer | Remote (London, UK) | www.countfire.com Countfire makes software for the construction industry. Our software is well loved because we try to design solutions that are a magnitude more eff
750.
▲
by
aidos
6y ago
Yeah it’s a real problem for the industry. Revit has become this “standard” but its totally closed without running their systems. Something really needs to give.
More ›