RecordAndReplayReflector

[staabm]

Use cached recordings, while automatically re-validate db schema using schema-fingerprints.

in contrast to record & replay, this should be a solution with improved DX, as the developer doesn't need to manually re-generate the recording.. it should auto-generate the cached-data when the db schema changes without additional manuall steps

with this new reflector it should also no longer be needed to switch between record and replay mode.

after all it would combine the performance and db-less benefits of the Replay reflector while the developer would not need to fiddle with the possible problems of handling stale-cache issues.

[staabm]

a initial test shows this will work for mysql:

SELECT
    MD5(
        GROUP_CONCAT(
            CONCAT(
                COALESCE(COLUMN_NAME, ""),
                COALESCE(EXTRA, ""),
                COLUMN_TYPE,
                IS_NULLABLE
            )
        )
    ) as dbsingnature,
    1 AS grouper
FROM
    information_schema.columns
WHERE
    table_schema = 'my-database-name'
GROUP BY
    grouper

inspired by https://ckhconsulting.com/row-or-rows-md5-hash-with-mysql/