forked from squadrun/django-sql-explorer
-
Notifications
You must be signed in to change notification settings - Fork 0
/
HISTORY
143 lines (105 loc) · 5.07 KB
/
HISTORY
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
0.9.1, 0.9.2
=====
2/2/2016
- Fixed readme issue (.1) and setup.py issue (.2)
0.9.1
=====
2/1/2016
- Major changes
- Dropped support for Django 1.6, added support for Django 1.9. See .travis.yml for test matrix.
- Dropped charted.js & visualization because it didn't work well.
- Client-side pivot tables with pivot.js. This is ridiculously cool!
- Minor (but awesome!) changes
- Cmd-/ to comment/uncomment a block of SQL
- Quick 'shortcut' links to the corresponding querylog to more quickly share results. Look at the top-right of the editor. Also works for playground!
- Prompt for unsaved changes before navigating away
- Support for default parameter values via $$paramName:defaultValue$$
- Optional Celery task for truncating query logs as entries build up
- Display historical average query runtime
- Increased default number of rows from 100 to 1000
- Increased SQL editor size (5 additional visible lines)
- CSS cleanup and streamlining (making better use of foundation)
- Various bugfixes (blacklist not enforced on playground being the big one)
- Upgraded front-end libraries
- Hide Celery-based features if tasks not enabled.
0.8.0
=====
10/21/2015
- Snapshots! Dump the csv results of a query to S3 on a regular schedule. More details in readme.rst under 'features'.
- Async queries + email! If you have a query that takes a long time to run, execute it in the background and Explorer will send you an email with the results when they are ready. More details in readme.rst
- Run counts! Explorer inspects the query log to see how many times a query has been executed.
- Column Statistics! Click the ... on top of numeric columns in the results pane to see min, max, avg, sum, count, and missing values.
- Python 3! - Django 1.9!
- Delimiters! Export with delimiters other than commas.
- Listings respect permissions! If you've given permission to queries to non-admins, they will see only those queries on the listing page.
0.7.0
=====
2/18/2015
- Added search functionality to schema view and explorer view (using list.js).
- Python 2.6 compatibility.
- Basic charts via charted (from Medium via charted.co).
- SQL formatting function.
- Token authentication to retrieve csv version of queries.
- Fixed south_migrations packaging issue.
- Refactored front-end and pulled CSS and JS into dedicated files.
0.6.0
=====
11/5/2014
- Introduced Django 1.7 migrations. See readme.rst for info on how to run South migrations if you are not on Django 1.7 yet.
- Upgraded front-end libraries to latest versions.
- Added ability to grant selected users view permissions on selected queries via the EXPLORER_USER_QUERY_VIEWS parameter
- Example usage: EXPLORER_USER_QUERY_VIEWS = {1: [3,4], 2:[3]}
- This would grant user with PK 1 read-only access to query with PK=3 and PK=4 and user 2 access to query 3.
- Bugfixes
- Navigating to an explorer URL without the trailing slash now redirects to the intended page (e.g. /logs -> /logs/)
- Downloading a .csv and subsequently re-executing a query via a keyboard shortcut (cmd+enter) would re-submit the form and re-download the .csv. It now correctly just refreshes the query.
- Django 1.7 compatibility fix
0.5.1
=====
- Bugfixes
- Created_by_user not getting saved correctly
- Content-disposition .csv issue
- Issue with queries ending in ...like '%... clauses
- Change the way customer user model is referenced
- Pseudo-folders for queries. Use "Foo - Ba1", "Foo - Bar2" for query names and the UI will build a little "Foo" pseudofolder for you in the query list.
0.5.0
=====
- Query logs! Accessible via explorer/logs/. You can look at previously executed queries (so you don't, for instance, lose that playground query you were working, or have to worry about mucking up a recorded query). It's quite usable now, and could be used for versioning and reverts in the future. Itan be accessed at explorer/logs/
- Actually captures the creator of the query via a ForeignKey relation, instead of just using a Char field.
- Re-introduced type information in the schema helpers.
- Proper relative URL handling after downloading a query as CSV.
- Users with view permissions can use query parameters. There is potential for SQL injection here. I think about the permissions as being about preventing users from borking up queries, not preventing them from viewing data. You've been warned.
- Refactored params handling for extra safety in multi-threaded environments.
0.4.1
=====
2/24/2014
- Renaming template blocks to prevent conflicts
0.4
===
2/14/2014 - Happy Valentine's Day!
- Templatized columns for easy linking
- Additional security config options for splitting create vs. view permissions
- Show many-to-many relation tables in schema helper
0.3
===
1/25/14
- Query execution time shown in query preview
- Schema helper available as a sidebar in the query views
- Better defaults for sql blacklist
- Minor UI bug fixes
0.2
===
1/5/14
- Support for parameters
- UI Tweaks
- Test coverage
0.1.1
=====
12/31/13
Bug Fixes
- Proper SQL blacklist checks
- Downloading CSV from playground
0.1
===
12/29/13
Initial Release