4 ms·
That is cool. I have so many projects with sqlite but all on my local machine. Is it possible to import an sqlite ? Also could you help understand what happens
by samblr 6y ago
That is cool. I have so many projects with sqlite but all on my local machine. Is it possible to import an sqlite ?
Also could you help understand what happens behind the scenes in your backend & some best practices involved in using SQLite in backend. Like how do you mount them on to say to your backend if you are using docker/kubernetes.
- paulfitz 6y agoAh, we do have a general purpose importer from sqlite lurking but not published, I'll bump its priority. In the meantime, you can use the hosted or local rest api from python or javascript to generate a grist spreadsheet https://support.getgrist.com/rest-api/ https://support.getgrist.com/rest-api/. On the backend, for serving individual user spreadsheets, we use node/express workers connecting to a pool of sqlite files, persisted via the sqlite backup api https://sqlite.org/backup.html https://sqlite.org/backup.html https://github.com/mapbox/node-sqlite3/pull/1116 https://github.com/mapbox/node-sqlite3/pull/1116. If you want to dig in, you could poke around at https://github.com/gristlabs/grist-core https://github.com/gristlabs/grist-core