I’ve been making a project in zig 0.16 with Claude as a learning experiment. It’s a fairly non trivial project (BitTorrent compliant p2p downloader for model weights on top of huggingface xet) - whenever it doesn’t know the syntax or makes errors, it literally reads the standard library code to understand and fix it. The project works too!

yeah, I’ve noticed it do that too, it literally goes to the source and for all intents and purposes, “figures it out”

that’s why it sounds to me like these people commenting haven’t even used these models yet.

Agreed. I tried cline but roo code has been massively better at same tasks. The added features are also really nice.

I’ve honestly had consistently the opposite experiences for general questions. Also for images, Gemini just hallucinates crazily. ChatGPT even on free tier is giving perfectly correct answers, and I’m on Gemini pro. I canceled it yesterday because of this

Is remote from India a possibility?

No, unfortunately remote from India is not an option for these roles.

However we do have Engineering Manager and Software Engineer II roles open to India based engineers. They're also listed here: https://www.arcadia.com/careers

This is the exact problem I’ve been dealing with lately. As a dad of a toddler, can’t find any time for deep work for personal work. And that’s probably okay since family does take priority. Good strategies though, thanks.

Great article. The book Database Internals looks amazing. Are there any other such books that deep dive into internals?

Not a book, but I recommend the database class lectures from @apavlo's group at CMU.

https://www.youtube.com/c/cmudatabasegroup

All the classes (intro and advanced) are online, as well as presentations and lectures about industry products.

They are very useful.

Also, from a more high level theoretical CS and less physical-implementation focused POV, the "Alice" book ("Foundations of Databases") is amazing (though very dense and mathematical). Focuses on the relational algebra and Datalog (and the translation of that into the Rel Algebra). Getting print copies is hard now (my used copy arrived with a broken spine and pages falling out), but the entire book is online: http://webdam.inria.fr/Alice/

Another excellent DB textbook covering both theory and implementation is Weikum & Vossen:

https://www.google.com/books/edition/_/wV5Ran71zNoC?hl=en&gb...

In case you can't afford to donate $150 to Elsevier: https://www.dropbox.com/scl/fi/r0fros5y2kzeqv57v7myz/Transac...

There is a another famous one, focusing on Postgres: https://www.interdb.jp/pg/.

Is it available as a print or ebook?

addressed in the FAQ: https://www.interdb.jp/pg/faq.html. Short answer is no.

This is a good paper for a similar kind of overview: https://dsf.berkeley.edu/papers/fntdb07-architecture.pdf

Another book I found very useful (though this DI book is more modern) is Raghu Ramakrishnan Database Management Systems book.

Microsoft interviews are purely core CS stuff. I think even for 4-5 year experience guys they ask mostly data structures and algorithms.

Your experience in building the startup is highly valuable. If you're going to look for a job, you will be most likely asked architectural and system design related questions, with Data structures and algorithms problems for screening at some places. You will easily find a well paying job with your experience and portfolio, don't worry.

Hell, if they managed to muddle along at a startup for seven years (that is, it took seven entire years before it failed) they've probably picked up enough to be super valuable in non-programming roles. SEO, UX, (perhaps especially) product owner / strategist or (maybe) project manager. With that experience I think they're Doing It Wrong if they shoot for a software dev position, unless that's just really where they wanna be. They ought to consider agencies that have people in those roles (product strategist especially) if all else fails. Some are quite good.

Bonus: interviews for those positions are probably less stupid.

Agreed. A product owner or a product manager is what people in OP's position usually go for. And they draw very high salaries from what I've seen. Companies must desperately want people in OP's position.

Yeah unless you're going FAANG or finance that's a much, much nicer track to be on.

I've found podcasts to be incredible tools to induce sleep. It's very difficult to stay awake for me while listening to any podcast or audiobook. I really don't know how people do it.

I have to be engaged in something physical* to listen to podcasts/audiobooks. If I just try to listen, I inevitably fall asleep.

*I usually listen to audiobooks while I ride my bicycle to college.

Are there more great resources like this to learn finding, cleaning and structuring data? Would greatly appreciate it if someone could point me in a direction.

Hi!

I couldn't find much, that's why I stressed on it in the tutorial. Scraping is a fun hobby but it's extremely useful. I strongly suggest spending time using python's selenium and beautiful soup libraries. The former is good to automate pages with javascript elements, and the latter to parse HTML!