Debug Capsule

$results = Capsule::select(‘select * from table’); var_dump($results);   Capsule::connection()->enableQueryLog(); $results = Capsule::select(‘SELECT * FROM test’); $query = Capsule::getQueryLog(); print_r($query); $results = Capsule::select(‘select * from table’); var_dump($results); Capsule::connection()->enableQueryLog(); $results = Capsule::select(‘SELECT * FROM test’); $query = Capsule::getQueryLog(); print_r($query);

Scrapy: open source crawling and web scraping framework

Scrapy is a fast high-level web open source crawling and web scraping framework, used to crawl websites and extract structured data from their pages. It can be used for a wide range of purposes, from data mining to monitoring and automated testing. Requires Python 2.7 or Python 3.4+.

Travic: Transit visualization

Travic, a thin browser-based client, tracker provides movement visualization of transit data published by transit agencies and operators from all over the world. The movements are mostly based on static schedule data. Wherever real-time data is available it is also included in the visualization. Very handy to track public transportation.