Hello, again A new doubt Could we sync temporal table with binary log? I’m thinking something about stream, example: A client request, please sendme your table and the position of binarylog, and i will be in sync reading binary log The idea is execute an select with a known fixed position of binary log, and send the result of select as a “snapshot” of initial data and the position of binary log as a point to the client sync “incremental” data Could this be possible? I’m thinking id this could be possible without temporal table too, like an “atomic” (serialized transaction?) select of table and binlog position? Em seg, 8 de jun de 2020 às 19:38, Roberto Spadim <roberto@spadim.com.br> escreveu:
Ops, sorry, this was on my face thanks sergei
Em seg., 8 de jun. de 2020 às 17:29, Sergei Golubchik <serg@mariadb.org> escreveu:
Hi, Roberto!
On Jun 08, Roberto Spadim wrote:
Hi folks
Could be possible query temporal tables but instead of use a timestamp, use a “commit” id?
For example query first commit, second, third, ... and the last commit = current table?
Yes. See https://mariadb.com/kb/en/temporal-data-tables/#transaction-precise-history-...
Regards, Sergei VP of MariaDB Server Engineering and security@mariadb.org
-- Roberto Spadim SPAEmpresarial - Software ERP/Scada Eng. Automação e Controle, Eng. Financeira
-- Roberto Spadim SPAEmpresarial - Software ERP/Scada Eng. Automação e Controle, Eng. Financeira