SQLite is a good choice for those who want a fast and lightweight database solution without all of the overhead of MySQL or PostgreSQL. These articles provide the information you need to work with SQLite quickly and effectively.
You can use the sqlite3 program to connect directly to SQLite from the command line. Learn how here.
Learn how to connect to a SQLite database using PHP's PDO (PHP Data Objects). This article includes code samples that you can use in your own applications.
Learn how to connect to a SQLite database using Python. This article includes sample code you can use in your own sites.