zasdffaa

31 ms·

301.
by zasdffaa 4y ago
They don't capitalise their acronyms which regularly catches me, forcing a rewind and a re-read; anyone know why not?
302.
by zasdffaa 4y ago
This is getting even more interesting. > I have this fantasy that we could have an out-of-band hinting system for SQL, I think not breaking the optimiser, and out of band hinting appear somewhat orthogonal but I'd be very glad to b
303.
by zasdffaa 4y ago
> even the most reclusive artist is in a dialogue: with all the artists of the past several millenia It's not a dialogue if they're dead. https://en.wikipedia.org/wiki/Dialogue
304.
by zasdffaa 4y ago
From my non-economics perspective, they seem to have a genius for ignoring externalities (CO2 anyone?), that, and anything they don't want to consider. I can't have any trust in a model/framework that can pick and choose so f
305.
by zasdffaa 4y ago
Interesting. Ok > (3) just as with (2), the new thing transpiling to SQL wouldn't have to allow NULLs, and could generate SQL that uses `IS [NOT] NULL` / `IS [NOT] DISTINCT FROM NULL` to obtain the desired semantics if the new
306.
by zasdffaa 4y ago
Chilli peppers don't like waterlogged roots; they prefer higher ground. I'm told.
307.
by zasdffaa 4y ago
> Golang doesn’t use libc on Linux, and instead calls syscalls directly Could someone explain this. I'm not familiar with low level linux stuff. Why would you choose not to use libc, what are the implications?
308.
by zasdffaa 4y ago
Absolutely zero. He's as mortal as the rest of us.
309.
by zasdffaa 4y ago
In theory. In practice writing a bunch of constraints without understanding how prolog search works will get you terrible performance. It's essential to give constraints so as to match the search algo. This is straightforwad and not a
310.
by zasdffaa 4y ago
1) yeah, probably. 2) Supose you're writing sqlng, compiling it to sql. sqlng simply mandates a primary key on everything. Not a problem. 3) nulls can be a horror but the alternatives aren't pretty. Removing nulls means tables hav
311.
by zasdffaa 4y ago
I love it, I really do! That is perfect.
312.
by zasdffaa 4y ago
You work at MS, contact the Microsoft Research Centre, where C.A.R. Hoare works. Maybe ask to speak to him or another big name. Don't be afraid to ask[1]. Good luck! [1] Shy bairns go hungry, goes some saying.
313.
by zasdffaa 4y ago
I guess I have a different personality and life experiences from Ehrmann. It's bovine acceptance ("no doubt the universe is unfolding as it should") really grates. There's good advice in there about listening to others,
314.
by zasdffaa 4y ago
Is it really a lie? It's an approximation to something real happening. You might as well call the JWST pics of jupiter a lie because humans blatantly can't see it with their own eyes.
315.
by zasdffaa 4y ago
Getting funding is a means not an end.
316.
by zasdffaa 4y ago
Why does it rule out 'more sophisticated and elegant behaviours'?
317.
by zasdffaa 4y ago
If by 'randomly select' you do mean randomly, the TABLESAMPLE is what you want (although random means random pages not rows and the amount returned may be over or under) SELECT * FROM Sales.Customer TABLESAMPLE SYSTEM (10
318.
by zasdffaa 4y ago
'before using Apache Spark on a cluster, try using a single decent server and programming it properly' bit nerdy but from experience
319.
by zasdffaa 4y ago
Show me any sql dialect that will allow that CTE you give here (edit; and what on earth is that supposed to actually mean) > Or can you only use SELECT for WITH queries you can only use a select inside a cte (or should be able to) becaus
320.
by zasdffaa 4y ago
> You can only select with x as (...) update x set ... > you can't nest cte ok but you can linearise them with x as (...), y as (...) > the query planner has no understanding of joins that cross cte boundari
321.
by zasdffaa 4y ago
The only really useful highlighting I've found, really essential, is distinguishing comments from code. In on of my luddite moments I switched off all highlighting (because I am hardcore) and spent an hour debugging a block of commente
322.
by zasdffaa 4y ago
They're both for squares.
323.
by zasdffaa 4y ago
What the hell are you talking about?
324.
by zasdffaa 4y ago
> creating classes/structures that represent the tables AFAICS he's talking about creating AST objects. If the tables don't exist, you can't query the infoschema because the tables don't exist. Someone has to par
325.
by zasdffaa 4y ago
That is eye-opening but - if it actually works and I find it hard to believe - is no way ... ah, the insert is a CTE because it produces a value ('returning' I guess). Hmm. This is very odd. Doesn't seem to work in mssql. Wel
326.
by zasdffaa 4y ago
He actually lists at the end as an alternatives to his consulting: Consider if you can use existing tools or libraries to process SQL code. Some of them even support multiple SQL-dialects or multiple programming languages. If you can use a
327.
by zasdffaa 4y ago
You've completely missed the point. Author's talking about parsing SQL. That's utterly different from using infoschema to get an existing table structure.
328.
by zasdffaa 4y ago
> there are ORM libraries that generate the relevant sql dialect. This has been the case since the early 2000s; see Hibernate. And for C#, there’s LINQ to SQL. That's generating SQL. Parsing is going from text to the AST; the revers
329.
by zasdffaa 4y ago
Ok I take your bona fides but why not just search? There are 186,283 sites covering this, so a quick < https://html.duckduckgo.com/html?q=why%20speed%20light%20lim... > would have helped avoid irritating people, I mean
330.
by zasdffaa 4y ago
I dunno. If you can't see the ball's colours you can't meaningfully say that one is red, the other blue. It doesn't mean they aren't red/blue, you just can't infer which is in which box. Same here. Energy

More ›