This gets a bit personal.I love Heroku(most people who know me know that) but I have always found the lack of support of C a bit annoying.I recently voiced my concern over this on Heroku's official Facebook page.To my delight,they responded,saying that if I build a buildpack for that,they will promote it.So,this starts now then.
The software will generate a set of HTML files for a PostgreSQL database with inter linking.This shall allow users to conveniently see the overall structure of their database.The information will include tables,views,functions,schemas,sequences and more.
Later on we are also planning to interface ERD generation with our software.
I am enjoying doing the project like anything.I am learning a lot of SQL and how PostgreSQL maintains its data and metadata.It is so awesome.
I will also have to learn Python for the project.This should be interesting.
A patch that gives speed up upto 25% in the backend for workloads that involve a lot of data being touched by the same transaction.The patch tries to mitigate the cost of I/O in this case by trying to mitigate the I/O.It involves maintaining a cache that can be used for determining the commit status of the transaction that last touched a tuple in cases of workloads as described above.
The idea belongs to my mentor,Merlin Moncure.My work is a simpler implementation of the idea,simpler as compared to Baba(I call Merlin as Baba)'s implementation.
The patch is under review.Thanks a ton Amit Kapila and Hari Babu.