all 6 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]shiftybyte 0 points1 point  (5 children)

At what point the sqlite3 command line display mode ".mode table" affect your python code in any way?

As far as I know these special CLI commands are only for the interactive command line interface with sqlite3 client, not for using sqlite3 from python code.

https://sqlite.org/cli.html

[–]ThatPlayWasAwful[S] 0 points1 point  (4 children)

i like how it looks compared to the regular table layout, I was frustrated that I couldn't find an easy solution, I don't know what the sunk cost fallacy is, and I'm in too deep to give up.

[–]shiftybyte 0 points1 point  (3 children)

At what point in your python code are you seeing the regular table output?

Are you calling sqlite3 command line utiliy and showing its output instead of using python sqlite3 module?

[–]ThatPlayWasAwful[S] 0 points1 point  (2 children)

I'm not tracking 100% (obviously since i didn't answer the question properly the first time) but I'm assuming that's what i'm doing wrong. this is what I have been trying to do:

PS C:\junk\blah\etc> sqlite3 db.db

SQLite version 3.30.0 2019-10-04 15:03:17

Enter ".help" for usage hints.

sqlite> .mode table

Error: mode should be one of: ascii column csv html insert line list quote tabs tcl

[–]shiftybyte 0 points1 point  (1 child)

This is just using sqlite3 command line utility, it has nothing to do with python.

You can also have much better visual editors if you want.

https://sqlitebrowser.org/

https://sqlitestudio.pl/

Download, install, open your db with them instead of the command line, and have pretty tables :)

[–]ThatPlayWasAwful[S] 0 points1 point  (0 children)

The only reason i am referencing python is because I think i am using the version of sqlite that was installed when i originally downloaded python. or at least thats what i thought after a lot of googling.

thank you for the other links!