4 ms·
I see something about uploading the CSV file. Not clear where the sqlite dB is being created. Is it local? Does the browser create it? Ideally I would like to r
by obelix_ 8y ago
I see something about uploading the CSV file. Not clear where the sqlite dB is being created. Is it local? Does the browser create it? Ideally I would like to run this locally when I am playing with data.
What's been the largest file tested? Basically what's the max rows/cols it can handle fast?
- simonw 8y agoYou can run it locally - that's the default way to use it. "pip3 install datasette", create your SQLite database file and run "datasette mydb.db" to start exploring. I've run it successfully on SQLite files up to a GB in size and theoretically it should work with much bigger files than that. The https://publish.datasettes.com/ https://publish.datasettes.com/ tool works by taking your uploaded CSVs and running my "csvs-to-sqlite" script on them, then deploying the datasette application alongside that new SQLite database file.
- obelix_ 8y agoThanks! Looks pretty useful. Will be checking it out soon.