Items tagged sqliteutils, sql

Filters: sqliteutils × sql × Sorted by date

3 results

Datasette on Codespaces, sqlite-utils API reference documentation and other weeknotes

This week I broke my streak of not sending out the Datasette newsletter, figured out how to use Sphinx for Python class documentation, worked out how to run Datasette on GitHub Codespaces, implemented Datasette column metadata and got tantalizingly close to a solution for an elusive Datasette feature.

[... 2164 words]

4:57 am / 14th August 2021 / documentation, github, sql, sqlite, datasette, weeknotes, sqliteutils, mypy, githubcodespaces

Joining CSV and JSON data with an in-memory SQLite database

The new sqlite-utils memory command can import CSV and JSON data directly into an in-memory SQLite database, combine and query it using SQL and output the results as CSV, JSON or various other formats of plain text tables.

[... 1507 words]

10:55 pm / 19th June 2021 / csv, json, projects, sql, sqlite, weeknotes, sqliteutils

sqlite-utils 2.0: real upserts

I just released version 2.0 of my sqlite-utils library/CLI tool to PyPI.

[... 1140 words]

6:48 am / 30th December 2019 / museums, projects, sql, sqlite, upsert, weeknotes, sqliteutils

Simon Willison’s Weblog