[TOOL] ⭐Bitcointalk BRDb score

[dkbit98]

OP this is great work so far, and it's going to be useful for sure, but I wouldn't be me if I didn't have some remarks to add
I noticed that BRDb website is loading very slow when I open main page, while my own page or page from some other member is opening faster.
I really like merit flow chart, it reminds me a bit on bitcoin coinjoin mixing.

 

[*Ace*]

OP this is great work so far, and it's going to be useful for sure, but I wouldn't be me if I didn't have some remarks to add
I noticed that BRDb website is loading very slow when I open main page, while my own page or page from some other member is opening faster.
I really like merit flow chart, it reminds me a bit on bitcoin coinjoin mixing.

 

Without your feedback, this project would still be in its infancy, which is why I desperately need other people's opinions. I made some fixes, unfortunately after yesterday's imports I made the queries heavier and slower.It should be much faster now! Definitely not lightning-fast, but faster than before. It used to take about 17 seconds to load everything, now it shouldn't take more than 5 seconds.

As for the graph, I took inspiration from an old Bitcointalk user, it seemed like a nice graph, I studied it a bit and implemented it

Visually beautiful, I hope it is useful to someone 

[fillippone]

Perfection is not achieved suddenly, but it’s a long and slow grind where you build confidence, knowledge and capacity of execution.
Well done on your continued commitment to your product, *Ace*

[DYING_S0UL]

I noticed that BRDb website is loading very slow when I open main page, while my own page or page from some other member is opening faster.

No slowness from my end by the way! Maybe because the site is already cached to my browser. It almost loads instantly.

As for the graph, I took inspiration from an old Bitcointalk user, it seemed like a nice graph, I studied it a bit and implemented it

Visually beautiful, I hope it is useful to someone 

A few thoughts...

On the explorer section - under moderation and security logs - there are no specific date to an event - it only shows X days ago. Maybe if possible, please add on which date an event was logged (example: 21 September XYZ user got Nuked).

A few seconds of slowness with Board Overview section. I guess that's normal since it's fetching a lot of stats data.

Hats off to you man! What you did with the Merit Flows Network is extraordinary! 

[*Ace*]

Perfection is not achieved suddenly, but it’s a long and slow grind where you build confidence, knowledge and capacity of execution.
Well done on your continued commitment to your product, *Ace*

I'm not looking for perfection, but rather for something useful. Perfection is subjective; not everyone sees things the same way.
I have some other minor things in mind to implement, but I'll post about them later.

I noticed that BRDb website is loading very slow when I open main page, while my own page or page from some other member is opening faster.

No slowness from my end by the way! Maybe because the site is already cached to my browser. It almost loads instantly.

As for the graph, I took inspiration from an old Bitcointalk user, it seemed like a nice graph, I studied it a bit and implemented it

Visually beautiful, I hope it is useful to someone 

A few thoughts...

On the explorer section - under moderation and security logs - there are no specific date to an event - it only shows X days ago. Maybe if possible, please add on which date an event was logged (example: 21 September XYZ user got Nuked).

A few seconds of slowness with Board Overview section. I guess that's normal since it's fetching a lot of stats data.

Hats off to you man! What you did with the Merit Flows Network is extraordinary! 

I implemented a pre-warm of the data, so as to always have the cache warm and have the data always available.

As for mod&seclog, bitcointalk does not return an event date, what you see is just the date the scraper found the event and stored it, but it does not reflect the actual date the post was banned or deleted. If you prefer to see the more or less indicative date I can do it

[dkbit98]

Without your feedback, this project would still be in its infancy, which is why I desperately need other people's opinions. I made some fixes, unfortunately after yesterday's imports I made the queries heavier and slower.It should be much faster now! Definitely not lightning-fast, but faster than before. It used to take about 17 seconds to load everything, now it shouldn't take more than 5 seconds.

Confirmed.
Main page loads much quicker now.
But here comes more nitpicking from me... now when entering member username on main page, it takes really long time to find and show it.
To clarify things I recorded gif video as proof for my claims:

[DYING_S0UL]

But here comes more nitpicking from me... now when entering member username on main page, it takes really long time to find and show it.
To clarify things I recorded gif video as proof for my claims:

Seems fine from my end. The search result comes as soon as I hit the button (almost instantly as you can see).

Note that, I'm damn sure the usernames weren't cached anywhere inside my browser. I used two separate browser for the test. And, one of them was totally fresh, newly installed, first time visiting the brdb site.

As for mod&seclog, bitcointalk does not return an event date, what you see is just the date the scraper found the event and stored it, but it does not reflect the actual date the post was banned or deleted. If you prefer to see the more or less indicative date I can do it

In that case, can't you just add the event date when the scraper logged it first? So as long as the scraper doesn't fail or get stuck, the dates will be correct.

btw, do you have any plan to acquire the old sec & mod log data? So far, I have changed my forum password 3 times (lifetime). But your site doesn't reflect that anywhere.

[*Ace*]

But here comes more nitpicking from me... now when entering member username on main page, it takes really long time to find and show it.

This little issue has also been fixed, thanks for reporting it.

But here comes more nitpicking from me... now when entering member username on main page, it takes really long time to find and show it.
To clarify things I recorded gif video as proof for my claims:

Seems fine from my end. The search result comes as soon as I hit the button (almost instantly as you can see).

Note that, I'm damn sure the usernames weren't cached anywhere inside my browser. I used two separate browser for the test. And, one of them was totally fresh, newly installed, first time visiting the brdb site.

As for mod&seclog, bitcointalk does not return an event date, what you see is just the date the scraper found the event and stored it, but it does not reflect the actual date the post was banned or deleted. If you prefer to see the more or less indicative date I can do it

In that case, can't you just add the event date when the scraper logged it first? So as long as the scraper doesn't fail or get stuck, the dates will be correct.

btw, do you have any plan to acquire the old sec & mod log data? So far, I have changed my forum password 3 times (lifetime). But your site doesn't reflect that anywhere.

I've already fixed the problem after receiving the telegram notification from dkbit98. But I had gone to dinner before you tried the site after the fix.  

For modlogs there is no way to retrieve old events from bitcointalk, I would have to fetch every bitcointalk user on bpip, it's not hard, but I would have to make more than 3 million requests on bpip. Or if there's an alternative way to get this data from bitcointalk, I can add it without any problems. Let's see if Loycev knows if it's possible to do it, maybe there's a hidden page that I don't know about.

[LoyceV]

For modlogs there is no way to retrieve old events from bitcointalk, I would have to fetch every bitcointalk user on bpip, it's not hard, but I would have to make more than 3 million requests on bpip. Or if there's an alternative way to get this data from bitcointalk, I can add it without any problems. Let's see if Loycev knows if it's possible to do it, maybe there's a hidden page that I don't know about.

I can give you 7 years of daily modlog snapshots: loyce.club/other/tmp/ace/ (scheduled to be deleted in 14 days).
I might have missed a day sometimes, and I might have added a duplicate, but most of the data will have been taken daily. That should give a pretty good estimate of when things happened.

For seclog, see my seclog log for 6 years of data. Seclog comes with timestamps.

[*Ace*]

For modlogs there is no way to retrieve old events from bitcointalk, I would have to fetch every bitcointalk user on bpip, it's not hard, but I would have to make more than 3 million requests on bpip. Or if there's an alternative way to get this data from bitcointalk, I can add it without any problems. Let's see if Loycev knows if it's possible to do it, maybe there's a hidden page that I don't know about.

I can give you 7 years of daily modlog snapshots: loyce.club/other/tmp/ace/ (scheduled to be deleted in 14 days).
I might have missed a day sometimes, and I might have added a duplicate, but most of the data will have been taken daily. That should give a pretty good estimate of when things happened.

For seclog, see my seclog log for 6 years of data. Seclog comes with timestamps.

You are a well of information.
Thanks a lot, I'm already importing the modlogs, although I've found it quite difficult to do so.
Your modlogs are made in daily snapshots, it's not a problem in itself, and that a sigban (for example) I found 79 times in different files  So I had to deduplicate all the eventualities, however, for the seclogs I shouldn't have any problems since they are saved with a timestamp!
I thank you infinitely

[LoyceV]

I had to deduplicate all the eventualities

I did the same for my Sigban list. It was annoying to deal with.
But I don't see how one sigban could have ended up in there 79 times: with daily snapshots each event should have been in there exactly 7 times.

[*Ace*]

I had to deduplicate all the eventualities

I did the same for my Sigban list. It was annoying to deal with.
But I don't see how one sigban could have ended up in there 79 times: with daily snapshots each event should have been in there exactly 7 times.

You're right. I double-checked just to be sure and realized I'd used a too generic grep command, basically just checking uid.

With a more specific grep I find exactly 9 times the sigban applied to that uid, which would still be 7 days, there are double daily snapshots, one in the morning and one in the late evening

Code:

Files where 'Sigban applied' for #658163 appears:

modlog.2026-07-20_Mon_23.57h.html
modlog.2026-07-21_Tue_23.57h.html
modlog.2026-07-22_Wed_23.57h.html
modlog.2026-07-23_Thu_15.40h.html
modlog.2026-07-23_Thu_23.57h.html
modlog.2026-07-24_Fri_23.57h.html
modlog.2026-07-25_Sat_23.57h.html
modlog.2026-07-26_Sun_08.58h.html
modlog.2026-07-26_Sun_23.57h.html

Summary:
  Total files:        9
  First appearance:   2026-07-20
  Last appearance:    2026-07-26

[LoyceV]

there are double daily snapshots, one in the morning and one in the late evening

That's probably from when I manually created them to test my sigban-listing.