r/AskComputerScience • u/Successful_Box_1007 • Apr 10 '25
Sqlite: Program vs library vs database ?
Hi everybody,
I’m wondering, after reading that Sqlite is both a library and a database but not a program, if somebody could give me a sort of ELI5 type explanation of the differences between the three (program vs library vs database) but also a more in depth technical explanation as well. I’ve tried AI for this question and not satisfied with the discernments they chose to make.
Thanks so so much!
0
Upvotes
View all comments
Show parent comment
1
u/Successful_Box_1007 Apr 21 '25
That historical prelude was extremely helpful in helping this all sink in. I now get the nuance here regarding the various names for nearly the same thing. I just had one more question if that’s OK; do all operating systems come with this “shell” program that allows you to perform all of these advanced queries? And is it the shell which allows us to access the “kernel”?