db
db copied to clipboard
This adds support for canceling Postgres queries according to [53.2.8. Canceling Requests in Progress](https://www.postgresql.org/docs/current/protocol-flow.html#id-1.10.5.7.10). I don't love the `connect&attach` stuff, but I wanted to minimize the number of changes, and...
Hi all. I am using Racket 8.7 on debian bookworm, and trying to connect to postgresql 15(from docker image postgresql:15). the database is deployed well, and I can connect it...
The `query-exec` function will execute only a single SQL statement. There seems no way that I can see of adding multiple statements at once. Specifically, I would hope that something...
Hi Ryan, > version 3.37, SQLite allows [multiple connections to a shared in-memory database](https://sqlite.org/inmemorydb.html). I'd like to implement that. currently, `(sqlite3-connect #:database "file::memory:?cache=shared")` fails with: > file-or-directory-permissions: access failed >...
Logging?
Inspired by [this racket-users thread](https://groups.google.com/forum/#!topic/racket-users/AlhEFpUajvw). It would be useful to have some loggers for various database connection events to debug database connection issues. For example, logging all queries at the...
I set up a notification handler on a pg connection, then made that connection `LISTEN` on a channel and I expected the handler to get called whenever something got published...
This program: ```racket #lang racket/base (require db) (define pool (connection-pool #:max-connections 64 (lambda () (postgresql-connect #:database "congame" #:user "congame" #:password "congame")))) (define N 1000) (define sema (make-semaphore 64)) (define (test...