Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
benoau
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
18 ms
·
481.
▲
by
benoau
11mo ago
A view is just a query that pretends to be a table, so it will come down to the complexity of that query. Each time you're querying the view it will be running the combination of the user's query against the view's query so
482.
▲
by
benoau
11mo ago
I think the main thing you're missing is creating an account in the DB that only has access to those views, so for each customer you'd do something like: CREATE USER customer_xyz WITH PASSWORD 'foo'; CREATE
483.
▲
by
benoau
11mo ago
YouTube assembled a catalog of virtually all music videos and recorded concerts that ever existed, I think anyone trying to do this today would spend all their time dealing with automated DMCA takedowns.
484.
▲
by
benoau
11mo ago
Possibly achieve that with some views or w/e the equivalent is in your database, and database accounts that can only access those views. Another option might be to let them ingest their data directly into the existing BI tools they use
485.
▲
by
benoau
11mo ago
I'd stick with SQL, they can pull queries straight out of ChatGPT if they don't know it themselves. If everyone lives within one database I'd throw up a per-customer read-only database in front of it for running their queries
486.
▲
by
benoau
11mo ago
I like to deploy automatically from pushes to dev, staging and main which are all gated by mandatory PR reviews, and any scripts run from Lambda which are gated by account access, so it's always a deliberate occurrence and only certain
487.
▲
by
benoau
11mo ago
The 'pain' comes from breaking changes, at worst if you delay you're going to ingest the same quantity of changes, and at best you might skip some short-lived ideas.
488.
▲
by
benoau
11mo ago
Or just 'npm ci' so you install exactly what's in your package-lock.json instead of the latest version bumps of those packages. This "automatic updating" is a big factor in why these attacks are working in the firs
489.
▲
by
benoau
11mo ago
The other notable thing is still waiting for M5 Max and M5 Ultra which should be a big performance increase and maybe more RAM per device, should be amazing for small clusters.
490.
▲
by
benoau
11mo ago
It's worse than that, someone else's models, someone else's smartphone operating systems, it's every conceivable disadvantage.
491.
▲
by
benoau
11mo ago
Exactly. And same for games for children that somehow don't detect pedophiles spending $100s and $1000s to lure children. And same for the platforms taking immense fees from Meta and such games that are suspiciously unaware of what
492.
▲
by
benoau
11mo ago
Is this also a React web application?
493.
▲
by
benoau
11mo ago
It's "based on WebKit" like English is based on Germanic languages.
494.
▲
by
benoau
11mo ago
Because if they're just an extension they're stuck with whatever rules Microsoft makes up, and Google is no stranger to using this leverage against others.
495.
▲
by
benoau
1y ago
This is low-key the most exciting part of Steam's announcements today IMHO, hopefully we're not far away from being able to use it on smartphones.
496.
▲
by
benoau
1y ago
You can also get a USB charger for them which is very convenient.
497.
▲
by
benoau
1y ago
It helps in preserving the access to the game but if you're not the original license-holder it becomes piracy which isn't really ideal for preserving it long-term.
498.
▲
by
benoau
1y ago
> I wonder how many games are impossible to preserve because of the copyright system and apathy on the part of rights-holders. Pretty much all of them. Your Steam licenses are forfeit when you die and your games and account are non-trans
499.
▲
by
benoau
1y ago
> How exactly would they come after you if your data is "outside of the UK's reach and jurisdiction"? By suspecting you of a crime first , then they can establish access to your device through legal due process and access
500.
▲
by
benoau
1y ago
> The reality is Valve often does a better job at preservation than GoG. They're solving very different problems: executing old games well that they still have the right to distribute vs reinstating access to games that have left ci
501.
▲
by
benoau
1y ago
Vantadark patterns.
502.
▲
by
benoau
1y ago
They can't police every online server you can possibly rent, and they can't police them "all at once" like they can with the Google/Apple duopoly, all they can do is go after them one-by-one as they need access an
503.
▲
by
benoau
1y ago
> But what do you think happens once you that gateway is blown open, isn't your front door next? Yes this is the way policing should work, if they think you have done something they knock on your door rather than go to Apple and G
504.
▲
by
benoau
1y ago
Sure but in this case most of the difficulties are artificially imposed by Apple, depending on how the tribunal responds to their alleged iCloud monopoly it could become as simple as choosing a compatible provider and putting your username&
505.
▲
by
benoau
1y ago
Allegedly it's deliberate, according to a pair of legal actions they face in the UK (hearing in 9 days) and US (hearing in August 2026). > 13.1 a set of technical restrictions and practices that prevent users of iOS from storing cer
506.
▲
by
benoau
1y ago
It's more likely to be a problem with Apple (and Google) because they have put themselves in a position where they are a gateway to everybody . There are multitudes of online storage providers outside of the UK's reach and juris
507.
▲
by
benoau
1y ago
Hopefully pretty soon Apple will have to provide the same functionality iCloud monopolizes so you can have an equivalent service. But right now you can do an encrypted transmission to a privately-owned NAS like Synology and then E2E clou
508.
▲
by
benoau
1y ago
Reminds of the thought experiment, "if a tree falls in a forest and no one is around to hear it, does it make a sound?"... People you never heard of are open-sourcing projects you'll never find every day, there are hundreds o
509.
▲
by
benoau
1y ago
Those other smart TV companies write shit software that performs terribly on bad hardware and may have ads - YMMV but that's not really "worse" than Apple's anti-steering clauses concealing massive fees on ATV apps like
510.
▲
by
benoau
1y ago
> Meta is claiming that some of its employees are downloading and possibly masturbating to porn at work. Who doesn't amass vast archives of pornography on their work computers and networks...
More ›