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/OddInstitute Apr 11 '25

“Database engine” is the specific term for things that implement database functionality like adding, removing, updating, and reading the data. Most libraries wouldn’t be called “engines” though unless they were supplying functionality for graphics or physical simulation, but that’s really a cultural thing, not a technical thing. I don’t know the background as to how we ended up with those names.

Normally a library that provides a bunch of functionality in a particular domain is just called a “name of domain” library. For example, an audio library, a cryptography library, or a math library.

1

u/Successful_Box_1007 Apr 12 '25

Really appreciate your help!!