Jeremy Taylor
Jeremy Taylor
Proposal A: - [x] SSL - [ ] `xtdb` user, password configured in YAML (possibly via `XTDB_PASSWORD` env var). - If this is specified, then we reject all other connections....
Despite setting OID=16, currently boolean parameters will always be interpreted as `false` - see the test case (and also https://github.com/xtdb/xtdb/issues/3589#issuecomment-2313687107 for prior notes)
Reproduce as follows... ``` python3 -m pip install "psycopg[binary]" ``` script.py: ```python import psycopg as pg conn_str = 'user=admin password=quest host=127.0.0.1 port=5432 dbname=qdb' with pg.connect(conn_str, autocommit=True) as connection: # Open...
Currently (since https://github.com/xtdb/xtdb/pull/3448) you can do e.g. `SETTING DEFAULT SYSTEM_TIME TO AS OF TIMESTAMP '2024-07-15T12:37:00' SELECT * FROM PEOPLE;` but this is insufficient for true repeatability because the query body...
Initial tasks: - [ ] Include connect-api version in the [docs.xtdb.com](http://docs.xtdb.com/) Sink documentation - [ ] Document that we only support JSON for now - [ ] Document earliest version...
```python import psycopg # Define the connection parameters conn_params = { "host": "localhost", "port": "5432" } # Example data to insert data_to_insert = [ (1, 'Alice'), (2, 'Bob'), (3, 'Charlie')...
``` docker run -it --pull=always -p 6548:3000 -p 5432:5432 ghcr.io/xtdb/xtdb-standalone-ea:latest latest: Pulling from xtdb/xtdb-standalone-ea Digest: sha256:24000ac281d9b0d0059822e08d640ba7563ac383af7cade762d65a4820429a48 Status: Image is up to date for ghcr.io/xtdb/xtdb-standalone-ea:latest Starting XTDB 2.x (pre-alpha) @ "dev-SNAPSHOT"...
Per the [Jepsen report](https://jepsen.io/analyses/datomic-pro-1.0.7075) on Datomic: > While transaction functions can make decisions based on the results of reads they perform internally, there is no channel to return those reads...
``` ➜ ~ psql -h localhost -p 5432 psql (16.3, server 16) Type "help" for help. jdt=> INSERT into foo (_id, val) VALUES (1, 1); INSERT 0 0 jdt=> UPDATE...