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.

Python SQLite

Connect SQLite to Python

Leave a Reply