HNHacker News
TopNewBestAskShowJobs

TristanBall

168 karma · joined June 25, 2020

submissionscomments
TristanBall··on Is a DB that doesn't need indexes attractive to DBAs?
If the system can run without indexes while still being performant in other areas ( multiuser oltp for example ) then that's awesome, absolutely. Pretty much every other trick for faster multi-record queries sacrifices oltp performance in some way.

But to step back a bit. DBA's manage database engines as much as they manage the data, often more. Schema design, index maintenance etc is part of it, but on a stable system often only a small part.

And replacing those db engines is a big deal, as per my earlier comments about compatability and integration - without big, strategic management support, it's often effectively impossible to change them. So you're offering a choice that, in my experience at least, DBA's actually rarely make - coders, architects and history usually make, or made those choices.

We also often don't care about the data "as information", only in the sense that it's been entrusted to our care. The people who use the data usually wear different hats (bi, ml, analyst, data science, sometimes managers and of course coders ).

But those people aren't adding / removing indexes in DBA managed environments.

Your parallel column scan sounds cool, and I can see how it falls naturally from your design, and it's often hard to retro fit onto an older engine.

My instances have 11000+ clients during peak, we've already turned off almost all capabilities for parallel queries - because for 95% of the workload it cant help, and likewise an errant query that suddenly jumped up and started consuming multiple cores worth resources could be a disaster.

So it sounds like you've got some cool stuff, you're just talking to the wrong demographic!

TristanBall··on Is a DB that doesn't need indexes attractive to DBAs?
I suspect the data science folks are more likely to be interested in what you've done than dba's, at the stage you're at.

They're more likely to be working with desktop tools, with their own copies of unstructured or semi-structured data and they're far more likely to be doing as-hoc or exploritory queries and manipulations, and they'll care far less about concurrent access.. which is absolutely critical to just about any environment who still think it's worthwhile to hire dba's.

Faster queries for a single user on a desktop solves no problems I have - as nifty as some of the techniques you're starting to talk about are.

TristanBall··on Is a DB that doesn't need indexes attractive to DBAs?
Yeah, tbh, it sounded harsher than i intended, and you could actually plot a pretty successful path by life simply by doing the opposite of everything I say.

But there's lots of new shiny. Yes, some of it turns out to be the new big thing. Lots more of it turns out to a neat feature that simply gets replicated / bought and integrated into current platforms. Lots more settled into specific niches or makets you'll almost never hear about on HN.

The majority disappears, wrong or right, and we all have time and attention budgets.

I'm not against, I'm just not interested until it can tick more boxes. Or unless it happens to tweak my interest for whatever personal quirk of mine - and in this instance all the information is stuck behind my least preferred delivery style so....?

Even then it's often moot.. the database I'm using now is dictated by application compatibility more than anything.. there's already "better" for almost any measure of the word, _except_ that this is the db our vendor app supports and have stored procedures developed for, and porting isn't a priority.

All that said, if and when you take over the db industry, you're welcome to hold me up as yet another grumpy old timer who couldn't keep up!

TristanBall··on Is a DB that doesn't need indexes attractive to DBAs?
Not interested in video, text or it didn't happen.

I run transactional systems, concurrent oltp performance or it didn't happen.

We have hugely diverse sets of interrelated applications and systems build either against the primary data set, down stream datalake/bi/cubes systems. Integration and compatibility or it didn't happen.

We run Cloud or Linux systems. Platform support or it didn't happen.

Some of us run databases that are decades old.. it needs to have been happening for at least 5 years and/or be being shipped by a major vendor or it didn't happen.

See also: must have 10 years experience in technologies that have existed for 5.

New tech is hard, data is important and we're busy, in an industry with many many new shiny things.

Neither nice nor fair, sorry.

TristanBall··on New cars make me want to Saab (2020)
Dad is/was a Saab guy, and for a long period my folks had matching terracotta Saab 900's. Not sure mum ever fully forgave him for that, she wasn't consulted!!

I learned to drive in one, before buying my very own 1986 Mitsubishi Sigma.

The Saab 900 weighs 18 bazillion tonnes, and is almost impossible to to roll or skid. The Sigma weighs about 4.2 grams, and will skid sideways if you close the door too hard. Driving on the winding country roads of my youth, some rapid adjustment of driving styles was required!

I don't remember it being all that quirky tho.. I know you couldn't take the keys out of the ignition in any of the "on" positions, and I think the driver's side door could only be locked from the outside, making it hard to lock your keys in the car.

Something similar with the lights, I think, it was very hard to leave any lights on accidentally overnight and run your battery flat

And I think maybe reverse gear was an odd spot compared to other cars.. although it also made it very hard to accidentally (try to) put the car in reverse while shifting..

Given the tech level at the time tho, they were all pretty sensible solutions to issues that people had with other cars, even if they were all "operator error" problems.

TristanBall··on Selling to the Fortune 500, Government, and Other Lovecraftian Horrors
Also, finance departments exist primarily to complain about the time it takes to reconcile your credit card charges, and to push as much as possible for said purchases to go through the B2B "on account" purchase process, and in 99.99% of non tech companies the head of finance will have more clout in the board room than anyone in your management chain - or you report to them, because tech is so obviously a finance function, in which case just give hope now*

(* Actually, it can be fine, finance directors are often perfectly nice people, with that deeply soothing habit of just rounding up to the nearest $10k/100k/1M.. but really can we get this stuff of your credit card, Clair complains every week about chasing you for receipts)

TristanBall··on Selling to the Fortune 500, Government, and Other Lovecraftian Horrors
I've been doing senior sysadmin or adjacent work, mostly for SME corporations with turnover in the $250-750m for 20 years, which has consisted primarily of saying "oh f, no price list, they're going to want to charge enterprise prices at a level I can't possibly make a business case for", interminable meetings with the dreaded pre-sales Two Suits and a Skirt hydra monster, and some minor stuff with backups and printers.

While everything this guy says is largely true - I have after all had purchase proposals rounded up to the nearest $100k ( it wasn't close... ), But likewise it's often true that that $500-1000 credit card is only held by one person in a given team, and there are already many competing monthly charges on it, and it's also said manager's "get out of jail free card" for just throwing money at small problems that come up, without having to talk to their manager. That's an emotional requirement as much as anything, but it's linked to whether said manager can appear competent to their 1-up.. so if you think that $1000 card has more that $250 available for all reoccurring expenses, you may need to reconsider.

And you might, justifiably, decide that's a reasonable customer selection filter, because no one wants a customer that behaves like a big enterprise but pays like consumer.

But we're not like that, honest - I just want your X for me and the 3 people in the team it'd help, you'll probably never hear from us otherwise. Truly! Come on, we believed your marketing brochure.. meet us half way?

TristanBall··on Hand tremors and the giant-button-problem (2018)
So happy to see someone paying attention to this.. my shakes come and go, better with meds, but laptop trackpads without separate buttons have been nearly unusable for me for years. Tap to click and drag to scroll are terrible ideas if you have the shakes.

All the various multi finger gestures? Pfft, I can do 2 fingers well enough to be recognised about 80% of the time, but that's still hugely frustrating, especially when the attempt ends up registing as a click because I twitched.

I have only bought Lenovo and some dell latitude laptops for years because of this, because they're they only ones that consistently have separate buttons.

TristanBall··on Why don't we use the math we learn in school?
I'm 43, I got taught fractions in primary.. wait let me do some math, about 32 years ago. 1

I seem to recall fractions being presented as the necessary "old way" before they taught us decimals, but maybe that was just me.

I had no idea* about the multiplying fractions thing to solve the example. 2. Maybe I was tought it, I guess I probably was, but it also just about the last time the curriculum touched on fractions at all, at least until I dropped out at year 10 ( 2 years early ). Maybe those last two years are a fraction filled bonanza.. but I suspect not.

So unless I'm super interested on my own, its quite possible it's decades before I find a use for it?

Just how effective do you think 5 hours a week for two 4 week periods 30 is at instilling knowledge - especially over decade timeframes.

The example is actually a good one, because finding a fraction of a fraction of a cup is the kind of thing you might need when reducing the size of a recipe.. but it also demonstrates the problem... Close enough is good enough.. I can tip out part of the measure and eyeball it anyway - and can do so without thinking about it at all! And I'm cooking.. I'm doing rough measures and adjusting as I go anyway..

If math concepts aren't revisited throughout schooling, with concrete uses how does anyone retain this stuff? ( Of course, I'm a drop out with a notoriously bad memory, so maybe I'm a bad example )

There might be some value in local colleges or whatever running little "hey, now that you're an adult, here's how you can use all that math you've mostly forgotten" classes...

1: The uncertainty is I don't remember which year they taught us, not that I can't calculate the answer!! *2: OK, if I think of them as decimal values it makes sense and is semi-obvious. But I'd still just spoon out a bit of the measuring cup.

TristanBall··on Efficient Pagination Using Deferred Joins
For uncached query, I just got a 10x speed improvement on this on an Informix 12.10 instance.

Will I might hesitate to deploy it in an app, because the index scan is still relatively heavy weight, I can certainly see myself using this for ad-hoc stuff, so thankyou.

TristanBall··on The Zen of Drinking Alone
It's still a fringe treatment, but Baclofen turned off my alcohol cravings like a light switch.

It did nothing for the underlying causes of my wanting to be inebriated of course, but the "I can't think about anything else until I've had a drink" just disappeared.

TristanBall··on Unix Shell Programming: The Next 50 Years
When you say "switched away from bash".. what did you switch to?
TristanBall··on Ask HN: Are most of us developers lying about how much work we do?
Right? The OP is literally saying he slacks off then bullshits his way through meetings and that he regularly doesn't understand what's going on.

Everyone else appears to be talking about time spent directly thinking about a problem - which absolutely can look exactly like you're staring into space and this magic "subconscious processing" everyone claims to do.

That is far too seductive and idea, and far too ego flattering for me to trust it. "I'm so smart I solve problems in my sleep!"

Oh really?

But the phenomenon of solving problems quickly after a break/sleep/shower/whatever is one I recognise too.

Something else I recognise is that I also jump to solutions too quickly, often wrong ones, or by something that feels quit similar, jump to the idea that I don't understand things or that I don't know how to solve a problem.

Either the "wrong idea(s)" or the "no idea" are patterns of thinking that make it that much harder to see the problem a different way, or to think up new approaches. You can absolutely overcome it, but it takes a deliberate effort of will, and possibly explicit step by step techniques to do.

Much easier to just put it down and have a nap or a walk or whatever.

But that time isn't "subconsciously working on the problem", it's time spent letting go of you original ideas, letting those neuron interconnections to loosen up ( or whatever, not a neurologist, can you tell? ) so you can generate new ideas, obviously you haven't forgotten them.. but they have that softening distance to them now, and the no longer carry as much weight.

To take in one more, completely unsubstantiated step further, maybe that what a 10x coder is: someone who can more freely move between their ideas ( naturally or via learned technique ) meaning the the need to sleep on it far less often. Or maybe they give themselves a chance to let go of there currently working on the next and the next ( which I'm sure we all do some of, or every software company would be surrounded by a cloud of Devs, walking or staring off into spec! ) But maybe to 10x engineer does that more readily? Without the the exhausting drain I know I feel jumping from deep thinking on one think to deep thinking on another?

We shouldn't discount how many of the "other things" people list are either directly rejuvenation ( sleep! ) Or at least refreshing via increased bloodflow from some level of physical movement, even if it is just getting up to do the dishes.

Personally I think "well rested me" is of about average intelligence, "well rested and in the zone me" is perhaps a little higher but "tired me"? Wow can that be a big drop!

So.. rest, rejuvenation, letting go of mental models by directing your attention else where all seem like more likely causes than "my brain solves problems without even trying"

( Sorry tsike, kinda went of on a tangent there.. ! )

TristanBall··on Zillow lost money because they weren't willing to lose money
Honestly, this is the most important point. Rampant speculation, amount other things, is already destroying housing affordability ( Hi from Melbourne Australia, where I'll probably need $150k for a deposit on nothing special at all, in an inconvenient location ). It's massively increasing wealth inequality, at a rate that seems to be increasing.

If this kind of algorithmic speculation took off, not only are we likely to see the algorithms themselves form feedback loops to push prices up far higher than otherwise, even if they don't sell directly to each other, I believe it will drastically increase the size and rate of the boom bust cycle.. and we're doing that to _peoples homes_.

The scope of human suffering possible here is huge, the societal damage massive.

This needs to be so very very illegal.

TristanBall··on Ask HN: Do you still miss your RIM BlackBerry?
I do, a lot.. no one since has managed to integrate sms and email quite so smoothly either.

I really don't miss the RSI and cramps I used to get from it though. I realise that's a partly my own fault, but still.

TristanBall··on Ask HN: Managing career progression for those with no interest in progressing?
It is, or should be, totally OK. I've worked with many people like that, but particularly those over 35, who due to their life stage were perfectly happy with their current roles, and often more importantly, level of responsibility/stress/overtime expectations. Their roles fit with their current work/life balance.

They were, without exception, great to work with, or have work for me.

We can't, after all, all be the boss, or the senior whatever.

Where possible, I'd try and focus on skills development within their current roles.. directly applicable skills where possible - if not, I'd look for indirectly applicable ( look at the training other teams in the business do.. cross skilling, or even just having a better understanding of other roles in the business is rarely a bad thing )

TristanBall··on Show HN: I’m an introvert – made an app to help maintain connections with people
People with social anxiety often come accross as introverted, because they are anxious about interacting - however that doesn't mean they don't want to interact, the desire might be extremely strong, exacerbated be the perceived difficulty in doing so. Compare an introvert who is not socially anxious, who simple has a lower desire to interact. Likewise, some socially anxious people cope by being more extroverted, louder, more interactive. So.. there is a difference in the internal experience, and the external presentation.. and i think when we're talking about a person, rather than their current actions, we normally mean the former but are mislead by the latter.
TristanBall··on A journey to io_uring, AIO and modern storage devices
Everything I've seen say using the no-op scheduler for very low latency devices is the way to go - particularly for nvme and optane devices.. interesting that it doesn't seem to be mentioned here, or in the linked paper?
TristanBall··on Why Some Old Computers Are Interesting
So, I guess video and network cards are the two most common remaining components that could be called "peripheral processors"?

My interpretation of the ( frustratingly sparse ) documentation for the AWS Nitro hardware support seems to imply that it's pushed a bit more of the processing back out to the peripherals - which seems to buck the trend, but also seems highly effective.

For example, so far as I can tell, AWS's NVME drives have a lower latency from within a Nitro EC2 vm than a 905P Optane accessed from a KVM VM with PCIE passthrough on my play machine at home - although it's possible I've done something wrong with the setup!

TristanBall··on Ask HN: Is there a way to efficiently subscribe to an SQL query for changes?
Informix has its "push data" feature - except it appears to be limited to a single table, not complex queries - I suspect you're right, it's hard to do safely and efficiently.

https://www.ibm.com/docs/en/informix-servers/14.10/14.10?top...

TristanBall··on Whistleblower: Ubiquiti Breach “Catastrophic”
This, plus the advertising thing, plus their weak firewall & wan feature set means they've lost me as both a customer and an advocate.
TristanBall··on Ubiquiti starts serving ads in their management interface
I'd been wondering about this.. Ubiquiti's wan and firwalling is super weak, especially for multi-site, when compared to some of the sd-wan products out there.

What's wrong with the ap's? Have you used the switches? How much of their kit can managed via a single console?

TristanBall··on Class Action Lawsuit Filed Against Robinhood
Surely its a response to market manipulation? Which, almost by definition is going to require some level of intervention.

My understanding is the forum members were colluding to drive up the price of particular securities? How is that not manipulation?

Although I guess I would have preferred the relevent stock markets to step in with a complete trading halt on those securities if intervention was required.

TristanBall··on OO in Python is mostly pointless
Couldn't agree more. I'm a sysadmin living in a powershell world right now, and the ability to abstract away "things that mostly behave like filesystems, but aren't” behind some classes with standard interfaces is extremely useful, as it clarifies the actual logic of the code a lot, and means I can support different backends usually with just a new class

I absolutely could have done it without classes, in fact I did that first, until it clicked that I really was doing things the dumb way.

Everything else is a bag of functions.. its only a couple of thousand lines of code, but limited OO was still very useful, and to me, more elegant

TristanBall··on Ask HN: What are you surprised isn’t being worked on more?
Many of the nas's get pretty close too this... but there's really no such thing as a mail server for non-technical people. "Whats a domain? Can just put whatever like?" Etc etc.. even if you baby people through all of that, you still end up with a device that needs to be backed up, isn't available when the powers out at home etc..

Not knocking the nas's btw, I really like them because they do make it relatively simple to do a whole swathe of the common services, but it's only simple to me because I know how to do it by hand. A non technical person won't even understand the terminology.

That said.. I did wonder whether the deployment of solar and batteries to many homes might eventually also enable the deployment of edge services to per home servers. Right now the power draw prob makes in unworkable, as do maintenance costs.. but won't someone think of the reduced latency?

TristanBall··on The stock market is the cheapest since 1980
I can't find the link now, but at least in Australia this doesnt appear to true. We have a reverse mortgage system here, and the take up is extremely low ( I think it was <10,000 for the whole country).

Particularly with house prices here being completely insane, parents very much want to leave houses to their children.

I've also read multiple articles around how to get, or encouraging, retirees to be comfortable actually spending their retirement savings, rather than the interest/earnings from those savings, given its so hard to get a living income that way.

I think the 'die broke' crowd will be limited to a very small sliver of any generation... those poor enough that they have a chance to actually spend all their money, but well off enough that their children own their own houses ( possibly debt free )

TristanBall··on The Untimely Demise of Workstations
So.. I guess this really is nostalgia for a time when you could go out and spend $10-100k, and buy a workstation that had capabilities simply not available on a consumer pc.

Thats kind of a hard thing to do these days.. and there doesn't seem to be a market for it.

If you want to do that now you just look at “server“ class equipment, or its "workstation“ smaller siblings, to get ”truck” features... multiple cpu sockets, more ram, more pcie lanes etc. Add pcie cards to as required for the workload. All the old-school unix workstation benefits, and it will still be able to run excel and outlook, which matters in lots and lots of environments.

TristanBall··on Remove auto renew from my account
Do this with Teamviewer, without formally terminating the account, and they'll chase you for it, including passing your case on to a legal firm ( at least, here in Australia they did ) I sent a fairly polite letter back explaining id long since stopped using the product, and all they were doing now was destroying any residual good will they had. I never heard anything back.
TristanBall··on Drivers who keep their windows down are exposed to 80 percent more air pollution
Not that I've noticed here in Australia. Personally, my current car is an auto, and trying to engine break just isn't very effective without switching to manual in my car. Engine breaking can also be noisier, as may have to shift down gears in a way that means the engine revs relatively high, for a brief time - making it a more noticible noise.

Out in the country, and for me that often means the hills and mountains, then engine breaking is a much bigger part of my driving style, esp down hills!

Engine breaking also doesn't cause your break lights to come on, and they provide a quicker signal that a car is slowing, than relying on people to detect the change in speed.

TristanBall··on No-reply emails from businesses shouldn’t be allowed
Ha.. or they'll send multiple invoices from no-reply, then pass you off to debt collection and/or lawyers.

I'd draw a distinction between this kind of email - where a company is at least trying to require you to do something, and which may have ongoing personal or legal or personal ramifications ( e.g., credit score ), and just about any other commercial email, whether it's a "campaign", or automated function alerts or whatever.

Sending invoices from no-reply, with a vague "see our website for contact details" is such terrible customer service that it borders on bullying.

If a business can't deal with all the auto-responders, then the method of response should include enough context that the first person a reach knows what's going on, and is most likely the right person to deal with the response. So, for example a link to a contact form that's prefilled with context information ( like an invoice number, or a ticket number that was auto-created when the invoice was ), and that routes directly to the correct people, eg ccounts, not sales or tech support!

← PreviousPage 4 of 4