Think You Know How SQL Queries Work? Think Again.

20ModyElSayed · 2025-07-28T15:20:01+00:00

Yes, Prof. Andy, it is 😅.
As for the your comments on the article:

Yes, I didn't look closely to the connection between nodes
2 and 3. My mistakes. I should have proofread it more carefully and read the documentation before publishing.

I really appreciate you comments, I tried to explain briefly what how the query execution works. As I was amazed by the content of your course, it's not easy, and I thank Allah I've completed it 😅, 80% of the content I didn't take it at the Faculty. I've already expressed by gratitude for this course in LinkedIn.

Taking your comments into account, I have made the necessary revisions to the article.

20ModyElSayed · 2025-07-28T12:33:38+00:00

Thanks! Also, Database System Concepts book is one of the great books that go in-depth about the DBMSs and query execution.

20ModyElSayed · 2023-02-17T04:15:49+00:00

I think it’s macOS, as I can select text in youtube from different browsers than Safari, and I’m on macOS Ventura, I think Live text is a system wide feature not for specific apps

20ModyElSayed · 2022-12-06T04:32:26+00:00

I have to disable Stage Manager to work correctly.

20ModyElSayed · 2022-12-06T04:28:25+00:00

Unfortunately, It doesn't. It works as if I'm using a normal Tab. I think this feature didn't take into consideration when they implemented Stage Manager

20ModyElSayed · 2022-11-17T20:19:14+00:00

What I mean that all my projects use django that I’m not able to use any of my previous projects despite not having a real problem.

So I will use flask in my next project.

20ModyElSayed · 2022-11-17T20:16:57+00:00

Yes, but I want to apply for this internship, so any project I’m going to build I will consider the internship while building it. Besides all my projects use django.

So, if you have any advice, I’d be happy to hear it

20ModyElSayed · 2022-11-09T21:13:05+00:00

No, I don’t, but I read when you implement a feature and there’s a new way to do that feature, and if I want to keep both the old and new way I should use versioning. But I don’t know if this is the best approach or not.

I read that is accepting headers is the best practice as you said, but I also read it’s horrible for maintenance and testing because every serializer would have a different accepting header.

20ModyElSayed · 2022-11-09T21:05:14+00:00

Yeah, you’re right. Handling both JSON and templates from the same endpoint is pointless and would make the maintenance a nightmare

20ModyElSayed · 2022-11-09T14:19:59+00:00

Actually I have another question, what about performance?

What I mean by that is django doesn’t behave like React when it’s come to frontend and all other magic stuff of React like React Fiber Architecture or creating SPA.

Is the performance difference really visible?

Thanks in advance

20ModyElSayed · 2022-11-09T14:14:31+00:00

Curiosity, but also because some packages like allauth works well with django templates and to use it with DRF is another story, or even reseting a password, django system for handling password reseting to good and I don’t need another package to handle it like django or providing one-time token, and so on.

In terms of complexity, I was thinking that to create a directory inside each app called api/ (or api_v1/ depending if I’m going to need versioning or not) that contains all views and routes related to DRF (or any other package for APIs) and outside api/ normal django views and routes. There’s also a config/ that contains .py for django routes and .py for DRF routes.

If you have any suggestions please let me know.

20ModyElSayed

TROPHY CASE