Feature suggestions and discussion [READ THE FIRST POST]

@byte[]
Stats time!

This image is blocked by your current filter - click here to display it anyway

your current filter.

derpibooru=# select count(*) from users;
 count
--------
 462186
(1 row)

Time: 21.599 ms

derpibooru=# select count( distinct tag_changes.image_id ) as image_count, users.name
    from tag_changes
    join users on tag_changes.user_id = users.id
    group by users.name
    order by image_count desc
    limit 20;
 image_count |        name
-------------+--------------------
     2021969 | Dragonpone
      727405 | Zeb
      404496 | deactivateda0841fe
      333667 | GlitchedWolf
      261694 | Princess Luna
      236625 | LightningBolt
      224932 | Paws359
      189831 | Ereiam
      189221 | JP
      151202 | 971384265
      124257 | 🙂
      123776 | saby
      113768 | Mildgyth
      104096 | WatermelonRat
       99124 | patec
       96985 | Markiz93
       90304 | Defender of 5
       89030 | ZONESS
       80520 | Crow
       73005 | stsyn
(20 rows)

Time: 19999.431 ms (00:19.999)

derpibooru=# select count( distinct tag_changes.image_id )
    from tag_changes
    join users on tag_changes.user_id = users.id
    join tags on tag_changes.tag_id = tags.id
    where users.name = 'Dragonpone' and tags.name = 'g4';
  count
---------
 1979766
(1 row)

Time: 737.473 ms

derpibooru=# select count( distinct tag_changes.image_id )
    from tag_changes
    join users on tag_changes.user_id = users.id
    join tags on tag_changes.tag_id = tags.id
    where users.name = 'Dragonpone' and tags.name <> 'g4';
 count
--------
 177068
(1 row)

Time: 3359.351 ms (00:03.359)

derpibooru=# select count( distinct tag_changes.image_id ) as image_count, users.name
    from tag_changes
    join users on tag_changes.user_id = users.id
    where users.name = 'Dragonpone'
    group by users.name;
 image_count |    name
-------------+------------
     2021969 | Dragonpone
(1 row)

Time: 1169.377 ms (00:01.169)

derpibooru=# select count( distinct tag_changes.image_id ) as image_count, users.name
    from tag_changes
    join users on tag_changes.user_id = users.id
    where users.name = 'Zeb'
    group by users.name;
 image_count | name
-------------+------
      727405 | Zeb
(1 row)

Time: 647.426 ms

derpibooru=# select count( distinct tag_changes.image_id ) as image_count, users.name
    from tag_changes
    join users on tag_changes.user_id = users.id
    where users.name = 'patec'
    group by users.name;
 image_count | name
-------------+-------
       99124 | patec
(1 row)

Time: 101.447 ms

derpibooru=# select count( distinct tag_changes.image_id ) as image_count, users.name
    from tag_changes
    join users on tag_changes.user_id = users.id
    where users.name = '.'
    group by users.name;
 image_count | name
-------------+------
         815 | .
(1 row)

Time: 2.399 ms

And if you also make a description of each saved link, a feature that not every browser provides

Again, many people may have multiple browsers on different devices.

improve the site by adding new functionality that will expand the capabilities of the site.

Plus, many large sites already have similar functionality, because it’s more convenient.

What browser are you using that doesn’t allow you to name bookmarks?

What browser do you use that isn’t cross-platform and doesn’t sync bookmarks?

It looks like you are asking for a way to bookmark searches. Is this what you are asking for? If so, simply bookmark your searches.

Can you give an example?

!(trixie OR starlight glimmer)
!(bikini OR lingerie)
twilight sparkle

Otherwise… I guess what you’re looking for may be better described as having multiple Watchlists?

they want to save the bookmark on the site, not in their browser

Like TSP suggested: multiple watch lists.

I myself know that it is possible

@Ciaran

This image is blocked by your current filter - click here to display it anyway

your current filter.

Here you will find an example of tags and a concept of what it might look like. (Clause 3. Although all clauses have elements related to this problem)

Just one as a simple example of what you are asking for.