Posted On: Sep 3, 2020

Starting today, Amazon Aurora PostgreSQL supports the RDKit extension. The RDKit extension allows cheminformatics to deal with manipulation of chemical structures, fingerprinting search functions and molecular structure matching. Using PostgreSQL as a datastore, you can interact with several built-in functions to compare, manipulate and identify molecular structures via standard SQL.

RDKit is only supported for version 11.8 or higher. If you create the RDKit extension on a version prior to 11.8, you will need to drop and recreate it when you convert to 11.8. Please review the Aurora documentation to learn more. You can view a list of all PostgreSQL extensions supported on RDS on the AWS User Guide.  

Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to three times better performance than the typical PostgreSQL database, together with increased scalability, durability, and security. For more information, please visit the Amazon Aurora product page. To get started with Amazon Aurora PostgreSQL, take a look at our getting started page.

Don't see an extension you'd like to use? Let us know through the AWS Forum, through your sales rep or TAM, or by emailing us at rds-postgres-extensions-request@amazon.com.