Want to lock your table but only on DDL operations? Use the below code to ensure no one is altering your tables. To achieve this we will create a trigger on all alter table commands, then filter it down by table name and finally throw an exception telling the user that they cannot alter the table. …
Author: ashish
One of the tasks I recently came accross my job was ingest large files but with the following Do some processing ( like generate hash for each row ) Insert it into S3 for audit purposes Insert into postgres …
If your application allows your users to download files directly from s3, you are bound to get this error sometime in the future whenever you scale to other regions – The authorization mechanism you have provided is not supported. Please use AWS4-HMAC-SHA256. …
Do you want need a quick solution without going into the hassle of setting up a Database? If your answer to any of those questions was a yes, then you’ve come to the right place. This post will show you how you can use Google sheets as your database. For the purposes of this blogpost I will be usiing this Google sheet. As you can see, we will be collecting the following data from the user – Name, Email …
Today I came accross codesandbox which is an online editor catered for web applications. It is an opensource effort with all bugs being tracked and handled by the community. The feature I liked the most about codesandbox was its embed feature, that lets you embed code alongside it's rendered version. …
Social Profiles