Skip to content

Instantly share code, notes, and snippets.

View botic's full-sized avatar
👔
working for @orfon and @diehauswirtschaft

Philipp Naderer-Puiu botic

👔
working for @orfon and @diehauswirtschaft
View GitHub Profile
@botic
botic / BMSGPK-covid19.json
Created March 19, 2020 17:40
Datenbank-Schema für das Covid-19 Dashboard des BMSGPK
{
"results": {
"A": {
"refId": "A",
"meta": {
"rowCount": 16,
"sql": "select TableName = tbl.table_schema + '.' + tbl.table_name, TableDescription = prop.value, ColumnName = col.column_name, ColumnDataType = col.data_type FROM information_schema.tables tbl INNER JOIN information_schema.columns col ON col.table_name = tbl.table_name AND col.table_schema = tbl.table_schema LEFT JOIN sys.extended_properties prop ON prop.major_id = object_id(tbl.table_schema + '.' + tbl.table_name) AND prop.minor_id = 0 AND prop.name = 'MS_Description' WHERE tbl.table_type = 'base table'"
},
"series": null,
"tables": [
@botic
botic / dyypgyq.markdown
Last active October 8, 2019 13:43
TensorFlow.js with SharedMobility.ai Datasets
@botic
botic / vhost.conf
Created September 27, 2019 19:34
Apache Security + Cache Headers
<FilesMatch ".(ico|jpg|jpeg|png|gif|js|css)$">
Header set X-Content-Type-Options nosniff
FileETag -INode MTime Size
Header set Cache-Control "public, max-age=63072000, immutable"
Header unset Last-Modified
</FilesMatch>
<FilesMatch "\.(html)$">
# security-related headers
Header set Expect-CT "max-age=63072000, enforce"
@botic
botic / 100-api.sharedmobility.ai-le-ssl.conf
Created September 15, 2019 11:37
SharedMobility.ai Web API Installation Guide
<IfModule mod_ssl.c>
<VirtualHost *:443>
ServerName api.sharedmobility.ai
ServerAdmin [email protected]
DocumentRoot /var/www/api.sharedmobility.ai/
<Directory /var/www/api.sharedmobility.ai/>
Options -Indexes +FollowSymLinks
AllowOverride None
Order allow,deny
@botic
botic / helma-logo.svg
Created September 3, 2019 12:15
Helma Logo as Vector
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
01.01.2018
06.01.2018
30.03.2018
02.04.2018
01.05.2018
10.05.2018
21.05.2018
31.05.2018
15.08.2018
01.11.2018
@botic
botic / docs.md
Last active May 30, 2019 16:36
GEN Media Literacy URL Scoring

URL Scoring

The URL scoring runs on a Google Cloud Function and can be triggered via HTTPS:

https://europe-west1-gen-medialiteracy-paris2019.cloudfunctions.net/scoreUrl?url=<URL_TO_SCORE>

Please note that you need to perform URL encoding for the url query parameter. The endpoint sends an wildcard * access control header to fully enable CORS requests.

@botic
botic / party-colors-result.css
Created May 23, 2019 17:18
Generate Party CSS
.oevp .bar {
background-color: #64c4d2;
}
.spoe .bar {
background-color: #e3001c;
}
.fpoe .bar {
background-color: #2453a1;
@botic
botic / edges.json
Last active October 30, 2018 20:09
Wiener Linien Netz
{
"u1": [
"Oberlaa",
"00",
"Neulaa",
"02",
"Alaudagasse",
"04",
"Altes Landgut",
"06",

Breakpoints

Bootstrap

<576px  Extra small
≥576px  Small
≥768px  Medium
≥992px  Large
≥1200px Extra large