Category Archives: Database

How to prevent your application from SQL Injection?

Posted on May 13, 2012 by amol.ahirrao

Avoiding auto generated queries is best method to protect your application from SQL injection or you can use parametrized queries or stored procedures. For example, a login form has two basic form elements, a text box for accepting a user … Continue reading →

Posted in Database, Security | Tagged , | Leave a comment

MySQL storage engines

Posted on May 9, 2012 by harshal.kulkarni

MySQL supports the following the table types or storage engines: 1. ISAM 2. MyISAM 3. InnoDB 4. BerkeleyDB(BDB) 5. MERGE 6. HEAP While considering the table types you have to mainly focus on the following factors: 1. Transaction safe 2. … Continue reading →

Posted in MySQL | Tagged , , , , | Leave a comment

Database Indexing Techniques

Posted on April 26, 2012 by ranjit.bagul

Indexes are database objects associated with database tables and created to speed up access to data within the tables. Indexes are part of constraint mechanism. When we insert data in table and if a column has primary key constraint, then database checks … Continue reading →

Posted in Database | Tagged , , , | Leave a comment

A brief about MongoDB

Posted on April 25, 2012 by ranjit.bagul

Success of any application depends on database scheme. More normalized form of database leads to faster performance of application. To design database schema with normalization is not a piece of cake. Sometimes programmers need to change code according to change in requirement which changes … Continue reading →

Posted in Database | Tagged , , , | Leave a comment

Export MySQL Data in CSV File Through External URL

Posted on April 1, 2012 by pravin.sonawane

As you know, many of your clients need MySQL data stored on a daily, weekly or monthly basis from you. But if there is no option to share this data through web application or any other medium, then it will be … Continue reading →

Posted in Database, MySQL | Tagged , , , , , | Leave a comment

Delete/Truncate data from all Tables in SQL Server

Posted on March 18, 2012 by amol.ahirrao

We usually use a dummy database for testing. It gets filled with a lot of unwanted temporary data. At the time of deployment we replicate this database into Live Database. While doing so we need to delete all data from … Continue reading →

Posted in Database, MySQL | Tagged , , , | Leave a comment