YouTip

# SQLite Tutorial !(#) SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain. This tutorial will teach you how to program with SQLite and get you started quickly. **[Start Learning SQLite Now!](#)** ## Who Should Read This Tutorial? This tutorial is designed to help beginners understand the basics and advanced concepts related to the SQLite database engine. ## Prerequisites: Before you start practicing with the various examples provided in this tutorial, you need to understand what a database is, especially an RDBMS, and what a computer programming language is. ## Compiling/Executing SQLite Programs If you want to compile/execute SQL programs using the SQLite DBMS but do not have the setup, you can visit the (https://sqliteonline.com/ "Online SQL Compiler"). You can experience real programming on high-end servers with just a few clicks. This is a completely free online tool. ## SQLite Function Reference This tutorial provides a reference manual for all important built-in SQLite functions. (#) ## SQLite Useful Resources This tutorial lists SQLite database websites and books. #### SQLite Useful Websites * (http://www.sqlite.org/) - The official SQLite website provides the latest SQLite installation versions, the latest SQLite news, and complete SQLite tutorials. * (http://www.php.net/manual/en/book.sqlite3.php) - The website provides complete details of PHP support for the SQLite 3 database. * [SQLite JDBC Driver:](https://bitbucket.org/xerial/sqlite-jdbc) - SQLite JDBC, developed by Taro L. Saito, is a library for accessing and creating SQLite database files in Java. * [DBD-SQLite-0.31](http://search.cpan.org/~msergeant/DBD-SQLite-0.31/) - The SQLite Perl driver is used with the Perl DBI module. * [DBI-1.625](http://search.cpan.org/~timb/DBI/) - The Perl DBI module provides a generic interface for any database, including SQLite. * (https://docs.python.org/2/library/sqlite3.html) - The sqlite3 python module was written by Gerhard Haring. It provides a SQL interface that is compliant with the DB-API 2.0 specification. (#)[](#)