Data export and import

​

Exporting table data

​

CSV export

1. Open a table
2. Click Export → CSV
3. Choose options:
   • Include headers (recommended)
   • Delimiter (comma, semicolon, tab)
   • Quote character
4. File downloads automatically

id,name,email,created_at,status
1,John Doe,[email protected],2024-01-15 10:30:00,active
2,Jane Smith,[email protected],2024-01-16 14:22:00,active
3,Bob Johnson,[email protected],2024-01-17 09:15:00,inactive

​

JSON export

1. Open a table
2. Click Export → JSON
3. Choose formatting:
   • Compact: Minimal whitespace
   • Pretty: Indented and readable
4. File downloads automatically

[
  {
    "id": 1,
    "name": "John Doe",
    "email": "[email protected]",
    "created_at": "2024-01-15T10:30:00.000Z",
    "status": "active"
  },
  {
    "id": 2,
    "name": "Jane Smith",
    "email": "[email protected]",
    "created_at": "2024-01-16T14:22:00.000Z",
    "status": "active"
  }
]

​

Excel export

1. Open a table
2. Click Export → Excel
3. File downloads automatically as .xlsx

• Column headers in bold
• Proper data types (numbers, dates, booleans)
• Auto-sized columns
• Frozen header row

​

Query result export

1. Run your query in the Query Tool
2. Click Export in the results panel
3. Choose format (CSV, JSON, or Excel)
4. File downloads automatically

• Exporting filtered data
• Custom queries with JOINs
• Aggregated results
• Complex WHERE clauses

​

Encrypted backups

​

What’s backed up

• Server connections: Host, port, database, credentials
• Saved queries: All your saved SQL queries
• Query history: Recent query executions
• Notes: All notes and scratch pad content
• Settings: Application preferences
• UI state: Window layouts, selected tabs

​

Creating encrypted backups

1. Go to Settings → Backup & Restore
2. Click Create Backup
3. Choose backup type:
   • Full backup (.enc): Everything with encryption
   • Settings only (.json): No sensitive data
4. Enter encryption password (for full backup)
5. Click Create Backup
6. Save the .enc or .json file

• Algorithm: AES-256-GCM
• Key derivation: PBKDF2 with 100,000 iterations
• Salt: Random 32-byte salt per backup
• Authentication: Built-in with GCM mode

​

Backup file structure

{
  "version": "1.0",
  "encrypted": true,
  "algorithm": "AES-256-GCM",
  "salt": "<base64-encoded-salt>",
  "iv": "<base64-encoded-iv>",
  "data": "<encrypted-payload>",
  "created": "2024-03-15T10:30:00.000Z"
}

{
  "version": "1.0",
  "encrypted": false,
  "settings": {
    "theme": "dark",
    "autoLockTimeout": 30,
    "queryHistoryLimit": 100
  },
  "created": "2024-03-15T10:30:00.000Z"
}

​

Restoring backups

1. Go to Settings → Backup & Restore
2. Click Restore from Backup
3. Select your .enc or .json file
4. Enter decryption password (for .enc files)
5. Choose what to restore:
   • ☑ Server connections
   • ☑ Saved queries
   • ☑ Query history
   • ☑ Notes
   • ☑ Settings
6. Click Restore

​

Restore strategies

• Moving between computers but keeping local settings
• Sharing connection configs without history
• Recovering just your saved queries

• Merge (default): Combines backup with existing data
• Replace: Clears existing data first, then restores

​

Migration scenarios

​

Moving to a new computer

1. On old computer:
   • Create full encrypted backup
   • Save to cloud storage or USB drive
2. On new computer:
   • Open Poge
   • Complete first-time setup
   • Restore from backup

​

Sharing connection templates

1. Create settings-only backup (.json)
2. Share the JSON file (no encryption needed)
3. Team imports the file
4. Each person enters their own passwords

​

Browser migration

1. Create full backup before switching
2. Open Poge in new browser
3. Restore from backup
4. All data and settings return

​

Importing data into tables

1. Open the target table in Table Viewer
2. Click Import Data
3. Select your CSV or JSON file
4. Map columns:
   • Match source columns to table columns
   • Choose default values for missing columns
   • Skip columns you don’t want to import
5. Choose import mode:
   • Insert: Add new rows
   • Upsert: Update existing rows or insert new ones
   • Replace: Clear table first, then insert
6. Click Import

​

Import validation

• Data types: Ensures values match column types
• Constraints: Checks primary keys, foreign keys, and unique constraints
• Required fields: Verifies NOT NULL columns have values
• Formatting: Parses dates, numbers, and booleans

​

Large data exports

​

Chunked exports

1. Use query filters to export in batches:

-- Export users created in January
SELECT * FROM users 
WHERE created_at >= '2024-01-01' 
  AND created_at < '2024-02-01';

2. Export each month separately
3. Combine files later if needed

​

Streaming exports

COPY (SELECT * FROM large_table) 
TO '/tmp/export.csv' 
WITH (FORMAT CSV, HEADER);

​

Automation

// Example using Puppeteer
const puppeteer = require('puppeteer');

(async () => {
  const browser = await puppeteer.launch();
  const page = await browser.newPage();
  
  await page.goto('https://poge.dev');
  // Navigate to Settings → Backup & Restore
  // Click Create Backup
  // Handle download
  
  await browser.close();
})();

​

Next steps