Markers in DB?

Ask software engineering and SDK questions for developers working on Mac OS X, Windows or Linux.
  • Author
  • Message
Offline

MarcusWolschon

  • Posts: 801
  • Joined: Sun Apr 14, 2013 6:59 pm

Markers in DB?

PostFri Jan 10, 2020 11:11 pm

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.
Offline

MarcusWolschon

  • Posts: 801
  • Joined: Sun Apr 14, 2013 6:59 pm

Re: Markers in DB?

PostSun Jan 19, 2020 10:21 am

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?
Offline

MarcusWolschon

  • Posts: 801
  • Joined: Sun Apr 14, 2013 6:59 pm

Re: Markers in DB?

PostSun Jan 19, 2020 10:26 am

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.)

Return to Software Developers

Who is online

Users browsing this forum: No registered users and 20 guests