Fork me on GitHub
#xtdb
<
2020-04-03
>
refset11:04:41

Hello #crux - I hope you're all keeping well 🙂 We're running another Crux Showcase this afternoon at 1500 UTC (4pm UK time) to discuss and demo some of the work on Crux that's been happening recently. We will be covering: • SQL / Calcite / TPC-H • metrics on the bench environment • changes to the indexes • lazy queries, snapshots, resource management and open-q • our new soak environment • Q&A We'll be meeting here: https://meet.google.com/ego-gwky-uae - I will publish the recording to YouTube afterwards for those who can't make it. See you there!

👌 8
dotemacs14:04:26

Is the showcase running a bit late?

refset14:04:48

it's in 55 minutes from now - did I mess up my calculations? :thinking_face:

dotemacs14:04:02

I was just typing: Ah, I’m early, like a whole hour early 🙂

👌 4
dotemacs14:04:24

No, you’re good, it’s me who’s juggling timezones and dropping them to the floor

dotemacs09:04:28

I’m going to include the video from the Crux Showcase 11 in the next Clojure Weekly newsletter. I’ll link the individual topics covered with the approprate timestamps in the video, so that people can quickly jump to the different topics covered. In preparing the above, I had to search around in the video, and the code shown in Emacs looked fine in the hangout session, when shown live. But looking at it now on YouTube, it is a bit small/blurry. So maybe C-x C-+ to increase the font size in Emacs buffers, for those viewing later.

🙂 4
dotemacs09:04:35

Also, thanks for doing the showcase, I think that they are really informative as they shed more light on what’s going behind the PRs, for those who are following Crux development.

👍 4
refset09:04:45

That's awesome, thanks @U3SG7RX7A! Please go ahead. I will try to annotate the whole series to date separately

👍 4
Jorin18:04:31

Exciting things happening! 🎉 Regarding SQL from something like Metabase, guess there is still the challenge that you need support for the Calcite JDBC driver, right? Found this open issue https://github.com/metabase/metabase/issues/6230 But that would probably be not too hard to solve 🙂

🙂 4
refset18:04:25

Yeah we've been following that! Hopefully we/they/someone will get to it soon 😄

❤️ 4
Jorin15:04:28

Nice 🙂

adamfeldman14:04:36

As another approach, perhaps this could be adapted for Crux? https://github.com/lambdaisland/metabase-datomic

refset14:04:17

@UCHV4JZ7A How did you know I was looking at this page right now?! 👻

refset14:04:11

I was just looking through the "Architecture Decision Log" to see if as-of was thought about at all

adamfeldman15:04:48

Sidenote: that reminded me of https://www.metabase.com/blog/Time-Series-Comparisons/index.html (the latest Metabase release has some nice new features in the visual query editor that add more flexibility, without dropping into SQL https://www.metabase.com/blog/0.35/index.html)

👍 4
refset16:04:40

This is how bitemporal queries often look in SQL databases that support them: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/t0058946.html - seems like it would be useful for Metabase to support this syntax eventually (I can't see it mentioned anywhere in the repo)