fghber

JSONPath (WIP)

Original Specification/Foundation

• https://goessner.net/articles/JsonPath/
• IETF Draft of a more normative JSONPath definition (based on Goessner, expired)

Major Flavors and Environments

JSON Transformators

fghber

Why should I specify a use statement when using the say function?

use strict;
use warnings;
use 5.016;
//or: use feature qw(say);

my $str = "42dc3f74212c4e74bab2";
$str =~ s/(..)/chr(hex($1))/eg; #hex() -> convert hex string to decimal number, chr() -> convert decimal number to a character(string).

fghber

##

### rvest

* [Beginner’s Guide on Web Scraping in R (using rvest)](https://www.analyticsvidhya.com/blog/2017/03/beginners-guide-on-web-scraping-in-r-using-rvest-with-hands-on-knowledge/)

fghber

#git

Untrack files in local repository but keep at origin with git

git update-index --assume-unchanged file

fghber

https://www.shellcheck.net/#

fghber

SQL/DB Fiddles

• SQL Fiddle](http://sqlfiddle.com/) MySQL 5.6, Oracle 11g R2, PostgreSQL 9.3/9.6, SQLite (WebSQL, SQL.js), MS SQL Server 2017.
• db<>fiddle An online tool for testing, demonstrating and sharing database commands and scripts.
  Features MariaDB 10.x, MySQL 8.0, Oracle 11g, Postgress 8.4 -10, SQL Server 2012 - 2017, SQLite 3.8.
• DB Fiddle Supports MySQL 5.5-8.0, PostgreSQL 9.4-10, and SQLite database engines.
• rextester Supports MySQL, MS SQL 5.7, Oracle 11g, PostgreSQL 9.6, Server 2014.

Tutorials

• SQLZOO

fghber

Tester

https://twigfiddle.com/

doc

https://twig.symfony.com/doc/2.x/api.html

debug

fghber

XPath

https://blog.scrapinghub.com/2016/10/27/an-introduction-to-xpath-with-examples

XPath Online Checker (shareable)

• videlibri: Template / XPath 3.0 / XQuery 3.0 / CSS 3 Selector / JSONiq Online Tester
• XPath Evaluator: Online XPath tester that supports XPath 3.0 and XQuery 3.0 via Saxon-HE 9.7 and XPath 1.0 via .NET XPath engine (GitHub).
• BeautifyConverter XPath Tester (requires free registration, sports many other useful online tools like minifiers, beautifiers, converters, validators, etc.)

fghber

#!/usr/bin/env python
# Copyright (C) 2010, Scott W. Dunlop <swdunlop at gmail.com>
# 
# Redistribution and use in source and binary forms, with or without
# modification, are permitted provided that the following conditions are met:
# 
#   * Redistributions of source code must retain the above copyright
#     notice, this list of conditions and the following disclaimer.
#   * Redistributions in binary form must reproduce the above copyright
#     notice, this list of conditions and the following disclaimer in the

fghber

.htaccess

• How To Use the .htaccess File
• .htaccess Cheat Sheet
• https://www.askapache.com/htaccess/
• https://www.askapache.com/htaccess/mod_rewrite-variables-cheatsheet/#THE_REQUEST
• https://www.askapache.com/htaccess/crazy-advanced-mod_rewrite-tutorial/
• http://httpd.apache.org/docs/current/mod/mod_rewrite.html
• https://httpd.apache.org/docs/current/rewrite/remapping.html
• https://httpd.apache.org/docs/current/rewrite/flags.html