Fork me on GitHub
#xtdb
<
2022-03-28
>
tatut05:03:21

I was curious about the HTTP API formats (edn or transit) do they support all the types (like LocalDate/Time/DateTime) and noticed that the OpenAPI doc link at https://docs.xtdb.com/clients/http/#rest-api is broken (leads to NoSuchBucket error pagE)

tatut05:03:30

normally edn doesn't support all the types XTDB can have

> (pr-str (java.time.LocalDate/now))
"#object[java.time.LocalDate 0x60567b9 \"2022-03-28\"]"
so does it have write support and data readers for those?

refset07:03:22

Ah, thanks for reporting the broken link! XT doesn't natively support any extended edn types over http, though I suspect it's possible to make work if really needed

tatut07:03:44

I'm not currently using the HTTP API, just curious... it would be nice if it supported all the types

tatut07:03:07

because the HTTP API is the easiest way to use XTDB from non-JVM languages

refset07:03:55

Makes sense, I definitely don't disagree that it could be useful 🙂

tatut07:03:40

been dabbling in smalltalk and the kotlin dsl gave me ideas for some sort of ODM (object document mapping) library for persistence... would be an interesting side project in my copious free time

😄 1
tatut07:03:54

but that needs the HTTP API

refset08:03:34

That sounds rather interesting 🙂 a bit like duratom?

refset08:03:47

I just opened https://github.com/xtdb/xtdb/issues/1725 if you wanted to chime in

👍 1
neural15:03:27

I am using xtdb with postgresql. Is it possible to query my data direct via psql??

refset16:03:34

Hi - that's not a supported use-case, but it is technically possible to access the data. Pretty much all the data is encoded with https://github.com/ptaoussanis/nippy though so may be tricky to access within SQL meaningfully 🙂 what's the requirement?

neural17:03:27

I am using xtdb with a heroku postgresql database. In heroku dataclip you can inspect the data of your database directly.

refset17:03:13

ah interesting, I hadn't seen dataclips before. Sadly though I don't think you'll have much joy trying to use it to interpret XT's storage format though 😕 (though don't let me discourage you from trying!)

tatut08:03:09

that is an interesting feature, XTDB inspector has the possibility to save a query... though that isn't really meant for public consumption

tatut08:03:04

but perhaps I could make a separate endpoint that allows you to publish a query...

tatut08:03:36

not saying that that would be as good as the dataclips functionality, but in the same vein at least

🙂 1
neural16:03:11

Nice to know XTDB inspector! I was just planning to build an endpoint like a dashboard to query my db. Though losing the fun to build it myself 😆 but XTDB inspector could same me time! Thanks!

tatut14:03:42

if you have any feature requests about it , feel free to raise them in the github project

🌞 1