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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →