SQLjs
SQL-like interface for JavaScript
Usage
Trivial
; const characters = name: 'Han' profession: 'Smuggler' age: 30 name: 'Luke' profession: 'Hero' age: 32 name: 'Leia' profession: 'Princess' age: 32 name: 'Anakin' profession: 'Jedi' age: 50 name: 'Obi' profession: 'Jedi' age: 65 name: 'Chewie' profession: 'Smuggler' age: 30 name: 'Lando' profession: 'Smuggler' age: 50 ; let resultSet = ;
The easy way
; const characters = name: 'Han' profession: 'Smuggler' age: 30 name: 'Luke' profession: 'Hero' age: 32 name: 'Leia' profession: 'Princess' age: 32 name: 'Anakin' profession: 'Jedi' age: 50 name: 'Obi' profession: 'Jedi' age: 65 name: 'Chewie' profession: 'Smuggler' age: 30 name: 'Lando' profession: 'Smuggler' age: 50 ; const isJedi = personprofession === 'Jedi';const age = characterage; let resultSet = ;
Level Up
; const rebels = name: 'Han' profession: 'Smuggler' age: 30 name: 'Luke' profession: 'Jedi' age: 32 father: 'Darth Vader' name: 'Leia' profession: 'Princess' age: 32 name: 'Obi' profession: 'Jedi' age: 65 name: 'Chewie' profession: 'Smuggler' age: 30 ;const empire = name: 'Anakin' profession: 'Jedi' age: 50 name: 'Darth Vader' profession: 'Lord Sith' age: 65 name: 'Lando' profession: 'Smuggler' age: 50 ; const fatherJoin = join0father === join1name;const isJedi = join0profession === 'Jedi';const age = join0age;const older20 = group0 > 20; let resultSet = ;