picsql-1.0.5

• Convolution Mask function

• Discr Function

• Flip function

• Butter function

picsql-1.0.4

hotfix

picsql-1.0.3

Create GIF animation with syntax :

select lag(r, 5, t%20), (g*t)%255, (t * 10) % 255 
from (./examples/face.bmp, 50)

Create a GIF by applying 50 times the query on the same picture, with increments "t" from 0 to 50.

Run query like that :

picsql.jar "select lag(r, 5, t%20), (g*t)%255, (t * 10) % 255 from (./examples/face.bmp, 50)" "test.gif"

Result:

picsql-1.0.2

• Fix subqueries.

picsql-1.0.1

• Load a grid of a same picture with syntax :

select r, g, b
from (./examples/face.bmp, 5, 5)

Picture face.bmp is loaded 25 times in a grid of 5 x 5.

• Launch a simple GUI by add "--gui" flag: picsql.jar --gui
• Fixes and Gradle updates.

picsql-1.0.0

initial release :

• Select and manipulate pixels of pictures in your disk with SQL-like dialect (only BMP at this time).
• Access to each color channel r,b,g and pixel position : x,y, rank().
• Can query any number of pictures in the FROM clause, load only a region or subquery or build a colored rectangle.
• Math operators : *, /, +, -, %.
• Math functions: rand, pi, cos, sin, tan.
• Where clause with boolean operators : and / or.
• Lag and lead to get relative pixels from a position.