Finally some real software engineer who is making cool stuff. UA-cam 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 UA-cam 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.
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 UA-cam 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!
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 UA-cam channel explaining basic things will make you have more subs than explaining advanced 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!
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.
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.
This is fantastic. Great production quality, no nonsense clear explanations. A rare gem to find in programmer UA-cam. Congratulations on completing your project. I hope you'll continue to do it and be well rewarded for it!
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 UA-cam. Thanks for the realism! :D
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
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!
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 UA-cam 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.
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!
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!
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
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
Wow the UA-cam 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 👏
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 !
@@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 UA-cam. I bet you're going far
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 :)
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 !
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 🫡👨💻.
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.
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 🎉!
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!
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?
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.
This is an excellent video and I'm really happy to have found it. Last year I wanted to implement something similar and I went through the same pages you went through when you were doing the research but I didn't go too far. Excellent job!
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.
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!
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 🙌
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
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.
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
@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.
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
For my bachelor course in network systems, we had to write a multithreaded web server in C. It was brutal, even for someone who was used to C++ before, but I remember I learned a lot from it!
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.
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.
@@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
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!"
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!
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.
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.
If you don't mind my suggestion, please consider adding the simple expression "written in Rust" to the title, and you'll see the views go up exponentially, since Rust is currently a buzzword.
I know, you could be right but I want to decouple the programming language from the concepts that I explain, I didn't even mention Rust in the video. All the data structures and algorithms explained in the video can be implemented in any language. But still, I might add Rust to the title.
I'm certain your video is technically very rigorous , @@tony_saro. But for the sake of achieving a broader audience, those simple words in the title will add a lot more of interest.
Sure, I might give it a try, for now it's doing pretty well so it's not necessary, maybe later I'll change it to "Writing My Own Database in Rust" or something like that.
Hey Tony Saro, really good content you got there. I once had a POC project about sending digital data using acoustics, i could only spend 20 days from research to half-duplex transmission. But you show cased the atmost dedication to get the stuff done. That git push with commit "I dont know what i am doing", i felt that. I really find man.
Throwing a deadline on top of one of these projects will multiply the frustration by a factor of 10 😂. One day before submitting the assignment: Git push I don't know what I'm doing 💀
Amazing work dude. I had the idea to try to implement a database from scratch as well, but I always either didn't have time or was to lazy to start. I guess I'm gonna use this as motivation to get into harder and more complex CS problems.
Today is the first time UA-cam recommended your channel to me and really! I love what you do. You really did alot of hectic and complicated work in implementing that. I know, cause I am kinda a system programmer using C and visualizing what you did is just so damn awesome! You just earned a subscriber.
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.
Bro this is just pure gold and the resources you provided are damn , very helpful for the graduated students like me to understand databases internally .
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.
Amazing! There are coding tutorial channels and programming concept channels but next to none do what you did, explain it so well and illustrate it so wonderfully. Subscribed.
This video is spectacular and exactly what I was looking for. There is no other video on UA-cam 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).
Superb video. I use SQL every day, but I still learned a lot in this video, and will genuinely help me in my day-to-day. Also, you're super brave to take on making your own DBMS. Impressive!
What a masterpiece! I've been learning database internals for a about 4 month and know most of this things but it still suprise me.I beg you to keep making videos like this. It's a very useful video for everybody not excluding seniors developers. Thanks for your work. I also want to recommend some books to dive deeper into the topic. 1. Database internals 2. Postgresql 15 internal.
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.
I see you are only slowly (but fortunately surely) gaining traction on this video. I rarely sub on youtube, but man... you deserved it. I don't even code (I'm a project manager) and found your video so clear it merits a lot more likes and people watching it. Keep it up!
great video man. you did a really good job of explaining the concepts of each facet of your DB while keeping it accessible to those of us who are CS-challenged. I've certainly come away from it with a greater appreciation for database engineers.
Finally some real software engineer who is making cool stuff. UA-cam 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 👍
This was such a hidden gem.. lucky this came into my recommendation
I'm glad you liked the video. More coming soon.
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 UA-cam 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.
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 UA-cam 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
Finally found a real software engineer on UA-cam who builds cool stuff.
Junior SWE here. This was such a fun watch. Your channel is severely underrated!
Glad you liked the video, thanks for the comment.
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 UA-cam 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?
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!
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.
very rare to see a youtuber that use low level programming for content ❤🎉
im your new subscriber
Thanks for the sub
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.
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.
This is fantastic. Great production quality, no nonsense clear explanations. A rare gem to find in programmer UA-cam. Congratulations on completing your project. I hope you'll continue to do it and be well rewarded for it!
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 🤙
i've been wandering around youtube for a while but wait, ....how did i fall into this hidden treasure !?
Thanks to the UA-cam algorithm 📈🔥
Now this is real software engineering content that I'm looking for. Database engineers are on different level
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 UA-cam. Thanks for the realism! :D
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
random recommended video but it explains perfectly each concept and reasons behind decisions. Hidden gem!
UA-cam recommending some random stuff 🤙
@@tony_saro Im an engineer too and always wondered how databases are built so I happily clicked on it :D
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!
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 UA-cam 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.
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!
🫡🤙
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!
This is an amazingly edited and insightful video!
Thanks!
Thank you so much for it, really informative for a CS undergrad. I shared this with my friends. Keep it up, bro!
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
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
Wow the UA-cam 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 👏
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 !
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 UA-cam. I bet you're going far
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 :)
It showed up in my recommendation today when i try to make my own compiler 😄
Great video!
@@protonetwork6974 C compiler ? 😂
This video is insanely underrated... would love to see more real world projects like these!
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 🫡
Appreciate the effort you spent learning and sharing the DB internals
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
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.
Congrat bro, great project 👏👏👏👏 wow Rust, Query Plan, working with pages, transactions, MRU, etc 👌👌👌
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 🎉!
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
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
*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.
Extremely impressive, thank you for sharing the journey. Subscribed, look forward to more.
Finally some high quality content, keep up bro
Thanks, I will 👨💻🤙
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 😂
Hermano se cansó de los normies hispanos html css js y se cambió a la comunidad inglesa
😈😈😈
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.
This is an excellent video and I'm really happy to have found it. Last year I wanted to implement something similar and I went through the same pages you went through when you were doing the research but I didn't go too far.
Excellent job!
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.
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!
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 🙌
Good stuff! I'm glad that in the age of content spam you can still find high quality content on YT.
Very good idea, I often find looking at some low level detail actual help in doing high level staff in the long term
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
Awesome video! Very educational, informative, engaging, and inspiring! I'm looking forward to whatever else you decide to work on.
mad respect to you Tony!! You are truly the "One Man Army" in Software development!!
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.
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.
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
You came back, bro. Happy to see you again, your videos are really helpful and well explained
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 ....
So many concepts touched in one video, especially handling IO and the data structures. Loved it!
@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.
keep it up; your content is amazing and I am looking forward to see more and more videos from you !
What a productive way to learn complex topics and also sharing it. You are a real software engineer!
I was wondering where u've been all this time! Good to see u again.
We are so back😈
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
For my bachelor course in network systems, we had to write a multithreaded web server in C. It was brutal, even for someone who was used to C++ before, but I remember I learned a lot from it!
Love the series going in depth! Can't wait for part two!
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.
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.
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
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!"
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!
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.
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.
Great video, I'm surprised at the number of subscribers you have! The production is something I'd expect of a large channel
Let's just say I have some experience with UA-cam 😂🤙, glad you liked it.
@@tony_saro That spoiler went too far xD
Congrats, Tony !
That's a great and very impressive project, both on the technical side and on the didactic side, that deserves much more views.
If you don't mind my suggestion, please consider adding the simple expression "written in Rust" to the title, and you'll see the views go up exponentially, since Rust is currently a buzzword.
I know, you could be right but I want to decouple the programming language from the concepts that I explain, I didn't even mention Rust in the video. All the data structures and algorithms explained in the video can be implemented in any language. But still, I might add Rust to the title.
I'm certain your video is technically very rigorous , @@tony_saro. But for the sake of achieving a broader audience, those simple words in the title will add a lot more of interest.
Sure, I might give it a try, for now it's doing pretty well so it's not necessary, maybe later I'll change it to "Writing My Own Database in Rust" or something like that.
Good luck and congratulations for your great work @@tony_saro !
Hey Tony Saro, really good content you got there. I once had a POC project about sending digital data using acoustics, i could only spend 20 days from research to half-duplex transmission. But you show cased the atmost dedication to get the stuff done. That git push with commit "I dont know what i am doing", i felt that. I really find man.
Throwing a deadline on top of one of these projects will multiply the frustration by a factor of 10 😂. One day before submitting the assignment:
Git push I don't know what I'm doing 💀
@@tony_saro project, that is sprinkled with non-function group members give exponential trajectory to that frustration curve.
Thank you very much! I hope you keep up the good work.
Thank you so much
it's amazing how far Antonio Sarosi has gone with his curiosity and cunning
Amazing work dude. I had the idea to try to implement a database from scratch as well, but I always either didn't have time or was to lazy to start. I guess I'm gonna use this as motivation to get into harder and more complex CS problems.
Today is the first time UA-cam recommended your channel to me and really! I love what you do. You really did alot of hectic and complicated work in implementing that. I know,
cause I am kinda a system programmer using C and visualizing what you did is just so damn awesome! You just earned a subscriber.
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 is a really great teaching video for young pups to learn database fundamentals. Excellent, well done.
Bro this is just pure gold and the resources you provided are damn , very helpful for the graduated students like me to understand databases internally .
Thanks bro
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👍
Amazing! There are coding tutorial channels and programming concept channels but next to none do what you did, explain it so well and illustrate it so wonderfully. Subscribed.
This video is spectacular and exactly what I was looking for. There is no other video on UA-cam 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.
Superb video. I use SQL every day, but I still learned a lot in this video, and will genuinely help me in my day-to-day.
Also, you're super brave to take on making your own DBMS. Impressive!
What a masterpiece! I've been learning database internals for a about 4 month and know most of this things but it still suprise me.I beg you to keep making videos like this. It's a very useful video for everybody not excluding seniors developers. Thanks for your work. I also want to recommend some books to dive deeper into the topic.
1. Database internals
2. Postgresql 15 internal.
Sure I will make more of these, it's just that it takes a long time, these videos are very hard and tedious to make
Would you mind recommending a book or two on the topic of database fundamentals and internals?
Really great information delivery - concise, crisp, detailed, organized. And all in-depth, fundamental concepts. I love your style.
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
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.
I see you are only slowly (but fortunately surely) gaining traction on this video. I rarely sub on youtube, but man... you deserved it. I don't even code (I'm a project manager) and found your video so clear it merits a lot more likes and people watching it.
Keep it up!
Thank you
great video man. you did a really good job of explaining the concepts of each facet of your DB while keeping it accessible to those of us who are CS-challenged. I've certainly come away from it with a greater appreciation for database engineers.
Honestly, never commented on a vid before, but this is goated!!! make more of this, and make them as lengthy as possible, I will watch it all day.
Thank you.