Sqlite-utils Alternatives

sqlite-utils reviews and mentions

• This Week In Python
  5 projects | dev.to | 12 Jul 2024

  sqlite-utils – Python CLI utility and library for manipulating SQLite databases

• Dbmate: A lightweight, framework-agnostic database migration tool
  2 projects | news.ycombinator.com | 16 Jun 2024

  The transform=True parameter means "if the table already exists but does not match the provided schema, transform it to add missing columns etc".

  I don't generally recommend it though, it's a risky way of working compared to stateful migrations.

  Here are the tests for that option: https://github.com/simonw/sqlite-utils/blob/577078fe01da6d87...

• Ask HN: High quality Python scripts or small libraries to learn from
  12 projects | news.ycombinator.com | 19 Apr 2024

  https://github.com/simonw/sqlite-utils

  So, his code might not be a good place to find best patterns (for ex, I don't think they are fully typed), but his repos are very pragmatic, and his development process is super insightful (well documented PRs for personal repos!). Best part, he blogs about every non-trivial update, so you get all the context!

• Why you should probably be using SQLite
  8 projects | news.ycombinator.com | 27 Oct 2023

  Sounds like your problem is with SQLAlchemy, not with SQLite.

  My https://sqlite-utils.datasette.io library might be a better fit for you. It's a much thinner abstraction than SQLAlchemy.

• Welcome to Datasette Cloud
  6 projects | news.ycombinator.com | 20 Aug 2023

  There are a few things you can do here.

  SQLite is great at JSON - so I often dump JSON structures in a TEXT column and query them using https://www.sqlite.org/json1.html

  I also have plugins for running jq() functions directly in SQL queries - https://datasette.io/plugins/datasette-jq and https://github.com/simonw/sqlite-utils-jq

  I've been trying to drive the cost of turning semi-structured data into structured SQL queries down as much as possible with https://sqlite-utils.datasette.io - see this tutorial for more: https://datasette.io/tutorials/clean-data

  This is also an area that I'm starting to explore with LLMs. I love the idea that you could take a bunch of messy data, tell Datasette Cloud "I want this imported into a table with this schema"... and it does that.

  I have a prototype of this working now, I hope to turn it into an open source plugin (and Datasette Cloud feature) pretty soon. It's using this trick: https://til.simonwillison.net/gpt3/openai-python-functions-d...

• SQLite Functions for Working with JSON
  10 projects | news.ycombinator.com | 10 Aug 2023

  I've baked a ton of different SQLite tricks - including things like full-text indexing support and advanced alter table methods - into my sqlite-utils CLI tool and Python library: https://sqlite-utils.datasette.io

  My Datasette project provides tools for exploring, analyzing and publishing SQLite databases, plus ways to expose them via a JSON API: https://datasette.io

  I've also written a ton of stuff about SQLite on my two blogs:

  - https://simonwillison.net/tags/sqlite/

  - https://til.simonwillison.net/sqlite

• Show HN: Trogon – An automatic TUI for command line apps
  11 projects | news.ycombinator.com | 21 May 2023

  This is really fun. I have an experimental branch of my sqlite-utils CLI tool (which has dozens of sub-commands) running with this now and it really did only take 4 lines of code - I'm treating Trogon as an optional dependency because people using my package as a Python library rather than a CLI tool may not want the extra installed components:

  https://github.com/simonw/sqlite-utils/commit/ec12b780d5dcd6...

  There's an animated GIF demo of the result here: https://github.com/simonw/sqlite-utils/issues/545#issuecomme...

• I'm sure I'm being stupid.. Copying data from an API and making a database
  2 projects | /r/Database | 19 Jan 2023

  My project https://datasette.io/ is ideal for this kind of thing. You can use https://sqlite-utils.datasette.io/ to load JSON data into a SQLite database, then publish it with Datasette.

• Just: A Command Runner
  27 projects | news.ycombinator.com | 9 Jan 2023

  I've been using this for about six months now and I absolutely love it.

  Make never stuck for me - I couldn't quite get it to fit inside my head.

  Just has the exact set of features I want.

  Here's one example of one of my Justfiles: https://github.com/simonw/sqlite-utils/blob/fc221f9b62ed8624... - documented here: https://sqlite-utils.datasette.io/en/stable/contributing.htm...

  I also wrote about using Just with Django in this TIL: https://til.simonwillison.net/django/just-with-django

• Ask HN: What Do You Use for a Personal Database
  4 projects | news.ycombinator.com | 16 Nov 2022

  SQLite with the open source toolchain I've been building over the past five years:

  https://datasette.io as the interface for running queries against (and visualizing) my data.

  https://sqlite-utils.datasette.io/ as a set of tools for creating and modifying my databases (inserting JSON or CSV data, enabling full text search text)

  https://dogsheep.github.io as a suite of tools for importing my personal data - see also this talk I gave about that project: https://simonwillison.net/2020/Nov/14/personal-data-warehous...

• A note from our sponsor - SaaSHub
  www.saashub.com | 21 Mar 2025

  SaaSHub helps you find the best software and product alternatives Learn more →