@robocoder opened this Issue on November 25th 2009 Contributor

At present, Piwik has two Db "layers" -- one for reports, the other for the Tracker (non-Zend_Db for speed) -- and largely MySQL-ish SQL.

Doctrine has a Database abstraction layer that may help with supporting more database servers (non-MySQL).

Obstacles to adopting Doctrine:

  • requires php 5.2.3+ (implies raising Piwik requirements)
  • only supports PDO drivers (which rules out mysqli)
  • desire for speed vs the overhead of Doctrine's ORM

Keywords: wishlist

@robocoder commented on November 25th 2009 Contributor

This is a sign post for future discussion. Closing for now.

@ak5 commented on August 29th 2014

Does anyone else think it makes sense to check this one out again? I think this would be a great way to support a range of NoSQL databases.

@mattab commented on August 29th 2014 Owner

I think this would be a great way to support a range of NoSQL databases.

see #2592

@sgiehl commented on August 29th 2014 Member

I would rather disagree. I think Doctrine ORM would be a too big performance killer.

@diosmosis commented on August 29th 2014 Member

I think @sgiehl is correct. Additionally, using an ORM won't provide instant compatibility w/ NoSQL (relational databases & NoSQL databases are too different).

@julienmoumne commented on September 9th 2014 Member

I think it is useful here to acknowledge the fact Piwik has different types of persisted data : tracking/raw data, report/processed data and "application" data (users, sites, pdf reports, ..).

Ideally, different types of data require different persisting methods.

I think "Application" data could benefit from being managed by an ORM.

This Issue was closed on March 21st 2010
Powered by GitHub Issue Mirror