Skip to content

Instantly share code, notes, and snippets.

View epok07's full-sized avatar

Franck E. epok07

  • Astrio Sarl
  • Douala
View GitHub Profile
@mbostock
mbostock / .block
Last active June 21, 2023 17:50
Zoomable Map Tiles
license: gpl-3.0
redirect: https://observablehq.com/@d3/zoomable-map-tiles
@andsens
andsens / dump.sh
Last active May 29, 2025 03:41
Backup all MySQL databases into separate files
#!/bin/sh
## backup each mysql db into a different file, rather than one big file
## as with --all-databases. This will make restores easier.
## To backup a single database simply add the db name as a parameter (or multiple dbs)
## Putting the script in /var/backups/mysql seems sensible... on a debian machine that is
## Create the user and directories
# mkdir -p /var/backups/mysql/databases
# useradd --home-dir /var/backups/mysql --gid backup --no-create-home mysql-backup
## Remember to make the script executable, and unreadable by others
@andrew8088
andrew8088 / prof.sql
Created July 5, 2012 18:51
This is the SQL code to set up a database for a problem I had on a database management exam. Here's the problem: write an SQL query that will return a table of the names and salaries of the professors who teach 20 or more students.
CREATE DATABASE profs;
USE profs;
CREATE TABLE professors (
name varchar(30) NOT NULL,
specialization varchar(20),
salary double(8,2),
CONSTRAINT prof_pk PRIMARY KEY (name));
CREATE TABLE students (
@enygma
enygma / gist:2697434
Created May 14, 2012 21:41
Hashing in REST Requests (with FuelPHP)
<?php
class Controller_User extends Controller_Rest
{
protected function validateHash()
{
$request = file_get_contents('php://input');
$requestHeaders = apache_request_headers();
if (!isset($requestHeaders['X-Auth']) || !isset($requestHeaders['X-Auth-Hash'])) {
$this->response('fail!',401);