Skip to content

issues Search Results · repo:simonw/sqlite-diffable language:Python

Filter by

9 results
 (72 ms)

9 results

insimonw/sqlite-diffable (press backspace or delete to remove)

simonw/sqlite-diffable
`sqlite-diffable` callable as a library

I ve been using this package to build my website for a while and it s been absolutely great! I normally call the package through the CLI as intended but recently created callable function to consolidate ...
  • PeskyPotato
  • 1
  • Opened 
    on May 4, 2024
  • #9

simonw/sqlite-diffable
Restoring dumps which contain AUTOINCREMENT columns

Hi, great tool, this is exactly what I m looking for. I do however have an issue when using AUTOINCREMENT columns. If you create a table like this CREATE TABLE IF NOT EXISTS DummyTable ( DummyTableId ...
  • Timmeey86
  • Opened 
    on Mar 9, 2023
  • #8

simonw/sqlite-diffable
Command for outputting a dump as NL objects

Rows are currently stored on disk in this format: [1, Simon ] [2, Cleo ] You have to consult the accompanying metadata JSON file to find out what the column names are. A command that streams out one ...
enhancement
  • simonw
  • 2
  • Opened 
    on Aug 15, 2022
  • #7

simonw/sqlite-diffable
`load` should handle case where database tables already exist

% sqlite-diffable load simonwillisonblog.db simonwillisonblog Traceback (most recent call last): File /Users/simon/.local/share/virtualenvs/sqlite-diffable-J1UjzcIN/bin/sqlite-diffable , line 33, in ...
enhancement
  • simonw
  • 3
  • Opened 
    on Jul 11, 2022
  • #6

simonw/sqlite-diffable
Documentation should show examples of output

The only way to see what this does at the moment is to install and run it! Maybe even have a live demo in a GitHub repo somewhere.
documentation
  • simonw
  • 1
  • Opened 
    on May 27, 2021
  • #5

simonw/sqlite-diffable
Ability to round-trip binary data

e.g. for the binary numbits column in the .coverage SQLite database generated by coveragepy. Those currently end up represented like this: [4, 1, b \\xfe\\xff\\xfd{\\xe0\\x02\\x10\\x00W}o\\xdb{\\xef}o\\xef\\xbd\\xf7\\x92\\xe8\\x00\\x00\\xca\\t\\xe0\\xfb\\xdf\\x07y\\xdb\\xbe\\xf3\\x97s\\xd7\\xd8\\xeb\\x06\\xd9Y\\x16A\\x17\\xe6\\x02\\x02 ...
enhancement
  • simonw
  • 6
  • Opened 
    on Jun 14, 2020
  • #4

simonw/sqlite-diffable
`sqlite-diffable load` command for restoring a dump

The reverse operation to sqlite-diffable dump - this will create a brand new SQLite database using the data in the specified directory. sqlite-diffable load mydb.db path-to-directory
enhancement
  • simonw
  • 1
  • Opened 
    on Jul 4, 2019
  • #3

simonw/sqlite-diffable
Option to dump table rows as individual files in a directory

Inspired by the Who s On First directory layout: https://github.com/whosonfirst-data/whosonfirst-data-admin-us/tree/master/data I ll have an option for dump each row as a file in a directory named after ...
  • simonw
  • Opened 
    on Jul 4, 2019
  • #2

simonw/sqlite-diffable
Handle tables with surprising names

E.g. a table called foo/bar should be dumped to a predictable filename. I ll probably use the same trick as Datasette for this. https://github.com/simonw/datasette/blob/f0d32da0a9af87bcb15e34e35424f0c0053be83a/tests/test_utils.py#L202-L215 ...
  • simonw
  • Opened 
    on Jul 4, 2019
  • #1
Issue origami icon

Learn how you can use GitHub Issues to plan and track your work.

Save views for sprints, backlogs, teams, or releases. Rank, sort, and filter issues to suit the occasion. The possibilities are endless.Learn more about GitHub Issues
ProTip! 
Press the
/
key to activate the search input again and adjust your query.
Issue origami icon

Learn how you can use GitHub Issues to plan and track your work.

Save views for sprints, backlogs, teams, or releases. Rank, sort, and filter issues to suit the occasion. The possibilities are endless.Learn more about GitHub Issues
ProTip! 
Press the
/
key to activate the search input again and adjust your query.
Issue search results · GitHub