CHAPTER 4

image

Working with the Relational Model and SQLite

You’ve seen how to create a table, add rows to it, insert data into it, and then retrieve the data. Granted, there’s not much data involved so far, but these are the basics of database management. Along the way you’ve seen that SQLite (like many other libraries and data managers) is typically embedded in a framework, language, class, or database management system (DBMS). As noted, today, most DBMSs are relational database management systems (RDBMSs). They are based on the relational model first proposed in 1970 by E. F. Codd, and they typically use SQL or a derivative (like SQLite!) to create, ...

Get Introducing SQLite for Mobile Developers now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.