Fork me on GitHub
#off-topic
<
2022-11-24
>
Drew Verlee03:11:09

You know what i would watch? A tech show where when a dev ran into some shanagins tech issue they didn't just roll over and accept it but traveled around the world tell the fixed it no matter the cost. Like, why can't I copy more then like 50 words in discord at a time. Or why chrome crashed when i moved a tab too fast.

👍 3
Drew Verlee03:11:24

I feel like the later one would end up at Google HQ. Visually, something like this:

andy.fingerhut03:11:14

Watch people spend unlimited time and money to fix problems? Sure, why not watch that? Who will fund the creation of the episodes? 🙂

😆 2
Drew Verlee03:11:23

Amazon, they fund a lot of shows, whats one more!

andy.fingerhut04:11:49

I suspect the advertising revenue for the show you describe will be far lower than most big-budget shows 🙂

Lyn Headley13:11:28

One reason system design is difficult is because everything is up in the air, you are creating something from nothing. So concretely, when you are considering a particular question, you have the problem of remembering which questions you have already tentatively answered. To tackle this problem I use an outline tree structure. Every node of the tree is a question or an answer. The answer-children of a particular question represent the different possibilities you are considering in the design. The question children of a particular answer represent further questions, given the world in which the answer (and all of its answer-ancestors) obtains. So when asking a question, you can remember the questions you have already tentatively answered.

👍 2
1
Max19:11:27

I do the same thing! I also only append to notes, sometimes questions that become irrelevant at one stage of the design become relevant again at a later stage, and saving your answers to them saves you having to figure them out again

m.q.warnock00:12:51

I tend to think of such things as a Bayesian DAG. I wish there were a good (open) collaborative tool for building them.

andy.fingerhut17:11:18

Any favorite recommended books on databases? I'm particularly interested in normalization in relational databases from a perspective of either a theoretical bent, but more especially from a practical perspective of what people do in production that might violate normalization, but has solid practical use that doesn't have any gotchas, or at least has known delimited gotchas that are explained. Also anything that compares relational databases with EAV model.

👀 5
chucklehead17:11:08

It comes at it from the opposite perspective, but there is some content like that in https://pragprog.com/titles/bksqla/sql-antipatterns/ discussing when the various anti patterns might actually be appropriate.

🙌 1
stopa19:11:24

Not a book, but my all-time favorite resource has been CMU’s Database Systems course on youtube, taught by Andy Pavlo. I watched the 2019 fall videos and they were great. Databases change so quickly that a lot of older materials tend to start with incorrect constraints (hdd drives as an example). Andy’s course is more up to date, and does go deep. (Note: realized you may be looking for data modeling, not how dbs work under the hood. Feel free to ignore this message xD)

👍 1
jumar11:11:24

Designing Data Intensive Applications is a great book about databases and distributed systems in general. It doesn't go into details (afaik) about relational modeling but it describes a lot of foundational concepts and techniques and also gives an overview of various data modeling approaches (relational, document, graph) in Chapter 2. There's also this old book called Data &amp; Reality which is very popular and (probably - I only read a small portion of it) great. Finally, a good book about SQL databases is The Art of SQL.

👍 1
johnny.martin19:12:05

my 2c... garcia-molena, ullman, and widom's text (database systems) is a very nice book, but may not offer too much in the way of practical advice for RDBMS normalization, theoretical yes, but not so much practical. On the other hand, the authors' insights into, and theoretical comparisons among Relational, Object DB's, Semistructured DB's, etc. is really solid and may guide you to some insights to comparing EAV's with RDB's.

andy.fingerhut12:12:17

Thanks for suggestions, everyone! Good Xmas list of books for me.

Thomas Moerman20:11:17

🎵 Hi, in my free time i sometimes dabble around with synthesizers and Bitwig (not that I'm any good at it). In the car just now I was listening to some podcasts and had the idea: how about making some podcast jingles? So, if you have a podcast and can use some jingles, call me maybe so we can have a laugh together 😉.

🎹 3
🚀 1
ozzymcduff05:11:58

I think @U1BQCSP88 is doing things along those lines: https://github.com/ut-proj/undertone

ozzymcduff05:11:10

Making music with lisp and programming I mean

vemv22:11:03

I find it truly fascinating how each Chrome or Gmail UX update will be invariably for the worse. I don't remember ever not hating any of these tweaks over some 10 years?

👍 1
☝️ 1
hiredman22:11:17

There is an apocryphal story of someone visiting the chrome team at Google and noting they all used the old html only version of gmail

Martynas Maciulevičius06:11:05

I was trying out google pixel phones yesterday and on top of not having a 3.5mm jack they all don't show home and task switcher buttons. The back button is actually pretty alright as I have to swipe from the side of the screen. But if I want to switch to another app (a.k.a. alt-tab) then I have to fiddle with bottom bar to somehow open that app menu. I couldn't get how it works in one minute of fiddling. in 10 seconds he shows what I mean: https://youtu.be/Hv4F9iZdhNQ?t=7

borkdude11:11:13

I agree with you @U45T93RA6 - it's almost as if those big corps have nothing better to do and need to keep their designers occupied with some made up requirements and imo breaking changes.

🙂 1
mauricio.szabo05:11:36

I hate Google updates with all my might. Every new android they decide to fix something that wasn't broken, breaking it in the process. My newest Android basically doesn't allow me to change keyboards, because they moved the keyboard switch to the same place as the accessibility button. And I can't disable the accessibility button because they ALSO changed the way autofill works to be inside accessibility...

🥳 2