The TinyDB forum has found a new home at GitHub discussions. The content here remains as a read-only archive.
How would I query only one column from a database. Like "SELECT column_name FROM db" in SQL
Hey bogusstarwars ,
TinyDB is a document oriented database and has no special notion of columns. You just search for the document you need to have and then access fields like you would with normal Python dicts. If you want a relational database for Python, you'll probably want to look into sqlite.