Andro Geeks

Helping you out to be an Android Geeks

Query Optimization!

Context: Recently, I was asked to load some data quickly for a particular tab. For around 1000 rows of data, it was taking almost 40-45 seconds! The admins had to wait for a long time when they used to see… Continue Reading →

How to import large SQL dump file in MySQL using CMD

In this tutorial, I will show you how to import a large SQL file (1GB<) to MySQL database using Windows Command Line. This tutorial will cover both Windows and Linux platform as those commands are the same for both OS…. Continue Reading →


the In this tutorial, we will show you how to create REST API with full Database CRUD functionality. We will start from configuration to database functionality step by step. If you are not familiar or not have a better knowledge… Continue Reading →

Database Event(1.1) : Scheduler Event

Definition: The MySQL Event Scheduler is a process which runs in the background and constantly looks for events to execute. DB Outline & Context of the example: Suppose, we are monitoring traffic intensity in our living city Dhaka, Bangladesh. Android,… Continue Reading →

CRUD inside Database in IONIC Framework

Introduction: Ionic apps are created and developed primarily through the Ionic command line utility (the “CLI”), and use Cordova to build and deploy as a native app. This means we need to install a few utilities to get developing. To… Continue Reading →

Database Event(1.0) : Triggering

DML: According to Wikipedia, A data manipulation language (DML) is a family of syntax elements similar to a computer programming language used for selecting, inserting, deleting and updating data in a database. Triggering: Whenever you operate any DML operations in… Continue Reading →

No More Redundant Data !

Background In every real life Application, Database is a must. It might reside in Backend (ex: MySQL server-side) or in Application-end (ex: Android’s Local DB) to make application user-friendly and fetch data faster. A handy knowledge on Database always makes… Continue Reading →

Clean Code is what everyone expects !

Freshers and Software Companies (1.0) The Software Industry is cruel. Freshers think that after completing graduation they will join some office and code there which will be satisfactory. Is it actually? No, definitely not. What will you develop? Why the… Continue Reading →

Database’s 4 Transaction Properties

Basic Terminologies: Table: where all the information of the real world is stored. Database(DB) : comprises of Table(s) . Server: where the Database is hosted. A Database might be hosted in USA/Bangladesh etc. Transaction:  An example might be transferring money… Continue Reading →

StartApp Ad Integration in Android

What is StartApp? StartApp is an alternative of Google AdSense and in a short sentence ad service provider for mobile and web. StartApp provides both publisher and advertiser service, where the publisher can post an ad for their company and… Continue Reading →

© 2021 Andro Geeks — Powered by WordPress

Theme by Anders NorenUp ↑