Relative Content

Tag Archive for database

to obtain the data dictionary and ERD for D365 tables

I have created a data lake with data ingested directly from D365. We have about 250 tables but we do have data dictionary or ERD for these tables. As such, I do not how to link the tables to form reports and dashboards.

How to update data on daily basis for my app?

I have a app, and the app data is coming from a excel sheet and for now i pass this sheet file path in the code manully. But this sheet’s data change daily, so how can i update/refresh/delete any data on the daily basis in my app?

How to handle data when source of truth is through API

I am making a webapp that deals with money movement. All the financial actions are done through an API. For example, right now I can create an account for a user, add funds to their account, transfer funds to another account, etc. Currently I grab all the information on a user, their account balance, transactions etc. and store it on my local db.

Text files vs. MySQL Performance for Large Dataset

I am currently making a system for users to generate flashcards for Languages.
This involves adding information such as the definition, pronunciation, and example sentences for a word.
So far, I have had success by loading all of the information into a Python Dictionary, however as I add more features/words, I will run out of memory.