Clojurians Log v2

Hi all, I'm looking into Datomic for a new project of mine that might have live-collaborative editing. I noticed that Datomic Cloud doesn't allow use of the tx-report-queue to broadcast updates. Are there any alternative solutions for Datomic Cloud for realtime updates? Thanks!

I think you should be able to use tx-range, but you’ll have to manage the cursor into the transaction log yourself https://docs.datomic.com/cloud/time/log.html

Hey, I'm running into a really strange issue with datomic boot datoms. A member on my team accidentally transacted to an entity with :db/id 3 , but that entity refers to a "boot" datom. I think datomic should have rejected the transaction, but unfortuntely it allowed it:

{:t 1095565,
  :data
  [#datom[13194140628877 50 #inst "2020-12-09T18:09:14.299-00:00" 13194140628877 true]
   #datom[3 95 :order.status/fulfillManual 13194140628877 true]]}

:db.error/datom-cannot-be-altered Boot datoms cannot be altered: ...

Hi @me1260 Is this dev-local, on-prem, cloud db? Also how important is this database?

You can transact your own facts about system entities (emphasis entities, not datoms). You cannot retract such facts. That being said, I need to create a reproduction of this issue and I imagine that a query workaround is to have queries ignore entities in the system partition (partition 0). Are you seeing any errors? The entity that was altered pointed to:

#:db{:id 3,
     :ident :db.part/tx,
     :doc "Partition used to store data about transactions. Transaction data always includes a :db/txInstant which is the transaction's timestamp, and can be extended to store other information at transaction granularity."}

I guess I know you are saying you have queries that depend on that attribute having valid data, but I want to understand if you are seeing errors outside of query data validation.

If you get a chance shoot an email to <mailto:support@cognitect.com|support@cognitect.com> so I can track this issue with a ticket and we can share relevant details.

Hi Jaret. This is with on-prem. It's a mission critical database. Needed to fix this, so what I did is I created a new entity, copied the old entity data to the new entity, then renamed the entity to the old entity name. Of course this will mean historical queries will be weird, but had to be fixed. Will send an email to support with details to create a ticket, thank you!

Hi, I'm trying to select user by name and email, but if email and name are empty return all users This is my query but works only when I have email and username

(->> (d/q '{:find  [[(pull ?user [:user/id
                                    :user/name
                                    :user/email])

                       ...]]
              :in    [$ ?name ?email]
              :where [[?user :user/consumer]
                      [?user :user/email ?email]
                      [?user :user/name ?name]
                      [(util/includes? ?name ?email)]]}
            db (or username "") (or email "")))

I’m not sure I’m understanding what you are saying, but you can generate query maps programatically, its just a map, after all — say if ?name is not provided, not generate the [?user :user/name ?name] clause

If the name and email was not provide return all entity