On 18 Sep 2014, at 9:38am, RSmith <rsm...@rsweb.co.za> wrote: > Thanks Keith for taking the time, I imagine this is a topic you are > passionate about and I think it should be published somewhere as an article > because it will save lives of beginner DBA/Programmers for millenia to come - > I have certainly born witness to many of these pitfalls at various clients, > and in the past stepped in some myself.
But the actual lesson from this list (plus academic books, experienced database professions and the industry) is not to do anything that works like a database cursor at all. In the bad old days, with single-access databases and limited screen space, it might have been a good idea. These days, where people have big screens and the database is being continually updated in the background, it leads to nonsense. That's the gist of Keith's post and many previous ones. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
