
Sept. 11, 2022
9:17 a.m.
For example, a common confusion is to identify None with NULL in DB, but then when you are filtering rows in a SQL query generated by a framework function, you have to do convoluted things because most frameworks do not distinguish "Do not filter" and "Keep only rows where value is NULL",
Good example— wouldn’t it be nice if all the database interaction packages used the same Sentinel for this? In that case it would go in the DB api, but the idea holds. -CHB -- Christopher Barker, PhD (Chris) Python Language Consulting - Teaching - Scientific Software Development - Desktop GUI and Web Development - wxPython, numpy, scipy, Cython