Dendi Handian articles - 78 total
Simulating Paralel Processing in Python using AsyncIO
Here is a simple simulation of how to run multiple process (or simply a function) in paralel using...
Hashing in Presto/Athena
The following hashing function require any parameter string to be casted into varbinary first. The...
URL Functions in Presto/Athena
Extract Host SELECT...
Capture Browser XHR/Fetch API Response Automatically into JSON Files
I wonder if we can capture the response of any browser's XHR/Fetch or simply API response into JSON...
Simple Python JSON Exporter & Importer
Exporter Function import json def export_json(filename, obj): with open(filename,...
VS Code Extensions for Data Engineering - Part 1
This is my opinionated list for Visual Studio Code Extension that helped me during data wrangling,...
Alpine Linux in WSL
After trying Debian in WSL, now I'm trying for something lighter, the Alpine distro. ...
Debian in WSL
This post is my journal on trying debian in WSL and playing around with it as starter. ...
Installing SQLite3 on Windows
Downloading SQLite binary Go to sqlite.org/download.html, choose...
Import and Export Large SQL File in Laragon
Importing or Exporting large SQL file through PHPMyAdmin or Adminer may not be a good idea, since...
Updating Adminer in Laragon for PHP 8
In Laragon, when you switching to PHP 8 and accessing adminer at http://localhost/adminer, you will...
Regular Expression (Regex) with Python
The Playground the re package is a built-in package in python to work with Regular...
Logical Grouping in Laravel Query Builder
When you could work well with SQL query, sometimes when it come to laravel query builder (or any...
Adding PostgreSQL to Laragon
Downloading The PostgreSQL Binary You can find any version you want to install at...
Adding MySQL 8 to Laragon
Using MySQL 5.7 for development still comfy for you, right? But why don't you try the higher version...
MongoDB on Laragon
UPDATE: the mongodb website was changed, and the previous link doesn't work anymore. So, you may...
Redis on Laragon
Redis is no longer supported in Windows, but the version 3.2.1 is still available to use (ref), so...
Scraping a Web Page in Browser using XPath and Javascript
As a programmer we should think to automate anything related to our daily task every single time if...
Adding PhpMyAdmin to Laragon
PhpMyAdmin is still your favorite MySQL database admin tool, right? RIGHT? Say no more, let's add it...
Adding PHP 7.4 to Laragon Lite
It's also recommended to use the Laragon Full version if you don't want to bother with this...
Seaborn Scatterplot
Prerequisite and How to Code Along It's recommended to use Google Colab or Jupyter...
Creating New Environment in Anaconda
Open the Anaconda Prompt If you're using Windows machine, you can find it directly using...
SQL Query into Pandas DataFrame - Part 3
After playing some aggregation and grouping in the last part, now we will play harder with table...
SQL Query into Pandas DataFrame - Part 2
Continuing the last part, we are going deep into intermediate SQL translated into Pandas...
Getting Started with Splash in Docker
Splash is a javascript rendering service. I don't have much idea what this service actually is. All I...
SQL Query into Pandas DataFrame - Part 1
The Playground Database I'm using a database from sqlitetutorial.net and SQLite Browser to...
MS SQL Server and Adminer in Laradock
Local server solution like XAMPP, WAMP or Laragon doesn't provide MSSQL server rdbms out of the box,...
Additional Column for Incremental Numbering in SQL
The Playground Database I'm using a database from sqlitetutorial.net and SQLite Browser....
Gitlab in Laradock
It's been a while since the last time I used Laradock, because my current projects development still...
Adding PHP 8 to Laragon
Currently I'm using Laragon Lite version, it has PHP 7.4.16 and apache 2.4.35 running well in my...