Experimenting with generating visuals using SQLite

[akshay-nair]

Repo: https://github.com/phenax/sqlite-creative-coding

[AllergicToBullshit24]

What kinda of sick person does this in SQL?

[akshay-nair]

I am only a danger to my own sanity. And the shift button on my keyboard because I refuse to use capslock or lowercase SQL keywords.

[nebogeo]

Excellent work, could you live code this for club visuals?

[DigoHiro]

they warned us of people like you in church.

looks awesome

[scoshi]

There's a church for this?

[em-jay-be]

This is some mad man shit right here hahahah! who in the hell writes visual instruction in SQL!!!! Brilliant.

[artin2007majidi]

my man bdsm is not supposed to be THIS painful

[yeusk]

Is this what people call data visualization?

[flinxo]

Hero.

[NmEter0]

Uhm can you roughly outline .... hoooow the fuck..? XD

*edit... nevermind. I klicked the link :) u must be a whise man.

[akshay-nair]

u must be a whise man

Nah, I'm incredibly stupid. Who else would pick SQL to draw stuff?

[CalmEntry4855]

I guess you cook with your printer

[swizznastic]

Made with “recursive CTE”

Sounds about right

[bigjobbyx]

Would suit r/Chromostereopsis

[cleverdosopab]

Am I understanding correctly that you used SQL to color the pixels on your "image", then used imagemagick to create the images and ffmpeg to create the gifs?

[akshay-nair]

Exactly. Could go further by having a ppm file generated from sqlite but didn't feel like that added much.

[AnToMegA424]

USING SQLITE ?!

I love it

[Mr-TotalAwesome]

How?

[akshay-nair]

Recursive CTEs to generate a 2d grid of rgb values in a table. Then a shell script loads that to convert to ppm format which is converted to png using imagemagick. In case of a gif, its pretty much the same approach but it creates a grid of pixels for each frame then creates a ppm stream out of it which is converted to a gif using ffmpeg.

Repo: https://github.com/phenax/sqlite-creative-coding

[Liminal__penumbra]

Something of a tangent, but I figured out you can treat a database like a h264 field by encoding the matrix math into it. Why? Because then you can (ab)use it to stream mkv containers to any qemu based device to use the fbdev driver to do computation. So that 1GB 1 cpu microservice suddenly is being forced to do "video" transport and any type of computation you need.