rphlmr

// Credits to Louistiti from Drizzle Discord: https://discord.com/channels/1043890932593987624/1130802621750448160/1143083373535973406

import { sql } from "drizzle-orm";

const clearDb = async (): Promise<void> => {
  const query = sql<string>`SELECT table_name
      FROM information_schema.tables
      WHERE table_schema = 'public'
        AND table_type = 'BASE TABLE';
    `;

andygeorge

These are manual instructions on enabling SSH access on your Steam Deck, adding public key authentication, and removing the need for a sudo password for the main user (deck).

This gist assumes the following:

• you have a Steam Deck
• you have a home PC with access to a Linux shell that can ssh, ssh-keygen, and ssh-copy-id
• your Steam Deck and home PC are on the same local network, with standard SSH traffic (tcp/22) allowed over that network from the PC to the Steam Deck

NOTE: @crackelf on reddit mentions that steamOS updates blow away everything other than /home, which may have the following effects:

• removing the systemd config for sshd.service, which would prevent the service from automatically starting on boot
• removing the sudoers.d config, which would reenable passwords for sudo

rj00a

{
  "minecraft:worldgen/biome": {
    "value": [
      {
        "id": 0,
        "element": {
          "precipitation": "none",
          "temperature": 0.5,
          "downfall": 0.5,
          "effects": {

robertkirkman

How to record or stream SteamOS 3.X in gamescope (Gaming Mode)

Here is another method that uses Flatpak and obs-vkcapture, which don't meet my personal needs but are very likely to be useful for you. In the comments there there is also an obs-gstreamer method.

Here is another method for recording that has its own GUI for Gaming Mode built with Decky Loader.

Force SteamOS to behave very much like Arch Linux

Key phrase: very much like, not identical. Always treat this as more unstable than Manjaro and only expect support with it in my comments section here.

1. Set a password (if you haven't already) and disable read-only rootfs (yes this means after updating SteamOS [not Steam Client] this will all be deleted and you will have to do all this again if you want

johnestima

#!/bin/bash

USER_POOL_ID=POOL_ID

RUN=1
until [ $RUN -eq 0 ] ; do
echo "Listing users"
USERS=`aws cognito-idp list-users --user-pool-id ${USER_POOL_ID} | grep Username | awk -F: '{print $2}' | sed -e 's/\"//g' | sed -e 's/,//g'`
if [ ! "x$USERS" = "x" ] ; then
	for user in $USERS; do

thelegendofbrian

Ports used

Some of the exact port numbers seem to be different between installations. I'm not sure if any have to be as listed, but those were a working number I used at some point

Port	Description	Place Defined	Open Port	Unique
11000	Overworld server port	Master/server.ini	x	x
11001	Cave server port	Caves/server.ini	x	x
8768	Steam auth port for overworld	Master/server.ini
8769	Steam auth port for cave	Caves/server.ini
27018	Steam master server port for overworld	Master/server.ini		x

vi

#!/bin/bash

IN=$1
OUT=$2

true ${SD_PARAMS:="-55dB:d=0.3"};
true ${MIN_FRAGMENT_DURATION:="20"};
export MIN_FRAGMENT_DURATION

if [ -z "$OUT" ]; then

kentbrew

Finding Twitter User IDs

User accounts on Twitter are commonly identified by screen name, which may be changed by operators when they take over an account, or have been sitting on an old account for a long time and want to transition it into malicious use.

User IDs, however, are permanent. There are several services out there that will try to find them for you but it seems like a bad idea to me, since you're alerting them to the fact that there's something interesting about this account. There's also plenty of bad advice that uses many long-since-abandoned Twitter API endpoints.

As of this writing (2018-02-18) you can view source and search for /profile_banners/, which will show something like this:

.enhanced-mini-profile .mini-profile .profile-summary {

Serganbus

Полезные ключи программы psql

-U - Указываем пользователя, например postgres
-W - Приглашение на ввод пароля
-d название_БД - Подключение к БД название_БД
-h имя_хоста - Подключение к хосту имя_хоста
-p порт - По какому порту постгря ожидает подключения
-c команда - Выполнение команды SQL без выхода в интерактивный режим
-f file.sql - Выполнение команд из файла file.sql
-S - Однострочный режим, то есть, переход на новую строку будет выполнять запрос (избавляет от ; в конце конструкции SQL)

mikemunsie

{ 
  "AC": "+247-####", 
  "AD": "+376-###-###", 
  "AE": "+971-5#-###-####", 
  "AE": "+971-#-###-####", 
  "AF": "+93-##-###-####", 
  "AG": "+1(268)###-####", 
  "AI": "+1(264)###-####", 
  "AL": "+355(###)###-###", 
  "AM": "+374-##-###-###",