Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
eftpotrm
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
26 ms
·
211.
▲
by
eftpotrm
15y ago
But with a normalised database you couldn't the above without two inner joins (and it's still a trivial query that any competent dev for that sort of position should be able to dictate while driving, it's that easy). Really, if you can't re
212.
▲
by
eftpotrm
15y ago
That sort of thing specifically, never actually tested it. The last test I did help administer was for a VB+SQL job, and the first question was to write an example of a valid INNER JOIN. I'd say at maximum 25% of the candidates could do thi
213.
▲
by
eftpotrm
15y ago
Well, that's a start at least - I'm nothing to do with that project any more to verify if the workflow is any better and of more value to developers, but obviously that would be a larger concern and one I'd hope had also been addressed :-)
214.
▲
by
eftpotrm
15y ago
I had a partner organisation insist on Jira for their project a few years back. It'll obviously have changed since then and much might be down to user-specific customisations, but I hated it. Awkward, obstructive, poorly thought out workthr
215.
▲
by
eftpotrm
15y ago
If you don't feel you understand fashion combinations (and I don't claim to be a world authority myself, as would be apparent if you could see me right now): spend some time deliberately watching others' choices. Wander round shopping centr
216.
▲
by
eftpotrm
15y ago
Which is context dependent. If I rocked up to any UK client I've known in the alternative outfit you've highlighted, I'd expect some decidedly odd looks. Replace the t-shirt with a shirt and possibly tweak the shoes a bit and we might be ge
217.
▲
by
eftpotrm
15y ago
If you think performers are merely mechanically repeating someone else's composition, I would suggest that you're not a musician...
218.
▲
by
eftpotrm
15y ago
Yes, on the condition that you own a halfway decent (not £40 from a supermarket) suit and you're comfortable wearing it. I do and am, and always have - it's a sign of taking the other party seriously, to my mind. If it proves laughably form
219.
▲
by
eftpotrm
15y ago
So if I express myself by writing I get life + 70, but by playing I get a flat 50? Why the differing value judgment? I'm a firmly amateur musician so this isn't relevant to me, but as it happens I do as much improvisation as formal writing;
220.
▲
by
eftpotrm
15y ago
From the article and other sources I've seen before, it seems that algorithmic trading is not necessarily high frequency, but that high frequency trading is necessarily algorithmic. In which case is this not a rather thin hair to split?
221.
▲
by
eftpotrm
15y ago
Why should we be surprised that the company whose business is in shipping and selling a wide range of physical products has more revenue than a range of companies whose income are either service fees or advertisements? We're not comparing l
222.
▲
by
eftpotrm
15y ago
Including public holidays, it should be noted.
223.
▲
by
eftpotrm
15y ago
If I wrote a book in 1961 (hypothetically, that would have been precocious even for my parents ), it would be in copyright for 75 years after my death. If I recorded a song in 1961, that recording would go out of copyright this year under
224.
▲
by
eftpotrm
15y ago
This only encourages a race to the bottom though, which doesn't help them build viable, sustainable long-term careers. While I see where you're coming from, I do still think the advice is sound in the long term.
225.
▲
by
eftpotrm
15y ago
But what percentage of them are active sites and what are parking pages / domain squatting? It's been shown in the past that a single domain parker moving their hosting can have a vastly disproportionate effect on these numbers while affect
226.
▲
by
eftpotrm
15y ago
That's definitely the challenge, but the advantages of last-mile depot collections as a universal service rather than the current 'system' of waiting for the missed delivery cards then trying to find a depot 20 miles away would be a major b
227.
▲
by
eftpotrm
15y ago
Hopefully coming to the UK soon. This (well, ideally a generic multi-retailer version) has been to me an obvious business opportunity for years; if I had the slightest of relevant contacts I'd have been trying to set it up. Hopefully it wil
228.
▲
by
eftpotrm
15y ago
There's certainly a lot of the Old Boys Club about auditing and regulation, anecdotally... Too big to fail? The boundary cases will always be the challenge but I suspect we could get started by mandating a limit to percentages of GDP under
229.
▲
by
eftpotrm
15y ago
Yes, but that's a separate issue of shareholder governance. At present there isn't a legal power of criminal incompetence in charge of a financial institution to go after Adam Crozier, Fred Goodwin or Victor Blank for setting up businesses
230.
▲
by
eftpotrm
15y ago
Well, that's a rather different situation. The cause of the underlying collapse in the securitised mortgage market was borrowers being over-rated on credit worthiness and the securities derived from these mortgages then also subsequently be
231.
▲
by
eftpotrm
15y ago
Hmmm. Modern SQL dialects are Turing complete and frankly pretty rich dialects. I know MS SQL Server best so can't speak in detail for others, but the community around that is certainly very substantial. Library support, well, doesn't work
232.
▲
by
eftpotrm
15y ago
I also think data integrity is easier to maintain with a system like this. SQL constraints don't allow me to express nearly as much about data integrity as I can in code. Sure, I could use stored procedures, but if I'm going to write code
233.
▲
by
eftpotrm
15y ago
Perhaps, but I wouldn't use that as a starting dataset; noise resilience and a training set for enhancing this functionality is surely better developed on top of a working implementation for a lower-noise input? Better to build the easier s
234.
▲
by
eftpotrm
15y ago
Hmm, good point, though still against a cleaner audio signal, easier input data to process and (likely) closer matching of text. I'm not remotely involved with the field so I won't indulge in further wild speculation, but an interesting bal
235.
▲
by
eftpotrm
15y ago
Aside from issues relating to background noise on the soundtrack, the subtitles are frequently abridged from the spoken word in the interests of space and / or readability, so you'd need to account for that in your algorithm. If it were me.
236.
▲
by
eftpotrm
15y ago
If the compressed version is apparently sharper than the original file, that's an artifact surely? It might be pleasing in some contexts but it's not an accurate representation of the original file in that aspect.
237.
▲
by
eftpotrm
15y ago
The market dynamics with TV are rather different though. The music industry as a whole Apple haven't broken; record labels still exist and the bulk of commercial music is distributed through them. What they've broken was the physical dist
238.
▲
by
eftpotrm
15y ago
Limited granularity, too. K5 improved on that, while HN's factoring in of time since posting seems to help to my mind as well. Yet, for all its failings, it was an impressive starting point that led the way for a lot of others, and was mass
239.
▲
by
eftpotrm
15y ago
Well, they're definitely failing with iTunes. It's the one Apple program I use and, bluntly, it's rubbish.
240.
▲
by
eftpotrm
15y ago
Beautiful, maybe; maintainable, not so sure. A colleague's iMac is likely to need a motherboard replacement and he was going through the procedure with me. The amount of work and the sheer cost of parts for something so routine on a PC asto
More ›