[Tutor] Proper SQLite cursor handling?

[Alan Gauld]

On 11/07/2021 21:02, boB Stepp wrote:
> ahead and finish the program, your information has strongly motivated
> me to study databases in more depth, especially as I have forgotten so
> much. For future programs I envision doing I will have great need for
> database use, so I might as well dive in now.

Almost every real-world programmer needs a good knowledge of SQL
and database design. When dealing with large volumes of data a RDBMS
can take a lot of the strain leaving the programmer much less to hand-craft
in Python (or whatever language they choose). Studying data design is
never time wasted!

I spent the last 10 years of my career with the label "Enterprise
Architect".

That meant I was in charge of the design of many large projects. But,
in each case I had a "Data Architect" working with me, and frequently
a "Network architect" too. These are both specialist skills that no matter
how good you get at system level design, you always want an expert in
your corner. In fact, on large projects, if there is a performance problem
it will 90% of the time be either database or network related.

-

Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/
http://www.amazon.com/author/alan_gauld
Follow my photo-blog on Flickr at:
http://www.flickr.com/photos/alangauldphotos