connotea-code-devel

[Connotea-code-devel] about tags

[<co...@eb...>]

Would it be possible to get:
a) all the tags used in posts having certain string
b) all the tags used together with certain tag (like "memory")

I was thinking using these resulting tags as suggestions for keywords in =
my=20
PubMedTool (http://ebounce.info/pubmedtool/)

I tried following, but they weren't quite what I was looking for:
http://www.connotea.org/data/tags/tag/memory (gives only count details an=
d=20
strangely this tells that postcount is 229, when site search tells there'=
s=20
809 posts)
http://www.connotea.org/data/tags/?q=3Dmemory (server error, too high loa=
d)
http://www.connotea.org/data/tag/memory (takes too much time to load)

I was looking these kind of results:
http://www.connotea.org/data/tags/uri/http://www.google.com/

--

However, I might need to rethink my keyword system anyway, as currently t=
hey=20
are only single worded. Maybe I should try to integrate my website with=20
Connotea in other ways too, as it would make sense to save certain things=
=20
found with my tools to somewhere.

--

Marko Sepp=E4nen
ebounce.info - http://ebounce.info

[Connotea-code-devel] about tags

[<co...@eb...>]

Would it be possible to get:
a) all the tags used in posts having certain string
b) all the tags used together with certain tag (like "memory")

I was thinking using these resulting tags as suggestions for keywords in =
my=20
PubMedTool (http://ebounce.info/pubmedtool/)

I tried following, but they weren't quite what I was looking for:
- http://www.connotea.org/data/tags/tag/memory (gives only count details =
and=20
strangely this tells that postcount is 229, when site search tells there'=
s=20
809 posts)
- http://www.connotea.org/data/tags/?q=3Dmemory (server error, too high l=
oad)
- http://www.connotea.org/data/tag/memory (takes too much time to load)

I was looking these kind of results:
- http://www.connotea.org/data/tags/uri/http://www.google.com/

--

However, I might need to rethink my keyword system anyway, as currently t=
hey=20
are only single worded. Maybe I should try to integrate my website with=20
Connotea in other ways too, as it would make sense to save certain things=
=20
found with my tools to somewhere.

--

Marko Sepp=E4nen
ebounce.info - http://ebounce.info

Re: [Connotea-code-devel] about tags

[Martin F. <ma...@ne...>]

Hi Marko,

Just responding to the count discrepancy at the moment:

Marko Sepp=E4nen wrote:
> I tried following, but they weren't quite what I was looking for:
> http://www.connotea.org/data/tags/tag/memory (gives only count details =
and=20
> strangely this tells that postcount is 229, when site search tells ther=
e's=20
> 809 posts)

There are 229 public posts. I confirmed it in the database.

mysql> select tag_id from tag where name =3D 'memory';
+--------+
| tag_id |
+--------+
|     13 |
+--------+
1 row in set (0.00 sec)

mysql> select count(*) from user_bookmark ub left join user_bookmark_tag=20
ubt on (ubt.user_bookmark =3D ub.user_bookmark_id) where ub.private =3D 0=
=20
and ub.private_gang is null and ub.private_until is null and ubt.tag =3D =
13;
+----------+
| count(*) |
+----------+
|      229 |
+----------+
1 row in set (0.04 sec)

There are actually 16 more that are private in some way.

mysql> select count(*) from user_bookmark_tag where tag =3D 13; +--------=
--+
| count(*) |
+----------+
|      245 |
+----------+
1 row in set (0.00 sec)

If you type memory in the search box that is a full text search on lots=20
of fields, not just a tag search, so you'll get more (I also get 809).

I think you may have led me to a bug of some kind though - the page
http://www.connotea.org/tag/memory?num=3D1000
...says 202 at the bottom but there are 229 instances of "Posted by" on=20
the page as found in grep. That can't be right. I'll examine it tomorrow.

Martin

Re: [Connotea-code-devel] about tags

[<co...@eb...>]

----- Original Message -----=20
From: "Martin Flack" <ma...@ne...>

> If you type memory in the search box that is a full text search on lots=
 of=20
> fields, not just a tag search, so you'll get more (I also get 809).

Oh, sorry about that. I guess I was too focused on the word "post"(count)=
=20
and I forgot what I was actually searching (tags). Happens often to me. A=
lso=20
didn't mean to double post. I wasn't registered on the first time, so I=20
thought it won't get through.

- marko sepp=E4nen