SQLite

In this chapter, you will learn how to use SQLite in Python programs. Installation SQLite3 can be integrated with Python using sqlite3 module, which was written by Gerhard Haring. It…

In this chapter, you will learn how to use SQLite in Perl programs. Installation SQLite3 can be integrated with Perl using Perl DBI module, which is a database access module…

In this chapter, you will learn how to use SQLite in PHP programs. Installation SQLite3 extension is enabled by default as of PHP 5.3.0. It's possible to disable it by…

In this chapter, you will learn how to use SQLite in Java programs. Installation Before you start using SQLite in our Java programs, you need to make sure that you…

In this chapter, you will learn how to use SQLite in C/C++ programs. Installation Before you start using SQLite in our C/C++ programs, you need to make sure that you…

SQLite has many built-in functions to perform processing on string or numeric data. Following is the list of few useful SQLite built-in functions and all are case-in-sensitive which means you…

SQLite supports five date and time functions as follows − Sr.No.FunctionExample1date(timestring, modifiers...)This returns the date in this format: YYYY-MM-DD2time(timestring, modifiers...)This returns the time as HH:MM:SS3datetime(timestring, modifiers...)This returns YYYY-MM-DD HH:MM:SS4julianday(timestring, modifiers...)This…

VACUUM command cleans the main database by copying its contents to a temporary database file and reloading the original database file from the copy. This eliminates free pages, aligns table…

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…

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…