commits

Table actions

15 rows where "author_date" is on date 2017-10-24

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: author_date (date), committer_date (date)

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
02b1814fcfdc61b1b69b5955f2b60252ff10cde9 Redirects now preserve query string Fixes #28 2017-10-24T23:54:26Z 2017-10-24T23:54:26Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
0fa177269767e5e55c863382333fde627d2b7074 Allow ?sql= argument against database e.g. /database-234324?sql=select * from table limit 1 2017-10-24T02:48:56Z 2017-10-24T02:48:56Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
12f7e1dc5624d14f644abead18bd90b420b6d97e Hashed URLs now have far-future cache expiry Since the URL now includes a hash of the database, we can return a Cache- Control: max-age=31536000 header for every response. The exception is our 302 redirects. These we now serve with a Link: header that tells any HTTP/2 server-push aware fronting proxies (such as Cloudfront) to push the target of the redirect. Closes #4 2017-10-24T02:36:44Z 2017-10-24T02:36:44Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
255e2611e5c3cfdda76c9da7abdbe5af976044ac CORS headers for JSON responses Access-Control-Allow-Origin: * 2017-10-24T02:48:06Z 2017-10-24T02:48:06Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
2a09d3708777116daedc548078a662086552523f Allow views to be browsed as well as tables 2017-10-24T23:55:08Z 2017-10-24T23:55:08Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
5f806880c9766daf09fc9535171637ebb8224cab Correctly JSON serialize sqlite3.Cursor 2017-10-24T23:53:21Z 2017-10-24T23:53:21Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
606ff9e35e007ae58a491d417f47779034bacabc python app.py --build to generate build-metadata.json This is now run by the Dockerfile to build this at compile time. 2017-10-24T05:53:13Z 2017-10-24T05:53:13Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
6a9fdcc0718aea2cbc01ae4d60b9a1fba3601a66 Added addressable page per row Refs #1 - only exists for tables with introspectable primary keys. Still need to link to this page. Also added first unit tests - refs #9 2017-10-24T05:54:58Z 2017-10-24T05:54:58Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
9d219140694551453bfa528e0624919eb065f9d6 Refactored to use class based views Closes #22 2017-10-24T02:25:48Z 2017-10-24T02:25:48Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
b20d7119e4f6506cdb9d5d11322e28130823adfd Implemented template inheritance and brought back errors 2017-10-24T02:56:27Z 2017-10-24T02:56:27Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
b2372605d63248f422b6e67cb5c392236a3aa612 Implemented multi-db support plus initial URL structure Refs #24 Fixes #15 2017-10-24T02:00:37Z 2017-10-24T02:00:37Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
b46e370ee6126aa2fa85cf789a31da38aed98496 Link to pages-per-row Closes #1 2017-10-24T14:10:58Z 2017-10-24T14:10:58Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
bc9379aabcedce7fbc661ac15008d8801199a045 Added .jsono extension Returns JSON key/value objects for each row instead of lists of values. Closes #6 2017-10-24T15:07:52Z 2017-10-24T15:07:52Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
c371f06fdea413cfb00aa8f81b7a5535a7ecdbc4 Include took_ms in JSON output 2017-10-24T23:55:53Z 2017-10-24T23:55:53Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
f643f7aee1b3d29df82b93a6560887a35b7a2f13 base64 encode bytestrings from DB in JSON Fixes #29 2017-10-24T14:58:41Z 2017-10-24T14:58:41Z 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]);