add batch
remove batch
split batch
comment selection
show hidden batches
hide batch
highlight batch
db<>fiddle
Db2
Firebird
MariaDB
MySQL
Node.js
Oracle
Postgres
SQLite
SQL Server
TimescaleDB
YugabyteDB
Developer-C 11.1
3.0
4.0
10.2
10.3
10.4
10.5
10.6
10.7
10.8
10.9
5.5
5.6
5.7
8.0
18
11g Release 2
18c
21c
23c
8.4
9.3
9.4
9.5
9.6
10
11
12
13
14
15
16
3.8
3.16
3.27
3.39
2012
2014
2016
2017
2017 (Linux)
2019
2019 (Linux)
2022
2.11
2.6
2.8
2.18
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
Sakila
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
AdventureWorks
no sample DB
no sample DB
AdventureWorks
no sample DB
no sample DB
no sample DB
no sample DB
run
markdown
donate
feedback
about
By using db<>fiddle, you agree to license everything you submit by
Creative Commons CC0
.
create table forum_posts( id int identity primary key, created_at datetime2 not null, msg nvarchar(max) not null, scrape_time datetime2 not null default current_timestamp ); create table fish_forum_posts( id int primary key references forum_posts(id) on update cascade on delete cascade, -- Delete this if it's in the same sequence as the other fora post_id int unique not null, reply_count int not null check(reply_count >= 0), reply_to_post_number int references fish_forum_posts(post_id) -- Needed to avoid cascade cycles on update no action on delete no action ); create table golf_forum_posts( id int primary key references forum_posts(id) on update cascade on delete cascade, -- Delete this if it's in the same sequence as the other fora post_id int unique not null, profile_id int not null, like_count int not null check(like_count >= 0) ); create table models( id int identity primary key, name nvarchar(256) unique not null ); create table preprocessed_posts( id int primary key references forum_posts(id) on update cascade on delete cascade, prediction nvarchar(256) not null, confidence decimal(12, 4) not null check (confidence between 0 and 1), model int not null references models(id) on update cascade on delete cascade );