Tutorial completo em 5 minutos Acesse Banco SQLite React Native

1. Instalar Flipper:

2. Plugin SQLite:

3. Configurar no código:

import {flipperDatabasesPlugin} from 'flipper-plugin-databases';

// No seu database helper
if (__DEV__) {
  flipperDatabasesPlugin(db, 'MyAppDB');
}

1. Abrir Organizer:

2. Selecionar Simulator:

Escolha o simulador ativo → Installed Apps

3. Download Container:

Selecione sua app → Download Container

Listar todas as tabelas:

Schema de uma tabela:

Tamanho do banco:

Índices existentes:

Estatísticas de tabela:

Query plan:

Verificar login ativo:

SELECT 
  id, username, token, 
  datetime(last_login, 'unixepoch') as last_login_formatted
FROM users 
WHERE token IS NOT NULL 
  AND token != '';

Sessões expiradas:

SELECT 
  COUNT(*) as expired_sessions
FROM user_sessions 
WHERE expires_at < datetime('now');

Cache válido:

SELECT 
  key, 
  datetime(expires_at, 'unixepoch') as expires,
  length(data) as size_bytes
FROM cache 
WHERE expires_at > strftime('%s', 'now')
ORDER BY expires_at DESC;

Limpeza de cache:

DELETE FROM cache 
WHERE expires_at < strftime('%s', 'now');

Dados pendentes de sync:

SELECT 
  table_name,
  operation,
  COUNT(*) as pending_count,
  MIN(datetime(created_at, 'unixepoch')) as oldest_pending
FROM sync_queue 
WHERE status = 'pending'
GROUP BY table_name, operation;

Falhas de sincronização:

SELECT 
  id, table_name, operation, error_message,
  datetime(last_attempt, 'unixepoch') as last_attempt,
  retry_count
FROM sync_queue 
WHERE status = 'failed'
ORDER BY last_attempt DESC;

Conteúdo offline disponível:

SELECT 
  content_type,
  COUNT(*) as items_count,
  SUM(length(data)) as total_size_bytes,
  MIN(datetime(downloaded_at, 'unixepoch')) as oldest_download
FROM offline_content 
GROUP BY content_type;

Limpeza de dados antigos:

DELETE FROM offline_content 
WHERE downloaded_at < strftime('%s', 'now', '-7 days')
  AND content_type = 'cache';