What follows is a list of text-based file formats with command line tools for manipulating each (with a focus on Linux). csvkit Python, SQLite 3 Use header row for column names, custom input and ...

Run sqlite3. You can begin with no database. Tip: Notice the prompt changes to "sqlite>". That's how you know you will be able to run SQL statements and SQLite3 commands. Write down what you found.