Understanding databases and tables in SQLite


show more Understanding databases and tables in SQLite provides you with in-depth training on Business. Taught by Bill Weinman as part of the SQLite 3 with PHP Essential Training show less
please wait ...

Understanding databases and tables in SQLite

SQLite is different than other database management systems in two significant ways. First, SQLite is a database management system in a driver, and two, SQLite stores an entire database in one file. So SQLite itself, the code base that comprises the database management system, lives inside your application as a driver. So when it needs to access its database, which is contained in a file, SQLite must first go through the application, and then the application accesses the file.

What this means is the directory where you're creating your files, and the files themselves, must be accessible by the application. So the application, whatever user it's running under, has to have access to that file, read and write access to the file, and read and write access to the directory the file is contained in, because SQLite creates and destroys a few temporary files along way, as it's managing your database. This becomes a little bit more complicated when your application is a web application...

Understanding databases and tables in SQLite
Video duration: 2m 34s 6h 2m Beginner

Viewers:

Understanding databases and tables in SQLite provides you with in-depth training on Business. Taught by Bill Weinman as part of the SQLite 3 with PHP Essential Training

Subjects:
Business Developer Web
Software:
SQLite
Author:
please wait ...