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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.