Twitter Persistence for SQLite

Saves data from Twitter to a SQLite database using dogsheep/twitter-to-sqlite.

First time setup

Twitter credentials are required, which may be obtained at https://developer.twitter.com/en/apps.

Run 'make auth' or supply a twitter-credentials.json file

Routine execution

Run 'make search' or 'make user-timeline' to grab the tweets and put them into a SQLite database

Dev Container setup

Uses default Python 3 configuration from Microsoft
Installs Netspective default setup for zsh + Antigen + Oh My ZSH!
Installs Powerlevel9k ZSH theme through Antigen
Installs SQLite 3.x from Debian
Installs Latest JDK from Debian
Installs SchemaSpy database documentation tool from GitHub
Installs Xerial SQLite JDBC Driver from BitBucket

Visual Studio setup

Install Meslo LG M Regular for Powerline.ttf font for improved terminal typeface. This font is already set in devcontainer.json settings.
The default shell is /bin/zsh

TODO

Integrate SQLite Web database management utility to allow editing and viewing of databases.