1,917 rows

View and edit SQL

Link labels_id issues_id
json-api 754730474 Redesign JSON output, ditch jsono, offer variants controlled by parameter instead 275092453
large 729587544 Datasette serve should accept paths/URLs to CSVs and other file formats 275125561
feature 947261894 Datasette serve should accept paths/URLs to CSVs and other file formats 275125561
duplicate 727708733 Filtered table view should show a count 275176094
bug 727708732 ?_search=x should work if used directly against a FTS virtual table 275179724
good first issue 727708736 "Reformat SQL" button next to SQL editor textarea 275228834
large 729587544 Per-database and per-table metadata, probably using data-package 275476839
feature 947261894 datasette publish gcloud 276455748
enhancement 727708734 Set up a pattern portfolio 276718605
css 1918831023 Set up a pattern portfolio 276718605
design 2175284252 Set up a pattern portfolio 276718605
bug 727708732 Incorrect display of rows page for tables with a primary key 276765070
bug 727708732 A primary key column that has foreign key restriction associated won't rendering label column 277589569
bug 727708732 Link should not show up in the column selection dropdowns 279199916
documentation 750789605 Document the querystring argument for setting a different time limit 279547886
bug 727708732 Nasty bug: last column not being correctly displayed 280315352
metadata 947465681 License/Source in footer should inherit from top level 281197863
feature 947261894 Add GraphQL endpoint 285168503
metadata 947465681 More metadata options for template authors  288438570
bug 727708732 500 from missing table name 292011379
small 729585263 500 from missing table name 292011379
feature 947261894 Metadata should be a nested arbitrary KV store 299760684
metadata 947465681 Metadata should be a nested arbitrary KV store 299760684
large 729587544 Ability to bundle metadata and templates inside the SQLite file 309047460
feature 947261894 Ability to bundle metadata and templates inside the SQLite file 309047460
metadata 947465681 Ability to bundle metadata and templates inside the SQLite file 309047460
medium 729586521 Ability to sort (and paginate) by column 309471814
bug 727708732 Keyset pagination doesn't work correctly for compound primary keys 309558826
help wanted 727708735 Figure out how to bundle a more up-to-date SQLite 310533258
small 729585263 Run pks_for_table in inspect, executing once at build time rather than constantly 312313496
feature 947261894 Ability to sort by more than one column 312395790
feature 947261894 Ability to sort with nulls last 312396095
small 729585263 Ability to apply sort on mobile in portrait mode 312620566
small 729585263 Support explain select / explain query plan select 313512748
plugins 754269786 Load plugins from a `--plugins-dir=plugins/` directory 314471743
plugins 754269786 Documentation for plugins system 314506033
plugins 754269786 Ability for plugins to define extra JavaScript and CSS 314506446
javascript 2389410569 Ability for plugins to define extra JavaScript and CSS 314506446
plugins 754269786 Allow plugins to define additional URL routes and views 314506669
feature 947261894 Allow plugins to define additional URL routes and views 314506669
bug 727708732 Bug: Sort by column with NULL in next_page URL 314665147
datasette-publish 750250793 Plugin support for datasette publish 314725342
plugins 754269786 Plugin support for datasette publish 314725342
feature 947261894 Plugin support for datasette publish 314725342
small 729585263 Support custom unit display in order to handle "$10,000" 314771615
feature 947261894 Support custom unit display in order to handle "$10,000" 314771615
wontfix 727708739 Investigate syntactic sugar for plugins 314847571
plugins 754269786 Investigate syntactic sugar for plugins 314847571
feature 947261894 Investigate syntactic sugar for plugins 314847571
wontfix 727708739 Allow plugins to add new cli sub commands  315142414
plugins 754269786 Allow plugins to add new cli sub commands  315142414
feature 947261894 Allow plugins to add new cli sub commands  315142414
plugins 754269786 datasette publish --install=name-of-plugin 315327860
plugins 754269786 Ability for plugins to bundle templates 315517578
plugins 754269786 Unit tests for installable plugins 315738696
tests 2092302176 Unit tests for installable plugins 315738696
plugins 754269786 prepare_context() plugin hook 315960272
feature 947261894 prepare_context() plugin hook 315960272
small 729585263 If spatialite detected, mark idx_XXX_Geometry tables as hidden 316031566
bug 727708732 Setting page size AND max returned rows to 1000 doesn't seem to work 316128955
small 729585263 Setting page size AND max returned rows to 1000 doesn't seem to work 316128955
plugins 754269786 metadata.json support for plugin configuration options 316323336
metadata 947465681 metadata.json support for plugin configuration options 316323336
feature 947261894 Option to expose expanded foreign keys in JSON/CSV 316444720
medium 729586521 Add limit on the size in KB of data returned from a single query 316621102
help wanted 727708735 datasette publish lambda plugin 317001500
datasette-publish 750250793 datasette publish lambda plugin 317001500
feature 947261894 datasette publish lambda plugin 317001500
wontfix 727708739 External metadata.json 317714268
plugins 754269786 External metadata.json 317714268
feature 947261894 External metadata.json 317714268
metadata 947465681 External metadata.json 317714268
small 729585263 FTS table detection should be part of .inspect() 317900587
feature 947261894 Default datasette logging format should be JSON 318490133
documentation 750789605 Documentation explaining how to use SQLite FTS with Datasette 321631020
faceting 1382668283 Facets 322477187
feature 947261894 inspect() should detect many-to-many relationships 322787470
metadata 947465681 Validate metadata.json on startup 323223872
large 729587544 Add ?_extra= mechanism for requesting extra properties in JSON 323658641
plugins 754269786 Add ?_extra= mechanism for requesting extra properties in JSON 323658641
feature 947261894 Add ?_extra= mechanism for requesting extra properties in JSON 323658641
refactor 1379448359 Add ?_extra= mechanism for requesting extra properties in JSON 323658641
documentation 750789605 Add links to example Datasette instances to appropiate places in docs 323677499
large 729587544 Export to CSV 323681589
documentation 750789605 Export to CSV 323681589
feature 947261894 Export to CSV 323681589
documentation 750789605 Documentation for URL hashing, redirects and cache policy 323716411
help wanted 727708735 Mechanism for ranking results from SQLite full-text search 323718842
medium 729586521 Mechanism for ranking results from SQLite full-text search 323718842
feature 947261894 Mechanism for ranking results from SQLite full-text search 323718842
search 2477722856 Mechanism for ranking results from SQLite full-text search 323718842
medium 729586521 Mechanism for automatically picking up changes when on-disk .db file changes 324162476
feature 947261894 Mechanism for automatically picking up changes when on-disk .db file changes 324162476
large 729587544 Port Datasette to ASGI 324188953
feature 947261894 Port Datasette to ASGI 324188953
help wanted 727708735 Figure out a way to have /-/version return current git commit hash 324451322
small 729585263 Figure out a way to have /-/version return current git commit hash 324451322
feature 947261894 "config" section in metadata.json (root, database and table level) 324720095
metadata 947465681 "config" section in metadata.json (root, database and table level) 324720095
feature 947261894 Handle spatialite geometry columns better 324835838

Next page

Advanced export

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

CSV options:

CREATE TABLE [issues_labels] (
   [labels_id] INTEGER REFERENCES [labels]([id]),
   [issues_id] INTEGER REFERENCES [issues]([id]),
   PRIMARY KEY ([issues_id], [labels_id])
);
CREATE INDEX [idx_issues_labels_issues_id]
                ON [issues_labels] ([issues_id]);
CREATE INDEX [idx_issues_labels_labels_id]
                ON [issues_labels] ([labels_id]);