Pinned

1. Execute PSQL in background for large... Execute PSQL in background for large files

   1

   nohup psql -d mydb -f insert.sql > insert.log 2>&1 &

2. Get download progress with boto3 Get download progress with boto3

   1

   import sys

   2

   import threading

   3

   4

   class ProgressPercentage(object):

   5

     ''' Progress Class

3. Import transformer model into spacy v3 Import transformer model into spacy v3

   1

   from thinc.api import Config

   2

   import spacy

   3

   4

   DEFAULT_CONFIG_STR = """

   5

   [transformer]

4. Remove duplicados Remove duplicados

   1

   select count(*) from 

   2

     tb_lotacao le where le.ctid <> (select min(li.ctid) from tb_lotacao li 

   3

   where li.co_pessoa = le.co_pessoa and li.ds_mes_ano = le.ds_mes_ano and li.co_unidade = le.co_unidade)

5. Change java version on mac Change java version on mac

   1

   /usr/libexec/java_home -V

   2

   3

   export JAVA_HOME=`/usr/libexec/java_home -v 1.7.0_75`

   4

   5

   java -version

6. Redshift connection from NodeJS - fr... Redshift connection from NodeJS - from https://www.javaniceday.com/post/how-to-connect-to-a-redshift-database-from-node-js

   1

   import pgp from "pg-promise";

   2

   3

   const connections = [];

   4

   5

   export default class Redshift {