fghber

RegEx

Online Regex Tester Suites & Code Generators

• regex101 Online regex tester for PHP, PCRE, JavaScript and Python that highlights pattern and matches on the fly. Also features a code generator and a regex debugger!
• myregextester Sports a separate regex split tester and allows to optimize patterns (I guess this is based on Perl's Regexp::Optimizer module).
• regexr Online regex tester with good regex replace and explain functionality.
• debuggex Shows neat expression diagrams (not active anymore).
• regexper translates regular expressions into an SVG image (for documentation or embedding)
• RexV2 Evaluator for PHP PCRE, PHP Posix!, Perl, Python, Javascript, Node.JS!

fghber

Web IDEs

ideone Ideone is an online compiler and debugging tool which allows youto compile source code and execute it online in more than 60 programming languages and share links to the code.
repl.it Like ideaone, can also install missing Python packages.
Onlilne GDB Online compiler and debugger forC, C++, Python, Java, PHP, Ruby, Perl, Pascal, Fortran, Haskell, Objective-C, Assembly, HTML, CSS, JS, SQLite, Prolog, and more.
Coding Ground Advanced IDEs for C/C++, C#, GO, Java, PHP, Perl, Python, Octave/MATLOAB, R, Ruby, Scala, and compiler/interpreter for many other languages and frameworks.
JDOODLE very similar to ideone but a somewhat different set of languagse/compilers.

Dedicated:

fghber

using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Diagnostics.CodeAnalysis;
using System.IO;
using System.Linq;
using System.Net;
using System.Text;
using System.Threading.Tasks;
using System.Runtime.Serialization.Json;

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

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

.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

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

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

##

### 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