MySQL

 connect phpMyAdmin to localhost:3307

https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-ubuntu-18-04#step-2-%E2%80%94-installing-mysql

vim /etc/phpmyadmin/config-db.php

/etc/init.d/apache2 restart
 

ALTER USER 'asdf'@'%' IDENTIFIED WITH mysql_native_password
BY '123';
FLUSH PRIVILEGES;

SELECT user,authentication_string,plugin,host FROM mysql.user;

MS SQL

https://docs.microsoft.com/en-us/sql/relational-databases/databases/view-a-list-of-databases-on-an-instance-of-sql-server?view=sql-server-ver15 

SELECT name, database_id, create_date FROM sys.databases ; GO 

SELECT name FROM sys.databases ;

USE AdventureWorks2012;

SELECT DATEADD(month, 1, '20060830');

UPDATE column SET am=DATEADD(month, 1, column)   

AMD compatibility

 https://dlcdnets.asus.com/pub/ASUS/mb/SocketAM4/PRIME_A320M-E/Memory_QVL_for_AMD_Ryzen_2nd_Generation_Processors.pdf

 https://www.amd.com/en/products/apu/7th-gen-a6-9500e-apu

https://dlcdnets.asus.com/pub/ASUS/mb/LGA1151/Z170-K/E11133_MB_Pin_Definition_v2_web_only.pdf 

https://dlcdnets.asus.com/pub/ASUS/mb/SocketAM4/PRIME_A320M-E/PRIME_A320M-E_Devices_report.pdf?_ga=2.150868278.121035418.1589210573-1092435267.1587983989

SSL

 

 https://www.baeldung.com/spring-boot-https-self-signed-certificate

 keytool -genkeypair -alias baeldung -keyalg RSA -keysize 2048 -storetype PKCS12 -keystore baeldung.p12 -validity 3650

 https://mkyong.com/spring-boot/spring-boot-ssl-https-examples/

 $ keytool -genkeypair -keyalg RSA -keysize 2048 -storetype PKCS12 -keystore mkyong.p12 -validity 365

 

https://letsencrypt.org/ru/getting-started/

https://certbot.eff.org/lets-encrypt/ubuntubionic-other 

sudo certbot certonly --standalone

 https://dzone.com/articles/spring-boot-secured-by-lets-encrypt

 /etc/letsencrypt/live/asdf.pp.ua# openssl pkcs12 -export -in fullchain.pem -inkey privkey.pem -out keystore.p12 -name tomcat -CAfile chain.pem -caname root

Time Complexity

https://medium.com/@ariel.salem1989/an-easy-to-use-guide-to-big-o-time-complexity-5dcf4be8a444

O(1) — Constant Time

O(N)—Linear Time

O(log(n)) — Logarithmic Time

O(N²) — Quadratic Time

O(2^N) — Exponential Time

Docker

docker ps

docker ps -a (all)

docker ps -l (latest exited)

docker exec -it acc357f011f4 psql -U testuser testdb

# \dt

Schema | Name | Type  |  Owner   

--------+------+-------+----------

 public | asdf | table | testuser

 

docker images

docker ps --format $FORMAT

docker run -ti ubuntu:latest  bash

https://docs.docker.com/install/linux/docker-ce/ubuntu/#install-docker-engine---community-1

https://docs.docker.com/engine/examples/postgresql_service/

https://dev.mysql.com/doc/mysql-installation-excerpt/8.0/en/docker-mysql-getting-started.html#docker-starting-mysql-server

docker ps -a
docker pull mysql/mysql-server:tag
docker run  -P -p 3308:3306 --name=mysql3308 -d mysql/mysql-server:5.7
docker logs mysql3308 | grep GENERATED
docker exec -it mysql1 mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED BY '12345';

CREATE USER 'asdf'@'%' IDENTIFIED BY '12345';

GRANT ALL PRIVILEGES ON *.* TO 'asdf'@'%' WITH GRANT OPTION;


#########################################
https://dev.mysql.com/doc/mysql-installation-excerpt/8.0/en/docker-mysql-getting-started.html#docker-starting-mysql-server

https://stackoverflow.com/questions/50177216/how-to-grant-all-privileges-to-root-user-in-mysql-8-0

SELECT host, user FROM user ;

CREATE USER 'asdf'@'%' IDENTIFIED BY '12345';

GRANT ALL PRIVILEGES ON *.* TO 'asdf'@'%' WITH GRANT OPTION;

https://docs.docker.com/engine/examples/postgresql_service/

#############################33

docker-compose.yaml

version: '3.1'

services:

  db:
    image: postgres
    restart: always
    environment:

      POSTGRES_USER: usr
      POSTGRES_PASSWORD: pwd
      POSTGRES_DB: test     
    ports:
      - "5433:5432"

docker + postgres (amigoscode)

https://youtu.be/9i1gQ7w2V24?t=1590

AWS

Просмотреть все учебные пособия >>

 https://aws.amazon.com/ru/getting-started/tutorials/

 

Запуск виртуальной машины Linux

Хранение файлов в облаке

Запуск интернет‑приложения

 

Запуск приложения

с помощью AWS Elastic Beanstalk

Данное пошаговое руководство поможет вам запустить демонстрационное приложение на PHP с помощью AWS Elastic Beanstalk (EB). Помимо PHP, сервис EB поддерживает и другие языки программирования, в том числе Java, .NET, Node.JS, Python, Ruby, Docker и Go, однако в данном пособии будет рассмотрен пример с языком PHP (для других языков процесс аналогичен). Сначала выполняется настройка приложения EB, а затем настройка среды EB, в которой будет запущено приложение.

Вы уже знаете? AWS еще более упростила запуск интернет-приложений. Мгновенный запуск приложений с помощью Amazon Lightsail >>

 

MiB Mem :    483.2 total,    188.1 free,    132.0 used,    163.1 buff/cache

java -Xmx32m -Xss256k -jar some.jar

MiB Mem :    483.2 total,      6.7 free,    317.8 used,    158.6 buff/cache

Java Spring guides

https://www.youtube.com/watch?v=WDlifgLS8iQ&list=PLU2ftbIeotGoGSEUf54LQH-DgiQPF2XRO&index=3


https://spring.io/guides/gs/rest-service/

https://spring.io/guides/gs/securing-web/

http://logging.apache.org/log4j/2.x/manual/configuration.html

https://attacomsian.com/blog/spring-boot-console-application

Spring Data JPA

Supported keywords inside method name: 
https://docs.spring.io/spring-data/jpa/docs/current/reference/html/#jpa.query-methods.query-creation

https://spring.io/guides/gs/accessing-data-jpa/

https://spring.io/guides/gs/accessing-data-mysql/ 

https://attacomsian.com/blog/spring-data-jpa-one-to-many-mapping

Lambda, Predicate

class Animal {
 boolean canHop = true;
 boolean canSwim;
 int x = 1;
 int y = 10;
}

interface CheckIface {
 int test1(Animal a);
}

//interface Predicate {
// boolean test(T t);
//}

class Solution {
 static final int i = 0;

 public static void main(String[] args) {
  Animal animal = new Animal();
  print1(animal, a -> {
   return a.x;
  });
  print1(animal, a -> a.y);
  print1(animal, a -> {
   return a.canHop ? 1 : 0;
  });

  print(animal, a -> a.canHop);
  print(animal, a -> a.canSwim);
 }

 static void print1(Animal a, CheckIface check) {
  if (check.test1(a) > 0)
   System.out.println("test " + check);
 }

 static void print(Animal a, Predicate<Animal> check) {
  if (check.test(a))
   System.out.println("test1 " + check);
 }

Class StringBuilder

Modifier and Type	Method and Description
StringBuilder	append(boolean b)
StringBuilder	append(char c)
StringBuilder	append(char[] str)
StringBuilder	append(char[] str, int offset, int len)
StringBuilder	append(CharSequence s)
StringBuilder	append(CharSequence s, int start, int end)
StringBuilder	append(double d)
StringBuilder	append(float f)
StringBuilder	append(int i)
StringBuilder	append(long lng)
StringBuilder	append(Object obj)
StringBuilder	append(String str)
StringBuilder	append(StringBuffer sb)
StringBuilder	appendCodePoint(int codePoint)
int	capacity()
char	charAt(int index)
int	codePointAt(int index)
int	codePointBefore(int index)
int	codePointCount(int beginIndex, int endIndex)
StringBuilder	delete(int start, int end)
StringBuilder	deleteCharAt(int index)
void	ensureCapacity(int minimumCapacity)
void	getChars(int srcBegin, int srcEnd, char[] dst, int dstBegin)
int	indexOf(String str)
int	indexOf(String str, int fromIndex)
StringBuilder	insert(int offset, boolean b)
StringBuilder	insert(int offset, char c)
StringBuilder	insert(int offset, char[] str)
StringBuilder	insert(int index, char[] str, int offset, int len)
StringBuilder	insert(int dstOffset, CharSequence s)
StringBuilder	insert(int dstOffset, CharSequence s, int start, int end)
StringBuilder	insert(int offset, double d)
StringBuilder	insert(int offset, float f)
StringBuilder	insert(int offset, int i)
StringBuilder	insert(int offset, long l)
StringBuilder	insert(int offset, Object obj)
StringBuilder	insert(int offset, String str)
int	lastIndexOf(String str)
int	lastIndexOf(String str, int fromIndex)
int	length()
int	offsetByCodePoints(int index, int codePointOffset)
StringBuilder	replace(int start, int end, String str)
StringBuilder	reverse()
void	setCharAt(int index, char ch)
void	setLength(int newLength)
CharSequence	subSequence(int start, int end)
String	substring(int start)
String	substring(int start, int end)
String	toString()
void	trimToSize()

Class String

Modifier and Type	Method and Description
char	charAt(int index)
int	codePointAt(int index)
int	codePointBefore(int index)
int	codePointCount(int beginIndex, int endIndex)
int	compareTo(String anotherString)
int	compareToIgnoreCase(String str)
String	concat(String str)
boolean	contains(CharSequence s)
boolean	contentEquals(CharSequence cs)
boolean	contentEquals(StringBuffer sb)
static String	copyValueOf(char[] data) Equivalent to valueOf(char[]).
static String	copyValueOf(char[] data, int offset, int count) Equivalent to valueOf(char[], int, int).
boolean	endsWith(String suffix)
boolean	equals(Object anObject)
boolean	equalsIgnoreCase(String anotherString)
static String	format(Locale l, String format, Object... args) Returns a formatted string using the specified locale, format string, and arguments.
static String	format(String format, Object... args) Returns a formatted string using the specified format string and arguments.
byte[]	getBytes()
byte[]	getBytes(Charset charset)
void	getBytes(int srcBegin, int srcEnd, byte[] dst, int dstBegin) Deprecated.  This method does not properly convert characters into bytes. As of JDK 1.1, the preferred way to do this is via the getBytes() method, which uses the platform's default charset.
byte[]	getBytes(String charsetName)
void	getChars(int srcBegin, int srcEnd, char[] dst, int dstBegin)
int	hashCode()
int	indexOf(int ch)
int	indexOf(int ch, int fromIndex)
int	indexOf(String str)
int	indexOf(String str, int fromIndex)
String	intern()
boolean	isEmpty()
static String	join(CharSequence delimiter, CharSequence... elements)
static String	join(CharSequence delimiter, Iterable<? extends CharSequence> elements)
int	lastIndexOf(int ch)
int	lastIndexOf(int ch, int fromIndex)
int	lastIndexOf(String str)
int	lastIndexOf(String str, int fromIndex)
int	length()
boolean	matches(String regex)
int	offsetByCodePoints(int index, int codePointOffset)
boolean	regionMatches(boolean ignoreCase, int toffset, String other, int ooffset, int len)
boolean	regionMatches(int toffset, String other, int ooffset, int len)
String	replace(char oldChar, char newChar)
String	replace(CharSequence target, CharSequence replacement)
String	replaceAll(String regex, String replacement)
String	replaceFirst(String regex, String replacement)
String[]	split(String regex)
String[]	split(String regex, int limit)
boolean	startsWith(String prefix)
boolean	startsWith(String prefix, int toffset)
CharSequence	subSequence(int beginIndex, int endIndex)
String	substring(int beginIndex)
String	substring(int beginIndex, int endIndex)
char[]	toCharArray()
String	toLowerCase()
String	toLowerCase(Locale locale)
String	toString()
String	toUpperCase()
String	toUpperCase(Locale locale)
String	trim()
static String	valueOf(boolean b) Returns the string representation of the boolean argument.
static String	valueOf(char c) Returns the string representation of the char argument.
static String	valueOf(char[] data) Returns the string representation of the char array argument.
static String	valueOf(char[] data, int offset, int count) Returns the string representation of a specific subarray of the char array argument.
static String	valueOf(double d) Returns the string representation of the double argument.
static String	valueOf(float f) Returns the string representation of the float argument.
static String	valueOf(int i) Returns the string representation of the int argument.
static String	valueOf(long l) Returns the string representation of the long argument.
static String	valueOf(Object obj) Returns the string representation of the Object argument.

Interface List

All Known Implementing Classes:

AbstractList, AbstractSequentialList, ArrayList, AttributeList, CopyOnWriteArrayList, LinkedList, RoleList, RoleUnresolvedList, Stack, Vector

Class ArrayList

All Implemented Interfaces:

Serializable, Cloneable, Iterable, Collection, List, RandomAccess

Direct Known Subclasses:

AttributeList, RoleList, RoleUnresolvedList

Collections.sort(aList);
aList.sort(null);
A null value indicates that the elements' natural ordering should be used
aList.sort((e1,e2) -> e2 - e1); //DESC

boolean	add(E e)
void	add(int index, E element)
boolean	addAll(Collection<? extends E> c)
boolean	addAll(int index, Collection<? extends E> c)
void	clear()
Object	clone()
boolean	contains(Object o)
void	ensureCapacity(int minCapacity)
void	forEach(Consumer<? super E> action)
E	get(int index)
int	indexOf(Object o)
boolean	isEmpty()
Iterator<E>	iterator()
int	lastIndexOf(Object o)
ListIterator<E>	listIterator()
ListIterator<E>	listIterator(int index)
E	remove(int index)
boolean	remove(Object o)
boolean	removeAll(Collection<?> c)
boolean	removeIf(Predicate<? super E> filter)
protected void	removeRange(int fromIndex, int toIndex)
void	replaceAll(UnaryOperator<E> operator)
boolean	retainAll(Collection<?> c)
E	set(int index, E element)
int	size()
void	sort(Comparator<? super E> c)
Spliterator<E>	spliterator()
List<E>	subList(int fromIndex, int toIndex)
Object[]	toArray()
<T> T[]	toArray(T[] a)
void	trimToSize()