Functional SQL: https://www.codewars.com/kata/545434090294935e7d0010ab

100%

Functional SQL: https://www.codewars.com/kata/545434090294935e7d0010ab

✓ Published0🌍 Public

Last edited Aug 25, 2016

Created on Aug 5, 2019

This example recreates a functional SQL query engine in JavaScript, translating a Codewars kata into a working API. The code defines a `query` object with chainable methods like `select`, `from`, `where`, `groupBy`, `having`, and `orderBy`, mirroring SQL clause semantics. It performs cross joins across multiple arrays, applies filtering via nested callback arrays, and builds nested group structures using plain objects and recursive traversal. The final `execute` method returns mapped rows, demonstrating how relational query concepts can be implemented without external libraries, relying solely on native array methods and object literals.

AI-generated description

Similar vizzes

Loading thumbnail…

SQL builder sketches for node.js and node-postgres

Three variations of a JavaScript SQL query builder sketch generate `UPDATE` statements with parameterized placeholders for the node-postgres driver. The code demonstrates both a single-call function with positional arguments and a fluent, chainable interface named `UPDATE` that supports `.SET()`, `.WHERE()`, and `.RETURNING()` methods. Common utilities like `Object.keys`, `Array.map`, and `assert` manage column-value pairs, while the chained version tracks placeholder numbering against accumulated `values`. A third, prototype-free variant shows an alternative closure-based approach. The examples illustrate different API design patterns for safely composing dynamic SQL.

RRandomEtc

64% match

Loading thumbnail…

A set of pure and immutable ES2015 functions aimed to make functional JavaScript more idiomatic.

This example presents a collection of pure, immutable ES2015 utility functions for idiomatic functional JavaScript. It includes array operations such as `combine`, `compact`, `difference`, and `intersection`, object helpers like `merge` and `toMap`, math functions (`min`, `max`, `sum`, `product`), and function decorators including `curry`, `once`, `maybe`, and `pipeline`. The code relies on native JavaScript features like `Array.prototype.includes`, `Set`, `Map`, `Object.assign`, and spread syntax. No external libraries or data sources are used; the gist demonstrates standalone, reusable functional patterns.

JJaxonDvl

63% match

Loading thumbnail…

Gist 7d6a7404e99051bb7d2f36c61f0113ae

This example demonstrates functional programming techniques in JavaScript, including currying, composition, and generator functions. It shows how currying enables partial application, as seen with the `sum` function and reusable helpers like `getName` and `mapUserNames`. The code uses `compose` with `reduceRight` to chain array transformations, filtering user names by length. It also illustrates generator behavior with `next(true)` to control iteration completion. The data is a hardcoded array of user objects, and output is logged to the console via `console.log`.

IIliaIdakiev

61% match

Loading thumbnail…

A brief introduction to JSONiq for NashFP

This example demonstrates the JSONiq query language by showing code snippets for tasks like object navigation, FLWOR expressions, JSON-to-XML conversion, and the Luhn algorithm. The sample queries use JSONiq’s map operator, function libraries like `fn:upper-case` and `fn:fold-left`, and the `keys()` and `members()` functions. Each snippet includes a link to run it in the Zorba engine’s online sandbox, referencing the NashFP presentation context.

CCliffordAnderson

58% match

Loading thumbnail…

Useful functions

This example demonstrates a reusable JavaScript function for joining two datasets, enabling efficient data combination in visualization workflows. It builds an index from a lookup table and then maps rows from a main table through that index, selecting only the desired columns. The code shows a raw implementation of a lookup-table join, similar to SQL-style joins, with a commented usage example that merges brand and article data. The example relies on plain JavaScript arrays and objects, with no external libraries, making it a lightweight utility for preprocessing data before visualization.

RRodolfo Viana

57% match

Loading thumbnail…

Fork of Fork of Javascript-ArrayOfOjects-2

This example demonstrates functional JavaScript programming concepts through a simple HTML page. It shows how standard functions and arrow functions can compute mathematical operations, logging results to the browser console. The page uses vanilla JavaScript with basic CSS styling, featuring a `double()` function that multiplies inputs by 10 and a `tripple()` arrow function that calculates cubes. The code highlights syntax differences between traditional function declarations and modern arrow function expressions, with console output demonstrating their execution. No external libraries are used; it relies on native browser APIs for logging and DOM manipulation.

NNita

57% match

Loading thumbnail…

Eloquent JS: Chapter 4 (take 3)

This example demonstrates solutions to the Chapter 4 exercises from *Eloquent JavaScript*, covering range, sum, array reversal, list conversion, and deep comparison. It shows the implementation of functions like `range`, `sum`, `reverseArray`, `arrayToList`, and `deepEqual`, with expected outputs logged via `console.log`. The page uses plain HTML, CSS, and JavaScript without external libraries, rendering results in the browser console rather than as visual graphics. The code highlights recursive approaches, step handling, and in-place array mutation, with a note that the deep comparison exercise was not fully solved.

Eemberix@gmail.com

57% match

Loading thumbnail…

Eloquent JS: Chapter 4 (take 2)

This example shows the console output from solving several exercises from Chapter 4 of Eloquent JavaScript, focusing on array manipulation functions. The code defines and tests a `range` function that generates numeric arrays, a `sum` function that totals array values, and two reversal functions: `reverseArray` which creates a new reversed array using `unshift`, and `reverseArrayInPlace` which mutates the original array by repeatedly unshifting elements. Written in vanilla JavaScript with no external libraries, the page uses `console.log` to print intermediate results and styled text via CSS.

Eemberix@gmail.com

55% match