In order to secure assets such as scripts, styles, media on the site, the Content-Security-Policy header is used. It is handy to mitigate data injection attacks and XSS attacks among…
I had to duplicate the DynamoDB table a few times recently. Here is the quick way to do this using CLI (AWS Console). I assumed that you have your AWS…
I have to prepare several Raspberry Pi boards for some of our small projects. We have a bunch of SD cards we can use. I want to determine which one…
Recently, I published a short list of handy queries I’m using on Microsoft SQL Server when performing simple housekeeping tasks. Unfortunately, they are not working on old versions of SQL…
Recently, one of the readers, Derrick, asked such questions in the comments: I have done client/server stuff before but am new to WebSockets, hopefully, I can ask some questions –1)…
From time to time, I have to take a look at the Microsoft SQL Server to check if everything is fine. In some cases, I have some housekeeping to do.…
Consider the following piece of code: The code above produces the following output: Strange, isn’t it? The values which end with “5” should be rounded up! This is a common…
In my previous post, I wrote about the quick way to generate Excel export from the database using Python. This was a simple report, but in fact, I had to…
If you are thinking of a quick way to prepare an Excel report from the data you have in your database, you can use Python. In order to achieve this,…
This issue is related to MySQL (I’m using mysql-connector-python). Surprisingly, when I was changed my query to a stored procedure, my code stopped working. It looked like this: And it…