joomla-users.sql

[fititnt]

-- ID:             joomla-users
-- DESCRIPTION:    The joomla-users is "the typical" query for when asked to
--                 'just get me users data'.
--
-- AUTHOR:         Emerson Rocha <emerson[at]alligo.com.br>
-- COMPANY:        Alligo
-- LICENSE:        "SPDX-License-Identifier: MIT"
-- CREATED:        2021-01-18 22:57 BRT
-- REVISION:       ---

The v1.0 of joomla-users.sql still pretty simple. Using the same logic as commented on joomla-tags.sql #3, makes sense to already return some general statistics about content created by the user, so some uses may no need use data mining tools at all or the user have to manually dump the tables to make the relationships.

[fititnt]

Personal information

Some queries may return personal information (like email and username). As default, since the information is meant to be stored for data mining, I think is reasonable to at least do some simplistic hash, and if the user needs, let remove comment the lines who show the full data.