Product: PowerShell Universal
Version: 5.0.9
This may be me biting off more than I can chew, but I figure I’d ask around to see if anyone has any similar setups.
Currently we are using one of our PowerShell universal apps to aggregate and display large datasets with multiple sources. Currently the aggregation takes place via an API handler that those datasets are sent to, which then converts that data into a JSON structure and stores it into local JSON files (outside the repository). However, we have run into a pretty large efficiency problem in terms of requesting the data that we need.
To solve this, we are looking into implementing a relational database structure. What are some pointers, recommendations, or otherwise helpful pieces of information for implementing this and utilizing it within PowerShell Universal? I have yet to settle on a particular database, though MariaDB is my preferred choice.
Any thoughts? Opening the room to discussion. I haven’t seen anything in the documentation I’ve poked through that specifically references this, but please let me know if there’s a source I’m missing. I’d also like your opinion on the feasibility of this, @adam .
Thanks all!
ZG