Andarius

VACUUM (FULL, ANALYSE, VERBOSE ) entities;
REINDEX TABLE CONCURRENTLY entities;
VACUUM (FULL, ANALYSE, VERBOSE ) entity_roles;
REINDEX TABLE CONCURRENTLY entity_roles;
VACUUM (FULL, ANALYSE, VERBOSE ) entity_users;
REINDEX TABLE CONCURRENTLY entity_users;
VACUUM (FULL, ANALYSE, VERBOSE ) worksites;
REINDEX TABLE CONCURRENTLY worksites;

select count(*), 'entities' as source

Andarius

import { Colors } from 'app/styles/common'
import React, { FC } from 'react'
import {
    Platform,
    Pressable,
    StyleProp,
    StyleSheet,
    View,
    ViewStyle
} from 'react-native'

Andarius

#!/bin/bash



convert(){
  readonly FILENAME=`echo $1 | sed -r "s/.+\/(.+)\..+/\1/" | tr - _`
  readonly SIZES=(
    48 mdpi
    72 hdpi
    96 xhdpi

Andarius

#!/bin/bash

# set -xe

readonly BACKUP_FOLDERS=( /mnt/data/Projects )
readonly TARGET=server:/folder

sync(){
  rsync -avz --exclude={.git,build,.idea,__pycache__,node_modules,target} --rsync-path=/usr/bin/rsync $1 $2
}