Finally some real software engineer who is making cool stuff. RUclips is flooded with too many leetcode tutorials.. finally someone is making cool stuff..
@@plaintext7288Judging by this tweet, I don't think he likes this kind of content 😂😂😂 x.com/tsoding/status/1802792064347668603?t=n07b-kEtMynM1VB8Ri2F-w&s=19
This man is a legend, I don't know how this man finds 7 months of consistency and makes it work by not leaving the project in the middle and moving to another project!
Probably at 0:15 I have paused the video, opened your channel in new tab. Subscribed, and back here. No one is there to touch these topics. I salute you for sharing your knowledge.
huge respect here, I am a rust engineer and its hard to find someone on YT actually building cool shit and not click-baiting just to create a todo application
@@tony_saro learning how it works is infinitely helpful though. I've never written a database before, but I do have real-world experience with quickly locating a CSV import issue because I had written my own CSV parser/writer/converter before. Even if you never use the database you've built, this knowledge is gold on its own.
@@tony_saro how would having a PhD be of help? My experience has been that degrees don't matter, especially with IT where basically all the information is online
@@jiauyjiauy3777 Databases are an advanced CS topic that people have been researching for decades. Those who wrote the databases we use in production dedicated a large part of their career to just databases. This is not Fullstack web dev where you can just hop into a RUclips tutorial and learn most of what you need in one evening if you're good at coding. Sure you can find information online but it's mostly papers or university lectures. It's not necessarily the "degree" itself that is of help, it's the years of dedication to databases.
@@tony_saro Game devs roll their own databases all the time. Its very simple compared to most of game dev. As long as you store persistent data and have a way to edit that data, you have made a data base. B trees and parsing query languages are optional, but many game devs use console commands to debug and edit data. Its not hard to make a database.
Not only is this actual, real software engineering, as other comments have made it clear, but your teaching method is incredible! You've managed to make me follow you on an incredibly high level technical conversation even though my current technical understanding is that of a measly junior web dev. I want you to know that every single second you spent creating all these visualizations, explanations and teaching patterns was well used and highly, highly appreciated. I expect many of those seconds were painful, as I have some video editing experience myself, but for every one of your sweat drops, the quality of this video sky rocketed! Thank you!
It's been 4 weeks since you released your video. Man, it is unfair that you have only 1.8k views. If I stumbled upon this video, then you will find your viewers. Keep doing this!!
That's how RUclips works at the beginning, it recommends videos slowly until it gathers enough data to determine whether the video is worth recommending to the masses. I have another channel with over 160K subs and that's what happened with that one. It's gonna be a hard journey, but I'm pretty sure it'll work out in the end. Anyway, I'm glad people like you are finding my videos. Stay tuned for more content like this!
This is fantastic. Great production quality, no nonsense clear explanations. A rare gem to find in programmer RUclips. Congratulations on completing your project. I hope you'll continue to do it and be well rewarded for it!
Good job! I did my PhD in this field so I know how hard this journey is. Today I don't even bother with B-Trees anymore. The scattershot of updates you get from rotations kill write performance and they're very poor for compression as data may change everywhere without warning. Pretty much every major DB developed since 2012 uses LSM (Log Structured Merge) Trees. They have their own issues of course but no more stupid rotations! I invite you to take a closer look at them, they're a really cool data structure.
Thank you for keeping the timelapse and explanation of the 7 months in the video and showing that it takes a lot of work and time to do stuff like this. Most videos just skips over the hardest part, which is committing to spending time doing something. Learning (and building) something useful is seldom the 1-2-3...Profit 5--minute-tutorials that is everything else on RUclips. Thanks for the realism! :D
Gracias Antonio! Estupenda iniciativa, algunos estábamos aburridos ya del nivel de habla hispana donde solo se habla de cosas muy básicas. Me quedo por aquí para seguirlo de cerca. Un abrazo.
@@mikepro500 Puede influir también pero yo no tengo la responsabilidad de hacer ese contenido, me imaginaba que me iban a llegar comentarios de este estilo, no me refiero al tuyo en concreto porque tú no me has mencionado a mí justamente pero para el que lo haga, lo único que puedo decir es que hablo en el idioma que me dé la gana. Aparte he hecho videos de este estilo en español también.
I stumbled on this...watched first 5 mins and subscribed immediately! My first time seeing a programming content that resonates with me so much Great job! Keep it coming bro
It is so sad that the Spanish community mostly talks about HTML, CSS, JS and PHP. So happy to see your new channel and such a great content. Subscribed.
@@matwadoesgames I don't blame them. For instance, in Latin America, focusing solely on learning fields other than web/mobile development, such as low-level programming or machine learning, is basically a death sentence (you aren't getting a job lol). Unless you're a genius, there are simply no opportunities available. Even in more advanced countries like the United States, such opportunities are limited and highly competitive. That's why it's wiser to start by mastering the most in-demand skills. Once you've established yourself in the job market, you can then consider transitioning to other fields if you wish.
That's a really interesting point. I have to say that chances of getting a job knowing common programming languages as you mention are more than knowing how to write a database engine from scratch. As Tony mentions, this video is basically reinventing the wheel, so I understand that other content might be useful for those who want to improve skills and get a job. On the other hand, having a RUclips channel explaining basic things will make you have more subs than explaining advanced stuff
@@GustavoPinho89 I might throw in some hard sounding "H" (una buena Jota salida de to el cuello 🇪🇸 XD) or stuff like that unintentionally, but you might be surprised I'm not even Spanish 😂. So the English accent is not 100% Spanish, more like 50%.
@@tony_saro but the Js and the Ss give a really nice personal touch to the whole thing. Not to mention that the content you're making is incredibly super duper amazing: great explanation, super intuitive animations, nice lighting, clear audio recording, good editing, no brain-dead printf("hello, world);. Approaching more advanced topics, such as a DB from scratch, is a niche that's extremely underserved here on RUclips. I bet you're going far
Bro, this video is amazing! I've recently became Senior Engineer and now I'm kinda getting fed up with the whole superficial Intern/Junior level RUclips tutorials' non-sense. But your video is truly in-depth. It's so satisfying for a somewhat experienced programmer on so many levels. Kudos to you!!!
Yeah I'm also tired of that kind of content, I'm also tired of webdev stuff and JavaScript. I just like systems programming so I'll reimplement everything I can and explain how it works, most programmers work on application development so they take systems for granted, but without the systems infrastructure nobody would be able to build anything.
In reality, creating a compiler isn't that hard of a work (I mean just to learn, not a production compiler). In my university, one of the classes is completely dedicated to learn how a compiler or a interpreter really works and the final project is building your own compiler for a professor designed language. Great video, I missed your Spanish videos!
Easily highest quality DB video I've came across in a while! I found you by coming across you in my feed, and I've shared it in my work slack as well! Nice content, dude! Sub earned!
Man this is pure gooold! I really was missing you in your spanish channel. But this is amazing! Thank you for this and for all the spanish content. I'm the kind of person that likes to learn the deep concepts of everything we use everyday and you have helped me learn about them. Muchas gracias!
Wow the RUclips algorithm recommend you in my main activity, and I said I remember this guy, wow, you change your content to English and I understand very well 👏
@22:26: I hadn't considered offsets. Seeking toward or away from offsets is used in many fundamental telecommunications and electronics platforms and protocols. It's a key, fundamental part of TCP/IP frame and packet inspection, for instance, as in before or after a Protocol Identifier field or after the CRC and checksums, especially for Variable-Length packets in realtime Media codecs and protocols (H.264, RTP, etc). I'm blown away by the amount of work you've put in to acquire this special knowledge. Hats off to you, sir, you deserve excellent employment and good business your way.
Also reminds me of file-management systems and protocols, and journaling, they deal with similar modification and recording challenges, as well. Really, really good video and education, here, we're blessed to have this... and free, too!
@@tony_saro One of my mid-term goals in reorienting to computer science and automation is to understand enterprise DNS database architecture and management. This covers a good arrangement of systems programming, application programming, and network programming for such high-throughout, high-concurrency security models. One of the reasons I was looking at both SQLite and Postgres was due to use in DNS backends. Yep... offsets are everywhere.. even in electronics cryptanalysis in both cipher block chaining as well as well as (more sophisticated) one time pads.
I've been looking for this kind of content for a long time, it's perfect ! You took a daunting project, learned all you could from it and created the perfect resource for those willing to do the same along the way. Thank you for this !
This is incredible. The commitment is the major aspect most of us lack. Watching videos like this make all of us motivated towards our ultimate goal; to do something for the humanity. That's why we all became programmers, right?
Really well bade video and very educational. At no point did i felt bored nor did my attention went else where during the whole video. Loved it. You have just gained a new subscriber !
Some seriously high quality and insightful content that i stumbled upon randomly at 2AM... Had an overall unproductive day but this video just made it super productive..keep up the good work mate 🎉!
Te sigo desde que empezaste la carrera, en el otro canal, but this is another level, ni si quiera me di cuenta que te lo habias creado. La explicación y el tema top, como siempre!
No he querido darle publicidad hasta comprobar que el canal funciona por su cuenta. Pero viendo cómo está yendo pronto lo anunciaré por Instagram y Twitter. Gracias por el apoyo durante tanto tiempo 💪🫡
@@tony_saro Tambien te sigo desde hace tiempo y se extrañaban tus videos en youtube. Cuando empece a verte justo empezaba la carrera de ciencia de la computacion y ya estoy al graduarme. Gracias por tu trabajo
I'm also writing my own database manager too, it's a pain and a mess, 😂 but more than my code, I'm sticking with the concepts I'm learning. As soon as the semester ends I plan to rewrite my code, if possible in Rust now that my current project is in C++, thank you very much for your content. 🎉
It's definitely a pain, this is the hardest project I've ever worked on, including personal projects and "professional" work. Maybe it's because I wanted to implement all the subsystems myself, in that case not only do you have to learn database concepts but also caching, parsing, etc. I have mixed feelings about Rust and low level code, I really like Rust for high level code but building low level abstraction is still a pain. Anyway, good luck with your DB 🫡👨💻.
You’re just doing everything I wanted to do after university, re invent and understand software and tools that most of developers use all the time. Respect bro 🙌
Thank you for this detailed but very clear and understandable overview of the architecture of a SQL database. I learned a lot, especially the things about "doesn't fit in the memory!"
I used to follow you in your previous channel, and honestly I was pretty upset that you stopped uploading videos. Such a pleasant surprise to find you here! New sub here and all the best, man :)
This is so cool , i'm so excited about the incoming stuff , dude don't ever ever think about anything other than making videos like this , this might sounds so selfish of me , but you are one of the legends
Just came across your channel by accident and this seems amazing! In my opinion reinventing the wheel is always a good learning method to understand how 'we' got to the point we are now. Keep it up!
Thank you for sacrificing half a year of your life my guy. I've always been interested in how these things are implemented and I'm glad to see I was right about some things but I learned a lot and will definitely be reading through that repo.
I'm very surprised that almost all of it I needed to do in my graduation! I'm a student from UFOP, Brazil and its delightful to see how my teachers were able to explain such concepts while we had to implement the code per ser
Honestly i enjoyed the way you're attacking your problems and how you are processing the project, i feel like i really can learn from you how to be a true engineer, keep going
@@tony_saro it's not clickbait if it's an accurate description! I've thought about doing this project before, but the sheer scope overwhelms me. So, it's interesting seeing how you tackled all of the hard problems
I was also working on something like this. I decided to do it because of your Spanish videos. I may share it when I'm done. I'm jealous be cause I found your videos learning to program when I was finishing university and, at first, it was cute but now you are so much better than me is embarrassing. You deserve all the success you are going to get because of your discipline.
This makes me truly appreciate the teams that developed databases especially opensource ones like postgres. Though it is not a tutorial but more of a quick rundown and demo of the project, but still a lot of new concepts can be learnt.
I have coded rudimentary NoSql db(s) and primitive OS(s), and have dreamed of leveling up like this, but I never got there, you have my respect. I hope some DB or backend company are hitting you up for job offers. You've got a bright future.
Dude, this is my first youtube comment ever in over 10 of usage. You did a great job, please keep up the good work because we need more creators who focus on system level content like you.
I immediately subscribed to your channel because that's the content and code I want to see. YT is full of "hello world" code, so please continue with this type of coding!
Man, I can't even remember how I started this video-it was two days ago. I just came back to the chrome tab (yeah, I’m that developer with hundreds of tabs open), hit play, and it’s a gem!
Very nice job drilling down into these concepts. Postgres is the gold standard OSS project and I was impressed with how you were able to explain concepts like how 8k pages work for both heap and indexes and how they're encoded. The entire "cache" issue then becomes relatively simple - either a page is in memory or not. How to evict a page when a new page is requested? LRU vs clock? All really neat concepts. The WAL also gives you PITR (point in time recovery) which is literal database time travel. How cool is that? And that's just the tip of the iceberg - parsing something like Java is simple - only 20'ish grammar rules. SQL has over a thousand! How then can the planner use relational algebra to come up with a reduced (and equivalent) query plan that is optimized? Again, nice work with this. Database technologies is the entire reason I entered the field of computer science and I'm glad you are having fun with this too.
this is the best video I watched in a long time, your presentation and way of talking and explaining is top notch. will definitely watch the next thing you release as soon as you do. thanks a lot for taking the time to document your journey and share it with us!
well earned subscribe and like ,i love this type of videos,deep dive into topics no bs... keep it up even making smaller projects but with this approach is awesome.
This is great content bro. I’ve got a job at an insurance company but so I don’t really get to work at it but my low level skills have decreased so much. I’m about to plunge into some C as a side project. Thinking about making my own basic web server from scratch. No where as good as you, but you frame of thinking is infectious and inspiring
How fantastic to find someone who also enjoys creating their own database. Excellent project, congratulations. I did this same process of creating my own database called LiteDB (written in C#). Congratulations for the initiative!
Your work is awesomely excellent, and I could watch the full video without a single thought of boredom all the way down to the end while learning new things.
wow, the fact that i needed a paper & a pen to store the information i got from this video is Gold. Thanks mate! ( As a 2.5 - years of experience Data Engineer ). You know, sometimes you may use software and tools daily but in order to get a deeper understanding of wtf you doing you need to consider some research on stuff like yours. Thanks again.
Very awesome, man! Coincidentally I just started writing my own database also for the learning experience. Although I'm doing it pretty blind so I can see what issues I run into going with "naive" implementations and then figure out how to solve those. I'm expecting my performance to be abysmal and see how to make optimizations afterwards.
This is straight forward and nothing gets in the way. Very engaging and clear. Appreciate the effort my friend. This will be valuable to a lot of people.
Fantastic video Tony. A great mix of enough info to get a 30000 foot view and enough detail where it matters, but crucially an understand of where to go for detail. Thanks for the repo as well :) Subbed and looking forward to diving into some more.
This video is spectacular and exactly what I was looking for. There is no other video on RUclips with this content. A suggestion: you touch on various concepts like parsers, multithreading, etc., in the time-lapse section. I think there is a lot of potential for cool videos diving deep into each of these topics, even though they are already touched upon in this video. Keep up the great work! Your channel is unique (no DB pun intended).
this is some shiny pokemon rarity level content here. so good! i've been a data engineer for many years and still learnt quite a bit from this video. PLEASE CONTINUE THIS SERIES, the peoples need more of this. ps: thank you and kudos for the dedication!
![Eminem - Fuel (feat. JID) [Official Lyric Video]](http://i.ytimg.com/vi/t5H_CewqpKA/mqdefault.jpg)
Finally some real software engineer who is making cool stuff. RUclips is flooded with too many leetcode tutorials.. finally someone is making cool stuff..
Time for some real shit 😂😂
Tsoding must be mentioned here!
@@plaintext7288Judging by this tweet, I don't think he likes this kind of content 😂😂😂
x.com/tsoding/status/1802792064347668603?t=n07b-kEtMynM1VB8Ri2F-w&s=19
@@tony_saro 😆😆😆😆
@@tony_saro i meant as another good swe channel!!!
First video on a channel is a 7-month project - you're a legend. Please continue!
Yeah, probably should have done something simpler 😂
@@tony_saroNo way!! Low effort content is a dime a dozen. I just subscribed hoping for the next banger video.
This man is a legend, I don't know how this man finds 7 months of consistency and makes it work by not leaving the project in the middle and moving to another project!
@@tony_saro No way! This just so good 👍
Probably at 0:15 I have paused the video, opened your channel in new tab. Subscribed, and back here. No one is there to touch these topics. I salute you for sharing your knowledge.
huge respect here, I am a rust engineer and its hard to find someone on YT actually building cool shit and not click-baiting just to create a todo application
You work on systems or backend APIs with Rust?
Rust engineer in what domain exactly?
@@stefanalecu9532 I work on crypto infrastructure
@@tony_saro A mix of both, a few APIs here and there and we work on an open source ethereum client
Brave. Databases are one of those areas of computer science that gifted experts spend their entire career on
They're very hard, I don't have a PhD in databases or anything like that, I don't even know what I'm doing 😂
@@tony_saro learning how it works is infinitely helpful though. I've never written a database before, but I do have real-world experience with quickly locating a CSV import issue because I had written my own CSV parser/writer/converter before. Even if you never use the database you've built, this knowledge is gold on its own.
@@tony_saro how would having a PhD be of help? My experience has been that degrees don't matter, especially with IT where basically all the information is online
@@jiauyjiauy3777 Databases are an advanced CS topic that people have been researching for decades. Those who wrote the databases we use in production dedicated a large part of their career to just databases. This is not Fullstack web dev where you can just hop into a RUclips tutorial and learn most of what you need in one evening if you're good at coding. Sure you can find information online but it's mostly papers or university lectures. It's not necessarily the "degree" itself that is of help, it's the years of dedication to databases.
@@tony_saro Game devs roll their own databases all the time. Its very simple compared to most of game dev. As long as you store persistent data and have a way to edit that data, you have made a data base. B trees and parsing query languages are optional, but many game devs use console commands to debug and edit data. Its not hard to make a database.
This was such a hidden gem.. lucky this came into my recommendation
I'm glad you liked the video. More coming soon.
Finally found a real software engineer on RUclips who builds cool stuff.
Not only is this actual, real software engineering, as other comments have made it clear, but your teaching method is incredible! You've managed to make me follow you on an incredibly high level technical conversation even though my current technical understanding is that of a measly junior web dev.
I want you to know that every single second you spent creating all these visualizations, explanations and teaching patterns was well used and highly, highly appreciated. I expect many of those seconds were painful, as I have some video editing experience myself, but for every one of your sweat drops, the quality of this video sky rocketed! Thank you!
It's been 4 weeks since you released your video. Man, it is unfair that you have only 1.8k views. If I stumbled upon this video, then you will find your viewers. Keep doing this!!
That's how RUclips works at the beginning, it recommends videos slowly until it gathers enough data to determine whether the video is worth recommending to the masses. I have another channel with over 160K subs and that's what happened with that one. It's gonna be a hard journey, but I'm pretty sure it'll work out in the end. Anyway, I'm glad people like you are finding my videos. Stay tuned for more content like this!
I got notification today
@@OmbasaMukhwami Looks like I was right then 🤙
It showed up in my recommendation today and I'm absolutely stunned 😳
Great video!
Let him cook bro, he will hit the algorithm and explode
This is fantastic. Great production quality, no nonsense clear explanations. A rare gem to find in programmer RUclips. Congratulations on completing your project. I hope you'll continue to do it and be well rewarded for it!
Junior SWE here. This was such a fun watch. Your channel is severely underrated!
Glad you liked the video, thanks for the comment.
When people tell me I'm smart I tell them that's not true because I know people like you exist. Bravo on this achievement.
I wouldn't say I'm smart, I'm just persistent enough.
Good job! I did my PhD in this field so I know how hard this journey is. Today I don't even bother with B-Trees anymore. The scattershot of updates you get from rotations kill write performance and they're very poor for compression as data may change everywhere without warning. Pretty much every major DB developed since 2012 uses LSM (Log Structured Merge) Trees. They have their own issues of course but no more stupid rotations! I invite you to take a closer look at them, they're a really cool data structure.
Now this is real software engineering content that I'm looking for. Database engineers are on different level
i've been wandering around youtube for a while but wait, ....how did i fall into this hidden treasure !?
Thanks to the RUclips algorithm 📈🔥
Thank you for keeping the timelapse and explanation of the 7 months in the video and showing that it takes a lot of work and time to do stuff like this. Most videos just skips over the hardest part, which is committing to spending time doing something. Learning (and building) something useful is seldom the 1-2-3...Profit 5--minute-tutorials that is everything else on RUclips. Thanks for the realism! :D
Gracias Antonio! Estupenda iniciativa, algunos estábamos aburridos ya del nivel de habla hispana donde solo se habla de cosas muy básicas. Me quedo por aquí para seguirlo de cerca. Un abrazo.
En la comunidad de habla hispana solo se habla de HTML, JS y PHP 😂
Mas bien se debería traer este tipo de contenido al español para que el nivel de habla hispana deje de ser tan básico ¿No? 🤔
El que vende se va donde más compradores hay 🤷🏼♂️, el problema del español no es que el nivel sea básico sino que esto no interesa.
@@tony_saro hay poco interés por la misma razón de que hay poco contenido en español. 🤷🏻♂️
@@mikepro500 Puede influir también pero yo no tengo la responsabilidad de hacer ese contenido, me imaginaba que me iban a llegar comentarios de este estilo, no me refiero al tuyo en concreto porque tú no me has mencionado a mí justamente pero para el que lo haga, lo único que puedo decir es que hablo en el idioma que me dé la gana. Aparte he hecho videos de este estilo en español también.
Wow, this is really something. You’re incredibly talented, Tony. Look forward to seeing what else you create.
Thanks, I got some videos already planned, I'll work on them as soon as I can. Stay tuned 🤙
very rare to see a youtuber that use low level programming for content ❤🎉
im your new subscriber
Thanks for the sub
I stumbled on this...watched first 5 mins and subscribed immediately!
My first time seeing a programming content that resonates with me so much
Great job! Keep it coming bro
It is so sad that the Spanish community mostly talks about HTML, CSS, JS and PHP. So happy to see your new channel and such a great content. Subscribed.
Im also from an spanish speaking country and every "programmer" is a fkin react dev, i just want to do my golang stuff and find resources
@@matwadoesgames I don't blame them. For instance, in Latin America, focusing solely on learning fields other than web/mobile development, such as low-level programming or machine learning, is basically a death sentence (you aren't getting a job lol). Unless you're a genius, there are simply no opportunities available. Even in more advanced countries like the United States, such opportunities are limited and highly competitive. That's why it's wiser to start by mastering the most in-demand skills. Once you've established yourself in the job market, you can then consider transitioning to other fields if you wish.
That's a really interesting point. I have to say that chances of getting a job knowing common programming languages as you mention are more than knowing how to write a database engine from scratch. As Tony mentions, this video is basically reinventing the wheel, so I understand that other content might be useful for those who want to improve skills and get a job.
On the other hand, having a RUclips channel explaining basic things will make you have more subs than explaining advanced stuff
This guy is native speaker spanish
There are no jobs for distributed systems, microservices, etc?
random recommended video but it explains perfectly each concept and reasons behind decisions. Hidden gem!
RUclips recommending some random stuff 🤙
@@tony_saro Im an engineer too and always wondered how databases are built so I happily clicked on it :D
*I remember when I wrote my first database system from scratch in the 1990s*
I was sooo proud of myself as a 22 year old.
This video is insanely underrated... would love to see more real world projects like these!
Escuchar a Antonio hablando en ingles da 10 años más de vida
He's got the cool Spanish accent, though. "How to order una pinta de Turya from the terminal " 😂😂😂😂😂😂
@@GustavoPinho89 XDDDDDD
@@GustavoPinho89 I might throw in some hard sounding "H" (una buena Jota salida de to el cuello 🇪🇸 XD) or stuff like that unintentionally, but you might be surprised I'm not even Spanish 😂. So the English accent is not 100% Spanish, more like 50%.
@@tony_saro but the Js and the Ss give a really nice personal touch to the whole thing. Not to mention that the content you're making is incredibly super duper amazing: great explanation, super intuitive animations, nice lighting, clear audio recording, good editing, no brain-dead printf("hello, world);. Approaching more advanced topics, such as a DB from scratch, is a niche that's extremely underserved here on RUclips. I bet you're going far
Bro, this video is amazing! I've recently became Senior Engineer and now I'm kinda getting fed up with the whole superficial Intern/Junior level RUclips tutorials' non-sense. But your video is truly in-depth. It's so satisfying for a somewhat experienced programmer on so many levels. Kudos to you!!!
Yeah I'm also tired of that kind of content, I'm also tired of webdev stuff and JavaScript. I just like systems programming so I'll reimplement everything I can and explain how it works, most programmers work on application development so they take systems for granted, but without the systems infrastructure nobody would be able to build anything.
In reality, creating a compiler isn't that hard of a work (I mean just to learn, not a production compiler). In my university, one of the classes is completely dedicated to learn how a compiler or a interpreter really works and the final project is building your own compiler for a professor designed language. Great video, I missed your Spanish videos!
Easily highest quality DB video I've came across in a while! I found you by coming across you in my feed, and I've shared it in my work slack as well! Nice content, dude! Sub earned!
Man this is pure gooold! I really was missing you in your spanish channel. But this is amazing! Thank you for this and for all the spanish content. I'm the kind of person that likes to learn the deep concepts of everything we use everyday and you have helped me learn about them. Muchas gracias!
🫡🤙
it's amazing how far Antonio Sarosi has gone with his curiosity and cunning
Wow the RUclips algorithm recommend you in my main activity, and I said I remember this guy, wow, you change your content to English and I understand very well 👏
Thank you so much for it, really informative for a CS undergrad. I shared this with my friends. Keep it up, bro!
This is an amazingly edited and insightful video!
Thanks!
@22:26: I hadn't considered offsets. Seeking toward or away from offsets is used in many fundamental telecommunications and electronics platforms and protocols.
It's a key, fundamental part of TCP/IP frame and packet inspection, for instance, as in before or after a Protocol Identifier field or after the CRC and checksums, especially for Variable-Length packets in realtime Media codecs and protocols (H.264, RTP, etc).
I'm blown away by the amount of work you've put in to acquire this special knowledge. Hats off to you, sir, you deserve excellent employment and good business your way.
Also reminds me of file-management systems and protocols, and journaling, they deal with similar modification and recording challenges, as well.
Really, really good video and education, here, we're blessed to have this... and free, too!
Yep offsets are everywhere, they are present in the project for my next video as well 🤣
@@tony_saro One of my mid-term goals in reorienting to computer science and automation is to understand enterprise DNS database architecture and management. This covers a good arrangement of systems programming, application programming, and network programming for such high-throughout, high-concurrency security models.
One of the reasons I was looking at both SQLite and Postgres was due to use in DNS backends.
Yep... offsets are everywhere.. even in electronics cryptanalysis in both cipher block chaining as well as well as (more sophisticated) one time pads.
It showed up in my recommendation today when i try to make my own compiler 😄
Great video!
@@protonetwork6974 C compiler ? 😂
I've been looking for this kind of content for a long time, it's perfect ! You took a daunting project, learned all you could from it and created the perfect resource for those willing to do the same along the way. Thank you for this !
Congrat bro, great project 👏👏👏👏 wow Rust, Query Plan, working with pages, transactions, MRU, etc 👌👌👌
This is incredible. The commitment is the major aspect most of us lack. Watching videos like this make all of us motivated towards our ultimate goal; to do something for the humanity. That's why we all became programmers, right?
Maybe that's why 😂
Genuinely an amazing format of video. I know the algorithm doesn’t like this format but as a watcher it’s helpful and technical. Big fan!
Short & quick content is popular today but things like podcasts still work, I think this kind of content does have its place
@@tony_saro Me too! I’m thankful it does
This is a really great teaching video for young pups to learn database fundamentals. Excellent, well done.
Really well bade video and very educational. At no point did i felt bored nor did my attention went else where during the whole video. Loved it. You have just gained a new subscriber !
That's incredible considering the video is 42 minutes 🫡
Some seriously high quality and insightful content that i stumbled upon randomly at 2AM... Had an overall unproductive day but this video just made it super productive..keep up the good work mate 🎉!
Te sigo desde que empezaste la carrera, en el otro canal, but this is another level, ni si quiera me di cuenta que te lo habias creado. La explicación y el tema top, como siempre!
No he querido darle publicidad hasta comprobar que el canal funciona por su cuenta. Pero viendo cómo está yendo pronto lo anunciaré por Instagram y Twitter. Gracias por el apoyo durante tanto tiempo 💪🫡
@@tony_saro Tambien te sigo desde hace tiempo y se extrañaban tus videos en youtube. Cuando empece a verte justo empezaba la carrera de ciencia de la computacion y ya estoy al graduarme. Gracias por tu trabajo
Toca aprender ingles porque estos videos son muy top, gracias Antonio
mad respect to you Tony!! You are truly the "One Man Army" in Software development!!
I'm also writing my own database manager too, it's a pain and a mess, 😂 but more than my code, I'm sticking with the concepts I'm learning. As soon as the semester ends I plan to rewrite my code, if possible in Rust now that my current project is in C++, thank you very much for your content. 🎉
It's definitely a pain, this is the hardest project I've ever worked on, including personal projects and "professional" work. Maybe it's because I wanted to implement all the subsystems myself, in that case not only do you have to learn database concepts but also caching, parsing, etc. I have mixed feelings about Rust and low level code, I really like Rust for high level code but building low level abstraction is still a pain. Anyway, good luck with your DB 🫡👨💻.
@@tony_saro I'd love a video of you discussing this in more detail. Rust is such an interesting language but there seem to be a lot of caveats
Thank you very much! I hope you keep up the good work.
Thank you so much
Finally some high quality content, keep up bro
Thanks, I will 👨💻🤙
You’re just doing everything I wanted to do after university, re invent and understand software and tools that most of developers use all the time. Respect bro 🙌
Hermano se cansó de los normies hispanos html css js y se cambió a la comunidad inglesa
😈😈😈
Awesome video! Very educational, informative, engaging, and inspiring! I'm looking forward to whatever else you decide to work on.
Thank you for this detailed but very clear and understandable overview of the architecture of a SQL database. I learned a lot, especially the things about "doesn't fit in the memory!"
I used to follow you in your previous channel, and honestly I was pretty upset that you stopped uploading videos. Such a pleasant surprise to find you here! New sub here and all the best, man :)
finally got someone who really make core cs fundamentals stuff. It is the extract of the hard-work of 7 months. Thank You for developing ....
This is so cool , i'm so excited about the incoming stuff , dude don't ever ever think about anything other than making videos like this , this might sounds so selfish of me , but you are one of the legends
Just came across your channel by accident and this seems amazing! In my opinion reinventing the wheel is always a good learning method to understand how 'we' got to the point we are now.
Keep it up!
Exactly
Good stuff! I'm glad that in the age of content spam you can still find high quality content on YT.
Thank you for sacrificing half a year of your life my guy. I've always been interested in how these things are implemented and I'm glad to see I was right about some things but I learned a lot and will definitely be reading through that repo.
I'm very surprised that almost all of it I needed to do in my graduation! I'm a student from UFOP, Brazil and its delightful to see how my teachers were able to explain such concepts while we had to implement the code per ser
Honestly i enjoyed the way you're attacking your problems and how you are processing the project, i feel like i really can learn from you how to be a true engineer, keep going
Implementing my own GFS in golang but looking at this being built in Rust is crazy.
Another level to aim at.
You are definitely a legend.
Fantastic example and great use of the maximum "just because I can doesn't mean I should". Can't wait to show this to all my buddies for a solid laugh
Exactly, just because you can it doesn't mean you should 😂
❤It is really appreciated you said "I don't know ..." but you can finally find how to know them. 🎉
I was skeptical about this video from the title, but it's the real deal. Impressive project, and impressive explanation of everything you did.
Well since the channel was completely new and nobody knows me here I gotta clickbait a little 😂. Now that you know what I do you won't be skeptical.
@@tony_saro it's not clickbait if it's an accurate description! I've thought about doing this project before, but the sheer scope overwhelms me. So, it's interesting seeing how you tackled all of the hard problems
Extremely impressive, thank you for sharing the journey. Subscribed, look forward to more.
So many concepts touched in one video, especially handling IO and the data structures. Loved it!
keep it up; your content is amazing and I am looking forward to see more and more videos from you !
I was also working on something like this. I decided to do it because of your Spanish videos. I may share it when I'm done. I'm jealous be cause I found your videos learning to program when I was finishing university and, at first, it was cute but now you are so much better than me is embarrassing. You deserve all the success you are going to get because of your discipline.
This makes me truly appreciate the teams that developed databases especially opensource ones like postgres. Though it is not a tutorial but more of a quick rundown and demo of the project, but still a lot of new concepts can be learnt.
I have coded rudimentary NoSql db(s) and primitive OS(s), and have dreamed of leveling up like this, but I never got there, you have my respect. I hope some DB or backend company are hitting you up for job offers. You've got a bright future.
You came back, bro. Happy to see you again, your videos are really helpful and well explained
Dude, this is my first youtube comment ever in over 10 of usage. You did a great job, please keep up the good work because we need more creators who focus on system level content like you.
I will, thanks.
Finally, something i love. I dont like abstractions because i want to know what's happening behind the scene....Thanks for this ❤❤❤
What a productive way to learn complex topics and also sharing it. You are a real software engineer!
Appreciate the effort you spent learning and sharing the DB internals
This is amazing. Glad I stumbled upon your channel in the sea of the same boring trivial tutorials. Looking forward to seeing more
I woke up , opened youtube
Saw the title , got curious and open the vd
That was the best yt suggestion ever
It is really cool to see someone developed from scratch.
You are the real gangsta for having done all this. Extremely helpful, nice job man👏!
I immediately subscribed to your channel because that's the content and code I want to see. YT is full of "hello world" code, so please continue with this type of coding!
Man, I can't even remember how I started this video-it was two days ago. I just came back to the chrome tab (yeah, I’m that developer with hundreds of tabs open), hit play, and it’s a gem!
Very nice job drilling down into these concepts. Postgres is the gold standard OSS project and I was impressed with how you were able to explain concepts like how 8k pages work for both heap and indexes and how they're encoded. The entire "cache" issue then becomes relatively simple - either a page is in memory or not. How to evict a page when a new page is requested? LRU vs clock? All really neat concepts. The WAL also gives you PITR (point in time recovery) which is literal database time travel. How cool is that?
And that's just the tip of the iceberg - parsing something like Java is simple - only 20'ish grammar rules. SQL has over a thousand! How then can the planner use relational algebra to come up with a reduced (and equivalent) query plan that is optimized?
Again, nice work with this. Database technologies is the entire reason I entered the field of computer science and I'm glad you are having fun with this too.
Very good idea, I often find looking at some low level detail actual help in doing high level staff in the long term
this is the best video I watched in a long time, your presentation and way of talking and explaining is top notch. will definitely watch the next thing you release as soon as you do. thanks a lot for taking the time to document your journey and share it with us!
Very well done! Kudos! This is like a time machine to an era where people didn't fear learning.
True, makes even more sense nowadays with AI
This was awesome and super refreshing. Not a lot of quality mid level SWE content out there!!
Thanks for your effort!
well earned subscribe and like ,i love this type of videos,deep dive into topics no bs...
keep it up even making smaller projects but with this approach is awesome.
This is great content bro. I’ve got a job at an insurance company but so I don’t really get to work at it but my low level skills have decreased so much. I’m about to plunge into some C as a side project. Thinking about making my own basic web server from scratch. No where as good as you, but you frame of thinking is infectious and inspiring
Really great information delivery - concise, crisp, detailed, organized. And all in-depth, fundamental concepts. I love your style.
writing a db engine is a crazy quest. my compliment to you as you do it alone. someone dies in trying this
How fantastic to find someone who also enjoys creating their own database. Excellent project, congratulations. I did this same process of creating my own database called LiteDB (written in C#). Congratulations for the initiative!
Awesome video. Congrats, Toni!
Your work is awesomely excellent, and I could watch the full video without a single thought of boredom all the way down to the end while learning new things.
wow, the fact that i needed a paper & a pen to store the information i got from this video is Gold. Thanks mate! ( As a 2.5 - years of experience Data Engineer ). You know, sometimes you may use software and tools daily but in order to get a deeper understanding of wtf you doing you need to consider some research on stuff like yours. Thanks again.
You're welcome👍
Definitely found a highly prized niche to stand out against the other multitude of coding channels! I look forward to your insights!
Very awesome, man! Coincidentally I just started writing my own database also for the learning experience. Although I'm doing it pretty blind so I can see what issues I run into going with "naive" implementations and then figure out how to solve those. I'm expecting my performance to be abysmal and see how to make optimizations afterwards.
This is straight forward and nothing gets in the way. Very engaging and clear. Appreciate the effort my friend. This will be valuable to a lot of people.
Fantastic video Tony. A great mix of enough info to get a 30000 foot view and enough detail where it matters, but crucially an understand of where to go for detail. Thanks for the repo as well :) Subbed and looking forward to diving into some more.
This video is spectacular and exactly what I was looking for. There is no other video on RUclips with this content. A suggestion: you touch on various concepts like parsers, multithreading, etc., in the time-lapse section. I think there is a lot of potential for cool videos diving deep into each of these topics, even though they are already touched upon in this video. Keep up the great work! Your channel is unique (no DB pun intended).
There is some potential for them, I made a video about the sorting algorithm.
Love the series going in depth! Can't wait for part two!
this is some shiny pokemon rarity level content here. so good! i've been a data engineer for many years and still learnt quite a bit from this video. PLEASE CONTINUE THIS SERIES, the peoples need more of this. ps: thank you and kudos for the dedication!
Shiny pokemon rarity level 😂. Thank you man, I will continue with this series for sure.