Supported Databases

DevDb Pro supports multiple database systems with full compatibility for browsing, editing, and exporting data.

Database Support

SQLite

Status: Fully Supported

Features:

• Full CRUD operations
• Schema viewer
• Data export (JSON, SQL)
• Zero-config for Laravel, Django, Rails

Connection Example:

{
  "type": "sqlite",
  "path": "/path/to/database.sqlite"
}

Common Use Cases:

• Local development databases
• Embedded databases
• Testing databases
• Mobile app databases

MySQL

Status: Fully Supported

Versions: 5.7+

Features:

• Full CRUD operations
• Schema viewer with indexes and constraints
• Data export (JSON, SQL)
• Query explainer (Laravel integration)
• Zero-config for Laravel, DDEV, Adonis

Connection Example:

{
  "type": "mysql",
  "host": "127.0.0.1",
  "port": "3306",
  "username": "root",
  "password": "secret",
  "database": "myapp"
}

Common Use Cases:

• Web application databases
• WordPress sites
• E-commerce platforms
• CMS systems

MariaDB

Status: Fully Supported

Versions: 10.3+

Features:

• Same as MySQL (MariaDB is MySQL-compatible)
• Full CRUD operations
• Schema viewer
• Data export (JSON, SQL)

Connection Example:

{
  "type": "mysql",
  "host": "127.0.0.1",
  "port": "3306",
  "username": "root",
  "password": "secret",
  "database": "myapp"
}

Note: Use "type": "mysql" for MariaDB connections.

PostgreSQL

Status: Fully Supported

Versions: 10+

Features:

• Full CRUD operations
• Schema viewer with advanced types
• Data export (JSON, SQL)
• JSONB support
• Array types support
• Zero-config for Laravel, Django, Rails, Adonis

Connection Example:

{
  "type": "postgres",
  "host": "localhost",
  "port": "5432",
  "username": "postgres",
  "password": "secret",
  "database": "myapp"
}

Common Use Cases:

• Modern web applications
• Data warehouses
• GIS applications (with PostGIS)
• Analytics platforms

Microsoft SQL Server

Status: Fully Supported

Versions: SQL Server 2017+

Features:

• Full CRUD operations
• Schema viewer
• Data export (JSON, SQL)
• Windows and SQL authentication
• Zero-config for Laravel

Connection Example:

{
  "type": "mssql",
  "host": "localhost",
  "port": "1433",
  "username": "sa",
  "password": "YourPassword123",
  "database": "master",
  "options": {
    "trustServerCertificate": true
  }
}

Common Use Cases:

• Enterprise applications
• .NET applications
• Legacy systems
• Windows environments

Data Type Support

Common Types

All databases support these common types:

• Integers: INT, BIGINT, SMALLINT
• Decimals: DECIMAL, NUMERIC, FLOAT, DOUBLE
• Strings: VARCHAR, CHAR, TEXT
• Dates: DATE, DATETIME, TIMESTAMP
• Boolean: BOOLEAN, BIT
• Binary: BLOB, BYTEA, VARBINARY

Database-Specific Types

PostgreSQL

• JSONB: Full support with formatting
• Arrays: Displayed as formatted strings
• UUID: Displayed as strings
• ENUM: Supported
• Geometric types: Displayed as strings
• Network types: INET, CIDR displayed as strings

MySQL/MariaDB

• JSON: Full support with formatting
• ENUM: Supported
• SET: Supported
• Spatial types: Displayed as text

SQL Server

• UNIQUEIDENTIFIER: Displayed as strings
• XML: Displayed with syntax highlighting
• HIERARCHYID: Displayed as strings

Connection Methods

Direct Connection

Connect directly to the database:

{
  "type": "mysql",
  "host": "127.0.0.1",
  "port": "3306",
  "username": "user",
  "password": "pass",
  "database": "db"
}

SSH Tunnel

For databases behind SSH:

1. Create tunnel: ssh -L 3307:localhost:3306 user@server
2. Connect to local port:

{
  "type": "mysql",
  "host": "127.0.0.1",
  "port": "3307",
  "username": "user",
  "password": "pass",
  "database": "db"
}

SSL/TLS

For encrypted connections:

{
  "type": "postgres",
  "host": "secure-db.com",
  "username": "user",
  "password": "pass",
  "database": "db",
  "options": {
    "ssl": {
      "rejectUnauthorized": true,
      "ca": "/path/to/ca.pem"
    }
  }
}

Platform Support

Operating Systems

OS	SQLite	MySQL	MariaDB	PostgreSQL	SQL Server
macOS	✅	✅	✅	✅	✅
Linux	✅	✅	✅	✅	✅
Windows	✅	✅	✅	✅	✅

Architectures

• x64 - Fully supported on all platforms
• ARM64 - Fully supported on macOS (Apple Silicon) and Linux
• ARM - Supported on Linux
• Alpine Linux - Supported (x64)

Framework Support

Zero-Config Frameworks

Framework	SQLite	MySQL	MariaDB	PostgreSQL	SQL Server
Laravel	✅	✅	✅	✅	✅
DDEV	N/A	✅	✅	✅	N/A
Django	✅	✅	✅	✅	❌
Ruby on Rails	✅	✅	✅	✅	❌
Adonis	❌	✅	✅	✅	❌

Limitations

SQLite

• No concurrent writes: Use for development only
• Limited ALTER TABLE: Some schema changes not supported
• No stored procedures: SQLite doesn't support them

MySQL/MariaDB

• Max packet size: Large BLOB/TEXT may need configuration
• Character encoding: Ensure UTF-8 for full character support

PostgreSQL

• Array editing: Arrays displayed but editing limited
• Complex types: Some custom types shown as text

SQL Server

• Authentication: Windows auth requires specific setup
• Case sensitivity: Depends on collation settings

Performance Considerations

Large Tables

For tables with millions of rows:

1. Use pagination - DevDb loads data in pages
2. Apply filters - Reduce result set
3. Index columns - For faster sorting/filtering
4. Consider views - Pre-filter data at database level

Network Latency

For remote databases:

1. Increase timeout in connection options
2. Use compression if supported
3. Consider VPN for better connectivity
4. Cache schema - DevDb caches schema information

Connection Pooling

DevDb manages connections efficiently:

• Auto-reconnect on connection loss
• Lazy loading of tables
• Resource cleanup when switching databases

Future Database Support

We're considering support for:

• MongoDB - Document database
• Redis - Key-value store
• Oracle Database - Enterprise database
• CockroachDB - Distributed SQL

Vote for databases you'd like to see at GitHub Discussions.

Next Steps

• Configuration - Set up database connections
• Zero-Config Discovery - Auto-configuration
• Database Client - Using the interface