Comments (2)
I'm not interested in these in Datasette core itself, but I think they have a ton of potential for plugins.
I wonder what the best way to handle that would be?
Right now it's possible to write a plugin that adds extra routes, so someone could build a /dbname/-/prql?query=xxx
endpoint.
If this could return JSON, they could add JavaScript to the /dbname
page that provided a UI for kicking off one of those queries.
Something that could make that more ergonomic might be the plugin hook that allows plugins to add extra HTML to different core database pages - e.g. adding a "Query this database using PRQL" button or link or even a full form at the top of that database page. That's this issue here:
from datasette.
Thinking about this more, here a list of things I imagine a "compile-to-sql" plugin would want to do:
- Attach itself to the SQL code editor (switch from SQL -> PRQL/Logica, additional syntax highlighting)
- Add "Query using PRQL" buttons in various parts of Datasette's UI, like
/dbname
page - Use
$LANGUAGE=
instead ofsql=
in the JSON API and the SQL results pages - Have their own dedicated code editor page
- and 2) would be difficult to do with current plugin hooks, unless we add the concept of "slots" and get the JS plugin support in. 3) could maybe be done with the
asgi_wrapper(datasette)
hook? And 4) ca n be done easily with theregister_routes()
hooks.
So it really only sounds like extending the SQL editor will be the hard part. In #2094 I want to add JavaScript plugin hooks for extending the SQL editor, which may work here.
If I get the time/motivation, I might try out a datasette-prql
extension, just because I like playing with it. It'd be really cool if I can get the asgi_wrapper()
hook to work right there...
from datasette.
Related Issues (20)
- Datasette for serving JSON only
- Server hang on parallel execution of queries to named in-memory databases HOT 31
- "Test DATASETTE_LOAD_PLUGINS" test shows errors but did not fail the CI run HOT 6
- Deploy failing with "plugins/alternative_route.py: Not a directory" HOT 8
- `datasette publish` needs support for the new config/metadata split HOT 12
- Discord invite link returns 401 HOT 2
- click-default-group-wheel dependency conflict HOT 3
- --load-extension=spatialite not working with Windows HOT 3
- Detailed upgrade instructions for metadata.yaml -> datasette.yaml HOT 7
- Discord invite link is invalid
- custom plugin not seen as sql function
- request.post_body() can only be called once
- request.post_vars() method obliterates form keys with multiple values HOT 3
- ModuleNotFoundError: No module named 'click_default_group
- No suggested facets when a column named 'value' is included HOT 1
- Unreachable exception handlers for `sqlite3.OperationalError`
- Can't filter with numbers
- feature request: gzip compression of database downloads HOT 1
- CSV export with ?_labels=on fails at first row with a foreign key that fails to resolve correctly HOT 22
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from datasette.