Eric Soroos

This can probably be closed based on #7886

I've made a quick hack of the pyutilib library, essentially patching out all of the other portions of components in `components.__init__.py` ```diff --git a/pyutilib/component/__init__.py b/pyutilib/component/__init__.py index ccebeec..64a70a3 100644 --- a/pyutilib/component/__init__.py...

The sanitize_url test failure is a change in behavior in python 3.12: ``` Python 3.10.13 (main, Aug 24 2023, 22:36:46) [Clang 14.0.3 (clang-1403.0.22.14.1)] on darwin Type "help", "copyright", "credits" or...

From another site: ``` ckan=> select * from pg_stat_user_indexes where relname='package'; relid | indexrelid | schemaname | relname | indexrelname | idx_scan | idx_tup_read | idx_tup_fetch -------+------------+------------+---------+-----------------------------+----------+--------------+--------------- 21204 | 23062...

This has been superseded by #7105

Per-user databases would require per-user solr as well, which is a headache. I wonder if there would be a way to do it where: 1) User list is private 2)...

@smotornyuk -- This is passing except for the types, which seem to be a bunch of failures of the type system to understand how sqlalchemy works. Do you have any...

Thanks. Hopefully that does it.

Note, there's a new commit here with an additional optimization: Change the join to a subselect. This prevents a non-indexable seq scan on the activities table, and reduces it to...

Not sure if we can add the index in a point release, because we'd wind up forking the alembic history when upgrading to the next major?