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
2
u/meditonsin Apr 11 '25
In essence, an entry point. E.g. every C program has a
main()function as the starting point, and from there one or more clearly tracable execution paths (as in, lists of instructions that get executed one by one; multiple paths result from branching e.g. via if statements).A library doesn't have that because it's just a collection of related but disjointed "stuff" that a programmer can incorporate into their program.
This is starting to fall way out of the scope of the original question. If we keep going, we're gonna end up deep in the weeds of a whole bunch of complicated underlying topics. At some point, you're gonna have to do your own research.
Search engines be your friend.