Database is not encrypted but it’s not normalized. Data is serialized using Google’s protocol buffers format and that’s not supported by Microsoft PowerBI.
Once Manager is “feature-complete”, data could be stored in normalized database but for now, for performance reasons and also to make it easier to evolve the program rapidly, it is the way it is - it’s a trade-off.
Hi Lubos,
I am checking out Manager,and kicking the tires. Regarding the current state of the database: Is the data normalized as of yet, or is API currently still the current way as stated above? If it is not normalized yet, is that project on your short-term roadmap yet?
Thanks
Jason M.
What do you mean by normalized? If it’s the relational database normalization then no, the main transactions table is mostly flat and also, the transactions table or queries thereof aren’t exposed to the API yet.
The rest of the database follows Object/Document design and they’re as normalized just as much as needed. The Objects/Documents are fully exposed to the API.
What do you mean by normalized? If it’s the relational database normalization then no, the main transactions table is mostly flat and also, the transactions table or queries thereof aren’t exposed to the API yet
Thank you for the reply Ealfardan. That answers my question.