• Home
  • Technology
    • Ebullientech
    • Entrepreneurship
    • Video Technology
    • Cloud Computing
    • Business Analysis
  • Thoughts
    • Food
    • General
    • Stories
    • Places
    • Workplace
    • Social Issues
    • Reviews
  • Quotes
  • Ebullientech News and Events
  • About

Kamalika's Notebook

thinking nothing...............!!

Fetch DAFAULT Value from MySQL Table

September 16, 2014 By Kamalika Leave a Comment

Fetch DEFAULT value from MySQL table or MySQL get DEFAULT value for Column or How to SELECT DEFAULT value of a field or How Can I get back DEFAULT values for Column names in a MySQL Table.

We can fetch the column names in a MySQL Table fairly easily by the simple command:

[bash]

DESC tbl_admin_modules;

[/bash]DESC tablename MySQL

[Read more…]

Filed Under: MySQL, Technology Tagged With: Fetch DAFAULT Value from MySQL Table, How to SELECT DEFAULT value of a field, MySQL

How to Rename a Column in MySQL

September 15, 2014 By Kamalika Leave a Comment

If you have already created your MySQL database and table and suddenly realize that one or more table columns need to be modified, you can either drop / delete / remove the respective column and create new or you can alter the table. Altering of the table can be done using any MySQL GUI Tool / Editor like MySQL Query Browser (for Windows) or Sequel Pro (for Mac OSX) or using a MySQL ALTER TABLE Query. [Read more…]

Filed Under: MySQL, Technology Tagged With: How to rename a column in MySQL, MySQL, MySQL ALTER TABLE

Installing LAMP in Centos 6.3

May 20, 2013 By Kamalika Leave a Comment

LAMP is the abbreviation of Linux, Apache, MySQL, PHP. In this article I’ll try to explain how you can install an Apache2 webserver on a CentOS 6.3 server with PHP5 support (mod_php) and MySQL support. This approach should work if you start from scratch, i.e., the server has only CentOS 6.3 installed and nobody ever tried to install or configure LAMP!

Caution! This article is meant for those who rarely have to work on such projects when no expert advice / support available!  By no means this should be used by any Linux Pro.

Introduction

While deploying Centos 6.3 onto the server please put hostname as localhost, and don’t bind the server to any particular IP address.

Pages: 1 2 3 4 5

Filed Under: Apache, CentOS, CentOS 6.3, LAMP, Linux Servers, MySQL, PHP, Technology Tagged With: Apache, LAMP, Linux, MySQL, PHP

Architecting Scalable Systems for Cloud

February 28, 2013 By Kamalika 1 Comment

In my last post I asked whether “PHP is easy, is it a boon or bane?” because it is easy, most of the developers just develop systems but never pay attention to the architecture of the system on which they are developing. They never ask questions like “is the system stable?” or “will it be able to handle a lot of concurrent users?” or “is my code optimized enough for as the system required?” or “is the system that is holding my application and data designed well to ensure a better user experience?” or “is the system righteously architected / designed?”. Honestly I never asked myself a lot of these questions until I started working in Cloud Computing Environments, all that bothered me is the efficiency of my code, efficiency of my SQL queries, normalization status of my database, whether I need to de-normalize, finding solutions writing less numbers of lines of codes or single complex SQL JOIN queries, browser compatibility, etc, etc.

Encountering Cloud came as a shocker! I thought I knew fairly well about developing applications using LAMP stack, well I did know but what didn’t know was using LAMP stack on Cloud and what the architecture my cloud environment should have in order to sustain large volume of concurrent traffic. Also how should I write my SQL queries, how should I break a complex SQL query into multiple simple SQL queries and how should I complement complex database routines by PHP code. [Read more…]

Filed Under: Cloud Computing Tagged With: AWS, Cloud Architecture, Cloud Computing, EC2, Horizontal Scalability, LAMP, MySQL, PHP, Redundancy, Scalability, Scale Out, Scale Up, ScaleArc, ScaleBase, Vertical Scalability

Top 10 Common MySQL Mistakes Made By PHP Developers

February 19, 2013 By Kamalika Leave a Comment

Top 10 Common MySQL Mistakes Made By PHP Developers

The LAMP Stack

As per Wikipedia definition: LAMP is a solution stack of free, open source software. The acronym LAMP refers to the first letters of Linux (Operating System), Apache HTTP Server, MySQL (Database software), and PHP, Perl or Python, principal components to build a viable general purpose web server.

It is evident from the definition that Database is a fundamental component of most web applications. Even for developing static websites CMS software like WordPress, Joomla, Drupal are used all of which have a Database in the back end to store static content. If you are using PHP, Perl or Python then MySQL is an integral part of the development.

PHP is easy, is it a boon or bane?

PHP’s greatest strength has been its ease of use, any entry level programmer who has little bit knowledge of C Language and understands HTML / CSS / JavaScript to some extent can get a head start with PHP programming. But getting a head start does not ensure efficient completion of an expedition; it requires stability, fail safeness, sustainability & reliability. In order to write stable & reliable code along with building a solid, dependable, robust Database takes expertise and expertise comes from practice, experience & learning from mistakes. Here are 10 nasty mistakes I have seen PHP developers making quite often. [Read more…]

Filed Under: MySQL, PHP Tagged With: MySQL, MySQL Database, MySQL Mistakes, PHP & MySQL

  • 1
  • 2
  • Next Page »

Let’s connect…

  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
  • YouTube

Hello There…

I'm Kamalika, a techpreneur & startup mentor, blogger, hobbyist photographer, Netflix & Kindle indulgent, food connoisseur, Starbucks aficionado and former Disney employee ...next

Looking for something?

Tags

All in One SEO Pack AWS Banaras Blogger Blogging Blogs Creating Backup Schedule in RHEL 5 Dasaswamedh Ghat Ebullientech Ebullientech Interactive LLP Facebook Facebook Developers GeoTech GeoTech Informatics HipHop for PHP iPhone iPhone Apps Kamalika Guha Roy Kashi Ganga LAMP MindTwister MySQL Nabaneeta Guha Roy Online Marketing PayPal PayPal's suspension of Indian bank transactions Pentago PHP PHP & MySQL Saraswati Puja Search Engine Optimization SEO The Ganges TypePad UCO HUT UTV Indiagames Varanasi Web 2.0 Web 2.0 Design Web Design Web Marketing Website Design WordPress WordPress.COM WordPress.ORG

Timeline

  • 2020 (7)
  • 2019 (4)
  • 2018 (1)
  • 2015 (6)
  • 2014 (13)
  • 2013 (9)
  • 2010 (7)
  • 2009 (2)

Topics

Copyright © 2021 · Kamalika Guha Roy, Powered by Ebullientech Interactive LLP