Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
petalmind
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
5 ms
·
31.
▲
by
petalmind
1y ago
The secret sauce to Amazon's success is an obsessive compulsive focus on money.
32.
▲
Accounting for State Capacity
(americanaffairsjournal.org)
2 points
by
petalmind
1y ago
|
0 comments
33.
▲
NASA Systems Engineering Handbook (2018) [pdf]
(nasa.gov)
19 points
by
petalmind
1y ago
|
1 comments
34.
▲
by
petalmind
1y ago
What is "non-Unicode" text exactly?
35.
▲
by
petalmind
1y ago
Here are some scans from a 1957 Soviet book on nuclear aircraft: https://xplanes.tumblr.com/post/30938386375/from-the-cover-o... https://xplanes.tumblr.com/post/30941448265/from-nuclear-p
36.
▲
by
petalmind
2y ago
“What [schools are] bad at is teaching people to win in adversarial environments. And they're also bad at the meta-game of reminding someone that knowing the basic mechanics of some process does not make them an expert, but does make t
37.
▲
by
petalmind
2y ago
Funny that Nicolas Cage comes up in this context. Here is a trivia snippet from https://www.imdb.com/title/tt23468450/trivia/ : > During an interview, Osgood Perkins recalled a story from production where
38.
▲
by
petalmind
2y ago
Yes, absolutely, just present it in "historical misunderstandings" section. My only concern is that it is presented as if it was something natural to begin with.
39.
▲
by
petalmind
2y ago
> The fact that there are situations when implementing referential integrity is difficult does not mean you shouldn’t do it at all. > Referential integrity is specified at the logical level and does not dictate any particular implemen
40.
▲
by
petalmind
2y ago
Ah, okay. Yeah, I was thinking about the way how to actually build a non-1NF database. So far my best idea is to store sqlite files as blobs in a different database.
41.
▲
by
petalmind
2y ago
You can't enforce FKs if you just split a database into several, due to regulatory, performance/maintenance, organizational or architectural (m*croservices) reasons. Enforced PKs in modern setting basically only work in a single u
42.
▲
by
petalmind
2y ago
Thank you, the first three paragraphs with examples are very useful to think about.
43.
▲
by
petalmind
2y ago
Ah, okay, yes, sorry, thank you!
44.
▲
by
petalmind
2y ago
Ahh true, object oriented approach certainly helps making sense, and I assumed it by default. I'll think about that.
45.
▲
by
petalmind
2y ago
I don't understand that comment. What do you mean "let's hope" if I can easily store a text content of configuration or log into a column?
46.
▲
by
petalmind
2y ago
haha, I don't want to express disrespect to The Ancients, but I'm bewildered at the entire 3NF/BCNF thing, couldn't they just patch 3NF already by including the BCNF fix? Why do we need to bother with "3NF-but-not-
47.
▲
by
petalmind
2y ago
Thank you! > I'm seen some articles say that atomic in 1NF means you cannot have things that can be decomposed. Yeah, this seems to be an vague argument, but it's not clear what it means. If I write "WHERE name LIKE '
48.
▲
by
petalmind
2y ago
> What if the languages available do depend on what the lesson is about? Then it would be a completely different schema that would just be in 3NF. If you look at Kent's variations you will see that they work hard (graphically) at ma
49.
▲
by
petalmind
2y ago
> Once you have fast random access, it's data structures and algorithms: forget the database cruft. I mean, yeah, but in practice you have to provide ACID or other invariants, you have to provide distributed processing and storage,
50.
▲
by
petalmind
2y ago
> 4NF was explained confusingly because it's quite complex theory. The fact the author says 'to be best of his understanding' it is 4nf is kind of telling. > My 'colleagues' (I am external) claim to know all
51.
▲
by
petalmind
2y ago
> is not obvious at all without specifying requirements _first_. If there is a requirement that an employee skill depends on the language (ie. an employee can type in a particular language only) - the design with a single 3 attributes ta
52.
▲
by
petalmind
2y ago
> if you don't express the update rules in a database schema, it must be in the application code. Subtle errors are more likely in that case. This is a common sentiment but I think that you can always demonstrate a use case that is
53.
▲
by
petalmind
2y ago
This is a very good graphical demonstration (especially the merged cells), thank you. It is also a variation "2b" from Kent's list (just for reference). I think that the textual demonstration of the same effect could be foun
54.
▲
by
petalmind
2y ago
> Because the meaning of "atomic" didn’t change, nor did the meaning of 1NF. So what is the meaning of "atomic"? Are array-typed values atomic? (I think you can treat it that way, a lot of lists are immutable in dif
55.
▲
by
petalmind
2y ago
> I think the natural 'naive' approach is to have many columns with redundant information inside. Interesting, thank you. I either don't remember that phase in my own learning, or I was lucky to read about the "corre
56.
▲
by
petalmind
2y ago
> Things that aren't normalized are "ad hoc," or really just "input." I agree that every denormalization is "ad hoc". It may not even feel this way because sometimes such ad-hocs become intimately tied
57.
▲
by
petalmind
2y ago
Thank you, the second paragraph of your comment is illuminating. There are some more replies in the same vein. I did not understand the mutual independence of "cards", and how you can use a different data layout if you only need
58.
▲
by
petalmind
2y ago
Intercom on Sales: https://www.intercom.com/resources/books/b2b-sales +The Sales Handbook: https://www.intercom.com/resources/books/sales-handbook
59.
▲
by
petalmind
2y ago
> You don't want to store two dates for an event. It's easier to store the start time of the event and a duration for the event. Frankly speaking you could store all three (begin, end, duration) and just use whatever you need f
60.
▲
by
petalmind
2y ago
> this should really start with an analysis of the entire problem so as to capture both the static structure of the system (i.e. class model) and its dynamic behavior (i.e. use cases). How does the deliverable for this sort of analysis l
More ›