SQLite shell and command line confusion (EOF, entering commands, history, etc.)

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

  1. Construct SQLite commands in a text editor then paste them into the SQLite shell

  2. 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.

  3. 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.

3 Likes

Hi @dan19,

About your feedback, could you please share it with the Content & Product teams of Dataquest? Just click the ? button in the upper-right corner of any screen of the Dataquest learning platform, select Share Feedback, fill in the form, and send it. Thanks!

Thanks, Elena. Submitted. Will also use this for other feedback in the future.

1 Like