How hashtags work ...

About: Language - comment 59111

How do #hashtags work ?

Navigator says ...
No, it is a table, the same old tagging table in fact. There is no way to create an index in SQL without a table column to do it on.

Standard rules for hash tags, as can be seen at the below link, except that we also exclude dashes and underscores for the same reason they discourage them. Otherwise the same. 


  1. hashtags
  2. taggingtable
  3. shitass


Seth says
hmmm … i wonder how #shitass will show up in the #taggingtable

Seth says
hmmm …. how does this #taggingtable work … or do i mane #taggingtable work … just testing ...

Seth says
so the #hashtags appear in the data column of the stream table, and not in the “same old tagging table” as i originally thought based upon what you said above, Navigator …. right?

Seth says
here is one that i should be able to move but cannot because
when i paste the comment i get this error →

Si says
I think that happened because you were using the dropdown menu on the bottom of the thought instead of the one on the top. That should be fixed now to work with either.

Seth says

Si says
Actually, several of the buttons on the bottom are in the wrong context. I may have to remove the bottom menu until a full review can be done.

Si says
Nope. Hash-tags are only in the taggings table. The stream is just the stream, and anything created can appear there, but it is not used for indexing or storage, just as the stream sent out to all the browsers to synchronize changes.

Seth says
hmmm …. i could find no hashtags in the tagging table … do they not have a time stamp?

Si says
Yes, they are normal tags. This query will show them.

SELECT * FROM taggings WHERE type = 2

Right now there are a bunch of hex colors that got indexed too there, like #ff0000, but those will be removed later. I already fixed the indexer to avoid those in the future.

See Also

  1. Thought Why my trains of thought break ... with 108 viewings related by tag "hashtags".
  2. Thought Clarifying how hashtag’s are defined with 41 viewings related by tag "hashtags".
  3. Thought Announcing Ability to Better Express Ourselves with 19 viewings related by tag "hashtags".
  4. Thought about: Put the river in fastblogit - comment 60349 with 12 viewings related by tag "hashtags".
  5. Thought Name tagging and subscriptions ... a fuller treatment. with 3 viewings related by tag "hashtags".
  6. Thought Cute conversations with 2 viewings related by tag "hashtags".
  7. Thought fastblogit trains of thought with 1 viewings related by tag "hashtags".
  8. Thought Interesting use of hashtag as headline with 0 viewings related by tag "hashtags".
  9. Thought about: we dont need no stinking domain names with 0 viewings related by tag "hashtags".
  10. Thought #titlehashtags with 0 viewings related by tag "hashtags".
  11. Thought ISIS mocks Michelle O. with 0 viewings related by tag "hashtags".
  12. Thought about: Semantics of Social Media with 0 viewings related by tag "hashtags".
  13. Thought miscellaneous subjects & hashtags with 0 viewings related by tag "hashtags".
  14. Thought about: Facebook is faking hashtags .... err, NOT with 0 viewings related by tag "hashtags".