‫In this video, we will discuss the differences between a server side curser and a client side cursor
‫with regard to Postgres database and Python.
‫So here I have a Postgres database in my laptop.
‫I have a table here.
‫I create a database and I created a table.
‫It's empty.
‫Now, with that said, that's just something in the video.
‫So what's what is the difference between a server side cursor and a client?
‫sars-cov-2.
‫So to to connect to the database from Python, you essentially established something called a cursor,
‫right?
‫You create a cursor and then you either write or read from the database.
‫And the client side cursor is when you, for example, execute a select statement.
‫Select all from employees like here.
‫What happens is all the results are executed and delivered over the network to your client, which is
‫Python and versus the other approach where server side cursors, where a cursor is created on the database.
‫And only when you absolutely need something the client can say, hey, give me 10 results.
‫Give me 30, give me whatever, give me one.
‫Give me the next scroll through the results.
‫And only when you absolutely need it, it will start fixing this results.
‫So that result is actually executed on the server and said there and the client kind of fetches them
‫incrementally or if they wanted all of them.
‫OK, so that's the difference.
‫With that said, let's just jump into it.
‫So.