---
title: "SQLite 3.25 To Support Window Functions"
publication: "DB Weekly"
issue: 217
published_at: "2018-08-17"
canonical_url: "https://dbweekly.com/issues/217"
---

This week's database news       

#217 — August 17, 2018 

[Read on the Web](https://dbweekly.com/issues/217)   

Database Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/u4mzjfgwlnnzch6gyo2d.gif)](https://www.sqlite.org/draft/releaselog/current.html)  

[SQLite 3.25 To Support Window Functions](https://www.sqlite.org/draft/releaselog/current.html) — It’s not released _quite_ yet but this is an interesting step forward for SQLite. [Here’s the full documentation.](https://www.sqlite.org/draft/windowfunctions.html) And if you’re not familiar with SQL’s window functions support, [here’s an interactive quiz-based tutorial.](https://www.windowfunctions.com/) 

SQLite   

[The Cost of a JOIN](https://www.brianlikespostgres.com/) — A ‘join’ is the combination of two sets of data (i.e. columns from two tables) and a _very_ frequently performed operation in SQL queries - but how _expensive_ are they? This post takes a practical look at what affects their performance in PostgreSQL, and triggered quite a bit of [discussion on Hacker News.](https://news.ycombinator.com/item?id=17762067) 

Brian Likes Postgres   [![\](https://copm.s3.amazonaws.com/df057ecb.png)](https://studio3t.com/knowledge-base/articles/create-mongodb-joins-with-sql/?utm_source=studio3t&utm_medium=cooper&utm_campaign=aug2018) 

[Studio 3T Adds SQL Joins Wizardry To Its MongoDB IDE](https://studio3t.com/knowledge-base/articles/create-mongodb-joins-with-sql/?utm_source=studio3t&utm_medium=cooper&utm_campaign=aug2018) — Transfer your SQL skills to the new enterprise database, by reading: “How to Create MongoDB Joins Using SQL.” 

Studio 3T sponsor   

▶[MongoDB World 2018: The Breakout Sessions](https://explore.mongodb.com/mongodb-world-2018) — MongoDB World 2018 drew MongoDB developers from all around the world but you can watch many of the sessions online now. Learn about things like [sharded transactions](https://www.youtube.com/watch?v=dQh03YLkmyg), [change streams](https://www.youtube.com/watch?v=eBGC6z1fPs0), [how ideas become MongoDB features](https://www.youtube.com/watch?v=F-hkHTogRBY), and more. 

MongoDB, Inc.   

[Amazon Elasticsearch Service Now Supports Elasticsearch 5.6 & 6.3](https://aws.amazon.com/about-aws/whats-new/2018/08/amazon_elasticsearch_service_announces_support_for_elasticsearch_versions_5-6_and_6-3/) — You can even use in-place version upgrades to upgrade your existing domains. 

Amazon Web Services, Inc.   

[On The Release of RedisGraph v1.0 Preview](https://redislabs.com/blog/release-redisgraph-v1-0-preview/) — RedisGraph is a graph database architecture implemented as a Redis module, using GraphBLAS sparse matrices for internal data representation and linear algebra for query execution. 

Redis Labs    

[Selecting the Right Database for Your Microservices](https://thenewstack.io/selecting-the-right-database-for-your-microservices/) 

Roshan Kumar   

[A Review of MongoDB Backup Options](https://severalnines.com/blog/review-mongodb-backup-options) — A high-level overview of several available MongoDB backup tools and approaches. 

Akash Kathiriya   

[How Walmart Built a Robust Analytics Platform on Spark, Kafka and Cassandra](https://medium.com/walmartlabs/how-we-build-a-robust-analytics-platform-using-spark-kafka-and-cassandra-lambda-architecture-70c2d1bc8981) 

Rishi Saraf (Walmart Labs)   

[How Microsoft Drives Exabyte Analytics on the World’s Largest YARN Cluster](https://azure.microsoft.com/en-us/blog/how-microsoft-drives-exabyte-analytics-on-the-world-s-largest-yarn-cluster/) 

Raghu Ramakrishnan (Microsoft)   

[Webinar: Building Modern Apps with the MERN Stack and Google Cloud Platform](https://www.mongodb.com/webinar/building-modern-apps-with-the-mern-stack-and-gcp?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship&utm_content=20180817&utm_medium=display&utm_source=dbweekly) — Learn about the two dominant JavaScript stacks: MEAN and MERN and how to implement these web stacks on GCP. 

MongoDB sponsor   

[go-sqlite-lite: A New SQLite Driver for Golang](https://github.com/bvinc/go-sqlite-lite) — It supports SQLite’s [online backup API](https://www.sqlite.org/backup.html) and [BLOB incremental IO](https://www.sqlite.org/c3ref/blob_open.html). 

Brian Vincent   

[QLBridge: A SQL Expression VM for Building Your Own Query Engines in Golang](https://github.com/araddon/qlbridge) — A SQL execution engine for embedded use as a library for SQL or SQL-Like functionality. 

Aaron Raddon         

A **[Cooperpress](https://cooperpress.com/)** publication. 

[Change your email address](https://dbweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://dbweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom