IT Handyman

Because sometimes you need a little help…

Menu
Skip to content
  • Home
  • About / Contact information
  • Dulare uses…
ESP8266 and ESP32 Websockets considerations
  • ESP8266

ESP8266 and ESP32 Websockets considerations

  • Posted on 2022-01-192022-01-27
  • by dulare

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)…

Read More
A few handy SQL scripts for SQL Server users
  • SQL

A few handy SQL scripts for SQL Server users

  • Posted on 2022-01-122022-01-27
  • by dulare

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.…

Read More
Python rounding issue and how to fix it
  • Python

Python rounding issue and how to fix it

  • Posted on 2022-01-052022-01-27
  • by dulare

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…

Read More
Pivot pandas dataframe – convert row to columns (and join this to the rest of the other dataframe)
  • Python

Pivot pandas dataframe – convert row to columns (and join this to the rest of the other dataframe)

  • Posted on 2021-12-292022-01-27
  • by dulare

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…

Read More
Excel report from the database – the quick way in Python
  • Python

Excel report from the database – the quick way in Python

  • Posted on 2021-12-222022-01-27
  • by dulare

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,…

Read More
Don’t use “CALL StoredProcedure()” in Python :)
  • Python

Don’t use “CALL StoredProcedure()” in Python :)

  • Posted on 2021-12-152022-01-19
  • by dulare

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…

Read More
Convenient performance tracking in ColdFusion and Lucee
  • ColdFusion

Convenient performance tracking in ColdFusion and Lucee

  • Posted on 2021-12-082022-01-12
  • by dulare

I’m working on the old code right now and I try to perform some performance adjustments. The majority of work now relies on the identification of weak points and places…

Read More
Mark cells with changes in HTML Table
  • Javascript

Mark cells with changes in HTML Table

  • Posted on 2021-12-012022-01-12
  • by dulare

Why such a code? I’m displaying the history of the database record – in a table, each row is a separate record of the history. The highest row contains current…

Read More
Disabling AWS CloudFront distribution using Python and Boto3
  • AWS

Disabling AWS CloudFront distribution using Python and Boto3

  • Posted on 2021-11-242021-12-09
  • by dulare

AWS CloudFront is a widely-used content delivery network service and as most of Amazon Web Services elements can be configured programmatically in many ways. For beginners, the easiest way leads…

Read More
Using multiple (different) keys with GitHub
  • Programming

Using multiple (different) keys with GitHub

  • Posted on 2021-11-172021-12-08
  • by dulare

You are most likely aware of the fact that GitHub is no longer supporting simple username/password-based authentication when working from the command line using HTTP remote. This is deprecated and…

Read More

Posts navigation

Previous Page Page 1 Page 2 Page 3 … Page 18 Next Page

Recent Posts

  • ColdFusion XMLParse: The prefix “” for element “” is not bound.
  • Unable to start AWS Linux instance after instance type change – “a start job is running for…”
  • Disable TLS 1.0, TLS 1.1 and weak certificates on IIS
  • “Access denied for user” on views only – after MySQL database restore
  • The value class java.time.LocalDateTime cannot be converted to a date

Tags

3D printing administration Apache Arduino AWS ColdFusion databases development DNS EC2 ESP8266 Express FriendlyTracker FTP git gzip Handlebars IIS inodes IoT Java Javascript Linux Lucee Machine Learning MS SQL Server MySQL NextGen Node OpenVPN PHP programming Python Security Selenium SQL SSL tar threads timelapse tips TLS web development Windows WordPress
© Copyright 2022 – IT Handyman
Bezel Theme by SimpleFreeThemes ⋅ Powered by WordPress