I totally love your attitude when it comes to building things that you don’t necessarily need to, because there are these already made app suites (a.k.a Google) that you could comfortably just plug in to. The attitude I’m referring to is “for the sake of learning and building your skill set and experience”, which I can totally relate to. I have the same attitude when I dive into the world of Powershell, which I’m in love with for some reason. Thanks to that attitude I’ve learned to build my own tools as an IT technician and also share tools with my team that automate things for everybody. Boy, what a feeling that is! Keep ‘em comin’ Kalle!
Just wanted to say, i built my own database and now I have a full time job as a junior Python dev. You gave me the idea, it took me 3 months to build and I’m still adding to it! You’re an inspiration to us all
This reminds me of a personal project I did a few years ago. I used Google Apps Script and their built-in SQL database API to make a bookmark/note manager. I wanted a simple tool for storing notes and bookmarked webpages with the key feature being unlimited tags, so that I could organize the notes across different dimensions (kind of like a graph database). It also included a bookmarklet I could click in the browser to bring up a dialogue to enter tags and additional notes when saving a page. I was pretty happy with the app, but abandoned it because the database API was quite buggy and poorly documented. But Apps Script is a pretty fun tool to play with- especially if you want to turbocharge your Google documents. And maybe the database API is better by now!
I think there is step right before this which is understanding which tables you will need in order to then be able to write your database. You can do the reverse discovery, blind man through a room with furniture, but if you plan ahead you’re much better off. Using other software first to understand what your needs will be helps a lot.
Really interesting video. As a beginner in Python, everything still seems a bit much, but I think the purpose of such a database is well explained. I'm looking forward to trying it out for myself and growing with the challenge
Nice Juggling Start 🎇🎇Support From India!! Your intros are always so intricate an insane!! You learn and show us new things in every intro🔥🔥. Awesome Video. 👏🏽👏🏽👏🏽👏🏽👍🏽👍🏽👍🏽👍🏽
Wow, got lost in Derek's website reading up on everything I'm experiencing in my early understanding and learning.... Your vlogs are the best on RUclips. Thank you !
watched your database video and started implementing it in my life. it has made me more organized and efficient and is a very good idea ! works very nicely on the productivity app notion
Yes! Do it now! my main regret is not having started early to study software development or something related to computer science. I wish I was 13 again!
I built a database to track my trading by uploading brokerage statements. That lead me to get a job where I created a client portal database to track portfolios. Big W.
Why have I never thought about this before? It's such a simple idea (of course not so simple to implement) and it's incredible the way this motivated me to work and learn the skills I need as a tech student but never found a motivating project to help me get started. Thanks a lot for the video!
"what the person does and their information", that's some CIA level shit right there. All jokes aside this is pretty cool, time to try it on a raspberry pi!
@@hariramnarayanan5157 his data is at risk, it's microsoft. forever license means nothing, you own nothing with microsoft(it's all rental). go linux/bsd
Great video Kalle. You can also build your own datalake (unstructured database) in AWS S3 which is a great side project if you're looking to improve your Python (using Boto3) and your cloud knowledge!
Lol up until you mentionned using PostgreSQL, I thought by „building your own database“ you meant implementing it by yourself, from the file system up to the SQL progessor.
So yeah, I wrote a little python script and was messing around with a personal sqlite thingy recently as well. my reasons for it were actually everything you outlined in this video. so weird. I did get stuck and didn't know where to go from there, but i think you just gave me an idea on how to get past this coding "writers block". thanks man. I just subscribed to your other channel. didn't know until now you had one.
the self's ideas is really great and I think that in social distance times I can do that project but I'm just a sophomore, do not have much experience so hope you can build the vlog to show how to create your own database. Thank you so much
I’m actually building a password manager rn similar to the one did where it has the MySQL backend and Python front end. It’s been really fun so I definitely feel like this database could be a really fun project!
Hmm, I think starting with storage first (the DB) is an interesting approach. I would rather implement my UI and APIs first and postpone the decision on the DB after it becomes clear what the system needs to do. Because if you do this as a passion project you will get even better ideas once you‘ve started building it. Changing the DB could become more and more challenging.
I planned to create a mySQL-DB which I can interact with on a self crwated Browser-Interface running at my raspi. Thank you for the video, it made me start the project
@@BramVanhautte No, that was the reason I stopped the project not much later I began, I have to use quite a few tricks to get it work. When I dont forget it I will tell you which tricks I used
try to find one of your cat pictures in your hdd collection with a keyword. if you db as you add it you can search and have a web page result with a link to it.
@yoshi105 wrote, _"I feel like most people would spend 98% of the time building a database and 2% actually using it"_ The utility of a thing isn't related to how often the thing is used. It's utility is measured by how much time one saves using it vs not using it. But, even if we ignore that heurisitic, the element of doing it for the sake of learning and growing one's technical and professional skills is its own reward.
11:07 Whatsapp isn't a database, at least not in the sql sense. It has end-to-end encryption so all data is stored locally. The client probably just sends the private key to facebook so they most likely do have all messages/people etc in a database but they wouldn't tell you that
The general term for this type of personal database is "PKM - Personal Knowledge Management". If you start researching that, that you'll go down the rabbit hole of this whole concept… ;) And yes: there are plenty of tools for that ("H&M-style") or you can build one yourself around a database system. :)
I like the idea of having a database, but im not a coder, and have no interest at all in being one. Are there any such packages that handle this for you.
I hope Kally would not store me in his DB after this comment. While I like the idea behind the video. Be aware that storing personal info (PII) in a database that is not known for being secure and reliable is a road to catastrophe. And It might be just illegal from a GDPR standpoint. So make sure you get another person's consent.
In my opinion Notion give me the possibility to customise as much as i need something that i feel to name as db. As for personal skills if Building It Is a source of motivation, obviously go for It.
i am surprised you use notion in the first place considering you are watching this channel, which is really focused on security. Notion is like the worse note taking app out there for security.
Why are you comparing Google Drive (a cloud storage provider) with PostgresSQL? Those are completely different things. And a "tailored especially for you" database doesn't have to be full blown SQL, for the usecases you mentioned a simple Excel spreadsheet would do.
If you wanted to replace ants with a different insect. what features would you engineer your usurper insect to have? what behaviours would you engineer them to have? So they would, 1) beat out ants, ants are gone. Your (the new insect that you created) insect, it rules the ant world now but also not so effective they screw up the food chain.
Hope you liked the intro, I’m not kidding it took 4 hours to film
You are an all rounder brother ❤🤗
Damn, going back to your roots
what hardware is needed please
4 hrs 😂 😂 😂 😂 No way 😂 😂 😂 😂 😂 😂 😂 😂 😂 😂 😂 lol!
I don't like it, I love it 😍💚
My guy rocking that Eren Yeager haircut
Eren .. YEAAGER
Aaron Yoghurt ftw
Eren… YEAGER!
more like a Eren yeagayy
he jus has long hair…
I don't know if I need a DB, but I definitely need to know how to juggle
Admit it, you wanted too to be the most popular kid in school :D
@@phaberest_ :)
Lol XD
Me: "Hi bro, what is ur name?"
He: "I'm Bryan, and u?"
Me: "Wait a minute, let me store ur name ..."
He: 🙄
Bruh 🤣🤣
😂
hahaha great comment
😂😂
😂 😂 😂 😂
I totally love your attitude when it comes to building things that you don’t necessarily need to, because there are these already made app suites (a.k.a Google) that you could comfortably just plug in to. The attitude I’m referring to is “for the sake of learning and building your skill set and experience”, which I can totally relate to. I have the same attitude when I dive into the world of Powershell, which I’m in love with for some reason. Thanks to that attitude I’ve learned to build my own tools as an IT technician and also share tools with my team that automate things for everybody. Boy, what a feeling that is!
Keep ‘em comin’ Kalle!
Just wanted to say, i built my own database and now I have a full time job as a junior Python dev. You gave me the idea, it took me 3 months to build and I’m still adding to it! You’re an inspiration to us all
Don't tell me your database is single threaded.
For a moment I tought he was talking about creating a db software from scratch! LOL
Yeah same 😂
same lel .... its just use a DBMS (Database Management system)
Same 😂
Same lol I've been watching cherno rn I thought he got on the same kick
Are you still confused about what's the relation between juggling, being famous in school, and having a personal database?
I am with you!
I love this comment. 😂
as juggling makes you a bit more famous in school, having a in house DB makes you the cool dev "i have my own database in my house"
@@iagod6660 AND I HAVE MY DATABASE IN CLOUDS!!!!!!!!!!!
@@yt_prakhartiwari0 backups are never enough, and (at least me) you probably have some data you don't want any company having access
@@iagod6660 If you don’t want them seeing your data, just encrypt it
Skills!
This reminds me of a personal project I did a few years ago. I used Google Apps Script and their built-in SQL database API to make a bookmark/note manager. I wanted a simple tool for storing notes and bookmarked webpages with the key feature being unlimited tags, so that I could organize the notes across different dimensions (kind of like a graph database). It also included a bookmarklet I could click in the browser to bring up a dialogue to enter tags and additional notes when saving a page. I was pretty happy with the app, but abandoned it because the database API was quite buggy and poorly documented. But Apps Script is a pretty fun tool to play with- especially if you want to turbocharge your Google documents. And maybe the database API is better by now!
I use notion for keeping all my knowledge and keeping up with my study
Bro.. your editing skills are pristine 🤯
His videos are really well made, surprises us everytime with the intro, the intro animation looks sick too and the main content is great too!
I think there is step right before this which is understanding which tables you will need in order to then be able to write your database. You can do the reverse discovery, blind man through a room with furniture, but if you plan ahead you’re much better off. Using other software first to understand what your needs will be helps a lot.
Really interesting video. As a beginner in Python, everything still seems a bit much, but I think the purpose of such a database is well explained. I'm looking forward to trying it out for myself and growing with the challenge
I had just started learning databases.. but I didn't realise I could build my own APIs and an app too!
Oh damn I didn't even think of that - it would be super cool to have your own APIs and have different apps that call them :o
That one dev who's so cool to use a Linux based machine for development. Thanks for this video Kalle, much love 😍
Nice Juggling Start 🎇🎇Support From India!! Your intros are always so intricate an insane!! You learn and show us new things in every intro🔥🔥. Awesome Video. 👏🏽👏🏽👏🏽👏🏽👍🏽👍🏽👍🏽👍🏽
Wow, got lost in Derek's website reading up on everything I'm experiencing in my early understanding and learning.... Your vlogs are the best on RUclips. Thank you !
This has been heavy on my mind definitely a project I’ll embark for sure. Thanks for this
watched your database video and started implementing it in my life. it has made me more organized and efficient and is a very good idea ! works very nicely on the productivity app notion
I've tried looking for it, but i can't seem to find it, anyone can help me find the video?
I'm just here to see why I need a database.
to store data bruh
@@usernametaken3098 Wow! Can you do that? Amazing.
@@realsemig ikr
This is such a great idea, am excited to have my own database now, all the best mate, love your work!!
I totally loved this idea! I always wanted to build something of my own which I'll can customise the way I want. I'll definitely do this!
I am 13 years old, so I just found this video at the perfect age. Better start early! :D
Thank you for the inspirational video.
Keep up bro
Nice. Keep it up! XD
Go for it kid.
Yes! Do it now! my main regret is not having started early to study software development or something related to computer science. I wish I was 13 again!
@@eeebeltran5445 same here. If only I had someone to tell me programming is something no one should be afraid of. :(
nice juggle start.✌️
I built a database to track my trading by uploading brokerage statements. That lead me to get a job where I created a client portal database to track portfolios. Big W.
Why have I never thought about this before? It's such a simple idea (of course not so simple to implement) and it's incredible the way this motivated me to work and learn the skills I need as a tech student but never found a motivating project to help me get started. Thanks a lot for the video!
ok flexing on us with that intro! Also really good analogy about google drive being like h&m, great video!
"what the person does and their information", that's some CIA level shit right there.
All jokes aside this is pretty cool, time to try it on a raspberry pi!
I deploy my database in form of an Excel-sheet. Into production :)
I also like to live dangerously.
@@mscpl1681 why do you say it's dangerous lol ? pls explain
Excellent
@@hariramnarayanan5157 his data is at risk, it's microsoft. forever license means nothing, you own nothing with microsoft(it's all rental). go linux/bsd
That was the best intro EVER! Keep up the good work, your videos are great
Great video Kalle. You can also build your own datalake (unstructured database) in AWS S3 which is a great side project if you're looking to improve your Python (using Boto3) and your cloud knowledge!
Before even starting the video I have said it before I will say it again Kalle has the best intro I've seen on internet, back to the video
This channel is pure gold 🤍
I just love the music at the beginning of contents. GIves me confidence!!
This, yes. Thanks for the push. Upcoming passion project ! Perfect to learn load balancing at the same time 😈
Lol up until you mentionned using PostgreSQL, I thought by „building your own database“ you meant implementing it by yourself, from the file system up to the SQL progessor.
Me too I was pretty confused until that part, thinking to myself, couldn't you do it with mysql or postgres instead of implementing it from scratch.
Same thought
Exactly what I was looking for.
So yeah, I wrote a little python script and was messing around with a personal sqlite thingy recently as well. my reasons for it were actually everything you outlined in this video. so weird. I did get stuck and didn't know where to go from there, but i think you just gave me an idea on how to get past this coding "writers block". thanks man. I just subscribed to your other channel. didn't know until now you had one.
I've watched your Transformation my guy 👏🏾😁 been here long enough now ...you are a grown man now 👊🏾 KeepMoving
Amazing that your juggling matched the tempo of your intro. Sold 10,000x
I actually just finished my own 2TB database/cloud server and then this pops up😂😂
Wow, that's impressive. What resources & languages did you use?
Congragulations dude
Don't let yt access your mic
@@syedakib3534 well I made the cloud server, but the database is still on the making. I misunderstood database at first,so I'm gonna make one today
@Elias Productions I store another programs I use there, videos, etc. I'm also thinking about adding a section for contacts
the self's ideas is really great and I think that in social distance times I can do that project but I'm just a sophomore, do not have much experience so hope you can build the vlog to show how to create your own database. Thank you so much
Nice to see Kalle doing it after a lot of years
Coming back to your roots with the starting scene, arent we? Lol
Not gonna lie I’m loving this slicked back ponytail. I’ll cry when you cut it 😂🥲
This Video inspired me to buy myself a Raspberry Pi and make it into a sort of mini-server to access my db from everywhere I want. Thanks! :)
Good job man. This is a great video. You have excellent content. Thanks for posting.
I’m actually building a password manager rn similar to the one did where it has the MySQL backend and Python front end. It’s been really fun so I definitely feel like this database could be a really fun project!
The only drawback of using python as front-end is that when you type the password, it doesn't get hid, like you can see what you typing instead of '*'
I'm doing the same project but I'm making a chrome extension.
@@ashishpandagre6805 Django?
@@kamisama7462 yea I wanted to try and see if I could fix that problem
@@ashishpandagre6805 that’s a good idea!
Adding this project to my todo list. Thanks kalle!
Hmm, I think starting with storage first (the DB) is an interesting approach. I would rather implement my UI and APIs first and postpone the decision on the DB after it becomes clear what the system needs to do. Because if you do this as a passion project you will get even better ideas once you‘ve started building it. Changing the DB could become more and more challenging.
Wouldn't changing the DB structure over time be a valuable learning process itself? What is the best way to create a flexible structure?
Thanks, man. I am gonna do it this summer. looks challenging and I am excited about it. 😁
WOW the editing. That intro man, THAT INTRO
Make api for your database is so exciting
Gratz on half a million subs
Great things I have done between this lockdown free time is subscribing your channel 😍
Take a drink every time he says "database"
"Dattabase"
This channel keeps on getting interesting
Welcome back with a pretty nice, and valuable video.
I may need that haircut a little more right now.😂
Nice, I was actually going to try to do my own this weekend! More motivation to do so!
That juggle is godly
"automated happy birthday message". Boy how did we end up here?..
I planned to create a mySQL-DB which I can interact with on a self crwated Browser-Interface running at my raspi.
Thank you for the video, it made me start the project
The mySQL-DB is running on your Rpi? How do you 'host' your browser-interface?
@@BramVanhautte No, that was the reason I stopped the project not much later I began, I have to use quite a few tricks to get it work. When I dont forget it I will tell you which tricks I used
I absolutely loved this video! Great idea
I'm definitely going to create my own database now! Thanks for the video!
you sold me the video with that intro
amazing content, wonderful channel and brilliant structure and video organization and lots of useful informations , Thank you from Morocco
Never stop with the great intros
WOW, what an intro, fabulous.
Please make more videos like this about the projects you recommend!
Just great! Lots of new stuff to dig into 😁
Where on the livecoder channel is the live coding a database video?
the h and m suit analogy was a perfect example of using a custom database
I feel like most people would spend 98% of the time building a database and 2% actually using it
try to find one of your cat pictures in your hdd collection with a keyword. if you db as you add it you can search and have a web page result with a link to it.
@@sdrawkcabmiay good one
That's the spirit of diy
@yoshi105 wrote, _"I feel like most people would spend 98% of the time building a database and 2% actually using it"_
The utility of a thing isn't related to how often the thing is used. It's utility is measured by how much time one saves using it vs not using it. But, even if we ignore that heurisitic, the element of doing it for the sake of learning and growing one's technical and professional skills is its own reward.
Great video Kalle
11:07 Whatsapp isn't a database, at least not in the sql sense. It has end-to-end encryption so all data is stored locally. The client probably just sends the private key to facebook so they most likely do have all messages/people etc in a database but they wouldn't tell you that
Notion, Obsidian, Roam, RemNote? Google Contacts? To-Do Apps? Why might I take the time?
It took me over half of the video to realize that he wasn’t actually building his own RDMS.
Same here lol
saw my first mongodb atlas ad with this video
was that a fireship refrance at the start
The general term for this type of personal database is "PKM - Personal Knowledge Management". If you start researching that, that you'll go down the rabbit hole of this whole concept… ;) And yes: there are plenty of tools for that ("H&M-style") or you can build one yourself around a database system. :)
From thumbnail I thought he is from any web series like GOT😂
Excellent video al always Kalle! Checked out your other channel but did not see the coding video of the database..probably still work in progress?
nice juggling skills kalle
I like the idea of having a database, but im not a coder, and have no interest at all in being one. Are there any such packages that handle this for you.
Firebase could work.
You should probably look into firebase or mongodb for local
Airtable
MySQL workbench
LibreOffice Database or ms Access
dem jugglin skills in the intro. 💯
I love your random intros!
I hope Kally would not store me in his DB after this comment.
While I like the idea behind the video. Be aware that storing personal info (PII) in a database that is not known for being secure and reliable is a road to catastrophe. And It might be just illegal from a GDPR standpoint. So make sure you get another person's consent.
was useful thanks man
Idk about the video. But the thumbnail is fire
I'm using Notion for that but never thought about building it up from the ground. Hmmmmmmm
In my opinion Notion give me the possibility to customise as much as i need something that i feel to name as db. As for personal skills if Building It Is a source of motivation, obviously go for It.
i am surprised you use notion in the first place considering you are watching this channel, which is really focused on security. Notion is like the worse note taking app out there for security.
Kalle always give me inspiration and ideas. Idk what this man does but his videos are easily top tier
Amazing video, I also have a couple of "dadabases"!
Why are you comparing Google Drive (a cloud storage provider) with PostgresSQL? Those are completely different things. And a "tailored especially for you" database doesn't have to be full blown SQL, for the usecases you mentioned a simple Excel spreadsheet would do.
He just needed to make a new video
nice video!!! as always!!
Great motivational video ❤️
yeah kalle, it really was impressive
If you wanted to replace ants with a different insect. what features would you engineer your usurper insect to have? what behaviours would you engineer them to have? So they would, 1) beat out ants, ants are gone. Your (the new insect that you created) insect, it rules the ant world now but also not so effective they screw up the food chain.