RSS

Posts in 2020

  • Azure Change App Service HTTP Ping URL and Interval

    Last Update: in Azure

    In Azure app service, I want to change the keep-alive time period and want to change the HTTP ping (keep-alive) URL to /status, the default keep-alive URL is /.

    Issues Description In Azure app service, I want to change the keep-alive time period and want to change the HTTP ping (keep-alive) URL to /status, the default is /. Answer from Azure support I can not find proper answer so send request to Azure …

    Read more

  • Organize Go Project

    in Go

    demonstrates the development of a simple Go package inside a module and introduces the go tool, the standard way to fetch, build, and install Go modules, packages, and commands.

    Code organization Go programs are organized into packages. A package is a collection of source files in the same directory that are compiled together. Functions, types, variables, and constants defined in one source file are visible to all other …

    Read more

  • Docker container to connect localhost of host

    in Docker

    Inside Docker container, want to connect service on localhost of host machine. There is a magic hostname host.docker.internal can be used inside Docker container to reach localhost of host machine.

    Problem I have redis running in localhost, when I run a docker VM, I want to connect redis from inside of Docker VM, so I do not need docker-compose for another redis VM. Solution Docker for Mac: use host.docker.internal For Docker on Mac, there is a …

    Read more

  • Run docker on Raspberry Pi

    in Raspberry Pi

    Install docker on Raspberry Pi and and configure to run as non-root.

    Why docker A docker container is a standard unit of software that packages up code and all its dependencies so the application runs quickly and reliably from one computing environment to another. A Docker container image is a lightweight, standalone, …

    Read more

  • Custom Rails logger to use Azure application insights

    in Rails

    Rails Logger can be custom to have multiple loggers through extend(). Azure application insights can collect app’s log through trace. In this article creates a custom Rails logger and send a copy of log to Azure application insights.

    Rails Logger interface Logger The Ruby Logger class provides a simple but sophisticated logging utility that you can use to output messages. Log level Logger level define as Severity . class Logger # Logging severity. # # DEBUG < INFO < WARN …

    Read more

  • Running a DoH Client to encrypt all home DNS traffic

    Last Update: in Security

    With DNS over HTTPS (Secure DNS), nobody listening on the wire can see the DNS queries you make when you are browsing the Internet.

    If you haven’t setup Secure DNS, do it today.

    What is Secure DNS Traditionally, DNS queries are sent in plaintext. Anyone listening on the Internet can see which websites you are connecting to. To ensure your DNS queries remain private, you should use a resolver that supports secure DNS …

    Read more

  • PostgreSQL mini cookbook: Performance tuning, debugging and testing

    Last Update: in PostgreSQL

    PostgreSQL mini cookbook: Performance Tuning, Debugging and Testing, those tricks back to 2001 and still works today. 😉

    Keeping index statistics up to date Performance has been steadily deteriorating as you use your Postgres system. Solution Use the VACUUM ANALYZE command in psql or the vacuumdb command-line tool. vacuumdb is garbage-collect and analyze a PostgreSQL …

    Read more

  • PostgreSQL mini cookbook: Dealing with the system tables

    Last Update: in PostgreSQL

    PostgreSQL mini cookbook: Dealing with the system tables, those tricks back to 2001 and still works today. 😉

    Seeing what tables exist You want to check if a table already exists. Solution There is a view called pg_tables or the system table pg_class - you can query either. There is less information in pg_tables but it is easier to understand. List all the …

    Read more

  • PostgreSQL mini cookbook: Constraining your data

    Last Update: in PostgreSQL

    PostgreSQL mini cookbook: Constraining your data, those tricks back to 2001 and still works today. 😉

    Making sure a related record exists Records in one table should all be connected to records in another table - you shouldn’t have diary entries for a company that isn’t listed in the companies table. Solution Define a FOREIGN KEY on the …

    Read more

  • PostgreSQL mini cookbook: Controlling Access to your data

    Last Update: in PostgreSQL

    PostgreSQL mini cookbook: Controlling Access to your data, those tricks back to 2001 and still works today. 😉

    Restricting users to certain records or certain fields with views The accounts team don’t need to see unfilled orders and the sales team don’t need to see bank details. You want to enforce this. Solution Create one view for each group of …

    Read more