SQLite Forum

SQLite3 Extension
Login
Not sure what <i>pathological</i> actually means in the SQLite context; at a guess, I expect you are hinting at the issues introduced by null, zero, and non-numeric values in a numeric column that might be used to calculate these statistical metrics.

If that is the case, then Microsoft Excel columns (or rows) are just as susceptible to pathology as the (in essence type less) SQLite columns. Excel has those statistical methods built in. <i>No need for a debate on Excel!</i>

I mentioned R because like SQLite, it is free, extensible, and has an avid and loyal<sup>influential</sup> user base and has packages (aka extension or library) build around SQLite.

No harm in making suggestions for 3.35. In the end, it is SQLite development team that decides - that much is well understood.

<sup>influential</sup> = R conferences have an international attendance by people representing household name organisations; most of have more letters <i>after</i> their name than in their names. COVID-19 no doubt put an end to that.