SQLite on Mac OS X

[Berth]

I have a Compaq laptop on which i had installed Mac OS X as my operating system. I would like to know that for what purpose SQLite application can be used on Mac? What function does SQLite application can perform on Mac? Has anybody used SQLite application? Kindly provide me the correct information on SQLite application. Any information on SQLite application would be greatly appreciated.

[Eric B]

SQLite is an embedded SQL database engine. The SQLite engine is not a standalone process with which the application program communicates. SQLite is not a client library used to connect to a big database server. It is located in /usr/bin directory and called sqlite3.

[Glenny]

SQLite is the server. Using SQLite, users can create file-based databases that can be transported across machines, platforms, etc. You can check your sqlite installation is complete by typing using the which command in the OS X terminal:

$ which sqlite3
/opt/local/bin/sqlite3

[JonathanD]

Unlike most other SQL databases, SQLite does not have a separate server process. SQLite databases can be created by using the sqlite3 program in /usr/bin. SQLite reads and writes directly to ordinary disk files. Creating and editing databases is cumbersome using the command line program, so a graphical tool like RazorSQL that is capable of communicating with SQLite makes it much easier to manage your SQLite databases.