Hacker News Reader

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?

View on HN

You 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/ 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.

Thanks! Looks pretty useful. Will be checking it out soon.

Reply on news.ycombinator.com