[PostgreSQL] How to grant superuser authority when the user (role) with superuser authority is 0

I will leave it as a memo. # manner I write postgres10 as a prerequisite. Basically, you can do it by changing the path including the version described later. It also assumes that the default us

Paiza Python Primer 5: Basics of Dictionaries

Python3 is completely free on Paiza, so I summarized it. <a href="https://paiza.jp/works/python3/primer"> Introduction to Paiza Python3 ## 01: Learn what a dictionary is #### **`lesson.py`** ``

A story stuck with the installation of the machine learning library JAX

I heard that a machine learning library called JAX can be used from python, so I installed it It is a memo of the place where it got stuck at the time of installation I tried to install JAX using

Socket communication with Python LEGO Mindstorms

If you are developing robot programming etc. using [LEGO Mindstorms EV3](https://afrel.co.jp/product/ev3-introduction) (hereinafter EV3) in Python environment, naturally apply analysis such as machin

Codeforces Round # 594 (Div. 2) Bacha Review (10/29)

# This time's results ![スクリーンショット 2020-10-29 16.55.50.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/331393/de01cb31-cc18-e457-736f-401d6c2095bc.png) # Impressions of this t

[Nohup] Execution even if the terminal is turned off

Write code that allows the program to run even if you turn off the terminal. # How to use nohup nohup (execution code) & You can use nohup with. Below is an example of executing ./a.out. ``` C:>n

Topic extraction of Japanese text 2 Practical edition

[Aidemy](https://aidemy.net/) 2020/10/30 # Introduction Hello, it is Yope! I am a liberal arts student, but I was interested in the possibilities of AI, so I went to the AI-specialized school "Aidemy

I got lost in the maze

Good evening (* ´ω `) Thank you for your continued support. This time is a maze. Let's see how many moves you need from Start to Goal. The sample maze below is Thank you for borrowing the heri

IT Glossary [Links]

-[Variable length](https://wa3.i-3-i.info/word12068.html) -[Difference between return value and return value](https://oshiete.goo.ne.jp/qa/531721.html) - CPU - memory

Extract N samples for each group with Pandas DataFrame

I want to extract N pieces for each group, and one of the countermeasures. For example, when you want to extract the daily column and the top nth sales. ` sort_values` Sorting ` groupby` Groupi

Build a go environment using Docker

<head> This time, I built a go environment using Docker, which I have been studying recently. </ head> 1. Create a Dockerfile #### **`latest`** ```from golang RUN mkdir /go/src/charts_server && a

[Python] df Read and do the first memo (NaN confirmation etc.)

# Purpose of this article Taking the Titanic data as an example, make a note of what you do first to see the characteristics of the data. Usually, `pandas-profiling` may be better because it gives y

Authentication process with gRPC and Firebase Authentication

# Introduction I will show you how to process authentication on Go server using gRPC and Firebase Authentication. I will write about the authorization process in another article. Firebase Authentic

Train_test_split of features held by dict

# Thing you want to do The features held in the dictionary type as shown below ``` {'field1': array([0, 1, 2, 3, 4, 5]), 'field2': array([5, 4, 3, 2, 1, 0]), 'label': array([1, 0, 1, 0, 0, 0])} ```

converting argument $ 1 type: unsupported type [] string, a slice of string

# Overview This is the first post in my first year as an engineer. When I was operating the DB using sqlx, I was troubled by the following error, so I will record it. I would be grateful if you cou

Just print Python elapsed time in seconds

```python import time firstTime = time.time() while True: nowTime = time.time() - firstTime print(nowTime) ```

[Python] I want to get a common set between numpy

Use np.intersect1d ``` import numpy as np array_1 = np.array([1, 2, 3, 4, 5]) array_2 = np.array([1, 3, 5, 7, 9]) np.intersect1d(array_1, array_2) ```

[Python] I tried to implement stable sorting, so make a note

# problem See the site below * http://judge.u-aizu.ac.jp/onlinejudge/description.jsp?id=ALDS1_2_C # My answer ```py import collections def chk_before_tranp_bigger(now, before): return int(befor

Let's execute the command on time with the bot of discord

## The point * Develop in python using [discord.py](https://discordpy.readthedocs.io/ja/latest/index.html). * Implement a background loop with [discord.ext.tasks](https://discordpy.readthedocs.io/j

Manage multiple types of users with CustomUser in django-allauth (multi type user)

# Overview ――I want a system that can create multiple user types with Django --Allows you to create two types of users, "Supply user" and "Buyer user" --Give different attributes to each user type

Introduction to EV3 / MicroPython

## Let's run EV3 with MicroPython In this article, we aim to run EV3 with MicroPython. It's very easy to do so let's do our best together! ・ [What is EV3](https://afrel.co.jp/product/ev3-introduct

An error occurs when trying to import scikit-learn after connecting to Oracle with SQLAlchemy

## phenomenon If you import `sklearn` after actually connecting the DB from the ʻEngine` instance of SQLAlchemy as shown below, ʻImport Error` will occur. #### **`demo.Case of py / ImportError`** `

Make a SonicWall SSL VPN connection with the Linux CLI

SonicWall's SSL VPN clients include MobileConnect and NetExtender. NetExtender is available on Linux and has a GUI and CLI. The GUI version has garbled Japanese and is unexpectedly heavy, so I wou

Negative / Positive Analysis 1 Application of Text Analysis

[Aidemy](https://aidemy.net/) 2020/10/30 # Introduction Hello, it is Yope! I am a liberal arts student, but I was interested in the possibilities of AI, so I went to the AI-specialized school "Aidemy

[Linux] How to read .bashrc of general user as root user on WSL2 Ubuntu20.04

## Development environment -Host OS: windows10 Home ・ Guest OS: wsl2 Ubnutu20.04 ## Problems / problems Changed the default user of wsl to root user to quickly solve problems around container pe

Negative / Positive Analysis 2 Twitter Negative / Positive Analysis (1)

[Aidemy](https://aidemy.net/) 2020/10/30 # Introduction Hello, it is Yope! I am a liberal arts student, but I was interested in the possibilities of AI, so I went to the AI-specialized school "Aidemy

neo4j sandbox part 15

# Overview I tried sandbox with neo4j. I hit neo4j sandbox with python and tried to input gist data. # Input node. ``` from neo4j import GraphDatabase, basic_auth driver = GraphDatabase.driver(

Learn from “Beyond the Twelve-Factor App” & “The Twelve-Factor App” and practice on AWS (3) Dependency Management / Dependencies-Explicitly declare and separate dependencies

# Commentary This factor is a dependency management factor that is both original and beyond. Most modern development languages have package management tools for resolving library references such as n

Change Spider's Config at runtime.

# Overview ### Premise In Scrapy's Spider, you can set crawling in the configuration file (settings.py) and custom settings (custom_setting). However, if you try to use only this setting, you will h

First OSMnx ~ With shortest path search ~

There weren't many articles in Japanese about OSMnx, and it was too difficult for me as a weak English person to collect information ... So I wrote that it should be useful for other weak English p