Skip to content

Instantly share code, notes, and snippets.

View CalledByThe4ire's full-sized avatar

Andrey Karamnoff CalledByThe4ire

View GitHub Profile
@CalledByThe4ire
CalledByThe4ire / postgres-cheatsheet.md
Created January 8, 2024 08:52 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

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)
@CalledByThe4ire
CalledByThe4ire / free-photoshop.md
Created November 21, 2023 06:16 — forked from molcik/free-photoshop.md
Modify Photoshop to never ending trial

How Does It Work

All you have to do, to extend your trial period, is change number in TrialKey element in application.xml. This file is located in /Library/Application Support/Adobe/Adobe Photoshop/AMT. You can navigate there with this command:

cd /Library/Application\ Support/Adobe/Adobe\ Photoshop\ */AMT

Then you have to open the file and edit it. You can use just TextEdit app.

open -a TextEdit application.xml
@CalledByThe4ire
CalledByThe4ire / SassMeister-input.scss
Created January 10, 2021 04:26 — forked from yairEO/SassMeister-input.scss
Precise control over responsive typography for Sass
// ----
// libsass (v3.2.5)
// ----
/*! ========================================================================
PRECISE CONTROL OVER RESPONSIVE TYPOGRAPHY FOR SASS
---------------------------------------------------
Indrek Paas @indrekpaas

Definitely not comprehensive. This is meant to be a basic memory aid with links to get more details. I'll add to it over time.

Install

$ npm install mongoose --save

Connect

const mongoose = require('mongoose');
@CalledByThe4ire
CalledByThe4ire / resetFieldset.css
Created June 6, 2020 06:04 — forked from ultrox/resetFieldset.css
Reset fieldset and legend styles
/* From http://thatemil.com/blog/2015/01/03/reset-your-fieldset/ by Emil Björklund */
legend {
display: table;
padding: 0;
}
fieldset {
border: 0;
margin: 0;
min-width: 0;
this.state = {
productsFilter: {
fields: {
min: {
price: minBy(product => product.price, productsList).price,
isValid: true
},
max: {
price: maxBy(product => product.price, productsList).price,
isValid: true
// GUI stylies of the project
.link {
color: $link-color;
text-decoration: none;
background-color: transparent;
&:link,
&:visited {
// Mixins.
// Set element size
@mixin size($width, $height: $width) {
width: $width;
height: $height;
}
// Set margin-left / margin-right
@mixin margin-x($margin) {
// Colors
$color-primary: #000000 !default;
$color-secondary: #81b3d2 !default;
$text-color: $color-primary !default;
$body-bg: #ededed !default;
$active-link-color: #766357 !default;
$active-link-color--hover: darken($active-link-color, 10%) !default;
@font-face {
font-family: 'PT Sans';
src: url('../fonts/PTSans-Regular.woff') format('woff'),
url('../fonts/PTSans-Regular.woff2') format('woff2');
font-weight: 400;
font-style: normal;
}
@font-face {
font-family: 'PT Sans';