BigQuery Tips & Tricks – Part 1 I am becoming a fan of BigQuery recent days. It’s saving me a lots of time while of our business platforms are running on Google Cloud Platform. Every application, every operation we are keeping logs from every corner of our infrastructure as much as possible that gives us a greater good insight about everything. All logs are being stored in BigQuery. It’s awesome, completely automated and scaled. With Google’s Data Studio, our project …
Blog Posts
CSV is a very important file types to save mass amount of similar types data. Sometime to save those data from CSV file in PHP is an important task. So I am sharing a complete script to read data from CSV and save it in your data with PHP & PDO. Write your comments if this works for you.
Suppose, you have some rules to check whitelisted url. So everytime whenever you will get a new url so you can cross match that URL with your whitelisted URL. And whitelisted URLs sometimes can be wildcard url. So to check whether the given URL matched any of the wildcard urls. <?php $whiteListedUrls = [ "https://google.com/test/*", "https://yahoo.com/test/index.html", "https://sohelrana.me/*", "https://sohelrana.me" ]; $url = "https://google.com/test/testWildCard/ok.html"; function checkUrlWildcard($url, $whiteListUrls = []) { foreach ($whiteListUrls as $wUrl) { $pattern = preg_quote($wUrl, '/'); $pattern = str_replace('\*', …
BigQuery is one of the greatest products in Google Cloud Platform. Basically it is useful to analysis massive amount of data for analytical purpose. You can run queries, get insights and analytical reports from terabyte, petabyte amount of data within very short time that your traditional database can’t handle. That’s why it’s a popular choice among data scientists. As you can create multiple BigQuery dataset in a single project and a single dataset can have multiple table. So sometimes it’s …
It seems that I am pretty late here to play with WordPress REST API. It’s really super cool! Now I can think about how well and fast I can distribute or work with wordpress blog posts. Even now you can host your whole WordPress inside a static HTML page. Funny? Yea, like your HTML page will interact with your REST API json response and small JS can help you to display inside page. Then you will get 10000000x super fast blog …