commits

Table actions

6 rows where "author_date" is on date 2017-11-09

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committer_date (date)

author_date (date) 1 ✖

  • 2017-11-09 · 6 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
292f140a4f391f646ec0be85ec9f22dde30f9de2 Explicitly order by pk (or by rowid) Refs #5 2017-11-09T16:11:14Z 2017-11-09T16:11:14Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
8af7bc100c681975894f49f4ffd6d26a06e93f60 Added a MANIFEST.in Now python setup.py bdist_wheel creates a .whl that includes the CSS. 2017-11-09T02:39:42Z 2017-11-09T02:39:42Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
abb591d83264bbf11a5eb9daf03011d051e8f833 Added --reload argument to 'immutabase serve' command Uses hupper to restart the server when the code changes. Useful for development. Depends on https://pypi.python.org/pypi/hupper 2017-11-09T13:46:16Z 2017-11-09T14:14:26Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
b2dee11fcd989d9e2a7bf4de1e23dbc320c05013 Databases now get distinct colours A left border based on their content hash. Closes #31 2017-11-09T14:12:42Z 2017-11-09T14:14:40Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
bc9871c93583f3cdcca191b7fa05b255be7275c8 gt/lt/gte/lte now treat numeric arguments as numeric This now works: https://immutabase-dlmggyoepw.now.sh/northwind-40d049b/Products?UnitsInStock__gt=100 Previously the input value of 100 would be treated as a string. Also fixed a bug where filter arguments had stopped working entirely. Refs #23 2017-11-09T16:09:55Z 2017-11-09T16:09:55Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
d9fa2bf7ba2f9d3dcb2beb303f772c86344b4bcf Use rowid if no primary key available Allows us to link to individual records even for tables that do not have a primary key. Refs #5 2017-11-09T14:39:50Z 2017-11-09T14:39:50Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599

Advanced export

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

CSV options: 

CREATE TABLE [commits] (
   [sha] TEXT PRIMARY KEY,
   [message] TEXT,
   [author_date] TEXT,
   [committer_date] TEXT,
   [raw_author] TEXT REFERENCES [raw_authors]([id]),
   [raw_committer] TEXT REFERENCES [raw_authors]([id]),
   [repo] INTEGER REFERENCES [repos]([id]),
   [author] INTEGER REFERENCES [users]([id]),
   [committer] INTEGER REFERENCES [users]([id])
);
CREATE INDEX [idx_commits_committer]
                ON [commits] ([committer]);
CREATE INDEX [idx_commits_author]
                ON [commits] ([author]);
CREATE INDEX [idx_commits_repo]
                ON [commits] ([repo]);
CREATE INDEX [idx_commits_raw_committer]
                ON [commits] ([raw_committer]);
CREATE INDEX [idx_commits_raw_author]
                ON [commits] ([raw_author]);