使用Boto3与RDS上的amazon Aurora进行交互

时间:2022-09-05 23:10:24

I have set up a database in Amazon RDS using Amazon Aurora and would like to interact with the database using Python - the obvious choice is to use Boto.

我使用Amazon Aurora在Amazon RDS中建立了一个数据库,并希望使用Python与数据库进行交互 - 显而易见的选择是使用Boto。

However, their documentation is awful and does nopt cover ways in which I can interact with the databse to:

但是,他们的文档非常糟糕,并且可以覆盖我可以与数据库进行交互的方式:

  • Run queries with SQL statements
  • 使用SQL语句运行查询
  • Interact with the tables in the database
  • 与数据库中的表进行交互
  • etc
  • 等等

Does anyone have an links to some examples/tutorials, or know how to do these tasks?

有没有人有一些示例/教程的链接,或知道如何执行这些任务?

1 个解决方案

#1


8  

When using Amazon RDS offerings (including Aurora), you don't connect to the database via any AWS API (including Boto). Instead you would use the native client of your chosen database. In the case of Aurora, you would connect using the MySQL Command Line client. From there, you can query it just like any other MySQL database.

使用Amazon RDS产品(包括Aurora)时,您不会通过任何AWS API(包括Boto)连接到数据库。相反,您将使用所选数据库的本机客户端。对于Aurora,您将使用MySQL命令行客户端进行连接。从那里,您可以像任何其他MySQL数据库一样查询它。

There's a brief section of the "Getting Started" documentation that talks about connecting to your Aurora database:

有一些关于连接Aurora数据库的“入门”文档的简短部分:

Connecting to an Amazon Aurora DB Cluster

连接到Amazon Aurora数据库群集

#1


8  

When using Amazon RDS offerings (including Aurora), you don't connect to the database via any AWS API (including Boto). Instead you would use the native client of your chosen database. In the case of Aurora, you would connect using the MySQL Command Line client. From there, you can query it just like any other MySQL database.

使用Amazon RDS产品(包括Aurora)时,您不会通过任何AWS API(包括Boto)连接到数据库。相反,您将使用所选数据库的本机客户端。对于Aurora,您将使用MySQL命令行客户端进行连接。从那里,您可以像任何其他MySQL数据库一样查询它。

There's a brief section of the "Getting Started" documentation that talks about connecting to your Aurora database:

有一些关于连接Aurora数据库的“入门”文档的简短部分:

Connecting to an Amazon Aurora DB Cluster

连接到Amazon Aurora数据库群集