PixQL: SQL for image processing • Hacker News Board

Re: PixQL: SQL for image processing

#11

Post by richmarr » Tue, Jun 30, 2015, 8:36 AM UTC

kbenson wrote: post #6

If you are going to use SQL select, why use a separate operate statement when you could just use SQL's method for this, update? For that matter, if you are going to use SQL syntax, I would imagine you would want to keep one of the main features, which is joining of datasets. Being able to join an image with itself in some manner (or another image...), would be really useful. Instead of globals, use the images as tabl…

There are lots of fun things you can do with a few gigs of images and an inverted index.

Re: PixQL: SQL for image processing

#12

Post by no_gravity » Tue, Jun 30, 2015, 8:51 AM UTC

Wouldn't it be easier to use JavaScript?

    PixQL: SELECT WHERE COLOR = #FF0000FF; OPERATE SET COLOR = #00FF00FF
    JS   : if (rgba=='FF0000FF') rgba='00ff00ff'

    PixQL: OPERATE SET G = R
    JS   : g=r

    PixQL: SELECT WHERE ROW % 100 = 0 OR COL % 100 = 0; OPERATE SET COLOR = WHITE
    JS   : if (!(row%100) || !(col%100)) rgba="ffffffff"

Re: PixQL: SQL for image processing

#13

Post by brobdingnagian » Tue, Jun 30, 2015, 9:06 AM UTC

no_gravity wrote: post #12

Wouldn't it be easier to use JavaScript? PixQL: SELECT WHERE COLOR = #FF0000FF; OPERATE SET COLOR = #00FF00FF JS : if (rgba=='FF0000FF') rgba='00ff00ff' PixQL: OPERATE SET G = R JS : g=r PixQL: SELECT WHERE ROW % 100 = 0 OR COL % 100 = 0; OPERATE SET COLOR = WHITE JS : if (!(row%100) || !(col%100)) rgba="ffffffff"

No I'm pretty sure it would be easier (aka shorter) using 7zipped brainfuck.

Re: PixQL: SQL for image processing

#14

Post by JonaSmith » Tue, Jun 30, 2015, 10:02 AM UTC

kubiiii wrote: post #7

ddebernardy wrote: post #5

Does this have any practical use? It seems like the image equivalent of treating an HTML file as a huge string of characters -- instead of as the representation of a DOM tree. Which makes very little sense. Plus, you seldom want to do trivial things like selecting red pixels and flipping their color to green. You want to select red eyes and flip those to their correct color.

I find this interesting, but I also would like to see more complex use cases. For example using using some kind of select union on several images to output a synthetic image highlighting differences or similarities?

Same here. A more complex exemple/case study would be great.

Re: PixQL: SQL for image processing

#15

Post by charriu » Tue, Jun 30, 2015, 11:15 AM UTC

creshal wrote: post #10

joelthelion wrote: post #8

SQL is awesome, but it doesn't mean you have to keep the CAPITAL LETTERS.

Aren't SQL keywords case insensitive anyway?

Everything except quoted strings is case insensitive.

Re: PixQL: SQL for image processing

#16

Post by itsbits » Tue, Jun 30, 2015, 11:31 AM UTC

mappu wrote: post #3

Interesting! Can you support multiple image buffers? e.g. for xor or morphing operations. I would suggest taking a look at avisynth as an example of a media processing language.

may be we can use BETWEEN..

Re: PixQL: SQL for image processing

#17

Post by Keyframe » Tue, Jun 30, 2015, 11:34 AM UTC

ddebernardy wrote: post #5

Does this have any practical use? It seems like the image equivalent of treating an HTML file as a huge string of characters -- instead of as the representation of a DOM tree. Which makes very little sense. Plus, you seldom want to do trivial things like selecting red pixels and flipping their color to green. You want to select red eyes and flip those to their correct color.

Declarative language seems appropriate for image manipulation, at least for selecting an area for operation and then running a kernel over it. It would be interesting to see how one could implement, let's say, luminance calculation (any type) or anything that needs to go back and forth over pixels. Also, pixels which aren't 24-bit per pixel, but more.

Re: PixQL: SQL for image processing

#18

Post by juleska » Tue, Jun 30, 2015, 11:59 AM UTC

where I can apply it ? i mean, what would be a usefull usage for the lib?

Re: PixQL: SQL for image processing

#19

Post by paulasmuth » Tue, Jun 30, 2015, 1:34 PM UTC

I love this! Now all we need is some higher level DRAW operations (draw a line from here to there, draw a piece of rendered text here) and we can glue PixQL and ChartSQL together to implement SQL query result visualization to bitmaps completely in SQL (without going through SVG).

PS: Under which license is the PixSQL code available?

Re: PixQL: SQL for image processing

#20

Post by TeeWEE » Tue, Jun 30, 2015, 1:43 PM UTC

So how do i blur an image, probably its not possible with this kind of SQL language, right? Or can you do something like this:

SELECT *: OPERATE SET COLOR AVG(ROW[-1], ROW[0], ROW[+1]))

To apply a 1 pixel horizontal blur?