Color palette plugin for Piwigo
Home Page: http://piwigo.org/ext/extension_view.php?eid=874
License: MIT License
I love 💻 programming, 
open source, 🎧 music, 🎨 art, 🏃 running, 🤔 learning and 🗣️ sharing knowledge.
I'm the founder of annimon.com — a 10+ years old site where you can share your programming knowledge and learn something new.
Some tutorials you can find in annimon-tutorials organization.
More information about my projects and publications you can find on projects.annimon.com.
Hello there. I noticed that Color Palette does not appear on photo details page on Piwigo version 11.1.0 as it should. On version 11, it worked perfectly.
The extension is flagged as compatible in version 11 and now 11.1.0.
I've index my 35000 photos with color palette, and when I try a look up, I have a timeout.
The request looks like:
ANALYZE
SELECT
1 as i,
pal.image_id as pal_image_id
FROM
piwigo_color_palette pal
INNER JOIN piwigo_images img ON img.id = pal.image_id
INNER JOIN piwigo_image_category cat ON img.id = cat.image_id
WHERE
(
(
color_r BETWEEN 204
AND 204
)
AND (
color_g BETWEEN 0
AND 0
)
AND (
color_b BETWEEN 0
AND 0
)
)
AND cat.category_id NOT IN (0)
AND img.level <= 8
GROUP BY
pal.image_id
HAVING
SUM(i) = 1;The analyze give:
+------+-------------+-------+--------+---------------------------+-------------------+---------+---------------------+-------+----------+----------+------------+-----------------------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | r_rows | filtered | r_filtered | Extra |
+------+-------------+-------+--------+---------------------------+-------------------+---------+---------------------+-------+----------+----------+------------+-----------------------------------------------------------+
| 1 | SIMPLE | cat | range | PRIMARY,image_category_i1 | image_category_i1 | 2 | NULL | 16692 | 33926.00 | 100.00 | 100.00 | Using where; Using index; Using temporary; Using filesort |
| 1 | SIMPLE | img | eq_ref | PRIMARY | PRIMARY | 3 | piwigo.cat.image_id | 1 | 1.00 | 100.00 | 100.00 | Using where |
| 1 | SIMPLE | pal | ref | image_id | image_id | 4 | piwigo.cat.image_id | 12 | 8.00 | 100.00 | 0.11 | Using index condition; Using where |
+------+-------------+-------+--------+---------------------------+-------------------+---------+---------------------+-------+----------+----------+------------+-----------------------------------------------------------+
3 rows in set (1 min 20.215 sec)
It took 1min20 to filter!
I create this index:
create index pwg_cp_ccci on piwigo_color_palette (color_r, color_g, color_b, image_id);
Then the analyze give:
+------+-------------+-------+--------+---------------------------+-------------+---------+---------------------+------+--------+----------+------------+--------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | r_rows | filtered | r_filtered | Extra |
+------+-------------+-------+--------+---------------------------+-------------+---------+---------------------+------+--------+----------+------------+--------------------------+
| 1 | SIMPLE | pal | ref | image_id,pwg_cp_ccci | pwg_cp_ccci | 3 | const,const,const | 191 | 308.00 | 100.00 | 100.00 | Using where; Using index |
| 1 | SIMPLE | cat | ref | PRIMARY,image_category_i1 | PRIMARY | 3 | piwigo.pal.image_id | 1 | 1.00 | 50.00 | 100.00 | Using where; Using index |
| 1 | SIMPLE | img | eq_ref | PRIMARY | PRIMARY | 3 | piwigo.pal.image_id | 1 | 1.00 | 100.00 | 100.00 | Using where |
+------+-------------+-------+--------+---------------------------+-------------+---------+---------------------+------+--------+----------+------------+--------------------------+
3 rows in set (0.007 sec)
The look up takes 0.007 sec now !
Can you integrate this index with a migration or something?
Thanks.
Would it be possible to have multiple selections, for example 3 colors, to match an image ?
One sample helps but with over 10.000 images I'd like to be able to distinct even more then with just 1 color.
hi, awesome little plugin, love it, exactly what should be the default in any serious picture managers!
now, i see you are still active on it so can i ask for features and send pull requests?
Hi!
I encountered pretty serious bug with this plugin I think.
The palette search shows pictures from private albums, even for guests! When I click them, I got access denied, but the thumbs are visible!
I found it out by coincidence when I found images from private albums on Google image search - so it was evident they were exposed for guest access!
Please check the code, because without a fix it's impossible to use it for me.
Thanks.
Tom
If possible, I would like to be able to select the location inside the picture where it takes the sample.
Especially with large images, it takes a sample of the colors that are all the same
Hi :-)
For add your project on https://piwigo.org/translate, can you give acces to user Piwigo-TranslationTeam and say me it's ok ;-)
Implement without color palette prefilter
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
Django
The Web framework for perfectionists with deadlines.
Laravel
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft
Open source projects and samples from Microsoft.
Google
Google ❤️ Open Source for everyone.
Alibaba
Alibaba Open Source for everyone
D3
Data-Driven Documents codes.
Tencent
China tencent open source team.