`client_customer_id % 36` it's wrong in so many ways...
I'm interested in learning to develop more complex low-level systems. I thought about starting by learning database systems. I know how they work, having experience dealing with distributed systems and databases, and I have written some patches for considerably large databases here and there.I have started by giving this course a try: https://skyzh.github.io/mini-lsm/ , but I'm feeling it is...
- Technical (software and maths) - Psychology and philosophy - Well-being and anthropology
I always read before bed. I used to read fiction, which helped me disconnect and fall asleep.I have a pile of non-fiction books I never read because I can't find the motivation to read during the day. My brain is used to reading before bed and can't get motivated to do it at any other time during the day.I always thought that reading non-fiction before bed would be counterproductive since it...
I studied ECE but since the beginning I've been working as a Software engineer, as almost everybody from my promotion.Lately, I've been thinking about starting some hardware side projects. Despite my background I don't remember a thing about those years and would be great to start playing with smaller projects before jumping into something more complex.Are there any good resources on...
Honestly, I can't envision a near future where SQL is not the main interface. Happy to see the future proving me wrong here though!
Despite I can buy the arguments about how having a better data structure to communicate between processes (in the same server) could help, it's a bit difficult to wrap my mind around how Arrow will help in distributed systems (compared to any other performant data structure). Do you have any resources to understand the value proposal in that area?
Same for vector processing, would be great to read a bit more about some optimizations that would help improving Postgres leaving out pure analytical use cases.
Can you elaborate this? I understand it's a very opinionated statement but still I don't see how "polyglot" and "vector processing" could be considered the future of OLTP and general purpose DBMS.
During last years I started seeing less good answers, and discussions around that website.It's clear Google Search algorithm is favoring other websites. And probably AI and the new LLM models are being another reason devs will stop going directly to StackOverflow.What do you think? Will StackOverflow keep up, or will slowly dye?
SQL based databases are complex, and we have a vast amount of different flavors available.If someone fresh from university ask you for resources to understand basic concepts such as query parsing, query optimization, execution plans, etcWhat kind of resources will you share with them? I expect to see people here who have been developing complex database systems, how do you get started? How is...
Lately, I'm finding it particularly difficult to disconnect from work. I've tried deleting work apps from my phone, but I still find myself reinstalling them to check something.It's particularly annoying since I really want to disconnect and rest.What are your best tricks? Do you have any particular routine during holidays that allows you to completely forget about work?
Perhaps, that's the big thing to solve. Being attention/recognition dependants doesn't look like being a good professional.
I'm mid-thirties working in Software/Data Engineering. I've been working at different companies during the last decade, and currently making ~$120k, and hitting no more than 40h/week.I don't consider myself especially intelligent. Neither I'm dumb. I suffer from imposter syndrome from time to time, especially when I start a new job/challenge. I usually acknowledge these situations and manage to...
I've been trying different approaches such as subscribing to newsletters or using RSS readers to follow people I find interesting but not everything they write every time is interesting! Also, if you limit yourself to following people you've been reading before you probably end up not discovering new content.With the technology, amount of data, and algorithms we have currently should be pretty...