Tidy-tweet

Now with views! `tweet` and `user` tables are back to one row per tweet/user, but now they're views - `tweet_by_page` and `user_by_page` may have multiple rows for individual tweets or users if they appear in multiple results pages.

This is not thoroughly tested, so feedback is greatly appreciated!

Note there will still be some schema changes before we release a final 1.0, this alpha release is intended to start working with the partially-implemented new schema so we can test it out!

This release includes lots of fixes for parsing of tweet JSON.

We have a CLI! See https://github.com/QUT-Digital-Observatory/tidy_tweet#command-line-interface for docs or just run `tidy_tweet --help` after installation.

Some metadata has been added to the database schema, and the CLI allows multiple files to be input at once, but these features are not yet fully implemented, so use at your own risk.

We would very much appreciate feedback on the CLI and on the documentation :) Thank you and please let us know how you go with `tidy_tweet`!

Hello and welcome to tidy_tweet! As you can see from the readme, tidy_tweet is still missing some core functionality. But we wanted to get what we have so far published so people can start building their data workflows :) Stay tuned for more releases!