Skip to content

Instantly share code, notes, and snippets.

View sergeykuzmich's full-sized avatar
🎱
To be or not to be...

Sergey Kuzmich sergeykuzmich

🎱
To be or not to be...
  • Remedy Product, Inc.
  • Planet Earth, The Milky Way Galaxy
  • 10:53 (UTC +02:00)
View GitHub Profile
@sergeykuzmich
sergeykuzmich / wp-config.php
Last active November 28, 2022 13:59
WordPress Configuration
<?php
define( 'DISALLOW_FILE_MODS', true );
@sergeykuzmich
sergeykuzmich / query.sql
Created November 28, 2022 13:51
Cursored Query
SELECT uid, title, content, datetime
FROM news
WHERE (datetime, uid) < ((SELECT datetime FROM news WHERE uid = :uid), :uid)
ORDER BY (datetime, uid) DESC
LIMIT :per_page;
@sergeykuzmich
sergeykuzmich / index.sql
Created November 28, 2022 13:50
Index on UUID + DATETIME
CREATE INDEX idx_datetime_uid ON news (datetime, uid);
@sergeykuzmich
sergeykuzmich / api.json
Created November 28, 2022 13:48
An example of API payload
{
"data": [
{
"ID": "dc4a8926-4ca5-42d7-920a-4f0de5024619",
"...": "..."
},
{
"ID": "2a4f316a-3fb4-4ae9-864f-38a34e50b1d5",
"...": "..."
},
@sergeykuzmich
sergeykuzmich / Preferences.sublime-settings
Last active April 21, 2021 11:25
Sublime Text 3 - User Preferences
{
"caret_style": "phase",
"close_windows_when_empty": false,
"color_scheme": "Packages/Material Theme/schemes/Material-Theme.tmTheme",
"drag_text": false,
"ensure_newline_at_eof_on_save": true,
"fallback_encoding": "Cyrillic (Windows 1251)",
"file_exclude_patterns":
[
".DS_Store",
@sergeykuzmich
sergeykuzmich / Developer.terminal
Last active April 21, 2021 11:24
MacOS Terminal Profile
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>ANSIBlueColor</key>
<data>
YnBsaXN0MDDUAQIDBAUGBwpYJHZlcnNpb25ZJGFyY2hpdmVyVCR0b3BYJG9iamVjdHMS
AAGGoF8QD05TS2V5ZWRBcmNoaXZlctEICVRyb290gAGmCwwXHR4lVSRudWxs1Q0ODxAR
EhMUFRZcTlNDb21wb25lbnRzVU5TUkdCXE5TQ29sb3JTcGFjZV8QEk5TQ3VzdG9tQ29s
b3JTcGFjZVYkY2xhc3NPECgwLjQ5MDc4MDQ3MjggMC42NTExMzg2MDM3IDAuOTk5Njcw
@sergeykuzmich
sergeykuzmich / CV.html
Last active June 11, 2019 09:33
Curriculum vitae
<!DOCTYPE html><html><head><meta charset="utf-8"><title>CV.md</title><style>@charset "UTF-8";@import 'https://cdnjs.cloudflare.com/ajax/libs/KaTeX/0.9.0-alpha2/katex.min.css';code{color:#c7254e;background-color:#f9f2f4;border-radius:4px}code,kbd{padding:2px 4px}kbd{color:#fff;background-color:#333;border-radius:3px;box-shadow:inset 0 -1px 0 rgba(0,0,0,.25)}kbd kbd{padding:0;font-size:100%;box-shadow:none}pre{display:block;margin:0 0 10px;word-break:break-all;word-wrap:break-word;color:#333;background-color:#f5f5f5;border:1px solid #ccc;border-radius:4px}pre code{padding:0;font-size:inherit;color:inherit;white-space:pre-wrap;background-color:transparent;border-radius:0}.pre-scrollable{max-height:340px;overflow-y:scroll}table{background-color:transparent}th{text-align:left}.table{width:100%;max-width:100%;margin-bottom:20px}.table>thead>tr>th{padding:8px;line-height:1.4285714;border-top:1px solid #ddd}.table>thead>tr>td,.table>tbody>tr>th,.table>tbody>tr>td,.table>tfoot>tr>th,.table>tfoot>tr>td{padding:8px;line
@sergeykuzmich
sergeykuzmich / .gitconfig
Created April 7, 2019 19:02
.gitconfig aliases for ignore-on-commit feature
[alias]
hide = update-index --assume-unchanged
unhide = update-index --no-assume-unchanged
show-hidden = !git ls-files -v | grep '^h' | cut -c3-
@sergeykuzmich
sergeykuzmich / user_data.tf
Last active February 13, 2019 21:08
Domain setup template_file definition
data "template_file" "user_data" {
template = "${file("${path.module}/user_data.tpl")}"
vars = {
domain = "${var.domain}"
}
}
@sergeykuzmich
sergeykuzmich / main.tf
Last active February 13, 2019 21:06
Droplet definition with custom user_data
resource "digitalocean_domain" "default" {
name = "${var.domain}"
ip_address = "${digitalocean_droplet.default.ipv4_address}"
}
resource "digitalocean_droplet" "default" {
name = "${coalesce(var.droplet_name, var.domain)}"
image = "wordpress-18-04"
region = "${var.droplet_region}"
size = "${var.droplet_size}"