Is there an option for using a relational database as underlying storage (self-hosted)?
I’m afraid not - we’re dependent on it being an object-store suitable for larger files. One could technically adapt it to use ‘blob’ support in SQL databases but it’s not something we’re actively considering supporting, for both performance and TCO reasons.
How does conversion from snake_case / camelCase to kebab-case work? In the demo this seemed to be done implicitly.
This is done as part of the result output - by default, for SQL queries it returns the original snake_case; for XTQL queries (in EDN) it returns kebab-case. If you’d like to override it, it’s the :key-fn option - currently takes either :clojure or a user-supplied Clojure function that takes a key and returns its rendered form (there are a couple of others - :sql and :snake_case, but I can’t guarantee the longevity of their behaviour!).
Is there some sort of console through which to administer XTDB v2?
Not yet - this is the kind of thing we’ll be working on as part of its production readiness over the next year or so. By and large we’ll try to hook into existing monitoring etc tooling, but if there’s anything specific you’d want from such a UI, please do let us know