Screen Link: Table Relations and Normalization
This is for others who find themselves confused by the SQLite interface and how it differs from the UNIX shell. It’s also a suggestion to the DQ team to add a brief tip/explanation to the screen.
It would be helpful if the second screen of Table Relations and Normalization lesson included a short paragraph “tip” on a speedy way to manage input into the SQLite shell (cut and paste vs. line by line) + the difference between the SQLite shell and the UNIX shell. Some suggestions
-
Construct SQLite commands in a text editor then paste them into the SQLite shell
-
To enable this, use <<EOF stdin redirection. The DQ solution mentions EOF, but currently doesn’t provide context. Two useful links: background on bash heredoc and the DQ shell course screen on redirecting input.
-
Note that history shortcuts (up and down arrows), while available in the UNIX shell, do not seem to be available in the DQ version of the SQLite shell interface.
I hope this helps anyone else who is either confused or seeking a smoother, faster way to manage input into DQ’s SQLite shell in these exercises. Ideas and references sourced from earlier forum posts here, here, here, here, and here.