blocks|key|312377|text|可扩展性|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|312378|twisted.enterprise.adbapi不一定是以可伸缩的方式与数据库对话的接口。可伸缩性是一个你需要单独解决的问题。twisted.enterprise.adbapi真正声称要做的唯一一件事就是让您可以使用DB-API2.0模块，而不会出现通常所暗示的阻塞。|CODE|312379|Postgres|312380|是。这是正确的答案。我不认为所有的Python绑定都是被遗弃的--例如，psycopg2似乎是主动维护的。事实上，他们只是为异步访问添加了一些新的绑定，Twisted最终可能会提供一个接口。|312381|SQLite3也很酷。您可能希望在您的应用程序中使用Postgres或SQLite3；例如，即使您想在Postgres上部署，您的单元测试在SQLite3上运行也肯定会更愉快。|312382|Other?|312383|很难知道另一个数据库(也许是非关系数据库)是否比Postgres更适合您的应用程序。这在很大程度上取决于您将要存储的特定数据以及需要对其运行的查询。如果你的数据库中有有趣的关系，Postgres看起来确实是一个很好的答案。但是，如果您的所有查询看起来都像"SELECT+foo，bar+FROM+baz“，那么可能有一个更简单、性能更高的选项。|312384|entityMap^0|0|4|0|0|P|1S|P|0|0|8|0|0|0|0|6|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|X|8|@$9|Y|A|Z|B|H]|$9|10|A|11|B|H]]|D|@]|E|$]]|$1|I|3|J|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|K|3|L|5|6|7|15|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|16|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|17|8|@$9|18|A|19|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|6|7|1A|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|1B|8|@]|D|@]|E|$]]]|T|$]]

Scalability

<code>twisted.enterprise.adbapi</code> isn't necessarily an interface for talking to databases in a scalable way. Scalability is a problem you get to solve separately. The only thing <code>twisted.enterprise.adbapi</code> really claims to do is let you use DB-API 2.0 modules without the blocking that normally implies.

Postgres

Yes. This is the correct answer. I don't think all of the Python bindings are abandonware - psycopg2, for example, seems to be actively maintained. In fact, they just added some new bindings for async access which Twisted might eventually offer an interface.

SQLite3 is pretty cool too. You might want to make it possible to use either Postgres or SQLite3 in your app; your unit tests will definitely be happier running against SQLite3, for example, even if you want to deploy against Postgres.

Other?

It's hard to know if another database entirely (something non-relational, perhaps) would fit your application better than Postgres. That depends a lot on the specific data you're going to be storing and the queries you need to run against it. If there are interesting relationships in your database, Postgres does seem like a pretty good answer. If all your queries look like "SELECT foo, bar FROM baz" though, there might be a simpler, higher performance option.

blocks|key|312386|text|有txpostgres库，它是twisted.enterprise.dbapi的替代，线程池的-instead和阻塞的DB+IO，它是完全异步的，利用了psycopg2的内置异步功能。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|312387|我们正在一家大公司的生产中使用它，到目前为止，它一直很好地服务于我们。此外，它正在积极开发-我们最近报告的一个bug很快就被解决了。|312388|312389|http://pypi.python.org/pypi/txpostgres|unordered-list-item|312390|https://github.com/wulczer/txpostgres|312391|312392|entityMap|0|LINK|mutability|MUTABLE|url|1^0|1|A|F|O|24|8|0|0|0|0|12|0|0|0|11|1|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|13|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|14|8|@]|D|@]|E|$]]|$1|I|3|J|5|K|7|15|8|@]|D|@$9|16|A|17|1|18]]|E|$]]|$1|L|3|M|5|K|7|19|8|@]|D|@$9|1A|A|1B|1|1C]]|E|$]]|$1|N|3|-4|5|6|7|1D|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|1E|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|J]]|V|$5|R|S|T|E|$U|M]]]]

There is the <code>txpostgres</code> library which is a drop in replacement for <code>twisted.enterprise.dbapi</code>, —instead of a thread pool and blocking DB IO, it is fully asynchronous, leveraging the built in async capabilities of <code>psycopg2</code>.

We are using it in production in a big corporation and it's been serving us very well so far. Also, it's actively developed—a bug we reported recently was solved very quickly.

<ul>
<li><a href="http://pypi.python.org/pypi/txpostgres" rel="noreferrer">http://pypi.python.org/pypi/txpostgres</a></li>
<li><a href="https://github.com/wulczer/txpostgres" rel="noreferrer">https://github.com/wulczer/txpostgres</a></li>
</ul>

blocks|key|309266|text|你可以看看nosql数据库，比如mongodb或者couchdb+with+twisted。使用基于nosql的数据库比使用mysql或postgres向外扩展要容易得多。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|309267|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You could look at nosql databases like mongodb or couchdb with twisted.
Scaling out could be rather easier with nosql based databases than with mysql or postgres.

There's an API for Twisted apps to talk to a database in a scalable way: <a href="http://twistedmatrix.com/projects/core/documentation/howto/rdbms.html" rel="noreferrer">twisted.enterprise.dbapi</a>

The confusing thing is, which database to pick?

The database will have a Twisted app that is mostly making inserts and updates and relatively few selects, and then other strictly-read-only clients that are accessing the database directly making selects.

(The read-only users are not necessarily selecting the data that the Twisted app is inserting; its not as though the database is being used as a message-queue)

My understanding - which I'd like corrected/adviced - is that:

<ul>
<li>Postgres is a great DB, but almost all the Python bindings - and there is a confusing maze of them - are abandonware</li>
<li>There is <a href="http://initd.org/psycopg/" rel="noreferrer">psycopg2</a> for postgres, but that makes a lot of noise about doing its own connection-pooling and things; does this co-exist gracefully/usefully/transparently with the Twisted async database connection pooling and such?</li>
<li>SQLLite is a great database for little things but if used in a multi-user way it does whole-database locking, so performance would suck in the usage pattern I envisage; it also has different mechanisms for typing column values?</li>
<li>MySQL - after the Oracle takeover, who'd want to adopt it now or adopt a fork?</li>
<li>Is there anything else out there?</li>
</ul>

Database for Python Twisted

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

Twisted应用程序有一个以可伸缩的方式与数据库对话的API：令人困惑的是，选择哪个数据库？数据库将有一个Twisted应用程序，它主要进行插入和更新，相对较少的选择，然后是其他严格只读的客户端，它们直接访问数据库进行选择。(只读用户不一定选择Twisted应用程序插入的数据；它不像是将数据库用作消息队列)我的理解是...

问Python Twisted数据库
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Python Twisted数据库EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Python Twisted数据库
EN