itsmefox

--- 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

itsmefox

Discord app protocols

Home:

• /: discord://-/
• friends: discord://-/channels/@me/
• nitro: discord://-/store

General:

itsmefox

// apply this script into the build.gradle of modules which you have applied protobuf plugin
// also, this can be used to workaround others plugins not supporting macOS M1 soc, e.g. AndResGuard
// to support AndResGuard, append `|| it.name == "AndResGuardLocatorSevenZip"` 
// to the configuration matching condition sentence
configurations.matching {
    it.name.startsWith("protobufToolsLocator_")
}.configureEach {
    withDependencies { deps ->
        deps.matching { it instanceof ExternalDependency }.configureEach {
            it.artifacts.each {

itsmefox

private static byte[] intToLittleEndian(long numero) {
	ByteBuffer bb = ByteBuffer.allocate(4);
	bb.order(ByteOrder.LITTLE_ENDIAN);
	bb.putInt((int) numero);
	return bb.array();
}

// OR ...

private static byte[] intToLittleEndian(long numero) {

itsmefox

import java.io.IOException;
import java.net.URISyntaxException;
import java.nio.file.Files;
import java.nio.file.Paths;
import java.security.KeyFactory;
import java.security.NoSuchAlgorithmException;
import java.security.PrivateKey;
import java.security.interfaces.RSAPublicKey;
import java.security.spec.InvalidKeySpecException;
import java.security.spec.PKCS8EncodedKeySpec;