If the error occurs due to keyserver being unable, you can fix it by adding these. When pgp keyservers are missing there are many different errors that might occur. In ArchLinux some of those are...
4 Feb, 2021
There is a simple function for when you need to extract count of days from interval. It is returned as as double, but converted to integer in this example. You get interval when you subtract two...
26 Jan, 2021
How to create reader / read-only user in azure database.
25 Jan, 2021
This example shows how to set the default value of a smalldatetime column to current date time.
26 Nov, 2020
This form moves the table into another schema. Associated indexes, constraints, and sequences owned by table columns are moved as well.
12 Sep, 2020
Turn a relay on and off using a push button. When using a pushbutton, you have use a library (don't reinvent the wheel) to control the push button signal. It's called a debounce, taking account in...
7 Sep, 2020
go-pg is PostgreSQL client and ORM for Golang. To show generated queries we have to implement some hooks. There are multiple posts about this in issues, this is an exact working example of it.
23 Jul, 2020
Removing array element from vue property caused a tricky anomaly for me. I was trying different methods delete didn't work, splice worked but always removed the last item from array. Finally I...
15 Jul, 2020