SQL Online IDE - Fast SQL Editor | SQL Compiler

SQL OnLine - SQLite, MariaDB / MySQL, PostgreSQL, MS SQL Server. AI error helper, User-friendly interface for Data Science. No registration for start, No DownLoad, No Install. | sql compiler, federated queries, BI Analytics

En bref

Ajouté le

17 mars 2026

Matière et domaine

computer-science-fundamentals · database-systems

Niveaux scolaires

9e année (3e)–12e année (Terminale)

Type de page

Tool

Mots-clés

sqlite sqlite online data science sqlite viewer sqlite editor sqlite manager sqlite browserselectinsertupdatedeletesql

Introduction

SQL Online IDE Features and Virtual Table Syntax

  • Remote Database Loading: Supports loading SQLite databases via URL (e.g., Chinook, NorthWind, Sakila).
  • Remote Script Execution: Supports loading and executing external SQL scripts via URL.
  • Virtual Tables: Enables querying external data sources directly using SQL via the CREATE VIRTUAL TABLE syntax.
  • Supported External Formats:
    • JSON: Supports both object arrays and arrays of arrays.
    • CSV: Supports custom skip rows, delimiters, and quoting.
    • Database Sources: Allows querying external databases using specific group names, DB names, and SQL queries.
    • History Sources: Allows querying historical data using UIDs and page numbers.
  • Federated Queries: Designed for performing queries across multiple APIs and datasets.
  • Technical Note: Virtual table functionality is currently limited to the SQLite demo environment.

Avis de la communauté

Pas encore d’avis publiés. Soyez le premier à partager votre expérience.