petalmind

10 ms·

61.
by petalmind 2y ago
Up to chapter 6 the method is completely database-independent. In chapter 7, a classic relational table approach is explained. You can choose a different approach if you want to use something like Cassandra, MongoDB or DynamoDB (or some ot
62.
by petalmind 2y ago
> This is one of those aspects which is not really touched on in most courses. Thank you! As I was working on all of this, the more it seemed to me also that what you're saying is true. The goal of this approach is to quickly get
63.
by petalmind 2y ago
Thank you! > The term “anchor” feels kind of weird to me This term was inherited from Anchor Modeling ( https://en.wikipedia.org/wiki/Anchor_modeling ). "Entity" is pervasive, but I don't want to use t
64.
by petalmind 2y ago
> If we're supposed to go sentinel free does that mean no more numerical types? sorry what do you mean by "numerical types" here?
65.
by petalmind 2y ago
You may also be interested in Joumana Medlej's book "Wild Inks & Paints": https://majnouna.gumroad.com/l/wildinks?layout=profile . "this handbook introduces you to the wonder of transforming natu
66.
"Designing Transit Maps", an interactive book(bureau.rocks)
3 points by petalmind 3y ago|0 comments
67.
by petalmind 3y ago
> left outer join > A join that is guaranteed to keep all rows from the first (left) table. Columns from the right table are filled with actual values if available or with null otherwise. This wording only works for identity equality
68.
by petalmind 3y ago
> add deprecation notices one thing that I think needs to be more common is that you should not write simply "this method is deprecated". You must always say "...is deprecated * in favour of* FOO".
69.
by petalmind 3y ago
It seems that lots of people independently coin this expression. I did it too a couple of years ago. Just checked Google, and there are lots of hits for this.
70.
by petalmind 3y ago
This is my pet peeve. Top google search results and ChatGPT suggest this "same number of rows" mental model which is incomplete and breaks. I wrote about this: https://minimalmodeling.substack.com/p/many-expl
71.
by petalmind 3y ago
> For example not everyone has a middle name, but you don't want to go all 5th Normal Form on it. (actual question) how does 5NF apply here? I thought that this case could be handled null-free by introducing a separate table people_
72.
by petalmind 3y ago
I wonder what the problem is, how exactly is it falling apart: a) you need to write a lot of "clean up" sub-queries and fragments or b) the question you ask is more complicated and does not fit into the algebra of SQL. If it'
73.
SQL:2023 is finished: Here is what's new(peter.eisentraut.org)
278 points by petalmind 4y ago|153 comments
74.
by petalmind 4y ago
"caught"
75.
by petalmind 4y ago
By the way, thank you for the post.
76.
by petalmind 4y ago
I did not say anything about you. I've read the text as it was presented to me and reported some statistics about it that have caught my eye.
77.
by petalmind 4y ago
Name of the man is mentioned in the first paragraph (and three times more). Name of the woman who actually invented the concept you discuss is relegated to "someone" and a footnote.
78.
Biological Systems as Evolved, Overloaded, Multi-Scale Machines(arxiv.org)
2 points by petalmind 4y ago|0 comments
79.
How to Grow as a Database Developer?(minimalmodeling.substack.com)
3 points by petalmind 4y ago|0 comments
80.
by petalmind 4y ago
I think that many HRs would be suspicious about somebody who worked at each job for 2.261 ms.
81.
by petalmind 4y ago
Inadequate resource allocation does not make something unimportant. If you don't spend effort on better sleep, eat and physical exercise, that does not mean that those are "unimportant", it means that you suck at prioritizat
82.
by petalmind 4y ago
> unimportant legacy projects are they really unimportant? My goto question to find out how important something is: what happens if we turn it off? Usually the answer is "haha please do not". Ask the same question about "
83.
by petalmind 5y ago
True. Perl exists for more than 30 years already.
84.
Organizational scalability and flexible database schemas(minimalmodeling.substack.com)
2 points by petalmind 5y ago|0 comments
85.
by petalmind 5y ago
Monads are too specific, a lot of things that they are used for could be represented by weaker constructs such as Applicative. See e.g.: https://www.microsoft.com/en-us/research/publication/desugar... "F
86.
Handling Time with Supersecond Resolution(minimalmodeling.substack.com)
3 points by petalmind 5y ago|0 comments
87.
Making sense of 1NF, pt. II(minimalmodeling.substack.com)
1 points by petalmind 5y ago|0 comments
88.
by petalmind 5y ago
Sorry, where did you get this estimation from? (Genuine question). thanks,
89.
by petalmind 5y ago
You may also find useful: https://github.com/adworse/iguvium
90.
Iguvium extracts tables from PDF file in a structured form (2018)(github.com)
1 points by petalmind 5y ago|0 comments

More ›