Databases
Databases are made up of relational and non-relational structures that allow you to store and query all your real-time and historical data.
Last updated
Databases are made up of relational and non-relational structures that allow you to store and query all your real-time and historical data.
Last updated
Databases are made up of relational and non-relational structures that allow you to store and query all your real-time and historical data.
Its important to remember that the type of hosting we choose such as on-premise or managed will trigger different compliance requirements.
We can assume that we maintain our databases as PostgreSQL on Amazon Web Services so that our website can scale easily. Here, we can choose Frankfurt in terms of GDPR compliance from the geography options of the server offered to us by AWS.
At this point, we should not forget that there are risks of transferring personal data abroad due to the fact that the servers are located abroad within the scope of different data protection legislation, even if they are located in the EU.
We may want to receive reports on our number of users on a weekly basis.
For this, we can make certain queries in our user tables in our PostgreSQL database. Limiting who can make such queries is very important for data management and control of access rights. For example, we can query our database to find out how many new users registered for our product last week. With the following sample SQL query, we can generate reports about the users in our database.