DDNet Database SQL Interpreter

More serious discussions, information about official DDNet servers, important announcements.
User avatar
deen
Retired Administrator
Posts: 3384
Joined: Mon May 05, 2014 2:30 pm
Player profile: https://ddnet.tw/players/deen/

DDNet Database SQL Interpreter

Post by deen »

You can now run your own SQL queries against the official DDNet database in SQLite format: https://ddnet.tw/stats/sql.js/

Sample queries:

Code: Select all

select * from race order by Timestamp asc limit 30;
select * from race where Timestamp >= "2018-01-01" order by Timestamp asc limit 30;
select Mapper, count(*) from maps group by Mapper order by count(*) desc limit 30;
select Name, Map, count(*) from race group by Name, Map order by count(*) desc limit 30;
select sum(Points) from maps join (select distinct Map from race where Name = "nameless tee") as r on maps.Map = r.Map;
select Name, sum(Time)/3600 as "Time spent in all ranks (in hours)" from race group by Name order by sum(Time) desc limit 30;
select Map, Name, Time/60 as "Time (in minutes)" from race order by Time desc limit 30;
delete from race where Name = "deen";
Feel free to share your own queries here.
User avatar
Ryozuki
User
Posts: 1741
Joined: Tue Feb 24, 2015 7:28 am
Location: Catalonia
Player profile: http://ddnet.tw/players/Ryozuki/
Mapper profile: http://ddnet.tw/mappers/Ryozuki/
Clan: Unique
Website: https://edgarluque.com

Re: DDNet Database SQL Interpreter

Post by Ryozuki »

nice
User avatar
lola
User
Posts: 352
Joined: Thu Jan 04, 2018 10:23 pm
Location: France

Re: DDNet Database SQL Interpreter

Post by lola »

how this works?
GG Kid
User
Posts: 261
Joined: Sun Apr 16, 2017 2:33 am
Location: U.S.A.
Player profile: https://ddnet.tw/players/Bolto/
Clan: Kerger

Re: DDNet Database SQL Interpreter

Post by GG Kid »

lola wrote: Sat Apr 14, 2018 12:46 amhow this works?
lola it's "How does this work?". well here is a basic answerer; smart people who know programing/Coding stuff can now more easily get a (players) name statistics for there own use. it's not a very accurate description but it should get you A basic understanding.
Last edited by GG Kid on Sun Apr 15, 2018 11:15 pm, edited 1 time in total.
User avatar
lola
User
Posts: 352
Joined: Thu Jan 04, 2018 10:23 pm
Location: France

Re: DDNet Database SQL Interpreter

Post by lola »

GG Kid wrote: Sun Apr 15, 2018 4:18 am
lola wrote: Sat Apr 14, 2018 12:46 amhow this works?
lola it's "How does this work?". well here is a basic answerer; smart people who know programing/Coding stuff can now more easily get a (players) name statistics for there own use. it's not a very accurate description but it should get you A basic understanding.
So you mean I'm not smart? Oh thank you Mr. smart guy with BIG brain! :evil:
User avatar
Ryozuki
User
Posts: 1741
Joined: Tue Feb 24, 2015 7:28 am
Location: Catalonia
Player profile: http://ddnet.tw/players/Ryozuki/
Mapper profile: http://ddnet.tw/mappers/Ryozuki/
Clan: Unique
Website: https://edgarluque.com

Re: DDNet Database SQL Interpreter

Post by Ryozuki »

lola wrote: Sun Apr 15, 2018 2:20 pm
GG Kid wrote: Sun Apr 15, 2018 4:18 am
lola wrote: Sat Apr 14, 2018 12:46 amhow this works?
lola it's "How does this work?". well here is a basic answerer; smart people who know programing/Coding stuff can now more easily get a (players) name statistics for there own use. it's not a very accurate description but it should get you A basic understanding.
So you mean I'm not smart? Oh thank you Mr. smart guy with BIG brain! :evil:
You are just a faker and blocker. Thats all.
User avatar
lola
User
Posts: 352
Joined: Thu Jan 04, 2018 10:23 pm
Location: France

Re: DDNet Database SQL Interpreter

Post by lola »

Ryozuki wrote: Sun Apr 15, 2018 2:22 pm
lola wrote: Sun Apr 15, 2018 2:20 pm
GG Kid wrote: Sun Apr 15, 2018 4:18 am lola it's "How does this work?". well here is a basic answerer; smart people who know programing/Coding stuff can now more easily get a (players) name statistics for there own use. it's not a very accurate description but it should get you A basic understanding.
So you mean I'm not smart? Oh thank you Mr. smart guy with BIG brain! :evil:
You are just a faker and blocker. Thats all.
no u
User avatar
Lumpy ◐ω◑
User
Posts: 237
Joined: Wed Dec 16, 2015 10:53 am
Location: Russia, Ekaterinburg
Player profile: https://ddnet.tw/players/Lumpy-32--9680--969--9681-/

Re: DDNet Database SQL Interpreter

Post by Lumpy ◐ω◑ »

"Uncaught Error: no such table: race"
mhm
User avatar
lola
User
Posts: 352
Joined: Thu Jan 04, 2018 10:23 pm
Location: France

Re: DDNet Database SQL Interpreter

Post by lola »

Lumpy ◐ω◑ wrote: Mon Apr 16, 2018 1:28 pm "Uncaught Error: no such table: race"
mhm
omg... you broke it
User avatar
Lumpy ◐ω◑
User
Posts: 237
Joined: Wed Dec 16, 2015 10:53 am
Location: Russia, Ekaterinburg
Player profile: https://ddnet.tw/players/Lumpy-32--9680--969--9681-/

Re: DDNet Database SQL Interpreter

Post by Lumpy ◐ω◑ »

lola wrote: Tue Apr 17, 2018 12:09 am omg... you broke it
I was following the instructions :(
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests