Page cover image

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.

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.

“Something is wrong with GrandMaster. He was the reason why we got ambushed by Lilith. As if he wanted to be found by the spawns of Lilith.” said Ray. “Are you okay, where are you? replied Red but Ray’s voice stopped suddenly as the other dark energy fields started to break inside their white bright energy field. They surrounded Red as a dark cloud and just as the thunderous voices overwhelmed Master Talia closed the amplifier. Red felt a sudden pain in her head after disconnecting from the amplifier, she went into a shock and lost consciousness. - Journals of Order of Epoch, 2341 Anno Domini

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.

SELECT * 
FROM call
ORDER BY
    call.user_id ASC,
    call.register_time ASC;

Last updated

Was this helpful?