About

Hello,
my name is Sergei. I am interesting about computer science, such as programming (mobile and web), databases, IT security and administration.
My favorite technologies in mobile is Android/Java with using wide range of API's and SQLite.
For web development I use PHP (with my framework), MySQL and Postgresql databases.
Before I was also used Delphi (7,2009) for Win32 desktop programming.
My favorite OS is Ubuntu 16.04, also I use Debian 8 on some servers and Windows 7 on laptop & Windows 10 on stick. Python, bash and multi-thread PHP-fork are useful for me to write scripts.

Popular posts from this blog

Installing and using a free GeoIP database

Today's article is about install and update GeoIP database on Debian-like systems, integrate it with PHP and Apache. To install GeoIP on Debian 8 or Ubuntu 16.04 simple run this command: apt-get install geoip-database geoip-database-extra Now you have a GeoIP installed. But databases are obsolete. To update GeoIP databases, find data files on your system: dpkg -L geoip-database | grep GeoIP.dat You get a path like /usr/share/GeoIP/ Go to that directory and download updates: wget http://geolite.maxmind.com/download/geoip/database/GeoLiteCountry/GeoIP.dat.gz wget http://geolite.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz Unpack files with replace old: gzip -df *.gz Rename GeoLiteCity.dat to GeoIPCity.dat: mv -f GeoLiteCity.dat GeoIPCity.dat You can put all these commands into one bash file (e.g. geoipupd.sh ) to run as single command: #!/bin/bash cd /usr/share/GeoIP/ wget http://geolite.maxmind.com/download/geoip/database/GeoLiteCountry/GeoIP.dat.gz wget
Read more

Monopolization for Android

Last months I work for a new Android app - Monopolization. This is a game similar to the Monopoly board game but with smartphones optimization: less complex, more quick. Go to Play Market to get my Monopoly game .
Read more

Create custom Spinner on ActionBar

Image
Last days I start working on new Android app, working name is PassGen (Password generator) and plan to place spinner onto the ActionBar. Since API 21 ActionBar replaced to more flexible Toolbar with you can put widgets similar to regular layout. I plan to use spinner but by default it look not fine for me. Starting from modify colors, my mind moving me to add second line and icon to each item. Finally, it looks like this: Almost changes are in XML files. In MainActivity: < android.support.v7.widget.Toolbar android :id= "@+id/toolbar" android :layout_width= "match_parent" android :background= "@color/colorPrimaryDark" android :layout_height= "?attr/actionBarSize" > < Spinner android :id= "@+id/spinner" style= "@style/SpinnerTheme" android :layout_width= "wrap_content" android :layout_height= "wrap_content" android :layout_marginEnd= &q
Read more