DDNet Database SQL Interpreter
Forum rules
Please consider wheter there is a more appropiate subforum before creating a new thread here.
This is for offical DDRaceNetwork-related information and discussion only.
Please consider wheter there is a more appropiate subforum before creating a new thread here.
This is for offical DDRaceNetwork-related information and discussion only.
- deen
- Posts: 3576
- Joined: Mon May 05, 2014 2:30 pm
- Player profile: https://ddnet.org/players/deen/
- Discord: deen#5910
DDNet Database SQL Interpreter
You can now run your own SQL queries against the official DDNet database in SQLite format: https://ddnet.tw/stats/sql.js/
Sample queries:
Feel free to share your own queries here.
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";
Re: DDNet Database SQL Interpreter
how this works?
-
- Posts: 266
- 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
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.
Re: DDNet Database SQL Interpreter
So you mean I'm not smart? Oh thank you Mr. smart guy with BIG brain!GG Kid wrote: ↑Sun Apr 15, 2018 4:18 amlola 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.
- Ryozuki
- Posts: 1748
- 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
- Discord: Ryozuki#2188
Re: DDNet Database SQL Interpreter
You are just a faker and blocker. Thats all.lola wrote: ↑Sun Apr 15, 2018 2:20 pmSo you mean I'm not smart? Oh thank you Mr. smart guy with BIG brain!GG Kid wrote: ↑Sun Apr 15, 2018 4:18 amlola 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.
Re: DDNet Database SQL Interpreter
no uRyozuki wrote: ↑Sun Apr 15, 2018 2:22 pmYou are just a faker and blocker. Thats all.lola wrote: ↑Sun Apr 15, 2018 2:20 pmSo you mean I'm not smart? Oh thank you Mr. smart guy with BIG brain!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.
- Lumpy ◐ω◑
- Posts: 243
- Joined: Wed Dec 16, 2015 10:53 am
- Location: Russia
- Player profile: https://ddnet.tw/players/Lumpy-32--9680--969--9681-/
Re: DDNet Database SQL Interpreter
"Uncaught Error: no such table: race"
mhm
mhm
Who is online
Users browsing this forum: No registered users and 5 guests