Comments (5)
Thanks for the advice @jared-hardy! I've modified the issue to be clear that it is talking about how individual Grist documents are stored - which doesn't affect your point, I just realized the issue could be read to apply to the full service.
In the world of spreadsheets, it helps for Grist documents to have a complete, standalone, downloadable, email-able representation, and SQLite works very well for that. But as you point out there are ways we could retain that representation as a backing store. Worth thinking about.
from grist-core.
There's an endpoint for SQL queries. Documentation: https://support.getgrist.com/api/#tag/sql
from grist-core.
As a cloud service provider, I highly recommend you move up to a more reliable network-distributed database backend (which can still utilize an SQLite file backing store, such as Dqlite or BedrockDB), and this in turn should give you access to a known network wire protocol for SQL (and potentially GraphQL) transactions "for free" as a result of distributed service integration. BedrockDB for example provides the option of a MySQL emulated wire protocol. Other more advanced distributed databases like Yugabyte-DB offer the option of PostgreSQL compatible wire protocols, with many connection pooler and proxy options available to help control customer access.
from grist-core.
Hi - I've recently hacked together this POC. I plan to use this to run SQL on my Grist docs: https://github.com/johncant/gristfdw
from grist-core.
For a static export of an interactive grist, there is an SQLite version that compiles down to WebAssembly and is called sql.js-httpvfs
and described in the article Hosting SQLite databases on Github Pages - (or any static file hoster) - phiresky's blog, with more peeks on Twitter.
And as the storage interface already builds on the SQLite dialect 1 and TypeORM
Line 119 in 7f1f8fc
This is another direct SQL interface one could think of, not only as an interface in the grist
UI, but as swappable persistence layer for the application itself. And also for retroactive analysis and visualisation with software like:
- vega/voyager: Visualization Tool for Data Exploration
- vega/lyra: An interactive, graphical Visualization Design Environment (VDE)
- constellation-app/constellation: A graph-focused data visualisation and interactive analysis application.
- finos/perspective: Streaming pivot visualization via WebAssembly
- rawgraphs/rawgraphs-app: A web interface to create custom vector-based visualizations on top of RAWGraphs core
- getredash/redash: Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
Next to the prior aspects, an SQL dump/static SQLite export from a given user's point of view of the database also opens the door for selected exports, e.g. staticly packed, interactively visualised datasets in 'grist-to-go'.
from grist-core.
Related Issues (20)
- Improvements for switch site menu HOT 1
- User column type
- regression: GRIST_DEFAULT_PRODUCT not being respected HOT 1
- Access signaling
- Accidentally ran rootless: (Fatal SSL error crash), can rootless be supported? HOT 5
- File Retrieval Trigger Formula
- List uncaught exceptions
- Add more contextual css variables for more css customization control
- Rest API endpoint to purge history of a document HOT 3
- [SELF HOSTED] MINIO - Problem with "non-conventionnal" Region HOT 3
- BUG window.crypto.randomUUID is not a function HOT 4
- Improve onboarding flow
- Improve Grist home page
- High Vulnerability Count in Latest Docker Image
- Add duration column type
- decimal number entry broken with locale "Denmark (English)" HOT 6
- UI for 'Terms of use' modale HOT 4
- Mandatory field for widgets
- Test
- self-hosted: hide snapshot UI if not enabled
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 grist-core.