liveBook · Manning

Structured data

As explained in Practices of the Python Pro

Structured data is information organized according to an explicit schema or predictable fields, types, records, or relationships for consistent machine processing.

Tabular data organizes information into rows and columns. In a database, each row can represent a record, while columns define the record’s fields, such as a bookmark’s title, URL, notes, and date added. section 6.3.1

The persistence layer stores and retrieves tabular data through SQL statements. SQLite tables support creating, adding, deleting, listing, selecting, sorting, and counting records. section 6.3.1

How Practices of the Python Pro covers it

How deep it goes
Demonstrates schemas and CRUD queries in SQLite, stopping short of broader database design.
Examples
Uses a bookmarks table containing identifiers, titles, URLs, notes, and dates.
What you can do after
Operate tabular data through Python’s sqlite3 connection and parameterized SQL queries.
How it connects
Connects tabular data with SQLite, SQL, database persistence, and CRUD operations.

Also explained in

Compare how 24 books explain structured data →

Related concepts

This explainer was generated by Manning's knowledge graph from the text of Practices of the Python Pro. The section links point to the parts of the book it draws on.