Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

NoSQL support #2592

Closed
robocoder opened this issue Jul 27, 2011 · 12 comments
Closed

NoSQL support #2592

robocoder opened this issue Jul 27, 2011 · 12 comments
Labels
duplicate

Comments

@robocoder
Copy link
Contributor

@robocoder robocoder commented Jul 27, 2011

Using Mongodb, Hadoop, Tokudb, Piwik could scale to greater limits.

This ticket is an invitation to the community to comment and discuss the Nosql support of Piwik!

References:

@mattab
Copy link
Member

@mattab mattab commented Apr 5, 2014

Reopening as there is a lot of interest from the community to build a Nosql version of Piwik!

@mattab
Copy link
Member

@mattab mattab commented Apr 5, 2014

two years ago we have discussed this topic in the past Nosql for Piwik for a GSoC proposal: https://github.com/piwik/piwik/wiki/GSoC-2013#project-gsoc1-multiple-database-support-implement-mongodb-adapter

@robocoder robocoder added this to the Future releases milestone Jul 8, 2014
@mattab mattab removed Major labels Aug 3, 2014
@mattab mattab mentioned this issue Aug 29, 2014
@mattab mattab removed this from the Long term milestone Dec 23, 2015
@mattab mattab added this to the Mid term milestone Dec 23, 2015
@mattab mattab added this to the Mid term milestone Dec 23, 2015
@mattab mattab removed this from the Long term milestone Dec 23, 2015
@mattab mattab removed this from the Long term milestone Dec 5, 2016
@mattab mattab added this to the Mid term milestone Dec 5, 2016
@mattab mattab added this to the Mid term milestone Dec 5, 2016
@mattab mattab removed this from the Long term milestone Dec 5, 2016
@timofeytt
Copy link

@timofeytt timofeytt commented Jan 12, 2017

Well, it doesn't have to be completely No SQL. You may look into ClickHouse - the column-oriented DBMS used by Yandex for its own web analytics. It even has SQL syntax, so it doesn't require a complete rewrite of Piwik.

@gebi
Copy link

@gebi gebi commented Mar 24, 2017

Yes, clickhouse would be a really nice backend!

@gmenegatti
Copy link

@gmenegatti gmenegatti commented Apr 17, 2017

We have just contacted Piwik's team in order to check the viability to integrate SlicingDice as a backend for Piwik. Let's see how it goes.

@faust64
Copy link

@faust64 faust64 commented Jul 26, 2017

What about Cassandra?

@mattab
Copy link
Member

@mattab mattab commented Oct 16, 2018

FYI Clickhouse would be the more likely candidate we would look into eventually, as it's SQL compatible

@tsteur
Copy link
Member

@tsteur tsteur commented Jan 2, 2019

While it has SQL support you need to look into some details. Eg does it support delete/update and if supported, is it fast. Does it support eg 10 to 20 joins, does it support all kind of alter table statements etc.

@tsteur
Copy link
Member

@tsteur tsteur commented Feb 22, 2020

Closing this issue as a duplicate of #7526

@tsteur tsteur closed this as completed Feb 22, 2020
@tsteur tsteur added duplicate and removed Enhancement labels Feb 22, 2020
@flyonce
Copy link

@flyonce flyonce commented Mar 15, 2021

Yes, clickhouse would be a really nice backend!

Hi,what need to do if i wanna to use clickhouse as backend of matomo?

@sgiehl
Copy link
Member

@sgiehl sgiehl commented Mar 15, 2021

@flyonce Afaik we don't have supporting any other database backend on our roadmap, as it would require to much work.
Not sure if anyone ever tried running Matomo on clickhouse. But feel free to give it a try, if you are keen on it.
If it works smoothly feel free to report back to us :-)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
duplicate
Projects
None yet
Development

No branches or pull requests

10 participants