SQLite Cursor in Python


This entry is part 6 of 2 in the series Python SQLite

A cursor in SQLite is not the same as a cursor in other databases. In this context, we are working in Python and communicating with a SQLite database. Here it is related to the Python database API. However, even if you are working with another type of database, you should still create a cursor in your Python code.

With a cursor, we can go through tables row by row. A cursor is like a pointer to a row. In Python we can use a loop to go through a chunk of a table.

For more information, have a look at the course on Udemy called Master Databases in Python: In-Depth Training on SQLAlchemy, SQLite, PostgreSQL, and MySQL, video 47. Of course, Udemy charges for their courses but they do put them on sale frequently.

Series Navigation<< Connect SQLite to Python

Leave a Reply