Clojurians Log v2
xtdb
I'm trying to do some graph modeling in XTDBv2. I found this relevant discussion:
https://discuss.xtdb.com/t/xtdbs-sweet-spot/52/9
I am trying to figure out how to use XTQL to pull the full document of the related node across potentially disparate tables. It doesn't look like the table is available to the binding specifications, and I can't seem to find an example of using pull with just an entity ID without also specifying the table.
I suppose I can put all the entities I intend to model this graph relationship with (`nodes`) and include some :kind key in there to distinguish them, but it seems like that might not be the XTDBv2 way.
Hey @ander I think my advice here would vary quite a lot based on the use case. For instance if you have existing data you're trying to make sense of, then one-big-table may be a good idea. But if you have complete control over the data model then I would instead recommend sticking to 3NF, or even 6NF (one ''attribute' per table, per Datomic). That said, I can think of exceptions for both of those statements. > it doesn't look like the table is available to the binding specifications This is correct, in v2 all tables and columns must be known and enumerated prior to the query being compiled. The workaround is to compile many queries and stitch together the results outside
I appreciate the response! In this case it's for a new application, I have complete control over the data model. Are there any examples of implementing 6NF in XTDB?
I don't have a completely realistic example offer, but ChatGPT just generated this example for Postgres: https://dbfiddle.uk/XlD5e-PX Which can be adapted to XT https://play.xtdb.com/?version=2.0.0-beta6&type=sql-v2&enc=2&txs=NobwRAzgnhAuCmBbAtLAlo%2BYBcA7ArgDaEA0YsAHhDmAJIByAygKIBKAKgAQPsDynSAA4B9XAENMETgAphaACYlO4zAEpOANQCCAGQCqzRgB1cnMzIDkARhu2byOw9tP7dt7YtKLWwmgDG8BaqJCbmlgBMkVGRyNGxUfEx0clRnpwWAEIA9gBGQQDcJibIyJwAUrmcABZocFkATlCcWQBmnD7%2B8CYMLBzc9HwCiCIAVrnCYhAQaADmuJi4sFKyCkpjOcLosITwSsIAbmK%2B8sIt9VmIe4fHm1nq2vqGoebS1u5WLh%2BO3%2B92aRaMVqwADuYnq8E4zFwMzQuHg8HqaQAIlp2Mx0uEAAxY5CYj545Go9EWLHhfEANmQAGZMUEQqYXm93J8WT9fjZ-ox4Lg0A1IdDYfDEUoUWiMdj8QB2XFWQliknYqkOcLU2WqQq4YqlRhHMFNGp1RrNNodALdJhsLg8fhCYQQXX1NDwZZyRSce2EPVXI4KU7nS6cA4%2Bk6wO6aXQGYwMsyvX6s5xs9lpSWY1OYkVE8U4vEyuXE0kU6m04LPGNMtzx1wJ9kcpQADgArGmM-KC7jpQSW-nFcrVQUirgSuVKgbQ0bWpxsjlzb0rQMbcNhOsJlNZvNuUsZK61uMtjtvTczhcD77Q-cI09oxEUiq4neEjfkv8kWJYGJ2uJCDBYHnxVYAJy4kqnacKK3YxJidZ9uqA5DjqnpGqODRNBOU4zpa-SDLaHpgk6LqrO6DpQCeJxHgGQY3Ge4aPFGYSvI%2BiS3g%2BzGPpEaTkmm6agZmCoAUBuZdlmKqQdB%2BRgAAviQ4AAI74AiUA0LA9RyWAZCUNQ2BgEOACKclGqGnDgn4WS4HAyl%2BLAnAtEQhDVLUY5QCYLDsOwDAAOKgcwABiWh6DoXAPLQSLCK5ACy6KDLoOhOcwOjMAAwlw8AAHQqLsnAjMly57ulmUUb6ZFrMl%2BUhlkSgQMlOGNCYXmsLwoVDCIaVSF0uBlLwDCNUu4yTNMcwLJuIycLw9ACMVCicAAvBl43yCY7WddhDp4e6w2jSlrpTe6s3tPQSLbSVmwYBCvAaGwOhaAACowM2HegmAmLwrBImwk4AJpjWlRVwGCsDCPIr7wGJ4kALpAA
Out of curiosity, how come you prefer to chat here instead of continuing the thread on Discuss? 🙂