Category: Databases

Be MEAN and Lean in Web App Development – Build Apps with MEAN Stack

As developers, we know the importance of full stack of development technology putting our lives at ease. While LAMP stack started this trend many years back, we now see another trend fast catching up in the development universe- the MEAN stack Simply put, this technology bundle comprises of 4 components MongoDB – The database MongoDB is a widely popular schema-less open source NoSQL database system. Its design makes it easy to pass data to and fro from the …

4 MySQL clients for PHP developers in Windows

Using client apps for MySQL provides more than just a well-presented representation of your database. It elevates the level of accuracy and time saved by database administrators. And every dollar saved is a dollar earned in profit for your business. Hence, it makes total sense to go for MySQL client apps when you undertake a PHP web application development project. However, the million dollar question is – “Which client app should you go with?” The market is flooded …

4 iOS Backend as a Service (BaaS) Providers for Mobile app development

With the rapid emergence of technological innovations, there has been a dramatic rise in the demand for high-end technological solutions for web application development. Traditional technologies have taken a backseat, and application developers are constantly looking out for the latest development models. So what’s new and exciting in the tech landscape? It has to be BaaS or ‘Backend as a Service’. What is BaaS? Also termed as Mobile Backend as a Service (MBaaS), this particular application development model …

4 NoSQL Databases for modern Web app developers ( updated 2016 )

The new-age digital economy revolves around three key disruptive forces – Web, mobile, and Internet of Things (IoT). A new set of tools and technology is now needed to manage the overwhelming volume of data from these sources and glean actionable insights. When real-time data management and processing becomes a cause of concern with its demands on data processing speed, scalability, and availability, it is time to look beyond older RDBMS. This is precisely where NoSQL shows its …

Tips for building better mySQL architecture

Have you thought about the right Data type which you should use? Is VARCHAR bad? Do you review the SQL statements that you have written? Do you know what sort of impact indexes produce? How to leverage the query Caching techniques? Do you follow the naming standards? This simple slide teaches you the best mySQL practices to be followed up by 15 minutes. Taking out the best from mySQL will improve the application performance if its part of …

Database Optimization Techniques to Increase SQL SERVER Performance – Part III – Index on multiple columns

Index on multiple columns for SQL performance Since clustered index records the table and arranges the data according to the index key, SQL Server allows only one clustered index per table. This results in amazing performance and the worry arises when you need to order the data by more than one column. Since we can’t use clustered index for multiple columns, a unclustered index is used to gain an increase in performance. We can specify a key value …

Database Optimization Techniques to Increase SQL SERVER Performance – Part I – Increase SQL Server stored procedure performance

1) Increase SQL Server stored procedure performance with following three tips: Stored procedures play a vital role in enhancing the performance of the database. The following three tips will help us to maximize database performance when stored procedures are used. Use NOCOUNT: If NOCOUNT option is turned off, on each operation: stored procedures returns information concerning the number of rows affected and it increases network overhead. By default, the Option NOCOUNT will be turned off.  If we turn …

4 SQL injection methods every PHP programmer should be aware of.

The Problem with all the codes is that the value is not sanitized before it will be sent as a query. All we need to make sure is that we are passing a secure data into the database. We can send secure data and prevent the data hacking by following the four prime SQL injection methods Function mysql_real_escape_string() : In PHP, we have a function to deal with strings in MYSQL. (Modified Content) Function: mysql_real_escape_string() Above function seize the …

Simplify Database admin with free MySQL tools

Briefed below are four MySQL tools that are really interesting, and you would like to review them and test them for better DB management experience. They do a fairly good job with the database admin management and good alternates to phpMyAdmin. 1. SQL Buddy: A tool that allows you to get more work done for less, the SQL Buddy tool though not very colorful and flashy, is very easy to navigate and fast loading as well. This saves a …