Skip to content

Instantly share code, notes, and snippets.

View pheeria's full-sized avatar
💭
🍏 🍎

Olzhas Askar pheeria

💭
🍏 🍎
View GitHub Profile
@subpath
subpath / berlin_kitas.csv
Last active May 27, 2024 13:24
Berlin's Kitas with addresses and emails (csv file with ";" as separator)
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 1 column, instead of 4. in line 2.
address;name;type;postcode;phone;email;educational;topics;languages;lat;lon
Wartenburgstr. 7;Ev. Kirchengemeinde Jesus-Christus;Kindertagesstätte;10963;030216 30 87;Kita@jckg.berlin;;;;52.49654;13.38089
Wilhelmstr. 15;Trauminsel e.V.;Eltern-Initiativ-Kindertagesstätte;10963;030-25923697;trauminsel.ev@hotmail.de;Situationsansatz;Ästhetische Bildung (Musik und Kunst), Gesundheit, Interkulturelle Pädagogik, Körper und Bewegung;deutsch - arabisch;52.50275;13.38865
Wilhelmstr. 54;Kinder im Kiez gGmbH;Kindertagesstätte;10963;030208 92 14;franzoesischestrasse@kinder-im-kiez.de;;;;52.4985969;13.3783562
Dessauer Str. 27;Orte für Kinder GmbH;Kindertagesstätte;10963;0302639 7930;traumbaum@ortefuerkinder.de;;;;52.50369999999999;13.3791
Hornstr. 13;EMMA gemeinnützige GmbH;Kindertagesstätte;10963;03054849986;post@EMMAAPFEL.de;Montessori-Pädagogik;;;52.49478;13.38017
Wilhelmstr. 3;Trauminsel e.V.;Eltern-Initiativ-Kindertagesstätte;10963;030-25938954;trauminsel.ev@hotmail.de;Situationsansatz;Ästhetische Bildung (Musik und Ku
@thiagokokada
thiagokokada / test_runner.clj
Last active November 14, 2023 15:02
Babashka's test runner that dynamically discover the tests
#!/usr/bin/env bb
;; Inspired from https://book.babashka.org/#_running_tests
(require '[clojure.test :as t]
'[clojure.string :as string]
'[babashka.classpath :as cp]
'[babashka.fs :as fs])
(cp/add-classpath "src:test")

Make it real

Ideas are cheap. Make a prototype, sketch a CLI session, draw a wireframe. Discuss around concrete examples, not hand-waving abstractions. Don't say you did something, provide a URL that proves it.

Ship it

Nothing is real until it's being used by a real user. This doesn't mean you make a prototype in the morning and blog about it in the evening. It means you find one person you believe your product will help and try to get them to use it.

Do it with style

@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active June 17, 2024 15:54
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'