Fork me on GitHub
#xtdb
<
2023-03-02
>
ag06:03:41

I don't know what took me so long, but I just played a bit with xtdb and holy frijole, that shit is so awesome. I just can't stop loving it. Hey folks, since I'm a super-fresh nub, can I ask like a totally stupid question? So, I was digging through basic tutorial projects and they use rocks or lmbd, or whatever the default node uses, basically it creates a bunch of files on disk that I can't inspect. So of course, the first thing I attempted to do is that I figured out jdbc and hook it up to sqlite. Submitted a few transactions, looked into the db file. And guess what? It wrote in a bunch of blobs. So my question is, is there a way to make it write a human-readable format? I just want to be able to inspect the data.

tatut06:03:29

the output of q and pull is human readable, not the storage format

tatut06:03:50

likewise you wouldn’t be reading postgresql wal files

ag06:03:22

> the output of q and pull Yah, I know that. The point is, I want to visually explore the data without querying it. But, I guess, as I said "super stupid question".. lol

refset17:03:36

hey @U0G75ARHC if you are really curious about what's in the blobs, we're using https://github.com/ptaoussanis/nippy extensively so decoding should be straightforward

ag18:03:21

Oh, nice. Thank you Jeremy.

blob_thumbs_up 2
ag06:03:47

at least for the time while I'm still learning this stuff

ag06:03:54

there's no "db browser" or inspector app for XT, is there?

tatut06:03:20

you might be interested in https://github.com/tatut/xtdb-inspector

❤️ 4
ag06:03:11

yeah, I found that. looks a bit... too basic, no? well, I guess I'm gonna have to try

tatut06:03:46

well I made it for my needs, but what exactly would you need? you can open tickets for any ideas on new functionality

tatut06:03:55

the screenshot videos are somewhat old

ag06:03:24

ah, okay. sorry for judging the book without even opening it. I'll try it out.

tatut06:03:21

no worries

ag06:03:30

Yeah, I'm super excited about XT, definitely start using it in my next project. And the inspector most likely would be really helpful

tatut07:03:40

you could get pretty far with REBL, Portal or any tap> based tools

2