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

SQLite gains support for window functions in 3.25.0 #144

Closed
DavisVaughan opened this issue Aug 15, 2018 · 2 comments
Closed

SQLite gains support for window functions in 3.25.0 #144

DavisVaughan opened this issue Aug 15, 2018 · 2 comments
Labels
feature func trans 🌍
Milestone

Comments

@DavisVaughan
Copy link
Member

@DavisVaughan DavisVaughan commented Aug 15, 2018

According to the developers, it mimics PostgresSQL.

https://www.sqlite.org/draft/windowfunctions.html
https://www.sqlite.org/draft/releaselog/3_25_0.html

Would also need to update the vignette section, "Creating your own database", as it mentions the current lack of window function support.
https://cran.r-project.org/web/packages/dbplyr/vignettes/dbplyr.html

@RMHogervorst
Copy link

@RMHogervorst RMHogervorst commented Nov 30, 2018

depends on r-dbi/RSQLite#273

@krlmlr
Copy link
Member

@krlmlr krlmlr commented Dec 30, 2018

RSQLite PR now merged (issue in r-dbi/RSQLite#268), release planned end of February.

@hadley hadley added feature func trans 🌍 labels Jan 2, 2019
@hadley hadley closed this as completed Jan 2, 2019
@hadley hadley reopened this Jan 2, 2019
@hadley hadley added this to the v1.4.0 milestone Jan 9, 2019
@hadley hadley closed this as completed in ee8790f Jan 9, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature func trans 🌍
Projects
None yet
Development

No branches or pull requests

4 participants