Programming etc

sqlite browser to take notes

user1272047's photo
user1272047
·

2 min read

id.241221613.098734

Request.

I need a Linux software to insert in it several entry.

Every entry has several field, every field is a string.

When i search a sub string of a field of an entry, i get the entry.

You can use sqlitebrowser for this task. It allows you to create a SQLite database where you can define entries with fields (columns) as strings and perform substring searches.

Installation

Run the following command to install SQLite Browser on your Linux system:

sudo apt update && sudo apt install sqlitebrowser -y

Steps to Use SQLite Browser

  1. Open SQLite Browser with the command:

     sqlitebrowser

  2. Create a New Database:

    • Click New Database and name your database.

  3. Create a Table:

    • Define your fields (columns) as strings for each entry.

  4. Insert Entries:

    • Use the Browse Data tab to add entries manually or import them from a CSV file.

  5. Search for Substrings:

    • Use the Execute SQL tab to run a query like:

        SELECT * FROM table_name WHERE field_name LIKE '%substring%';

This approach is lightweight and allows efficient substring searches.

id.241221614.734892

Here are 2-3 Linux software interfaces that offer user-friendly database management with similar functionality:

1. dBeaver (Advanced Interface)

  • Description: A multi-platform database tool that supports various databases, including SQLite.

  • Features:

    • Easy insertion and filtering of records.

    • Visual query building and filtering.

    • Advanced table management tools.

  • Installation:

      sudo apt update && sudo apt install dbeaver -y

  • Website: https://dbeaver.io/

2. Kexi (Simple and Lightweight)

  • Description: Part of the KDE suite, Kexi is an open-source database application that resembles Microsoft Access.

  • Features:

    • User-friendly interface for adding and searching records.

    • Supports forms for better data input.

    • Good for small-scale projects.

  • Installation:

      sudo apt update && sudo apt install kexi -y

  • Website: https://kexi-project.org/

3. LibreOffice Base (Very Simple Interface)

  • Description: A component of LibreOffice, it is ideal for lightweight database management.

  • Features:

    • Create forms for easy record insertion.

    • Simple filtering options.

    • Built-in support for SQLite and other database formats.

  • Installation:

      sudo apt update && sudo apt install libreoffice-base -y

  • Website: https://www.libreoffice.org/

Recommendation

  • Use dBeaver for a professional, polished experience.

  • Use Kexi if you want a lightweight and efficient solution.

  • Use LibreOffice Base for simplicity and integration with the LibreOffice suite.

note-takingSQL