How to get all the values ​​of a column into a list from a database?

Question

Python

Hello, you need to get all the values ​​of one column from the database.
Let's say there are many users and you need to take their ID from each and write them into one list, how to implement this?

Answer 1

If you use the sqlite3 engine to work with the database, then it will be something like this

con = sqlite3.connect("mydb.sqlite") #подразумеваю, что таблицу ты уже создал
cur = con.cursor()
cur.execute("SELECT id FROM users")
ids = [row['id'] for row in cur]

Only if there is a lot of data, such a request can consume a lot of memory.
So a counter question: why do you need to select the entire table? Maybe you still need to filter some of the records?