This is just a repo to save my whole OS environment configuration. Feel free to use it if you want, there's nothing super fancy about it, if you follow through the installation process you should be able to have the very same environment as me.
OS: Arch linux 2019.01.01
RAM (Recommended): 4GB
| --- PSQL queries which also duplicated from https://github.com/anvk/AwesomePSQLList/blob/master/README.md | |
| --- some of them taken from https://www.slideshare.net/alexeylesovsky/deep-dive-into-postgresql-statistics-54594192 | |
| -- I'm not an expert in PSQL. Just a developer who is trying to accumulate useful stat queries which could potentially explain problems in your Postgres DB. | |
| ------------ | |
| -- Basics -- | |
| ------------ | |
| -- Get indexes of tables |
| #define _POSIX_C_SOURCE 2 // to allow popen and pclose. | |
| #include <stdio.h> | |
| #include <stdlib.h> | |
| #include <string.h> | |
| struct cl_reading { | |
| char **output; | |
| int malloc_error; | |
| int n_lines; | |
| int pclose_error; |
| const BASE_URL = 'https://www.novaragnarok.com/?module=vending&action=item&id='; | |
| let table = $("table#itemtable").DataTable(); | |
| let data = table.rows().data(); | |
| let ITEMS = {}; | |
| for (let i = 0; i < data.length; i++) { | |
| let item_id = data[i][1]; | |
| let quantity = data[i][4]; |
| #include "array.c" | |
| #include <stddef.h> | |
| #include <stdint.h> | |
| // Must be a prime number. | |
| #define MAP_SIZE 1009 | |
| // Another prime number, but less than MAP_SIZE. | |
| #define MAP_PRIME 31 | |
| typedef struct map_item { |
| wget https://www.python.org/ftp/python/3.11.5/Python-3.11.5.tgz | |
| tar -xzf Python-3.11.5.tgz && cd Python-3.11.5 | |
| ./configure --prefix=$HOME/localpython/3.11.5 && make && make install | |
| ./python -m venv env_3115 | |
| source env3115/bin/activate |
| /* converter.c | |
| * | |
| * This code converts `.md` files into `.html` files. | |
| * | |
| * The main use is to write a static website in `.md` files, and then run this | |
| * program to convert it to `.html` | |
| * | |
| * The program relies on the following variables: | |
| * | |
| * - INPUT_FOLDER: full path of the website with `.md` files. |
