Connecting to SQLite from the command line

SQLite is a lightweight, serverless database engine. On ruachost.com, you can connect to SQLite databases directly from the command line using the sqlite3 program.

Why Use the Command Line?

• Quick and easy access to SQLite databases.
• Run SQL queries without needing a GUI.
• Useful for debugging, scripting, and development.

Steps to Connect to SQLite

Step 1: Log in via SSH

• Use SSH to connect to your hosting account:

ssh username@yourserver.ruachost.com

Step 2: Run the sqlite3 Command

• At the command line, type:

  sqlite3 example.db

• Replace example.db with the name of your database file.

• If the file does not exist, SQLite will create it.

• If the file exists, SQLite will open the database contained in it.

Step 3: Use SQLite Commands

Once inside the sqlite> prompt, you can run SQL queries and special commands:

• Show tables

  .tables

• View table structure

  .schema tablename

• List all commands

  .help

• Exit SQLite

.quit

Important Notes

• SQLite databases are stored as disk files, making them portable across systems.
• You can copy .db files between 32‑bit and 64‑bit systems without issues.
• Always back up your database file before making major changes.
• SQLite is transactional, ensuring data integrity even in case of crashes.