Windows 10 Pro
I created a new connection to an existing active PostgreSQL 10 database, and I noticed that Base created a separate, but somehow linked, ODB database (in a folder of my choice). All PostgreSQL tables were migrated to this new ODB database (that I dumbly named “New Database” because I didn’t know what I was doing). I created a form front-end to some tables, and I’m able to add/change/delete rows. Referential Integrity works as defined, server-side triggers and sequences work fine. Any changes in this ODB New Database are reflected in my PostgreSQL database (when looking at it with pgAdmin4).
My best guess is that the ODB database stores all “LO Base”-related objects, like forms, reports, stored queries, etc., that are important to Base but that PostgreSQL doesn’t know about. But why duplicate the data? Also, can this ODB database be considered stand-alone? Say for example, I dropped the whole PostgreSQL database, would the ODB database still work?