Author Archives: user

SQLite – Views A view is nothing more than a SQLite statement that is stored in the database with an associated name. It is actually a composition of a table in the form of a predefined SQLite query. A view can contain all rows of a table or selected rows from one or more tables. […]

SQLite – Injection If you take user input through a webpage and insert it into a SQLite database there”s a chance that you have left yourself wide open for a security issue known as SQL Injection. In this chapter, you will learn how to help prevent this from happening and help you secure your scripts […]

SQLite – EXPLAIN SQLite statement can be preceded by the keyword “EXPLAIN” or by the phrase “EXPLAIN QUERY PLAN” used for describing the details of a table. Either modification causes the SQLite statement to behave as a query and to return information about how the SQLite statement would have operated if the EXPLAIN keyword or […]