masto.sh
masto.sh copied to clipboard
Save entire post JSON instead of just fav, reply and repost counters
The main problem is, that you would have to explicitly model the table DML with all JSON columns.
read_json_auto does a best-guess approach but its results depend on the sample size. So if we automatically create our table and one of the later posts conflicts with this structure, the INSERTs will fail.