A brief overview of SQLite

From the course: Database Clinic: SQLite

Start my 1-month free trial
  • Course details

    SQLite is a powerful embedded database engine that's a core storage technology in Android and iOS applications. In this installment of the Database Clinic series—in which experts and their databases of choice are pitted against a series of the same challenges— Mark Niemann-Ross demonstrates how to leverage SQLite to solve common database problems. After providing a brief overview of the strengths and weaknesses of SQLite, Mark explains how to create a database and populate it using a public dataset. He also shows how to use a SQLite database with programming languages such as Python and R, handle subqueries and queries in SQLite, and more.

    Instructor

    • Click here to view Mark Niemann-Ross’ instructor page

      Mark Niemann-Ross

      Science fiction author and educator at LinkedIn learning

      • Mark Niemann-Ross is a technologist with experience in hardware, software, and science fiction.

        Mark has been helping developers navigate APIs for almost 30 years, and has been responsible for third-party programs at Quark and Adobe. In addition to hands-on technology, he's also been involved in technology education, starting with a degree in industrial education and most recently working as a content manager for LinkedIn Learning.

        Mark's science fiction has most recently appeared in Analog Science Fiction and Fact. He's currently working on a murder mystery solved by a refrigerator.

    Skills covered in this course

  • Welcome

    - [Instructor] SQLite is a relational database based on the SQL language but optimized for use in small environments such as mobile phones or small applications. Queries in SQLite are almost identical to other SQL calls. SQL isn't so much a database as it is a library that provides database functionality. This code is an example of using SQLite with the C programming language. Notice the second line: #include <sqlite3.h> This includes the SQLite library in this program. Subsequent lines open SQLite for use by this C program. SQLite is built for simplicity and speed compared to a hosted client-server relational database such as MySQL. It sacrifices sophistication for utility and complexity for size. Consider SQLite as a replacement for fopen. Fopen is a low-level code function that provides programming languages with the ability to read and write data to a disk file. In this code sample, fopen is used to write the words "fopen example" to a file. In contrast to fopen, SQLite provides a way to write data to a file but also provides ways to structure that data and retrieve it using SQL. SQLite can be driven with a graphic user interface, command-line interactive interfaces, or a wide range of programming languages. As an example of SQLite's simplicity, it only has five datatypes: NULL, INTEGR, REAL, TEXT, and BLOB, or binary large object. In comparison, MySQL, another SQL type of database, has a large range of datatypes plus special types for geographic information systems and JSON, which stands for JavaScript Object Notation. The important thing to remember about SQLite is that it is primarily for use with programming languages and sacrifices sophistication in favor of size. For a more in-depth look at SQLite, please refer to SQLite courses in the library.

  • Practice while you learn with exercise files

    Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.

    Download the exercise files for this course. Get started with a free trial today.

  • Download courses and learn on the go

    Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.

    Watch this course anytime, anywhere. Get started with a free trial today.

Contents