Tuan-Vu Trinh trinhtuanvubk

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

tifffile

(specific read/write library, no extras) https://github.com/blink1073/tifffile/blob/master/tifffile/tifffile.py

from tifffile import imsave
import numpy as np

# create data

Tải nhạc từ Youtube

Cài đặt

sudo curl -L https://yt-dl.org/downloads/latest/youtube-dl -o /usr/local/bin/youtube-dl
sudo chmod a+rx /usr/local/bin/youtube-dl
sudo apt install ffmpeg

Sử dụng

How to install CUDA & cuDNN on Ubuntu 22.04

Install NVIDIA drivers

Update & upgrade

sudo apt update && sudo apt upgrade

Remove previous NVIDIA installation

How to install CUDA & cuDNN on Ubuntu 22.04

Install NVIDIA drivers

Update & upgrade

sudo apt update && sudo apt upgrade

	import openai
	import elevenlabs

	# Uncomment the following lines to set the API keys
	openai.api_key = "key_here"
	elevenlabs.set_api_key("key_here")

	def write(prompt: str):
	for chunk in openai.ChatCompletion.create(
	model="gpt-3.5-turbo-0301",

	nodes:
	- id: webcam
	custom:
	source: https://huggingface.co/datasets/dora-rs/dora-idefics2/raw/main/operators/opencv_stream.py
	outputs:
	- image
	- id: idefics2
	operator:
	python: https://huggingface.co/datasets/dora-rs/dora-idefics2/raw/main/operators/idefics2_op.py
	inputs:

	""" To use: install LLM studio (or Ollama), clone OpenVoice, run this script in the OpenVoice directory
	git clone https://github.com/myshell-ai/OpenVoice
	cd OpenVoice
	git clone https://huggingface.co/myshell-ai/OpenVoice
	cp -r OpenVoice/* .
	pip install whisper pynput pyaudio
	"""

	from openai import OpenAI
	import time

	# import torch
	# from transformers import AutoTokenizer, AutoModelForCausalLM

	# model_id = "andrewrreed/falcon-7b-guanaco-qlora-arr"
	# tokenizer = AutoTokenizer.from_pretrained(model_id)
	# model = AutoModelForCausalLM.from_pretrained(model_id,
	# torch_dtype=torch.bfloat16,
	# load_in_4bit=True,
	# )

	"""
	Examples:
	(1) python benchmark_distilled_sd.py --pipeline_id CompVis/stable-diffusion-v1-4
	(2) python benchmark_distilled_sd.py --pipeline_id CompVis/stable-diffusion-v1-4 --vae_path sayakpaul/taesd-diffusers
	(3) python benchmark_distilled_sd.py --pipeline_id nota-ai/bk-sdm-small
	(4) python benchmark_distilled_sd.py --pipeline_id nota-ai/bk-sdm-small --vae_path sayakpaul/taesd-diffusers
	"""

	import argparse
	import time