# ROW\_NUMBER

Published articles for ROW\_NUMBER.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Using Dolt's Versioned SQL Database for Feature-Store Point-in-Time Reads

DevFeed: [Using Dolt's Versioned SQL Database for Feature-Store Point-in-Time Reads](<https://devfeed.tech/articles/what-if-the-feature-store-had-git-built-in-40139.md>)

Original publisher: [Read original article](<https://korbonits.com/blog/2026-05-15-what-if-the-feature-store-had-git-built-in/>)

Published: 2026-05-15T00:00:00Z

Content type: opinion

Language: en

Sources: [Alex Korbonits](<https://devfeed.tech/sources/alex-korbonits.md>)

Topics: [feature-store](<https://devfeed.tech/topics/feature-store.md>), [Git](<https://devfeed.tech/topics/git.md>), [reproducibility](<https://devfeed.tech/topics/reproducibility.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [dedupe](<https://devfeed.tech/tags/dedupe.md>), [feature-store](<https://devfeed.tech/tags/feature-store.md>), [git](<https://devfeed.tech/tags/git.md>), [reproducibility](<https://devfeed.tech/tags/reproducibility.md>), [rfc](<https://devfeed.tech/tags/rfc.md>), [row-number](<https://devfeed.tech/tags/row-number.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-database](<https://devfeed.tech/tags/sql-database.md>)

### AI overview

This article describes a prototype Feast offline-store plugin backed by Dolt, a version-controlled SQL database. It argues that Dolt's revision-based reads can provide point-in-time feature retrieval and reproducible training snapshots without the usual append-only log deduplication CTEs. Tests on toy datasets produced identical results with shorter queries, though the article presents this as an early spike rather than a production benchmark.

### Source excerpt

A weekend spike asked whether Dolt's AS OF reads could replace the ROW_NUMBER dedupe at the heart of every feature store's point-in-time join. Four weeks later, the RFC is quiet and the plugin's get_historical_features works end-to-end against a live Dolt server. Notes on building anyway.

## Emulating Window Functions in MySQL 5.7

DevFeed: [Emulating Window Functions in MySQL 5.7](<https://devfeed.tech/articles/emulating-window-functions-in-mysql-5-7-28938.md>)

Original publisher: [Read original article](<https://blog.jooq.org/emulating-window-functions-in-mysql-5-7/>)

Author: lukaseder

Published: 2023-01-20T11:07:00Z

Content type: tutorial

Language: en

Sources: [jOOQ](<https://devfeed.tech/sources/jooq.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [dense-rank](<https://devfeed.tech/tags/dense-rank.md>), [deprecated](<https://devfeed.tech/tags/deprecated.md>), [emulations](<https://devfeed.tech/tags/emulations.md>), [local-variables](<https://devfeed.tech/tags/local-variables.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-5-7](<https://devfeed.tech/tags/mysql-5-7.md>), [ordering](<https://devfeed.tech/tags/ordering.md>), [rank](<https://devfeed.tech/tags/rank.md>), [row-number](<https://devfeed.tech/tags/row-number.md>), [sql](<https://devfeed.tech/tags/sql.md>), [window-functions](<https://devfeed.tech/tags/window-functions.md>)

### AI overview

This tutorial explains how to emulate window functions in MySQL 5.7 using user variables. It warns that the technique depends on incidental evaluation order, can break when query execution changes, and is deprecated in MySQL 8.x.

### Source excerpt

One of MySQL 8's biggest improvements is the support of window functions. As I always said in conferences, there's SQL before window functions and SQL after window functions. Once you start using them, you'll use them everywhere. Some of you poor souls are unfortunate enough to be stuck on MySQL 5.7, either of your own ... Continue reading Emulating Window Functions in MySQL 5.7 ->