xtdb 2024-12-11

Hey everyone! I'm Ben, a Software Engineer at JUXT, and I've been creating some videos to try and showcase some simple XTDB concepts, would love to get your thoughts and feedback on them: https://www.youtube.com/watch?v=xaYHUKAzwUo

πŸ’― 2
πŸ‘‹ 6

Is there a mvn release for xtdb-jdbc to go with beta4? Just checking as couldnt find it but can see beta3 releases for core and api

there's supposed to be, yep - thanks for the heads-up

πŸ‘ 1

it's been correctly pushed to Maven Central now - there's a little propagation time but should be available soon πŸ™‚

thanks for letting us know πŸ™

πŸ˜„ 1

All changes to next.jdbc will be automatically tested against the nightly Docker builds of XTDB from now on.

πŸ™Œ 3

I've attempted to document all the recent additions to HoneySQL that relate to XTDB: https://github.com/seancorfield/honeysql/blob/develop/doc/xtdb.md If there are any errors or misunderstandings on my part, I'd like to get them fixed before I cut a new release of HoneySQL. Some of these additions aren't fully documented in the railroad syntax diagrams in the XTDB docs and it's hard to find examples in the wild for some of this syntax(!) so I've sort of had to guess in places. Pointers to examples in the XTDB source or tests welcome!

thanks @seancorfield πŸ™ just a few notes: β€’ exclude/rename also support multiple columns in one clause: EXCLUDE (_id, foo, bar), RENAME (foo AS a, bar AS b). taken from https://docs.snowflake.com/en/sql-reference/sql/select#examples-of-selecting-all-columns-select (amongst others), I'll https://github.com/xtdb/xtdb/issues/3961 to our railroads β€’ object/records - there's a third here which is just the {} syntax, i.e. no need for a SQL keyword: "SELECT {_id: 1, status: 'active'}" β€’ SETTING BASIS became SETTING SNAPSHOT_TIME, have updated our docs but haven't deployed the change yet. aside from those, looking great, thanks! ☺️

β€’ HoneySQL supports multiple columns for EXCLUDE / RENAME so I'll update the examples to make that clear. β€’ Yes, I mention the inline record literal syntax but perhaps that isn't clear enough. Will update that section. β€’ Good to know, I'll update the tests and examples.

πŸ‘Œ 1
πŸ™ 1

heh, looks like we've found the other time that Pacific/UK have in common πŸ˜… quite early here though, and I'm guessing it must be pretty late for you?

It was nearly midnight. Next year, we'll have a lot more overlap -- I'll be on Eastern time, starting in the spring.

πŸ™Œ 1

Docs & tests updated.

πŸ™ 1