Cached database and synchronization system for providing dynamic linked panels in user interface
A system is configured to provide a dashboard creation system. Panels associated with queries for retrieving information from a database are shown in a user interface. Various other user interfaces show query code, panel display settings, function code, dependencies, etc. Queries in a first query format access a data source. Queries in a second query format access a cache database that is synchronized with the data source.
1. A computer system comprising:
one or more processors configured to execute code to cause the system to:
display a first user interface comprising:
a panel associated with code to query a first dataset, wherein the panel is configured to render a visualization of the first dataset based on display settings associated with the panel;
display a second user interface comprising:
the code to query the first dataset;
request, from a data synchronization server, a synchronization status of datasets between a cache and a data source;
receive, in response to the request, synchronization statuses of a plurality of datasets, the plurality of datasets including the first dataset;
display, as part of one or more user interfaces:
a listing of the plurality of datasets;
data included in the first dataset; and
information about a synchronization of the first dataset between a cache and a data source; and
receive user input indicating a selected dataset from among the plurality of datasets; and
generate a synchronization request to synchronize the selected dataset between the cache and the data source.
2. The computer system of claim 1 , wherein the information about the synchronization of the first dataset includes a time of a last synchronization event.
3. The computer system of claim 1 , wherein the one or more processors are further configured to execute code to cause the system to:
receive, in the second user interface, user input changing a format of the query.
4. The computer system of claim 1 , wherein the one or more processors are further configured to execute code to cause the system to:
in response to a user interaction with a dataset name in the code in the second interface, display a dataset helper menu showing autocorrected or autocompleted names based on the dataset name.
5. The computer system of claim 4 , wherein the dataset helper menu also shows a synchronization status of databases having the autocorrected or autocompleted names.
6. The computer system of claim 1 , wherein the one or more processors are further configured to execute code to cause the system to:
generate, in response to a modification of the data included in the first dataset, a synchronization request to synchronize the first dataset between the cache and the data source.
7. The computer system of claim 1 , wherein the one or more processors are further configured to execute code to cause the system to:
display, in a third user interface, a visualization showing which documents use the first dataset.
8. The computer system of claim 1 , wherein the one or more processors are further configured to execute code to cause the system to:
display, in a third user interface, a visualization showing other datasets dependent on the first dataset.
9. The computer system of claim 1 , wherein the one or more processors are further configured to execute code to cause the system to:
display an indication of a cache or data store that the first dataset is located in.
10. A computer-implemented method comprising:
displaying a first user interface comprising:
a panel associated with code to query a first dataset, wherein the panel is configured to render a visualization of the first dataset based on display settings associated with the panel;
displaying a second user interface comprising:
the code to query the first dataset;
requesting, from a data synchronization server, a synchronization status of datasets between a cache and a data source;
receiving, in response to the request, synchronization statuses of a plurality of datasets, the plurality of datasets including the first dataset; and
displaying, as part of one or more user interfaces:
a listing of the plurality of datasets;
data included in the first dataset; and
information about a synchronization of the first dataset between a cache and a data source.
11. The computer-implemented method of claim 10 , further comprising:
receiving user input indicating a selected dataset from among the plurality of datasets; and
generating a synchronization request to synchronize the selected dataset between the cache and the data source.
12. The computer-implemented method of claim 10 , further comprising:
receiving, in the second user interface, user input changing a format of the query.
13. The computer-implemented method of claim 10 , further comprising:
in response to a user interaction with a dataset name in the code in the second interface, displaying a dataset helper menu showing autocorrected or autocompleted names based on the dataset name.
14. The computer system of claim 13 , wherein the dataset helper menu also shows a synchronization status of databases having the autocorrected or autocompleted names.
15. The computer-implemented method of claim 10 , further comprising:
generating, in response to a modification of the data included in the first dataset, a synchronization request to synchronize the first dataset between the cache and the data source.
16. The computer-implemented method of claim 10 , further comprising:
displaying, in a third user interface, a visualization showing which documents use the first dataset.
17. The computer-implemented method of claim 10 , further comprising:
displaying, in a third user interface, a visualization showing other datasets dependent on the first dataset.
18. The computer-implemented method of claim 10 , further comprising:
displaying an indication of a cache or data store that the first dataset is located in.