← All categoriesExplore the topic

Technology

Software, devices and technical concepts, explained clearly.

444 summariesSorted by title
Technology

Sqlite3: passing values as query parameters

With sqlite3, parameters separate SQL text from input values. For example, execute('SELECT name FROM items WHERE id = ?', (item_id,)) supplies the identifier separately.

Published22 Oct 2026
Technology

String.Template: names in a simple text template

string.Template uses placeholders such as $name for text substitution. substitute() expects the required values; safe_substitute() can leave unresolved placeholders in the result.

Published22 Oct 2026
Technology

Struct: byte order belongs to the format

struct.pack('>H', 258) produces the two bytes b'\x01\x02'. The > prefix selects big-endian order, while H describes an unsigned short integer in that format.

Published22 Oct 2026