SQLite is a software library that translates high-level disk I/O requests generated by an application into low-level I/O operations that can be carried out by the operating system. (View Highlight)
the application sends a message containing some SQL over to a separate server thread or process. (View Highlight)
SQLite runs in the same address space as the application, using the same program counter and heap storage. SQLite does no interprocess communication (IPC). When an application sends an SQL statement into SQLite (by invoking a the appropriate SQLite library subroutine), SQLite interprets the SQL in the same thread as the caller. (View Highlight)
But with SQLite, a complete database is just an ordinary disk file. (View Highlight)
Other languages like Java, Perl, Python, and TCL typically translate the program source text into bytecode. This bytecode is then run through an interpreter that reads the bytecode and carries out the desired operations. SQLite uses this bytecode approach. (View Highlight)
all languages have a compiler step which translates programs into an executable format and a run step that executes the compiled program. (View Highlight)