Skip to content

Instantly share code, notes, and snippets.

View Geogouz's full-sized avatar
💭
When not coding? Bouldering, swimming and listening to great music!!

Dimitris Xenakis Geogouz

💭
When not coding? Bouldering, swimming and listening to great music!!
View GitHub Profile
@Geogouz
Geogouz / index.sql
Created January 24, 2018 10:59
Good indexes?
SELECT p.content, u.name
FROM posts p, admins a, users u
WHERE
p.tag = a.tag and
a.id = u.id and
p.content = 'Hello World';
SELECT u.name, p.date
FROM users u, posts p
WHERE
@Geogouz
Geogouz / avg.sql
Last active December 3, 2016 20:36
cA cB cC cD
============================
a v d 10
a c f 2
a c f 4
b b s 5
b b s 1
b c f 1
c1 c2 c3 avg
import kivy
import threading
import time
from datetime import datetime
import urllib2
import json
import operator
import gc
import os
@Geogouz
Geogouz / wdi_fix
Last active August 29, 2015 14:20
Hi, we made a check on your WDI data and we found some (79) topic duplicates on some indicators.
Below you can check the indicator id along with the duplicates.
IndicatorID-First_DuplicateTopicID-ListTopicsID
43 7 [7]
45 7 [7]
53 7 [7]
54 7 [7]
72 7 [3, 20, 7, 19]
73 7 [19, 7]
##############################################
# Python for kivy A1 and A2
##############################################
from kivy.app import App
from kivy.uix.boxlayout import BoxLayout
from kivy.uix.screenmanager import ScreenManager, Screen
class SecondScreen(Screen):
pass