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 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.
Learn how to connect to a SQLite database using Python.