DDNet Database SQL Interpreter

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

DDNet Database SQL Interpreter

Post by deen » Fri Apr 13, 2018 7:04 pm

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: 1693
Joined: Tue Feb 24, 2015 7:28 am
Location: Catalonia
Player profile: Ryozuki
Mapper profile: Ryozuki
Clan: Unique

Re: DDNet Database SQL Interpreter

Post by Ryozuki » Fri Apr 13, 2018 7:51 pm

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 » Sat Apr 14, 2018 12:46 am

how this works?

GG Kid
User
Posts: 201
Joined: Sun Apr 16, 2017 2:33 am
Location: U.S.A.
Player profile: Bolto
Clan: Kerger

Re: DDNet Database SQL Interpreter

Post by GG Kid » Sun Apr 15, 2018 4:18 am

lola wrote:
Sat Apr 14, 2018 12:46 am
how 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 » 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 am
how 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: 1693
Joined: Tue Feb 24, 2015 7:28 am
Location: Catalonia
Player profile: Ryozuki
Mapper profile: Ryozuki
Clan: Unique

Re: DDNet Database SQL Interpreter

Post by Ryozuki » 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 wrote:
Sat Apr 14, 2018 12:46 am
how 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 » Sun Apr 15, 2018 2:23 pm

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: 214
Joined: Wed Dec 16, 2015 10:53 am
Location: Russia, Ekaterinburg
Player profile: Lumpy ◐ω◑

Re: DDNet Database SQL Interpreter

Post by Lumpy ◐ω◑ » Mon Apr 16, 2018 1:28 pm

"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 » Tue Apr 17, 2018 12:09 am

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: 214
Joined: Wed Dec 16, 2015 10:53 am
Location: Russia, Ekaterinburg
Player profile: Lumpy ◐ω◑

Re: DDNet Database SQL Interpreter

Post by Lumpy ◐ω◑ » Tue Apr 17, 2018 7:30 am

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