Blog - Mohit Kumar Gupta

To install the Apache HTTP Server on Ubuntu, you can follow these steps: 1. Update Your Package List First, update your package list to ensure you have the latest information on available packages: bash Copy code sudo apt update 2. Install Apache Next, install the Apache server with the following command: bash Copy code sudo apt install apache2 3. Start and Enable Apache Once installed, you may want to start Apache and enable it to start automatically on boot: bash Copy code sudo systemctl start apache2 sudo systemctl enable apache2 4. Check Apache Status You can check the status of the Apache service to ensure it is running: bash Copy code sudo systemctl status apache2 If Apache is running correctly, you should see a status that includes active (running) . 5. Test Apache Installation To confirm that Apache was installed and is running properly, open a web browser and enter your server’s IP address or localhost : bash Copy code http://localhost If everything is set up correctly, you s...

sudo apt udpate; sudo apt install libboost-all-dev

For viewing and managing SQLite databases, there are several GUI tools similar to pgAdmin, MySQL Workbench, or phpMyAdmin. Here are some popular ones: 1. DB Browser for SQLite Description: DB Browser for SQLite is a high-quality, open-source tool designed to create, design, and edit SQLite database files. Features: Visual database file creation, modification, and query execution. Import and export databases to and from SQL or CSV files. Simple and intuitive user interface. Installation on Ubuntu: sh Copy code sudo apt update sudo apt install sqlitebrowser Usage: After installation, you can launch it from the application menu or by typing sqlitebrowser in the terminal. 2. DBeaver Description: DBeaver is a free, open-source database management tool that supports a wide range of databases, including SQLite. Features: Supports many types of databases (SQLite, PostgreSQL, MySQL, etc.). Visual query builder, data editor, and SQL execution. ER diagrams and data visualization tools. Instal...

To install SQLite on Ubuntu, you can use the following commands: Update your package list: sh Copy code sudo apt update Install the SQLite command-line tool: sh Copy code sudo apt install sqlite3 Install the SQLite development libraries (optional, if you plan to develop applications using SQLite): sh Copy code sudo apt install libsqlite3-dev Verification After installation, you can verify that SQLite is installed correctly by checking the version: sh Copy code sqlite3 --version This should display the installed version of SQLite. Basic Usage Example To create a new SQLite database and interact with it via the command line: Create a new SQLite database: sh Copy code sqlite3 mydatabase.db Perform CRUD operations: Create a table: sql Copy code CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, email TEXT); Insert data: sql Copy code INSERT INTO users (name, email) VALUES ( 'John Doe' , 'john@example.com' ); Query data: sql Copy code SELECT * FROM users; Updat...

sudo apt update sudo apt install libgdbm-dev sudo apt install gdbmtool 

To interact with a GDBM (GNU Database Manager) database via the command line, you can use the gdbmtool utility, which is included with the GDBM package. This tool allows you to perform basic CRUD (Create, Read, Update, Delete) operations on a GDBM database directly from the terminal. Accessing GDBM via Command Line with gdbmtool Open a Terminal and Start gdbmtool : sh Copy code gdbmtool mydatabase.gdbm This will open the GDBM database named mydatabase.gdbm . If the file doesn't exist, it will be created. Basic Commands in gdbmtool : Insert/Create: sh Copy code store key value Example: sh Copy code store name "John Doe" store email "johndoe@example.com" Fetch/Read: sh Copy code fetch key Example: sh Copy code fetch name Output: Copy code John Doe Replace/Update: sh Copy code store key new_value Example: sh Copy code store email "john.doe@newdomain.com" Delete: sh Copy code delete key Example: sh Copy code delete name List all keys: sh Copy code firs...

 Here's a simple C++ program that demonstrates how to perform basic CRUD (Create, Read, Update, Delete) operations using GDBM (GNU Database Manager). This example will show how to store key-value pairs, retrieve them, update them, and delete them using the GDBM API. C++ Program with GDBM cpp Copy code # include <gdbm.h> # include <iostream> # include <cstring> class GDBMWrapper { public : GDBMWrapper ( const char * filename) { db = gdbm_open (( char *)filename, 512 , GDBM_WRCREAT, 0666 , 0 ); if (!db) { throw std:: runtime_error ( "Failed to open GDBM database" ); } } ~ GDBMWrapper () { if (db) { gdbm_close (db); } } void create ( const std::string& key, const std::string& value) { datum db_key = { ( char *)key. c_str (), ( int )key. size () }; datum db_value = { ( char *)value. c_str (), ( int )value. size () }; ...