As a C programmer when we need to deal with multiple data elements of same type, we think of using array or linked list. Many times we scratch our head which data structure we should go for.. Though Array and linked list have many similarities, they are two fundamentally different data structures. Let’s see when … Continue reading “When to Prefer Linked List over Array in C?”
C Program to Implement a Singly Linked List
What is Singly Linked List? Linked List is a collection of interconnected nodes that together represent a sequence. Connected node means if you have access of a node, then you can get access to the next nodes even though they are not located in consecutive memory locations. For singly linked list, you can traverse the … Continue reading “C Program to Implement a Singly Linked List”
How to Access MySQL Database from C Program?
MySQL is an open sourcce database management system (DBMS). It is very popular among the web developers as it is part of LAMP (Linux, Apache, MySQL, PHP/Perl/Python) stack. Many popular large scale websites like WikiPedia, Facebook, Youtube use this database. Many times we need to use access MySQL database from C program. Here we’ll see … Continue reading “How to Access MySQL Database from C Program?”
SQL Query to Find Second Highest Salary
Finding the second highest salary from an employee table is a classic SQL problem the job seekers often face in their interview. Database programmers also have to solve similar problem like finding Nth highest number from a table. Finding the maximum salary from an Employee table is trivial. But finding the second highest is a tricky … Continue reading “SQL Query to Find Second Highest Salary”
How to Implement Periodic and Single Shot Timers in Linux?
In our program, we often need to do some tasks repeatedly with some time interval. We can think of a simple solution of having a loop with the actual task and a sleep().. The sleep() function can wait for some time and then we can call a function to do the task. Problem here is … Continue reading “How to Implement Periodic and Single Shot Timers in Linux?”