57 rows

View and edit SQL

Suggested facets: labels_id

Link labels_id pull_requests_id
enhancement 727708734 /db/table/-/blob/pk/column.blob download URL 507903392
enhancement 727708734 New explicit versioning mechanism 511868153
enhancement 727708734 .blob output renderer 512545364
enhancement 727708734 ?_col=/?_nocol= to show/hide columns on the table page 651492888
help wanted 727708735 Get tests running on Windows using Travis CI 296735320
help wanted 727708735 bump uvicorn to 0.9.0 to be Python-3.8 friendly 327541046
documentation 750789605 register_routes() plugin hook 431478724
documentation 750789605 load_template() plugin hook 513106026
plugins 754269786 render_cell(value) plugin hook 204851511
plugins 754269786 register_routes() plugin hook 431478724
plugins 754269786 Nav menu plus menu_links() hook 512736705
plugins 754269786 load_template() plugin hook 513106026
feature 947261894 --dirs option for scanning directories for SQLite databases 375180832
feature 947261894 base_url configuration setting, refs #394 393274433
ci 993222446 Get tests running on Windows using Travis CI 296735320
enhancement 993377884 on_create mechanism for after table creation 369394043
enhancement 993377884 Tracer mechanism for seeing underlying SQL 481616704
enhancement 993377884 Progress bar for sqlite-utils insert command 510956134
enhancement 993377884 changes to allow for compound foreign keys 521287994
enhancement 993377884 sqlite-utils analyze-tables command and table.analyze_column() method 537791675
documentation 1405404904 Tracer mechanism for seeing underlying SQL 481616704
css 1918831023 Radical new colour scheme and base styles, courtesy of @natbat 511005542
dependencies 1970143153 Update beautifulsoup4 requirement from ~=4.8.1 to >=4.8.1,<4.10.0 400578979
dependencies 1970143153 Update pytest requirement from ~=5.2.2 to >=5.2.2,<5.5.0 400579077
dependencies 1970143153 Update jinja2 requirement from ~=2.10.3 to >=2.10.3,<2.12.0 400579136
dependencies 1970143153 Update aiofiles requirement from ~=0.4.0 to >=0.4,<0.6 402645984
dependencies 1970143153 Update mergedeep requirement from ~=1.1.1 to >=1.1.1,<1.4.0 406067019
dependencies 1970143153 Update pytest-asyncio requirement from ~=0.10.0 to >=0.10,<0.12 406677205
dependencies 1970143153 Update janus requirement from ~=0.4.0 to >=0.4,<0.6 407929128
dependencies 1970143153 Update pytest-asyncio requirement from ~=0.10.0 to >=0.10,<0.13 412951191
dependencies 1970143153 Update pytest-asyncio requirement from <0.13,>=0.10 to >=0.10,<0.15 439203808
dependencies 1970143153 Update pytest requirement from <5.5.0,>=5.2.2 to >=5.2.2,<6.1.0 458435592
dependencies 1970143153 Update black requirement from ~=19.10b0 to >=19.10,<21.0 474703007
dependencies 1970143153 Update pytest requirement from <6.1.0,>=5.2.2 to >=5.2.2,<6.2.0 494146043
dependencies 1970143153 Update janus requirement from <0.6,>=0.4 to >=0.4,<0.7 501579088
dependencies 1970143153 Update asgiref requirement from ~=3.2.10 to >=3.2.10,<3.4.0 501579315
dependencies 1970143153 Update aiofiles requirement from <0.6,>=0.4 to >=0.4,<0.7 511549374
dependencies 1970143153 Update pytest requirement from <6.2.0,>=5.2.2 to >=5.2.2,<6.3.0 539489525
dependencies 1970143153 Update pytest-asyncio requirement from <0.15,>=0.10 to >=0.10,<0.16 618011977
dependencies 1970143153 Bump black from 20.8b1 to 21.4b0 624635440
dependencies 1970143153 Bump black from 20.8b1 to 21.4b1 625457579
dependencies 1970143153 Bump black from 20.8b1 to 21.4b2 626130135
dependencies 1970143153 Upgrade to GitHub-native Dependabot 626222676
dependencies 1970143153 Bump black from 21.4b2 to 21.5b0 630578735
dependencies 1970143153 Bump black from 21.4b2 to 21.5b1 640484966
dependencies 1970143153 Update click requirement from ~=7.1.1 to >=7.1.1,<8.1.0 643149273
dependencies 1970143153 Update jinja2 requirement from <2.12.0,>=2.10.3 to >=2.10.3,<3.1.0 643149320
dependencies 1970143153 Update itsdangerous requirement from ~=1.1 to >=1.1,<3.0 643149364
dependencies 1970143153 Update aiofiles requirement from <0.7,>=0.4 to >=0.4,<0.8 645849027
dependencies 1970143153 Bump black from 21.5b1 to 21.5b2 658991404
dependencies 1970143153 Update trustme requirement from <0.8,>=0.7 to >=0.7,<0.9 665892313
dependencies 1970143153 Bump black from 21.5b2 to 21.6b0 668129441
dependencies 1970143153 Update pytest-xdist requirement from <2.3,>=2.2.1 to >=2.2.1,<2.4 672620180
dependencies 1970143153 Update asgiref requirement from <3.4.0,>=3.2.10 to >=3.2.10,<3.5.0 679035847
design 2175284252 Radical new colour scheme and base styles, courtesy of @natbat 511005542
cli-tool 2374328705 sqlite-utils memory command for directly querying CSV/JSON data 671014751
hacktoberfest-accepted 2459412274 Allow iterables other than Lists in m2m records 510235909

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [labels_pull_requests] (
   [labels_id] INTEGER REFERENCES [labels]([id]),
   [pull_requests_id] INTEGER REFERENCES [pull_requests]([id]),
   PRIMARY KEY ([labels_id], [pull_requests_id])
);
CREATE INDEX [idx_labels_pull_requests_pull_requests_id]
    ON [labels_pull_requests] ([pull_requests_id]);
CREATE INDEX [idx_labels_pull_requests_labels_id]
    ON [labels_pull_requests] ([labels_id]);