not distinct from https://wiki.postgresql.org/wiki/Is_distinct_from Visualizing Plans http://www.postgresonline.com/journal/index.php?/archives/27-Reading-PgAdmin-Graphical-Explain-Plans.html Finding Locks https://wiki.postgresql.org/wiki/Find_Locks Disk Usage https://wiki.postgresql.org/wiki/Disk_Usage Enum https://wiki.postgresql.org/wiki/Enum/ Loose Indexscan https://wiki.postgresql.org/wiki/Loose_indexscan Mass type replacement https://wiki.postgresql.org/wiki/Mass_type_replacement Server Configuration https://wiki.postgresql.org/wiki/Server_Configuration Transactional DDL https://wiki.postgresql.org/wiki/Transactional_DDL_in_PostgreSQL:_A_Competitive_Analysis#PostgreSQL VacuumHeadaches https://wiki.postgresql.org/wiki/VacuumHeadaches Read more
Resources Read more
Snap Installation on Ubuntu Read more
Installing WireGuard Configuring WireGuard Create WireGuard private key Create WireGuard configuration Start WireGuard server Things to Understand Both client and server configurations have [Interface] section defined, but only server has ListenPort.Server has list of [Peer] sections for each client and... Read more
Mapping enum to string column Read more
Create Foreground Service https://robertohuertas.com/2019/06/29/android_foreground_services/ Check that application is installed Check that application is running Read more
I had a task to support background installation of Android apps on recent Android OS. My Googling/GPT skills identified that one way to do it on non-rooted device is to use PackageManager API along with marking the app as ‘device-owner’.... Read more
Get Android Version Start ADB Server On Specific Port List Processes Package Version Dump camera information Listing process logs Listing installed applications Read more
In order to root Android device, few steps will have to be performed. These steps are done in certain order, which when completed will provide root access. Major steps involved in rooting are: Unlocking Bootloader The loader needs to be... Read more
By default when Android application is installed for example via debugger, id only has permissions defined in it’s AndroidManifest.xml. But that’s actually not true, as some permissions cannot be given to regulary installed apps (e.g. android.permission.BROADCAST_SMS). To enable all posible... Read more