releases: 28975119

This data as json

html_url	id	node_id	tag_name	target_commitish	name	draft	author	prerelease	created_at	published_at	body	repo	reactions
https://github.com/simonw/sqlite-utils/releases/tag/2.12	28975119	MDc6UmVsZWFzZTI4OTc1MTE5	2.12	master	2.12	0	9599	0	2020-07-27T07:21:26Z	2020-07-27T07:24:10Z	The theme of this release is better tools for working with binary data. The new `insert-files` command can be used to insert binary files directly into a database table, and other commands have been improved with better support for BLOB columns. `sqlite-utils insert-files my.db gifs .gif` can now insert the contents of files into a specified table. The columns in the table can be customized to include different pieces of metadata derived from the files. See Inserting binary data from files. (#122) `--raw` option to `sqlite-utils query` - for outputting just a single raw column value - see Returning raw data from a query, such as binary content. (#123) JSON output now encodes BLOB values as special base64 obects - see Running queries and returning JSON. (#125) The same format of JSON base64 objects can now be used to insert binary data - see Inserting JSON data. (#126) The `sqlite-utils query` command can now accept named parameters, e.g. `sqlite-utils :memory: "select :num :num2" -p num 5 -p num2 6` - see Running queries and returning JSON. (#124)	140912432

Links from other tables