What are cursor-less development patterns

Question

Recently I came across development patterns call cursor-less. I try to find sources and articles about it and I couldn't find any. Can someone provide a example for cursor-less development patterns or point me to the right direction.

score 1 · Accepted Answer · edited May 23 '17 at 12:09

1

The term cursor-less is most likely related to databases. Relational database management systems typically provide cursors which can be used to iterate over a data set. Some systems also provide other mechanisms like while loops for the same purpose.

So cursor-less development pattern most probably means nothing more than using loops instead of cursors in database applications. This has nothing to do with general software design patterns.

Here are a few links:

Comparing cursor vs. WHILE loop performance in SQL Server 2008

Why is it considered bad practice to use cursors in SQL Server?

edited May 23 '17 at 12:09

Community

1
1

answered Jul 03 '16 at 15:51

Frank Puffer

8,135
2
20
45

Thanks for answering the question, it will be great if you can provide a article that i can read more about this. – tk_ Jul 03 '16 at 15:56
1

@thusharaK: Have added a few links. – Frank Puffer Jul 03 '16 at 16:07

What are cursor-less development patterns

1 Answers1