Designing your own Database in C
Vložit
- čas přidán 29. 08. 2024
- In this brand new series about databases you will learn about data structures, effective search algorithms etc.
In this first episode of the series you will learn how to design a database based of a variant of a binary tree. Later we will begin the actual coding of the database.
I have two years of C training now and have a decent understanding of C, but no doubt Jonas have the 'black belt' in C.
I'm mostly a hobby programmer, but I have coded a working small relational CRM database for my wife's business. The database consist of for four tables, queries, forms and reports to printer and have about 2500 lines of code and 15 files. I used Raylib as a graphical interface with editing facilities including a cursor and searching. The most difficult part was the mechanics of the memory handling and timing for cursor and typing, but in the end it works or I will know in a split second if my wife is not satisfied.
Your video is very informative and if I have write a new database, it will certainly have another construct, based on your video.
@grimvian Mockery aside, you have only seen the tree part of the Birchtree Architecture. Wait until you see the unique hash table construct. My database will outperform yours, 100%, we can even record videos where we compete. dr JB
@@dr-Jonas-Birch Looking forward to see to what you come up with.
A wish I have about your videos - could you please use more of the screen area for the code..?
No performance issue probably because my database at present only contains about 3500 records in four binary files.
Have you seen my latest episodes? I use more of the screen size there. If you still want it bigger I will try to oblige. You should also see the recorded livestreams where I develop the database server. Check the Live tab on my channel's page. JB
@@dr-Jonas-Birch No, but I'll will see your videos in near future.
New to this low level staff I should say I am liking the video so far
That's great Don. This channel keeps making low-level popular again... :) Take care, JB
Can we also please expect a video on databases based on disk?
Hi Sameera, how are you? It is not in the pipeline but that could change. Would you like that? JB
@@dr-Jonas-Birch thanks, ofc, i am thrilled to watch such a video from you.
Okay then, I will add that to my list. I have a couple of projects planned before that though. Btw, I hope to see you visiting my live stream next friday, if possible - take care. JB
@sameerakhatoon9508 Here is the link btw for Friday: czcams.com/users/liveFFxEoQyNQKM
JB
@@dr-Jonas-Birch thanks:)
I m a typescript dev but i dont know why i like your low level stuff
love from india …
Hehe nice, that made me smile :D Being a TS dev, what do you think of this post? tinyurl.com/2wc88h99
JB
I'm late to the party. This is great stuff. Thank you.
Thanks. How did you achieve that YT profile page crash? Xss? JB
This is so helpful men!! I've always wanted to implement one for a better understanding. Great content!! awaits implementation
Glad you liked it, will you watch the liive stream on Friday? JB
@@dr-Jonas-Birch sure, definitely!!
Great, tune in czcams.com/users/liveFFxEoQyNQKM. at 19:00 CEST Friday and I'll see you there.
JB
👌
Fabian, nice to see you. Glad you liked it. JB
Nice 🎉
Nimaq :) how are you my friend? JB
@@dr-Jonas-Birch Tnx
Hope to see you Friday at czcams.com/users/liveFFxEoQyNQKM
JB
Well never learn c.
I guess I am starting with your work
Hi Alex, welcome to the channel. JB
I am so bad at pointers!. Everytime i see these '*' i get a headache!.
Still, they are what makes C so beautiful, JB
@@dr-Jonas-Birch right! and I really need to get comfortable with them as soon as possible.
Perhaps this will help czcams.com/video/8G2_m4zY4TA/video.html
JB
@@dr-Jonas-Birch I watched this video already, but couldn't finish it because the screen resolution on smartphones at 240p (I have limited data/day) isn't that great. Therefore, I request you to please increase the font size or make the editor window full screen, in your upcoming videos for the convenience of learners and thank you for making these videos 🙏.
Yes all my new videos have a big font size, JB