Skip to content

Instantly share code, notes, and snippets.

View samael's full-sized avatar
🏠
Working from home

Bohdan Tsekhanskyi samael

🏠
Working from home
View GitHub Profile
import os
import random
class SecureDelete:
BLOCK_SIZE = 16 << 12
def secure_delete(self, base_path):
if os.path.isdir(base_path):
file_list = self._enum_paths(base_path)
@odan
odan / php-pdo-mysql-crud.md
Last active December 8, 2020 23:24
Basic CRUD operations with PDO and MySQL
@maephisto
maephisto / Bohemian Rhapsody in Javascript
Created May 20, 2015 10:14
Bohemian Rhapsody in Javascript
try {
assert(Life.isReal);
assert(Life.isFantasy);
} catch (LandSlideException ex) {
while(!Reality.isEscapable) {
self.eyes.forEach(function(eye) {
eye
.open()
.lookTo(Sky)
.see();
@theodorosploumis
theodorosploumis / Install_Phpstorm.sh
Last active June 16, 2022 11:15
Update phpstorm on Ubuntu linux.
#!/bin/bash -e
# IMPORTANT. My phpstom installation exists on /opt/phpstorm.
# Early Access program: https://confluence.jetbrains.com/display/PhpStorm/PhpStorm+Early+Access+Program
# For stable releases try: https://data.services.jetbrains.com/products/download?code=PS&platform=linux
if [ "$(whoami)" != "root" ]
then
echo "Sorry, you are not root."
exit 1
fi
@mitio
mitio / indexes_to_add.sql
Last active January 22, 2026 10:10
OpenCart SQL profiler and indexes for improved speed and page load time. Requires vqMod to be installed. Place it in <project-root>/vqmod/xml/ and that's it. Copy and paste the indexes once in PhpMyAdmin, in the database for your store.
-- Add these to speed up OpenCart
ALTER TABLE `oc_product` ADD INDEX(`date_available`, `status`);
ALTER TABLE `oc_product` ADD INDEX(`status`);
ALTER TABLE `oc_url_alias` ADD UNIQUE(`query`);
ALTER TABLE `oc_product_to_store` ADD INDEX(`store_id`);
ALTER TABLE `oc_category_path` ADD INDEX(`path_id`, `category_id`);
ALTER TABLE `oc_category_path` ADD INDEX(`category_id`, `path_id`);
ALTER TABLE `oc_product_description` ADD INDEX(`language_id`);
ALTER TABLE `oc_category` ADD INDEX (`parent_id`, `status`, `sort_order`);
ALTER TABLE `oc_category` ADD INDEX(`sort_order`);