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...
11 followers · 0 following
View GitHub Profile
@sergeykuzmich
sergeykuzmich / wp-config.php
Last active November 28, 2022 13:59
WordPress Configuration
<?php
#These values are intentionally left blank to avoid copy-pastes
define( 'AUTH_KEY', '');
define( 'SECURE_AUTH_KEY', '');
define( 'LOGGED_IN_KEY', '');
define( 'NONCE_KEY', '');
define( 'AUTH_SALT', '');
define( 'SECURE_AUTH_SALT', '');
define( 'LOGGED_IN_SALT', '');
@sergeykuzmich
sergeykuzmich / wp-config.php
Last active November 28, 2022 14:00
WordPress Configuration
<?php
define( 'DB_NAME', 'unique_database_name' );
define( 'DB_USER', 'unique_database_user' );
define( 'DB_PASSWORD', 'strong_and_unique_password' );
@sergeykuzmich
sergeykuzmich / wp-config.php
Last active November 28, 2022 14:00
WordPress Configuration
<?php
define( 'WP_DEBUG', false );
#if WP_DEBUG_LOG is enabled, you have to enable WP_DEBUG as well
define( 'WP_DEBUG_LOG', true );
define( 'WP_DEBUG_DISPLAY', false );
@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 / 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 / service.tf
Created February 12, 2019 12:31
Terraform Module usage
module "project_name" {
source = "[email protected]:sergeykuzmich/tfmodule-do_wordpress.git"
domain = "project_domain.com"
}
@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}"