Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
ldb
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
6 ms
·
31.
▲
by
ldb
7y ago
Same for me. From what I understood you want to say that "people love spreadsheets" but "spreadsheets have limitations" (e.g. they have weak/no data schemas). If this understanding is correct then it would be helpfu
32.
▲
by
ldb
7y ago
Couldn't find pricing information on the webpage. Does anyone have details on pricing for WayScript usage? (I assume it is not free as there is a "Payments" section in the terms & conditions)
33.
▲
by
ldb
7y ago
It's probably me, but the (great looking) web-site gave me no idea what the use-case of nuronlabs is. Naming a problem that nuronlab solves (and ideally showing how this is done) would be helpful.
34.
▲
by
ldb
7y ago
> The big boost in program readability is following a style guide with the rules for naming, indentation, commenting, and other important features, plus automated or manual style reviews. I completely agree. I just wondered if there has
35.
▲
Ask HN: I am looking for academic studies about computer program readability?
3 points
by
ldb
7y ago
|
2 comments
36.
▲
by
ldb
7y ago
Thanks for your thoughts which are all good and reasonable. Over the past years I've seen many programmers struggle with the combination of "data aggregation" and NULL. In the beginning I thought that these programmers should
37.
▲
by
ldb
7y ago
Hhm, this time your answer doesn't convince me. Setting "required" is not always possible, and using UPDATE to set a value works only as an ex-post solution, i.e. you must already know that there is an error. But this was exa
38.
▲
by
ldb
7y ago
Again, a very nice explanation. However, from a practical point, I see the following problem: Assume that "Select sum(amount) FROM Payments;" calculates the balance for a customer account, and assume further that for some reason (
39.
▲
by
ldb
7y ago
Good explanation! (which indicates why the handling of empty sets is sometimes a bit confusing) One more question: What was the motivation behind defining "sum({})" to be "0" rather then "{}" ?
40.
▲
by
ldb
7y ago
Thanks, that was helpful. However, I still think that having "sum(1,1,{})" returning "2" and "1+1+{}" returning "{}" can be viewed as somewhat inconsistent.
41.
▲
by
ldb
7y ago
I am still a bit unclear about this. Assume we have three actor records where two records have age=30 and for the remaining one the age is not set. From what I understand then "SELECT sum(age) FROM Actor;" returns "60" w
42.
▲
by
ldb
7y ago
Assume I have a table "Actors" with a column "age" and for some of the records the age is not set (an empty set). Does this mean that "SELECT SUM(age) FROM Actors;" gives "{}" or do you implement a sp
43.
▲
by
ldb
7y ago
> any element-wise operation on an empty set is, likewise, an empty set Does this mean that "SELECT 1 + {}" gives "{}"?
44.
▲
by
ldb
7y ago
How do I test for empty set? If I understand correctly then "SELECT * FROM Movies WHERE description = {};" will not work, right?
45.
▲
by
ldb
7y ago
I like the idea. Reminds me of the Eve language/IDE (www.witheve.com).
46.
▲
by
ldb
7y ago
Very nice work! Love the Mac Classic look :-)