Simon Willison
c5f06bc356
"white-space: pre-wrap" for all table cells, refs #896
2020-07-16 12:06:45 -07:00
Simon Willison
2115d7e345
Logout link in nav, refs #875
2020-06-29 11:40:40 -07:00
Simon Willison
4fa7cf6853
Flash messages mechanism, closes #790
2020-06-02 14:12:18 -07:00
Simon Willison
faea5093b8
Column headings now black in mobile view, closes #729
2020-05-15 11:16:47 -07:00
Simon Willison
504196341c
Visually distinguish float/int columns, closes #729
2020-05-14 22:51:39 -07:00
Simon Willison
2a36dfa2a8
Fix for input type=search Webkit styling, closes #701
2020-03-24 15:57:09 -07:00
Simon Willison
d3e1c3017e
Display 0 results, closes #637
2019-11-22 22:07:01 -08:00
Tobias Kunze
af2e6a5cf1
Button to format SQL, closes #136
...
SQL code will be formatted on page load, and can additionally
be formatted by clicking the "Format SQL" button.
Thanks, @rixx!
2019-10-13 20:46:12 -07:00
Simon Willison
787dd427de
white-space: pre-wrap for table SQL, closes #505
2019-07-07 13:26:38 -07:00
Simon Willison
f80ff9b07b
min-height on .hd
...
Now it should be the same size on the homepage as it is on pages with breadcrumbs
2019-07-07 13:16:48 -07:00
Simon Willison
a18e0964ec
Refactor templates for better top nav customization, refs #540
2019-07-05 13:34:41 -07:00
Simon Willison
bc6a9b4564
?_where= parameter on table views, closes #429
...
From pull request #430
2019-04-12 18:37:22 -07:00
Simon Willison
4462a5ab28
Show size of database file next to download link, closes #172
2019-02-05 20:58:29 -08:00
Simon Willison
83f4ef7ec7
Improved UI for CSV/JSON export, closes #266
2018-06-17 23:05:18 -07:00
Simon Willison
7381af85e6
Hide sort select on larger screens, closes #300
2018-05-31 07:43:06 -07:00
Simon Willison
918de9403e
Only apply responsive table styles to .rows-and-column
...
Otherwise they interfere with tables in the description, e.g. on
https://fivethirtyeight.datasettes.com/fivethirtyeight/nba-elo%2Fnbaallelo
2018-05-20 08:10:46 -07:00
Simon Willison
7261584f04
Display currently selected facets better, refs #255
2018-05-16 19:42:31 -07:00
Simon Willison
062303419c
Hide facet button is now a ✖ - refs #255
2018-05-16 08:27:24 -07:00
Simon Willison
91bf5f56bb
Show enabled facets in flexbox columns, refs #255
2018-05-16 08:27:24 -07:00
Russ Garrett
136a70d887
Add column name classes to <td>s, make PK bold
2018-04-17 18:13:02 -07:00
Simon Willison
57b19f09d1
Ability to sort using form fields (for mobile portrait mode)
...
We now display sort options as a select box plus a descending checkbox, which
means you can apply sort orders even in portrait mode on a mobile phone where
the column headers are hidden.
Closes #199
2018-04-09 17:34:32 -07:00
Simon Willison
1ecac1a438
Fix display of select boxes in Firefox
2017-12-02 12:53:08 -08:00
Simon Willison
a802cbee74
Search now applies to current filters
...
Combined search into the same form as filters.
Closes #133
2017-11-24 14:29:54 -08:00
Simon Willison
8a37baba14
Much tidier design for table view header
...
Closes #147
2017-11-24 14:02:39 -08:00
Simon Willison
7708887681
Tweaked styling of submit buttons and search box
2017-11-23 12:39:26 -08:00
Simon Willison
22b91dd95b
Further tweaks to select/input filter styling
...
Refs #86 - thanks for the help, @natbat!
2017-11-23 12:05:51 -08:00
Simon Willison
a74e455ced
Custom styled select boxes for filters
...
Refs #86
2017-11-23 07:58:55 -08:00
Simon Willison
38dc1ef73b
Show linked foreign key in table cells
2017-11-22 20:43:27 -08:00
Simon Willison
1c8638c30a
Hide FTS-created tables on index pages
...
Closes #129
2017-11-22 12:18:57 -08:00
Simon Willison
eed6a0fe36
Implemented ?_search=XXX + UI if a FTS table is detected
...
Closes #131
2017-11-19 08:59:26 -08:00
Simon Willison
1b04662585
Table views now show expanded foreign key references, if possible
...
If a table has foreign key columns, and those foreign key tables have
label_columns, the TableView will now query those other tables for the
corresponding values and display those values as links in the corresponding
table cells.
label_columns are currently detected by the inspect() function, which looks
for any table that has just two columns - an ID column and one other - and
sets the label_column to be that second non-ID column.
2017-11-17 19:15:49 -08:00
Simon Willison
5d8084a285
Added a UI for editing named parameters
...
Fixes #96
2017-11-15 17:32:48 -08:00
Tom Dyson
8252daa4c1
SQL syntax highlighting with Codemirror ( #89 )
2017-11-14 18:03:00 -08:00
Simon Willison
79216bac12
Added some breathing room to the footer
2017-11-13 11:38:20 -08:00
Simon Willison
f4794df070
Added border-right to table cells
2017-11-12 12:19:18 -08:00
Simon Willison
59580d02da
Implemented custom SQL via textarea
...
Closes #65
2017-11-11 18:35:35 -08:00
Simon Willison
fd3a33989a
Implemented new database view and template
...
Closes #53 - see comments there for screenshots.
2017-11-11 17:50:21 -08:00
Simon Willison
e4bf66d9b0
Added header with breadcrumbs and footer
...
Also cleaned up titles on various pages.
Closes #61
2017-11-11 12:36:20 -08:00
Simon Willison
7d81083d40
Implemented responsive tables, removed bootstrap
...
No need for all of bootstrap since we only need to style a few elements.
Implemented responsive table pattern from here:
https://css-tricks.com/responsive-data-tables/
Refs #16
2017-11-10 21:55:50 -08:00
Simon Willison
e7e50875d3
Renamed to 'datasette'
2017-11-10 10:38:35 -08:00