github

Custom SQL query returning 13 rows (hide)

Query parameters

This data as json, CSV

shamessageauthor_datecommitter_dateraw_authorraw_committerrepoauthorcommitter
3cce63b59851495b6d9d38936356e21ea8fbad3a URL to allow direct database download It's just the database URL with .db on the end, e.g. /flights.db Closes #19 2017-10-25T15:19:32Z 2017-10-25T15:19:32Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
f1b0521810bbc467721e4dcc5a2ff1bf2a1ddbb8 Preserve .json through redirects 2017-10-25T15:01:22Z 2017-10-25T15:01:22Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
d94d4465d7e72e668122f81206397f4f20cf555b Double quote around column names This means filters still work even with column names that contain spaces 2017-10-25T14:47:20Z 2017-10-25T14:47:20Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
e55bc3b2fa6e1e8be7b7c1f5b6cb3764713b6faa th align left for all tables 2017-10-25T14:46:38Z 2017-10-25T14:46:38Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
1c5977961f596dae5aaa18c8b2d7a10e9f42a543 Added glob and like lookups - refs #23 2017-10-25T01:53:01Z 2017-10-25T01:53:01Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
630b40038ef31b351abc2e39c3a0c7b3648814f8 Added support for gt, gte, lt, lte lookups Refs #23 2017-10-25T01:46:49Z 2017-10-25T01:46:55Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
6823b094066c5cb1dcd3581da2ed877ed72298b7 Set time limit of 1000ms on SQL queries Using the (undocumented in the Python docs) fact that if you return 1 from a set_progress_handler callback, SQLite will cancel the current query. Closes #35 2017-10-25T01:34:54Z 2017-10-25T01:34:54Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
2fe94641b0b2dc291d1fce3dad0fbf96294b3a32 Don't try to show row counts for views Also handle tables/views with spaces in their name in the URL. 2017-10-25T01:33:12Z 2017-10-25T01:33:12Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
bd5f3b2ba1a627383d512d613b77d15501dfccc4 Show time taken at bottom of table page 2017-10-25T01:31:54Z 2017-10-25T01:31:54Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
3eb79e1a5fa4c164a224ae0adbe0ea16fde35758 Show total row count at top of table page 2017-10-25T01:31:43Z 2017-10-25T01:31:43Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
eef213ab4d57622dfc60c8655c0c7a18afcc844f Show total number of rows in table 2017-10-25T00:11:36Z 2017-10-25T00:11:36Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
1ae8ea0f03cfb9f25b1e25f3194c456c3649789c Started implementing ?name__contains=X filters So far we support __contains=, __startswith=, __endswith= and __exact= Refs #23 2017-10-25T00:06:23Z 2017-10-25T00:06:23Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
4c7379a898df426af0c31159e5cb06d672189301 Don't crash on weird character encodings Expecting SQLite columns to all be valid utf8 doesn't work, because we are deailing with all kinds of databases. Instead, we now use the 'replace' encoding mode to replace any non-UTF8 characters with a [X] character. 2017-10-25T00:01:34Z 2017-10-25T00:01:34Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599