First, create db:
$ createdb avocadoThen, create user:
$ createuser avocado
Theodore Keloglou sirodoht
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="utf-8"> | |
| <meta http-equiv="X-UA-Compatible" content="IE=edge"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1"> | |
| <title>Hello</title> | |
| <link rel="stylesheet" href="main.css"> | |
| </head> | |
| <body> |
sirodoht
/ new-db-postgres.md
Last active
July 30, 2021 09:15
How to create new database and new user with password on PostgreSQL (the easiest way)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # default target so running 'make' by itself wll download and build nginx | |
| build: nginx | |
| cd nginx && ./configure --with-pcre=../pcre2 && make | |
| nginx: pcre2 | |
| curl -O https://nginx.org/download/nginx-1.21.6.tar.gz | |
| tar -xzvf nginx-*.tar.gz | |
| mv nginx-*/ nginx | |
| rm nginx-*.tar.gz |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "editor.bracketPairColorization.enabled": true, | |
| "editor.cursorStyle": "block", | |
| "editor.dragAndDrop": false, | |
| "editor.hover.enabled": false, | |
| "editor.linkedEditing": false, | |
| "editor.minimap.enabled": true, | |
| "editor.minimap.showSlider": "always", | |
| "editor.minimap.size": "fill", | |
| "editor.renderWhitespace": "selection", |
benob
/ reshard.py
Created
March 4, 2023 17:35
Script to decompose/recompose LLAMA LLM models with different number of shards.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # script to decompose/recompose llama model in different number of shards | |
| # note that it loads the full model * 2 in cpu memory | |
| import os | |
| import json | |
| import sys | |
| import torch | |
| import glob | |
| if len(sys.argv) != 4: |
gubatron
/ compiling_building_c_cpp_notes.md
Last active
February 29, 2024 05:23
Things to remember when compiling and linking C/C++ programs
charlesroper
/ How to setup a practically free CDN using Backblaze B2 and Cloudflare.md
Last active
March 1, 2024 08:02
How to setup a practically free CDN
⚠️ Note 2023-01-21
Some things have changed since I originally wrote this in 2016. I have updated a few minor details, and the advice is still broadly the same, but there are some new Cloudflare features you can (and should) take advantage of. In particular, pay attention to Trevor Stevens' comment here from 22 January 2022, and Matt Stenson's useful caching advice. In addition, Backblaze, with whom Cloudflare are a Bandwidth Alliance partner, have published their own guide detailing how to use Cloudflare's Web Workers to cache content from B2 private buckets. That is worth reading,
Kartones
/ postgres-cheatsheet.md
Last active
April 12, 2024 17:44
PostgreSQL command line cheatsheet
Magic words:
psql -U postgresSome 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)
