feviskus

feviskus

From here: Work with pipe query syntax  |  BigQuery  |  Google Cloud Documentation
HN: SQL pipe syntax available in public preview in BigQuery | Hacker News

Example usage:

-- Filter items with no sales.
FROM Produce
|> WHERE sales > 0;

-- Compute total sales by item.
FROM Produce
|> WHERE sales > 0
|> AGGREGATE SUM(sales) AS total_sales, COUNT(*) AS num_sales
   GROUP BY item;

Thought it could be worth mentioning, as it shows how Elixir proceeds to influence other languages.

Showing Posts 1 to 7

cmo

cmo

Brings to mind PRQL, which is a much larger change to query authoring.

sodapopcan

sodapopcan

To be “that guy,” Elixir took from |> from F#. Though perhaps someone will come along and tell me where F# took it from :upside_down_face:

acrolink

acrolink

For me, |> belongs only to Elixir. I will not consider working with any wannabes :slightly_smiling_face:

sodapopcan

sodapopcan

Haha, I agree. JavaScript might be getting it and I was watching a video on it. The guy kept calling it “the F# operator” and it was annoying me :sweat_smile: I didn’t lose any sleep over it, though :upside_down_face:

sodapopcan

sodapopcan

And the prophecy is fulfilled!

codeanpeace

codeanpeace

Really enjoyed that article on archeological semiotics and how it dropped a bunch of lore i.e. the original email thread. Well worth the read and really humanizes how the pipeline symbol came to be!

To summarize, |> was carried over from Isabelle/ML…

Now if we continue digging, The Early History of F#, also written by Don Syme aka the creator of F# unsurprisingly mentions the “obvious semiotic inspiration from UNIX pipes.” So this naturally begs the question of how the UNIX pipe operator came to be? Well here’s another fun tidbit of archeological semiotics …

Though Mahoney’s interview suggests that the original symbol for pipes was “> ,” in the 1994 book, “A Quarter Century of Unix,” McIlroy remembers when Thompson decided the symbol for pipes should instead be “|.” Thompson made the change “for a talk in London, because he couldn’t bear to reveal my ugly syntax.”
source: Pipe: How the System Call That Ties Unix Together Came About

So perhaps it went from > :icon_arrow: | :icon_arrow: |> :exploding_head:

— All posts loaded —

Where Next? Top

Trending in Discussions Top

AstonJ
The obligatory hello world thread! Who are you and where are you from? :stuck_out_tongue:
4663 61202 595
New
cblavier
Hey there, It’s been more than a year since we started using LiveView as our main UI library and building a whole library of UI componen...
515 12931 101
New
wmnnd
Hey folks, I wanted to share with you a project I’ve been working on for a while: It’s an Open Source (AGPLv3) newsletter tool. Think Ma...
New
raa-ziq
Hi everyone :waving_hand: I wanted to share something I’ve been building — NowBlind, a random chat app designed to help people discover ...
New
sntran
In my third year of college, around 2010, I found Erlang. A few years later, I found Elixir. I liked the ideas at once: many small proces...
New
Ganna
Hi everyone, I have 8 years of production experience with Erlang/OTP and I’m just starting to get to know Elixir. What would you learn f...
New
gtcode
I’ve been tinkering with Lynx (by José) via hold_ledger. I used AI to write the code, a separate specification, the tests, and the Lean p...
New

Other Trending Topics Top

dominicletz
Hey there, I haven’t seen a list of useful Elixir specific skills for the popular AI tools yet so I’m starting one here with my first. ...
New
mudasobwa
I fully migrated to my own harness from Anthropic/Gemini and I think it’s time to share it. Welcome DSH, the DeepSeek Harness, fully writ...
New
KristerV
Hey. Is there anyone here who creates agents in their apps? Not talking about using agents, but creating them. I’m finding it pretty diff...
New
OndrejValenta
(I just needed to vent somewhere and LinkedIn is full of hope, or hype, I’m not sure which exactly) AI dream has many faces, but general...
New
kip
Localize is the next generation localisation library for Elixir. Think of it as ex_cldr version 3.0. The first version will be released ...
New
webofbits
With AI doing more of the implementation work, I’ve been wondering how much coding I should deliberately keep doing myself. My main conc...
#ai
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews