Here's a practical, minimal guide for using GDB in Ubuntu terminal — from launching to setting breakpoints and navigating your code. 🧰 Step 1: Compile with Debug Symbols Use -g and disable optimizations ( -O0 preferred for debugging): bash Copy Edit g++ -g -O0 -o myprog myprog.cpp 🚀 Step 2: Launch GDB bash Copy Edit gdb ./myprog You'll see a (gdb) prompt. 🎯 Step 3: Set Breakpoints You can set breakpoints in three main ways : ✅ a. At a function gdb Copy Edit (gdb) break main ✅ b. At a specific file and line gdb Copy Edit (gdb) break myprog.cpp:42 ✅ c. At a method in a class gdb Copy Edit (gdb) break MyClass::doSomething If the symbol is mangled (C++), GDB usually demangles automatically, especially if compiled with -g . ▶️ Step 4: Run the Program gdb Copy Edit (gdb) run 🧠Step 5: Navigate Command Meaning next or n Step over current line step or s Step into function call finish Run until current function returns continue or c Continue until...
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
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.
- Installation on Ubuntu:sh
sudo apt update sudo apt install dbeaver
- Usage: Launch DBeaver from the application menu or by typing
dbeaver
in the terminal.
3. SQLiteStudio
- Description: SQLiteStudio is another open-source, user-friendly tool for SQLite databases.
- Features:
- Cross-platform with a focus on ease of use.
- No installation required, just download and run.
- Supports SQL editing, import/export, and visual table design.
- Installation:
- Download the latest version from the SQLiteStudio website and extract the files.
- Run the executable directly from the extracted folder.
4. TablePlus
- Description: TablePlus is a modern, native tool with a clean interface for managing multiple databases, including SQLite.
- Features:
- Supports multiple databases (SQLite, MySQL, PostgreSQL, etc.).
- Modern interface with code highlighting and data viewing.
- Quick access to query results and database structure.
- Installation: TablePlus offers a Linux version that you can download from their official website, though it might require a subscription for advanced features.
Summary
- DB Browser for SQLite and SQLiteStudio are specifically tailored for SQLite and provide a lightweight, focused experience.
- DBeaver and TablePlus are more general-purpose tools that support multiple database systems, making them ideal if you work with different databases.
These tools provide a user-friendly interface for managing SQLite databases, similar to pgAdmin for PostgreSQL or MySQL Workbench for MySQL.
Comments
Post a Comment
If you have any doubts, please let me know.