On 22 Apr 2015, at 11:28pm, Drago, William @ CSG - NARDA-MITEQ <William.Drago 
at L-3com.com> wrote:

> So, SQLite databases are accessed via .dll where as other local databases run 
> a server that is accessed via ???

Most database systems have client/server architecture.  There is somewhere a 
server.  The only program which actually opens the database files is the 
server.  Sometimes it runs on the same computer as the client and they 
communicate via a socket.  Other times it runs on another computer and they 
communicate across a network.

SQLite has no server.  You could call it a server-less multi-user DBMS.  Each 
program opens the database file itself.

If you are going to write about the differences between these two you should 
definitely see this page:

<https://www.sqlite.org/whentouse.html>

Ignore the .dll files, by the way.  DLL files are included for those 
programmers using compilers or development environments which can't compile C 
as well as their own code.  The 'proper' way to have your C program, or 
anything else compatible, use SQLite is to include one '.h' and one '.c' file 
into your project.  One would normally use the 'Amalgamation' download from

<https://www.sqlite.org/download.html>

Simon.

Reply via email to