Learn SQL Once, Use It for 30 Years

(fagnerbrack.com)

23 points | by karakoram a day ago ago

2 comments

  • teleforce 12 hours ago ago

    >The Only Programming Language Built on Mathematics, Not Fashion

    As a modern array language D4M is the natural successor for SQL [1].

    D4M is based on mathematics like SQL, specifically associative array algebra but not relational unlike SQL. It's more generic since can it caters to most modern data abstractions including spreadsheets, database tables, matrices, and graphs [2].

    You can achieve 100M database inserts per second with D4M and Accumulo more than a decade ago back in 2014 [3].

    [1] D4M: Dynamic Distributed Dimensional Data Model:

    https://d4m.mit.edu/

    [2] Mathematics of Big Data: Spreadsheets, Databases, Matrices, and Graphs:

    https://direct.mit.edu/books/monograph/5691/Mathematics-of-B...

    [3] Achieving 100M database inserts per second using Apache Accumulo and D4M (2017 - 46 comments):

    https://news.ycombinator.com/item?id=13465141

  • lanycrost 7 hours ago ago

    I've played once with codesignal to pass SQL chapters and it really helped to advance querying skills.