I am recently trying to implement my own database adapter with Cassandra database, I am using Yacassandrapdo as driver. The only document I could find is just a couple of lines from here
https://phalcon-php-framework-documentation.readthedocs.org/en/latest/reference/db.html#implementing-your-own-adapters
With the sample code from incubator, it makes sense about adapter, but not very helpful in terms of a fully new adapter.
https://github.com/phalcon/incubator/tree/master/Library/Phalcon/Db/Adapter.
The example from fishjerky is good one,
https://github.com/fishjerky/phalcon-mssql
But I think it will be good with more documents/tutorial of what are necessory steps (adapter methods) need to be done to build a new adapter