SQLLINE:(1)

📦 version 1.0.2, in debian bookworm, debian trixie, ubuntu jammy, ubuntu noble, ubuntu questing, ubuntu resolute, ubuntu stonking

🎀 NAME 🎀

sqlline — JDBC command-line utility for issuing SQL 💅

(it's giving "i talk to databases for a living and i look cute doing it")

✨ SYNOPSIS ✨

sqlline [ option... ]

💖 DESCRIPTION 💖

okay bestie, so sqlline is a JDBC command-line utility for issuing SQL, and it comes with a whole lil menu of options. here is the entire menu, no skips, no cuts, we are reading the whole thing 🫶

🌸 the options, take one 🌸

  • -u <database url> — the JDBC URL to connect to 🔌
  • -n <username> — the username to connect as 👤
  • -p <password> — the password to connect as 🔐
  • -d <driver class> — the driver class to use 🚗
  • --color=[true/false] — control whether color is used for display 🌈
  • --showHeader=[true/false] — show column names in query results 👑
  • --headerInterval=ROWS; — the interval between which heades are displayed (yes, it literally says "heades", i am not fixing it, that's the original's word and we respect it 😭)
  • --fastConnect=[true/false] — skip building table/column list for tab-completion ⚡
  • --autoCommit=[true/false] — enable/disable automatic transaction commit ✅
  • --verbose=[true/false] — show verbose error messages and debug info 🗣️
  • --showWarnings=[true/false] — display connection warnings ⚠️
  • --force=[true/false] — continue running script even after errors 💪
  • --maxWidth=MAXWIDTH — the maximum width of the terminal 📏
  • --maxColumnWidth=MAXCOLWIDTH — the maximum width to use when displaying columns 📐
  • --silent=[true/false] — be more silent 🤫
  • --autosave=[true/false] — automatically save preferences 💾
  • --outputformat=[table/vertical/csv/tsv] — format mode for result display 📊
  • --isolation=LEVEL — set the transaction isolation level 🧊
  • --help — display this message 🆘

🌀 usage: java sqlline.SqlLine 🌀

not me about to print the exact same list again... but it's literally what it does bestie, the usage output repeats the whole thing. periodt. 💀
  • -u <database url> — the JDBC URL to connect to 🔌
  • -n <username> — the username to connect as 👤
  • -p <password> — the password to connect as 🔐
  • -d <driver class> — the driver class to use 🚗
  • --color=[true/false] — control whether color is used for display 🌈
  • --showHeader=[true/false] — show column names in query results 👑
  • --headerInterval=ROWS; — the interval between which heades are displayed 😭
  • --fastConnect=[true/false] — skip building table/column list for tab-completion ⚡
  • --autoCommit=[true/false] — enable/disable automatic transaction commit ✅
  • --verbose=[true/false] — show verbose error messages and debug info 🗣️
  • --showWarnings=[true/false] — display connection warnings ⚠️
  • --force=[true/false] — continue running script even after errors 💪
  • --maxWidth=MAXWIDTH — the maximum width of the terminal 📏
  • --maxColumnWidth=MAXCOLWIDTH — the maximum width to use when displaying columns 📐
  • --silent=[true/false] — be more silent 🤫
  • --autosave=[true/false] — automatically save preferences 💾
  • --outputformat=[table/vertical/csv/tsv] — format mode for result display 📊
  • --isolation=LEVEL — set the transaction isolation level 🧊
  • --help — display this message 🆘

🔁 and then, for real, it says it ONE more time 🔁

no cap. third time. it's the same list. i'm not even mad, i'm impressed. 🫶
  • -u <database url> — the JDBC URL to connect to 🔌
  • -n <username> — the username to connect as 👤
  • -p <password> — the password to connect as 🔐
  • -d <driver class> — the driver class to use 🚗
  • --color=[true/false] — control whether color is used for display 🌈
  • --showHeader=[true/false] — show column names in query results 👑
  • --headerInterval=ROWS; — the interval between which heades are displayed 😭
  • --fastConnect=[true/false] — skip building table/column list for tab-completion ⚡
  • --autoCommit=[true/false] — enable/disable automatic transaction commit ✅
  • --verbose=[true/false] — show verbose error messages and debug info 🗣️
  • --showWarnings=[true/false] — display connection warnings ⚠️
  • --force=[true/false] — continue running script even after errors 💪
  • --maxWidth=MAXWIDTH — the maximum width of the terminal 📏
  • --maxColumnWidth=MAXCOLWIDTH — the maximum width to use when displaying columns 📐
  • --silent=[true/false] — be more silent 🤫
  • --autosave=[true/false] — automatically save preferences 💾
  • --outputformat=[table/vertical/csv/tsv] — format mode for result display 📊
  • --isolation=LEVEL — set the transaction isolation level 🧊
  • --help — display this message 🆘

and that's the whole thing bestie, every single flag, nothing skipped, we ate 💅✨

this page is from sqlline, dated August 2008, and it lives in section SQLLINE:(1) of the manual — so if you ever need to find it again, iykyk 🦋🌸

📦 where this page comes from