There are many kinds of orm databases, which one should I use?

Yii 3.0
1

about the database,

Yii DB
Yii Active Record
Cycle via Yii Cycle package
Doctrine via Yii Doctrine package
PDO

I used activeRecord in yii2, Doctrine in symfony, and I am learning about cycle orm.

Excuse me, which one is recommended?

2

It depends on your project’s requirements there isn’t a single recommended choice for everyone.

  • Yii DB – A lightweight query builder/DB abstraction. Good if you prefer writing SQL with minimal overhead.
  • Yii Active Record – Familiar and productive, especially if you’re coming from Yii2. Great for CRUD applications.
  • Cycle ORM – A modern Data Mapper ORM with good performance and flexibility. A solid choice for new Yii 3 projects.
  • Doctrine ORM – Very feature-rich and mature, ideal for complex domain models, though it has a steeper learning curve.
  • PDO – Best when you need full control over SQL and don’t require ORM features.
1 Like
3

I’d ditch PDO from the list, leaving Yii DB which is way more convenient and allows quite low level things to be done.