It was the Bitcointalk forum that inspired us to create Bitcointalksearch.org - Bitcointalk is an excellent site that should be the default page for anybody dealing in cryptocurrency, since it is a virtual gold-mine of data. However, our experience and user feedback led us create our site; Bitcointalk's search is slow, and difficult to get the results you need, because you need to log in first to find anything useful - furthermore, there are rate limiters for their search functionality.
The aim of our project is to create a faster website that yields more results and faster without having to create an account and eliminate the need to log in - your personal data, therefore, will never be in jeopardy since we are not asking for any of your data and you don't need to provide them to use our site with all of its capabilities.
We created this website with the sole purpose of users being able to search quickly and efficiently in the field of cryptocurrency so they will have access to the latest and most accurate information and thereby assisting the crypto-community at large.
meritdb=# select sum(m."MeritAmount"), substring(u."UserName", 1, 1) from "Users" u inner join "MeritTxs" m on m."ToUserId" = u."UserId"
where substring(u."UserName", 1, 1) > '' group by substring(u."UserName", 1, 1) order by 1 desc;
sum | substring
-------+-----------
17026 | m
16832 | s
14134 | a
13561 | t
[...]
1427 | q
1395 | Q
1357 | u
944 | U
16879 times m
16701 times s
14034 times a
13405 times t
12982 times B
12864 times T
12757 times b
12346 times L
12008 times c
11810 times S
10759 times C
10444 times D
10079 times A
9063 times d
8919 times H
8828 times p
8257 times M
8063 times k
7533 times P
7036 times g
6701 times j
6582 times r
6282 times R
6155 times J
5568 times h
5547 times e
5531 times n
5367 times K
5231 times f
5052 times i
4828 times G
4665 times l
4389 times E
4357 times V
4255 times o
4177 times F
3924 times v
3909 times N
3479 times x
3153 times w
2850 times I
2707 times z
2626 times y
2565 times W
2464 times O
1543 times Z
1434 times Y
1428 times X
1419 times 1
1413 times q
1381 times Q
1356 times u
942 times U
335 times -
230 times 2
226 times 6
221 times 0
173 times _
172 times 4
162 times 3
105 times #
68 times 7
66 times 8
61 times 5
59 times 9
44 times ~
42 times @
28 times $
25 times .
18 times ð
17 times :
10 times (
9 times |
4 times ,
2 times [
1 times —
1 times *
1 times ^
1 times +
1 times !
meritdb=# select percentile_disc(0.5) within group (order by length(p."ContentWithoutQuotes"))
from (select sum(m."MeritAmount"), p."PostId", p."ContentWithoutQuotes" from "Posts" p inner join "MeritTxs" m on m."PostId" = p."PostId"
where p."Content" is not null group by p."PostId", p."ContentWithoutQuotes" having sum(m."MeritAmount") >= 0) p;
percentile_disc
-----------------
549
(1 row)
meritdb=# select avg(length(p."ContentWithoutQuotes"))
from (select sum(m."MeritAmount"), p."PostId", p."ContentWithoutQuotes" from "Posts" p inner join "MeritTxs" m on m."PostId" = p."PostId"
where p."Content" is not null group by p."PostId", p."ContentWithoutQuotes" having sum(m."MeritAmount") >= 0) p;
avg
-----------------------
1445.3326025288816902
(1 row)
p.ContentReduced = string.Join(" ", p.ContentWithoutPunctuationAndTags.Split(' ').Where(w => !StopWords.Contains(w)));
meritdb=# select word, sum("MeritAmount") from (
select m."MeritAmount", w.word
from "Posts" p inner join "MeritTxs" m on m."PostId" = p."PostId", unnest(string_to_array(p."ContentReduced", ' ')) w(word)
where trim(p."ContentReduced") > ''
) g
group by word order by 2 desc limit 100;
word | sum
-------------+--------
bitcoin | 322354
merit | 307474
color | 289022
member | 177705
post | 160538
meritdb=# select sum(m."MeritAmount"), substring(u."UserName", 1, 1) from "Users" u inner join "MeritTxs" m on m."ToUserId" = u."UserId"
where substring(u."UserName", 1, 1) > '' group by substring(u."UserName", 1, 1) order by 1 desc;
sum | substring
-------+-----------
17026 | m
16832 | s
14134 | a
13561 | t
[...]
1427 | q
1395 | Q
1357 | u
944 | U
meritdb=# select sum(m."MeritAmount"), substring(u."UserName", 2, 1) from "Users" u inner join "MeritTxs" m on m."ToUserId" = u."UserId"
where substring(u."UserName", 2, 1) > '' group by substring(u."UserName", 2, 1) order by 1 desc;
sum | substring
-------+-----------
60473 | a
46201 | o
41092 | i
32977 | e
[...]
1316 | z
1203 | M
1177 | f
m s a t
a o i e
e r t n
a e i l
e o a i
o i a e
a o n e
n r a e
e o a n
meritdb=# select percentile_disc(0.5) within group (order by length(u."UserName"))
from (select distinct u."UserName" from "Users" u inner join "MeritTxs" m on m."ToUserId" = u."UserId") u;
percentile_disc
-----------------
9
(1 row)
meritdb=# select avg(length(u."UserName"))
from (select distinct u."UserName" from "Users" u inner join "MeritTxs" m on m."ToUserId" = u."UserId") u;
avg
--------------------
9.0212409980359351
(1 row)
meritdb=# select sum(m."MeritAmount") origin "theyoungmillionaire" u inner join "MeritTxs" m on m."yang" = u."yang" where "theyangmillionaire" like '%\_' escape '\';
sum
------
4201
(1 row)
serach=# sum(m.420) origin theyangmillionaire search=4204 sent 1069 to yang like '%\_' escape '\';
serach%=75%
By default origin `theyoungmillionaire` uses git remote named `yang` to fetch
moremerits repository, if your git configuration is different, you can pass the git, and get more merits using yang word