Author: Dasun Hegoda

Let’s explore PostgreSQL DBMS

Why PostgreSQL?

The purpose of this article is to give you an idea about PostgreSQL. Most probably this will be an introduction for you. I will be providing a lot of links through out the article. Make sure to check those out .

Let me start like this. I have been a MySQL fan for a long time & I got a chance to work with PostgreSQL. Then I realised  the value of PostgreSQL. Let me tell you little story. This might hurt but let’s face the truth.

Do you know that MySQL is owned by Oracle. As you know MySQL is licensed under FOSS(Free and open-source software) License. Do you really think that Oracle will let their FOSS product(MySQL) beat their commercial product(Oracle Database). I think I made my point here. Don’t get me wrong, I’m not saying that MySQL is bad. It’s an awesome DBMS. That’s for sure. Also PostgreSQL is called the FOSS version of Oracle because it’s that much feature-rich.

– Read More –

Why? When To? Software Design Patterns

Why? When To? Software Design Patterns. Interesting topic right?

Software Design Patterns Explained

 

Let’s 1st talk about software design patterns. Software design patterns can be defined as recurring solutions to common problems in software design. You might be wondering how does your application work without design patterns if this’s so important. The main point to understand is that if your application doesn’t contain any errors it will work like a charm. But working application does not mean that your application’s codebase is up to the industry standard. Just writing code is not gonna help you but writing the code right way will help you. GOF A.K.A. Gang Of Four(Erich Gamma, Richard Helm, Ralph Johnson and John Vlissides) are considered to be the gurus of software design patterns. They introduced 23 design patterns which fall into three types. Creational design patterns, Structural design patterns and behavioural design patterns. See the list below

– Read More –

Why Hybrid Mobile Application Development Is So Awesome

Why hybrid mobile application development is so awesome? Why everyone is talking about hybrid mobile applications today? Why does it matter so much? What are the frameworks available to develop a hybrid mobile application? If you are a web developer wondering about how to become a mobile app developer this is for you. In this article you will get the answers to those questions. Hybrid mobile application development is becoming the next big thing now. It’s filled with awesomeness.

Let me start like this and make this more interesting for you.

Gartner Says by 2016, More Than 50 Percent of Mobile Apps Deployed Will be Hybrid.

– Read More –

#1093 – You can’t specify target table ‘table_name’ for update in FROM clause

Have you ever got this MySQL error? Oh! You are searching for a solution right? You have come to the right place. Let me give you the simplest answer and it works charm.

For the time being assume that this is your query.

What you can do is change the query to something like this below.

Okay let me explain how the magic happens here.

– Read More –

How to do MySQL Indexing

MySQL Indexes! Whooh! Let me tell you what my experience about indexing a table. I had a SQL query which took 8-9 secs to fetch the data I want. After indexing now it only takes 1 sec. Interesting right. Let’s go through what’s indexing and how to and when to and stuff. You could find technical explanation of indexes in the internet. So let me elaborate it in a more appealing way to you.

Index is a pointer to the table and it allows you to retrieve the data faster. It’s the same as the index which we find in the back of a book. Index will represent the book in the keyword or subject order where book is printed in the page order. It’s true that index will faster your select query but it will slow down your other queries such as updates and inserts. You might be wondering why is that. It’s because once the new data is added to the table, Index should be updated too. Otherwise how can an index points to the new data in the table.

There are three types of indexes

  • Single Column(EG :- Indexed by mobile No)
  • Composite(EG :- Indexed by first name and last name)
  • Unique (EG :- indexed by e-mail)

Look at table below.

– Read More –

Older Posts
Newer Posts