Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
What this means is that the application itself lives inside the web server. So when SQLite needs to access the file, it must first go through the application, and then the application must go through the web server, and then the web server accesses the file. So this means that the database file itself, and the directory of the database file it's living in must have permissions that will allow read and write access to the web server. So, especially if your web server is a shared UNIX web server, or it's running on a Mac, the web server itself is probably running as a user different than your login user.
This means that your directory and your files must have read/write access to everyone. Keep in mind also that SQLite stores all of the data for a given database in one file. This means that all of your tables are stored in this one file. This can be very convenient for small and medium-sized applications, but it also is significant when you're planning the permissions for your files, and we'll talk more about this as we go on. So, as you create your databases and tables, be aware of how SQLite creates and accesses database files.
Maintain permissions so that the SQLite driver, and its host application, and even the web server has access to the directories and files that it needs. This will keep your development and maintenance cycles smooth and stress free.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74788 Viewers
80 Video lessons · 129863 Viewers
52 Video lessons · 64065 Viewers
59 Video lessons · 49855 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.