Released a new version of the PostgreSQL FDW for Cassandra
Published on July 31, 2022 by Stefanie Janine Stölting
PostgreSQL Cassandra Foreign data wrapper cassandra2_fdw
1 min READ
The cassandra2_fdw is a foreign data wrapper to connect to Apache Cassandra database from inside PostgreSQL written in C.
There hasn’t been any work on this foreign data wrapper for a long time. When I tried to use it, it didn’t work at all.
As the original goal was to convert data from Cassandra into PostgreSQL, I gave it a try, to bring it up to date.
First I took care of using the right PostgreSQL library files for the currently supported versions, which are 10 to 14.
Next step has been to rework and extend the supported data types.
. In addition I rewrote the documentation to make some stuff a bit more clear to the users.
Changes are merged into the original repository at GitHub: jaiminpan/cassandra2_fdw.
In the end I did not use the foreign data wrapper to move the data over from Cassandra to PostgreSQL. The library used to connect and query Cassandra does not support user defined types and that has been used in the data structures a lot.
I ended up with writing a conversion tool in Python, that also considered the data structure changes.