Lessons learnt writing PostgreSQL extensions for JSON(b) Wednesday 16:20 Baltic II+III
GitHub: furstenheim Company website: geoblink.com
My name is Gabriel Fürstenheim, I'm a mathematician working as Senior Developer at Geoblink.
I'm a very curious person, always trying to understand what is under the hood. On my free time I try to do Open Source and climbing.
No, this is my first time ever.
I will explain how to add native functionality to JSONb for a performance boost.
JSONb in postgres are really good for querying data, but manipulating them can be quite an adventure. It turns out that writing extensions for JSONs is not very hard and things can get really faster, for example JSON schema validation is 20x faster in C than in SQL.
Any PostgreSQL database user that has JSONs in his database.
Some prior knowledge of C extensions might be helpful, but the main point of the talk is that anyone can do it.