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

Update sqlite version to ≥3.25.x for window functions #828

Closed
jdanbrown opened this issue Oct 22, 2018 · 2 comments
Closed

Update sqlite version to ≥3.25.x for window functions #828

jdanbrown opened this issue Oct 22, 2018 · 2 comments

Comments

@jdanbrown
Copy link

Window functions were added in 3.25.0:

These are very useful, and they're usually difficult to emulate using other constructs (e.g. group by). I'd love to be able to use them in mobile sqlite.

Example: select the top 3 scoring users per region

select *
from (
  select
    *,
    row_number() over (partition by region order by score desc) as i
  from users
)
where i <= 3

(Thanks for all your great work!)

@brodycj
Copy link
Contributor

brodycj commented Nov 8, 2018

May be in a new release ref: #773, #687. This would need to be done in sql.js which will be used for browser platform support as discussed in #576.

@brodycj
Copy link
Contributor

brodycj commented Dec 16, 2018

Closing in favor of SQLite 3.26.0 update to resolve a known vulnerability (#837).

(Thanks for all your great work!)

You are welcome, thanks for the kind word.

@brodycj brodycj closed this as completed Dec 16, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants