Page 1 of 1

DADA.BASE Window functions?

Posted: Thu Jan 31, 2019 3:20 pm
by ratox
Hi Daniele,
Does dada.base implement window functions?? PERCENT_RANK, NTILE, CUME_DIST?…looks like not….

Re: DADA.BASE Window functions?

Posted: Thu Jan 31, 2019 3:49 pm
by ratox
Maybe because it’s too recent?
any hope to an easy fast upgrade?

https://www.i-programmer.info/news/84-d ... tions.html

Re: DADA.BASE Window functions?

Posted: Thu Jan 31, 2019 6:51 pm
by danieleghisi
Hi Alessandro, dada.base at the current stage takes advantage of the portion of the Max API linking with the SQLite database, which means that as long as they don't support them, the main dada branch won't either.

However you are perfectly free to make your own branch and use some other SQLite library of your choice, since dada is open source. The Max sqlite api is only used in a few lines of code. Let me know if you do so and how it goes!

Daniele