Can I mass insert/edit phrases?

Yes, you can mass insert or edit phrases using any database editor that can handle SQLite databases.

Using a Database Editor

We recommend DB Browser for SQLite (free and open-source).

1. Close PhraseVault completely before editing
2. Download and install DB Browser for SQLite
3. In PhraseVault, go to "Help" > "Show Phrase Database File" to locate your database
4. Open the .sqlite file in DB Browser
5. Navigate to the "phrases" table to insert or edit entries
6. Save changes and reopen PhraseVault

Important: Always back up your database before making bulk changes!

Tip: Use AI Tools for Guidance

AI tools like ChatGPT can help you create SQL queries for bulk operations. Use this prompt to get started:

Sample prompt for ChatGPT:

I need help with bulk inserting phrases into my PhraseVault SQLite database. Here is the table structure:

CREATE TABLE "phrases" (
    "id" INTEGER,
    "phrase" TEXT,
    "expanded_text" TEXT,
    "type" TEXT DEFAULT 'plain',
    "usageCount" INTEGER DEFAULT 0,
    "dateAdd" DATETIME DEFAULT CURRENT_TIMESTAMP,
    "dateLastUsed" DATETIME DEFAULT CURRENT_TIMESTAMP,
    "short_id" TEXT,
    PRIMARY KEY("id" AUTOINCREMENT)
);

Please help me create INSERT statements for the following phrases: [describe your phrases here]

ChatGPT will generate the correct SQL statements that you can run in DB Browser for SQLite.