1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
1
2
3
4
5
6
7
8
9
10
11
12
13
|
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
|
An informal list of FIXMEs which don't warrant full tickets...
This is not *intended* to be a list of long-lived fixme's, but more of a scratchpad for things which come up spontaneously and shouldn't be forgotten.
In no particular order...
# Global Config DB Handle (2021-11-09)
Currently the global config db handle is managed the same as the repo and checkout handles: they are `ATTACH`ed to an in-memory `main` db.
Experience with `fnc` suggests that we probably want to split it into its own db handle so that it can be opened and closed at will without
locking-related issues. As of this writing, it's not possible to close (detach) the config db while any statement handle is currently being
processed (that is, has been stepped but not yet finalized or reset) because any statement in such a state will lock the `ATTACH`ed dbs.
The internals are set up to handle such a thing but this will require many small changes, some of which will certainly have to be
discovered via trial and error.
There are currently no known use cases which require doing SQL joins on data from the global config db and the repo/checkout dbs,
so no significant SQL needs to be changed for this.
Sidebar: this will have one significant change: the db name for that db will no longer be `cfg`, but `main` for its handle. We'll need to ensure that
the schema does not use the name `cfg` anywhere.
|