Page 1 of 1

Markers in DB?

PostPosted: Fri Jan 10, 2020 11:11 pm
by MarcusWolschon
I'm trying to figure out where in the PostgreSQL database
Markers (on timelines) are stored.
I can't find them in any of the tables.

Re: Markers in DB?

PostPosted: Sun Jan 19, 2020 10:21 am
by MarcusWolschon
By dumping the database into a file and using greb on that file, I now know that the text of markers is not stored as some varchar column in some table.
But why whould anyone store markers in some kind of binary blob?

Re: Markers in DB?

PostPosted: Sun Jan 19, 2020 10:26 am
by MarcusWolschon
Okay, the table public."BtLockableBlob" has a binary LOB field "FieldsBlob".
Somewhere in that BLOB the text of my test-markers is contained in UTF8 or ASCII encoding.
(I only used ASCII characters, so it would have the same binary representation.)