nuBuilder Forum

Posted: **Sat Jan 16, 2021 2:00 pm**

Analysing NuBuilder Forum Membership Registrations over the last 5 years shows that interest (Registrations and Posts) peaked during 2015 and 2018.
Hopefully now that some rapid development ensues and it is now fully Open Source and the Wiki is getting populated, community interest will pickup again. As many users have been banned / deleted over time, the total users are only those currently valid.

All users are requested to provide feedback to improve the codebase.

After Registration, if users fill in their locations (atleast Country), the community in your vicinity can approach you in your own language. Currently less than 5% have filled in their locations. Alternatively, GeoIP based Country can be shown in the Membership listings though VPN, Cloud Operations and other changing IPs since registration will affect accuracy.

Posted: **Sun Jan 31, 2021 6:05 am**

The last 30 pages have been taken into a MySQL database and the stats re-analysed.
The old records have not been updated for posts yet except for the latest 25 users.

The total Posts are not posts made during each year but total posts of users registered in that year.

Code: Select all

CREATE TABLE `nub4_users` (
  `Username` varchar(255) NOT NULL,
  `Posts` int(11) DEFAULT NULL,
  `WebSite` varchar(255) DEFAULT NULL,
  `RegDT` datetime DEFAULT NULL,
  `Location` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

SELECT IFNULL(RegYr, 'Total') AS RegYr, Postings AS Posts, OnePostUsers, NonZeroPostUsers, Users AS NB_Forum_Users FROM (
  SELECT YEAR(RegDT) AS RegYr
     , SUM(Posts) AS Postings
     , SUM(IF(Posts=1, 1, 0)) AS OnePostUsers
     , SUM(IF(Posts>0, 1, 0)) AS NonZeroPostUsers
     , COUNT(*) AS Users 
  FROM `nub4_users` WHERE YEAR(RegDT) BETWEEN 2014 AND 2020 GROUP BY RegYr WITH ROLLUP
) a;

NuBuilder Stats.xlsx

nuBuilder Forum

NuBuilder Forum Interest Stats

NuBuilder Forum Interest Stats

Re: NuBuilder Forum Interest Stats