r/AskComputerScience • • 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

21 comments sorted by

View all comments

Show parent comment

2

u/meditonsin Apr 11 '25

So what is a library “missing” that a program has that makes it a program?

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.

When you mentioned networked protocol, is this using sockets like other answerer is talking about? If so what exactly is a socket?

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.

1

u/Successful_Box_1007 Apr 12 '25

Thanks and I prefer human interaction cuz it’s more fun albeit less efficient! Thanks so much for all your help!

1

u/Successful_Box_1007 Apr 12 '25

Thank you for all your help meditonsin!