sqlite browser to take notes

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.