Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
_a_a_a_
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
41 ms
·
451.
▲
by
_a_a_a_
3y ago
> The only alternative is an old-fashioned credit card -style thing, but even that requires you disclosing your real identity for who knows what reason. Oh bullshit. You can buy and use an oyster card anonymously. I do. Stop spreading FU
452.
▲
by
_a_a_a_
3y ago
IIRC OO is a design pattern. Just happens many langs support it directly.
453.
▲
by
_a_a_a_
3y ago
> doing it well hard(Composition), suggest how this may be fixed > and requires a list of caveats so large that it effectively draws down to "only use it in these specific places"? I don't recognise this, can you explai
454.
▲
by
_a_a_a_
3y ago
> I've toyed with a couple of 256-register ISAs, and the moment you hit function calls/parameter passing you realize that to utilize those efficiently Very revealing, thanks, this had never occurred to me
455.
▲
by
_a_a_a_
3y ago
NP, all suggestions welcome, thank you anyway!
456.
▲
by
_a_a_a_
3y ago
Thanks, never heard of it but from wikipedia: "Canary Mail is an email client that offers artificial intelligence (AI) capabilities backed by technology from OpenAI & Cohere, as well as open-source language models from Hugging Face
457.
▲
by
_a_a_a_
3y ago
Can anyone recommend a professional, good quality (preferably non MS) email client that isn't thunderbird, please. I'd happily pay.
458.
▲
by
_a_a_a_
3y ago
If I understand you correctly, the guy I'm responding to is proposing allowing the mixing of different sized instructions. Your suggestion effectively says "I'm starting a run of compressed instructions/I'm finishin
459.
▲
by
_a_a_a_
3y ago
> There is never a need for one piece of information without the other, so why not store it together. Why not? as I said, so you can have full-length instructions! And you can store it together in the same fetchable unit - the cache line
460.
▲
by
_a_a_a_
3y ago
Others have pointed out adding bits to identify instruction types eats into your instruction length, so let's go stupid big time: what if you had the instructions as described here, without any instruction length being part of the inst
461.
▲
by
_a_a_a_
3y ago
I was really asking about 64-bit instructions specifically, but going with what you've put, if you don't mind... > 1. PC-relative long jump My understanding is that these are rare > 2. GP-relative addressing to support large
462.
▲
by
_a_a_a_
3y ago
Why would you need a 64 bit instruction; what kinds of things are going to be used for it? What does 'rare' mean here, does it mean rare in execution, or rarely appears in code? (The difference being that something might only appe
463.
▲
by
_a_a_a_
3y ago
From the website Sandstorm is a self-hostable web productivity suite.
464.
▲
by
_a_a_a_
3y ago
tl;dr for everyone 1. Waaah! Much badness! (lots of it) 2. "We must do better" 3... well, that's it. No concrete suggestions for 2.
465.
▲
by
_a_a_a_
3y ago
I need to do some more checking, but you are right. The original relational algebra was a subset of first-order predicate logic. Adding recursion I believe just gave it parity with 1st order PL, so fulsome apologies and thanks for pointin
466.
▲
by
_a_a_a_
3y ago
Fair Q, I may be confusing relational and predicate calculus. Will check and get back. Apologies in advance if I'm wrong.
467.
▲
by
_a_a_a_
3y ago
> Relational algebra is not Turing complete. yes it is > SQL gets Turing completeness by means of various additions/alterations. Sigh. No. SQL was a subset of relational until recursive CTEs were included to round it off properly
468.
▲
by
_a_a_a_
3y ago
> In SQL, on the other hand, you'd have to write each of these queries by hand Nope. Can be written as a non-predicated recursive CTE. Just add a 'where' at the end to specify what you want. The practical difference is in
469.
▲
by
_a_a_a_
3y ago
> what do I get from Prolog that I can't get from using SQL? 1. Nothing, theoretically (but see 2, 3, 4) 2. They are for different domains/problems 3. Both are based on the same formal background (1st order predicate calculus I
470.
▲
by
_a_a_a_
3y ago
> For example when I’m traversing the AST when I’m looking at the node { type: "num", value: 10 }, without doing extra work to go back up the tree I have no way to tell that it belongs to the name “ten”. There's a very eas
471.
▲
by
_a_a_a_
3y ago
> There's no good reason why you couldn't rewrite DISTINCT to GROUP BY Exactly. People post a lot of things about SQL optimisation without knowing anything about it. Frankly, I'm getting really fed up with it on HN.
472.
▲
by
_a_a_a_
3y ago
A bit of context from the post: "Raptor yesterday officially announced that we're not getting Power10 systems. The idea is we're going to be getting something better: the Solid Silicon S1. It's Power ISA 3.1 and fully co
473.
▲
by
_a_a_a_
3y ago
> I thought floating point is an essential part of databases. Good heavens, no. Why on earth would you even think that, have you any experience with databases?
474.
▲
by
_a_a_a_
3y ago
Newbie questions, what is a 'softcore'? Also, how many transistors does this equate to? Because IIRC PowerPC is quite an extensive instruction set, and some instructions are quite involved
475.
▲
by
_a_a_a_
3y ago
Please don't generalise or you wipe out the occasional good that does exist.
476.
▲
by
_a_a_a_
3y ago
We are in strong agreement, and the phrasing and measure of your post made it pretty obvious you are knowledgeable (another inverse correlation: absolute opinions launched with violence also seemed to be the realm of newbies; and yours was
477.
▲
by
_a_a_a_
3y ago
I did say 'typically'! Yes, agreed, but it should rarely need help. Also hints are oh so often jammed in by newbies. I strongly get the impression use of hints is inversely correlated with experience/knowledge.
478.
▲
by
_a_a_a_
3y ago
You're right, I meant a failure of the DB/optimiser not the person. Thanks. No they're not perfect but I need them rarely with MSSQL > An optimizer will quickly run into NP-hard problems like join ordering As a start, dyna
479.
▲
by
_a_a_a_
3y ago
I've >25 years of DB rodeoing. Perhaps I know something about this by now. See my other answers on this thread. > that changed its plan based on the column order in the SELECT clause. Hmm? Could you elaborate; you mean the order
480.
▲
by
_a_a_a_
3y ago
> adding hints makes your queries dependent on current performance I don't understand this, can you explain. > Assuming you're a good DBA, you can be better than the optimizer because you understand the whole system That
More ›