How to access Grist's sqlite3 databases?

Ask for Help
1

I am experimenting with grist-desktop to handle a small application I’m developing. While all data entry will be using Grist I want to be able to read data programatically using sqlite3 on the command line.

I’m pretty sure Grist uses sqlite3 for storing its data but I can’t find where at the moment. Can someone tell me where the files are please? If I need to move to a different version of Grist then that’s OK, I’m running on a linux Debian system with a web server and so on.

2

Hi @Chris_Green, if you created a new document you should have been prompted for where you wanted to put it. It should be a *.grist file. Likewise if you imported something. a *.grist file can be read for the most part with sqlite3, for simple data types like numbers and strings. Your tables should be there, with your columns as you see in Grist.

3

Ah, OK, yes - thank you. I hadn’t realised that the *.grist file was a sqlite3 database. That’s exactly what I needed! :slight_smile: