chop-dbhi/sql-agent

Support for Cassandra

jmdacruz opened this issue · 2 comments

jmdacruz commented

I'm thinking about adding support for Cassandra via https://github.com/gocql/gocql. How would one go about implementing this? Any good pointers? I've briefly looked at #7, but I'm not a go expert.

bruth commented

Hi @jmdacruz! Hm, currently sql-agent depends on drivers implementing the database/sql interfaces, but according to this this version of the driver does not (the previous one does).

I am not familiar with what is unique about Cassandra in terms of sending read queries, but for the scope of sql-agent, it may be easy to provide a small database/sql compatible implementation for this driver.

jmdacruz commented

That makes sense, given to the distributed nature of Cassandra (e.g., consistency). You are probably right in that a small compatible subset of the queries could be made available via a a facade implementing the database/sql interface.