Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
batou
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
13 ms
·
91.
▲
by
batou
11y ago
Certainly not an anedote. I was an Oracle and SQL Server DBA for a number of years amongst other hats on stupid big datasets and loads. Add to that 25 years' experience getting companies out of deep trouble that everyone else has given
92.
▲
by
batou
11y ago
Yes. It's probably why I play a synthesizer. It's like, excuse the analogy, a giant audio dildo. Korg M3: https://www.youtube.com/watch?v=oeUN0W3WI0o (this is not me, I'm nowhere near this) Edit: further thou
93.
▲
by
batou
11y ago
I conceed. Some good points there.
94.
▲
by
batou
11y ago
Stateful: If I have to load the stored procedure into the persistence engine then that step is required. This is no more stateful than queries in the application but it means that the relevant state in both the application and the database
95.
▲
by
batou
11y ago
Yes that's true as well. JIRA does that in some configurations. Does my head in.
96.
▲
by
batou
11y ago
Definitely. Which is why we still use one. It's cheap, already there and does the job.
97.
▲
by
batou
11y ago
I think it's quite simple really. Sure it's a bit ugly but most APIs are behind the scenes. As long as the API itself is clean, that's not necessarily a problem. In this case though, the problem with growing the permission se
98.
▲
by
batou
11y ago
We are exactly there. We're having to remove vast swathes of stored procedures and rewrite everything.
99.
▲
by
batou
11y ago
Despite many attempts by people to prove otherwise. Literally every "enterprise" product I've seen tried to do this and fucked it up royally.
100.
▲
by
batou
11y ago
Exactly. If you isolate this as an programmer's concern then you can skip the administrative effort and assume that the application configures itself properly rather than relies on someone to experiment with producing a sandbox for it
101.
▲
by
batou
11y ago
No that's about it. Granted they give you efficient paths to get it back again and store it on the right shelves but that's about it. The key benefit is probably familiarity. I'm not saying they're an invalid tool, merel
102.
▲
by
batou
11y ago
That's a poor argument because we're not discussing the arbitraty boundary of storing versus working with data as the lines between those are very blurred. This is even more the case when you use stored procedures which work with
103.
▲
by
batou
11y ago
Counter-counter-points: 1) Stored procedures aren't that much faster than issuing plain SQL over the connection. The main performance bottlenecks in a RDBMS are cache and IOPS. Regardless of where you execute those, they are all inside
104.
▲
by
batou
11y ago
Hmm no. Avoid state at all costs. Stored procedures are stateful. Schema and migrations is pain enough already. Write me a check constraint that validates an email address being put in a varchar column and reports back a sensible message wh
105.
▲
by
batou
11y ago
That is quite frankly horse poop. We use stored procedures. Not by choice; this is a legacy we're stuck with. It is nothing but an unadulterated disaster of a technology regardless of what you use it for. I'm talking 45,000 stored
106.
▲
by
batou
11y ago
You're right but 99% of the problems I end up solving with SELinux are problems that fit tame perfectly. The rest of the problems are architectural i.e. the process doesn't have privilege separation mechanisms etc.
107.
▲
by
batou
11y ago
I really like this solution. Far better than pissing around with SELinux configuration and it's well contained.
108.
▲
by
batou
11y ago
Your app is compiled from MSIL to native on MS's servers if it's like Windows Phone. I think they can recompile everything if a dependency changes for example and push a new app version for you.
109.
▲
by
batou
11y ago
That's the ones! Never seen inside one before - thanks for posting!
110.
▲
by
batou
11y ago
Well they were pretty crap. There was a metalised bit of plastic for the card and the reader burned certain bits of the plastic to gate the light. If you bought a £5 card you could cut a hole in it, fill it up with epoxy and use a permanent
111.
▲
by
batou
11y ago
I've done this! You can see them with the naked eye quite easily. Just shine a light diagonally at the surface. I wouldn't bother reading them by hand though. You could take a photo of it with a digital camera then post-process i
112.
▲
by
batou
11y ago
Either that or early warning?
113.
▲
by
batou
11y ago
It this on windows phone too. It's not the phone's fault.
114.
▲
by
batou
11y ago
I owned one for a bit (A500 and A1500). AS I was in the UK, this was wiped out by the Acorn Archimedes coming on the scene. I can't say I ever "loved" it nor found it reliable. By 1998 it looked quaint compared to NT4 etc.
115.
▲
by
batou
11y ago
They'll still be reinventing the Amiga when I'm in my 80s I'm sure. I remember back in 1998 a friend had a bastardised A1200 in a PC case with bits of sticky tape holding it together. I was constantly lending him my soldering
116.
▲
by
batou
11y ago
Interesting. Either way that sounds like a glorious way of using your time.
117.
▲
by
batou
11y ago
I pull 120Gb a month down. That's going to be a fucking big OTP and side channel.
118.
▲
by
batou
11y ago
That's fine until you have a 4 MLoC behemoth with 50 developers (I use that term loosely) that isn't separated into logical concerns properly like your average "enterprise product". I've seen those things and what y
119.
▲
by
batou
11y ago
It got replaced. Plus I have three children already :)
120.
▲
by
batou
11y ago
Sounds just like the 2011 i7 MBP I had or "the cockburner" as it was officially named. Might be the CPU throttling due to heat. There is no active cooling system on the new MacBook by the looks so I reckon it's thermally mana
More ›