Posts

Oct 11, 2016
Off the streets, Land subdivision in PostGIS - Part 2
- postgis
- postgresql
- sql
- geometry
- gis
Oct 3, 2016
Optimizing parallel HTTP request batches
Sep 1, 2016
Detecting potentially malicious PHP code using checksums and heuristics on parse trees
- java
- php
- security
- postgresql
- static-analysis
- parsing
- xml
- xquery
Jul 21, 2016
FieldTop - find columns that might overflow soon
- mysql
- php
- sql
- databases
Jul 16, 2016
Analyzing PostgreSQL logs using pgBadger
- postgresql
- pgbadger
- logs
- monitoring
- performance
Jul 6, 2016
Geolocation using multiple services
- postgresql
- python
- geonames
- geolocation
- sql
- postgis
May 25, 2016
Redesigning a notification system
- postgresql
- notifications
- python
- performance
- telegram
- sql
May 10, 2016
Parallel testing multiple versions of ImageMagick
- testing
- debian
- imagemagick
- python
Feb 5, 2016
Simple job queue in Bash using a FIFO
- bash
- perl
- redis
- ipc
Jan 23, 2016
E-commerce solutions market research
- upwork
- market-research
- ecommerce
- analysis
- sql
Jan 17, 2016
The automatic hiring of distributed teams
- optimization
- recruiting
- management
- freelance
- startups
- glpk
Dec 28, 2015
Querying online datasets
- sql
- bigquery
- stackoverflow
- reddit
- IaaS
Dec 24, 2015
Out on the streets, leveraging geographical data - Part 1
- gis
- postgis
- postgresql
- openstreetmap
- leafletjs
- visualization
Dec 20, 2015
Overview of Perl-based opensource projects
- opensource
- perl
- UpStats
Dec 18, 2015
Postgres full-text search
- UpStats
- postgresql
- sql
- python
- alembic
- sqlalchemy
- search
Dec 12, 2015
Reading offline in batch mode
- offline
- org-mode
- firefox
- scripts
- reading
- emacs
Oct 14, 2015
Fishing for timezones in a compressed data lake
- UpStats
- UpStatsBot
- technical
- upwork
- upwork-api
- postgresql
- sqlalchemy
Oct 13, 2015
Freelance Job notifications on your phone via Telegram
- UpStats
- UpStatsBot
- upwork
- telegram
- product
- features
Oct 10, 2015
Why should I use UpStats?
- UpStats
- product
- features
- upwork
Oct 8, 2015
Mapping country codes to country flag icons
- UpStats
- postgresql
- perl
- json
Oct 2, 2015
Skill demand on UpWork
Sep 27, 2015
Word clouds suck
Sep 24, 2015
What is UpStats ?
Feb 7, 2015
Blog setup using Jekyll and Org-Mode
- org-mode
- jekyll
- emacs
- blogs