DDraceNetwork - developer

bors[bot]

[ddnet:master] 2 new commits

5acf6e7 Fix spacing in HUD settings for 5:4 resolution - def- 959e65d Merge #4326 - bors[bot]

00:00

bors[bot]

[ddnet/ddnet] Pull request closed: #4326 Fix spacing in HUD settings for 5:4 resolution

https://www.righto.com/2020/06/a-look-at-die-of-8086-processor.html

A look at the die of the 8086 processor

The Intel 8086 microprocessor was introduced 42 years ago this month, 1 so I made some high-res die photos of the chip to celebrate. The ...

09:31

i found a funny site https://ipv6excuses.com/

does someone have a link to the mysql lib docs that ddnet uses?

09:58

https://dev.mysql.com/doc/refman/8.0/en/

09:58

i assume this?

ddnets sqlite handler kinda sux

Kinda sux is possibly an even worse bug report than "there is a problem"

Its just unhandly to use, not a bug report D;

hater

11:30

man i am searching forever but idk how to get the mysql equivalent of sqlite3_column_name any ideas?

11:30

I am trying to retrive the column name of the query at offset x

Column name of a query doesn't make sense

why not?

11:39

it works fine in sqlite

11:39

image.png

11:39

i want to retrive the string "Time" out of this query

Ah, you want the column names from the result set of the query?

yes

11:40

thats what sqlite3_column_name does just fine but i can not find the mysql equivalent

11:40

can we drop mysql? :D

yes, in favor of postgres

11:41

if we add that first

The google search you are looking for is "mysql result set metadata"

postgres is superior

11:43

im also for using postgres

in favor of sqlite3 :D

sqlite should be used only for prototyping at most

After all the things that broke in the last week I wouldnt think you all so bold :D

11:44

Don't even want to begin imagining how much everything would fall apart with a migration to postgres

Learath2

After all the things that broke in the last week I wouldnt think you all so bold :D

its not like we will migrate db rn

thanks good query @Learath2 :)

@Learath2 but arent most of our problems due to windows incompetence

11:44

and c++ friendliness with memory unsafety

11:44

Well the last mysql patch also broke quite a lot

well but imho it was a biggger rework

11:45

from what i've seen the code rn wouldnt be hard to port to postgres

11:45

but idk

The lack of unit and e2e testing in ddnet makes it very annoying to properly test before we release

we are missing testing

oh ye

but i need some postgres practice

what does ur practice entail

porting official ddnet servers to postgres sounds like good practice

haha

11:46

maybe we could even optimize some stuff postgres has plugins for time-series stuff

11:46

https://www.timescale.com/

Time-series data simplified

TimescaleDB is a time-series SQL database providing fast analytics, scalability, with automated data management on a proven storage engine.

11:47

yikes postgres

Horizontally scale to petabytes doesnt sound like something we need :D

1

Postgres handles concurrency better than MySQL for multiple reasons:

>

Postgres implements Multiversion Concurrency Control (MVCC) without read locks Postgres supports parallel query plans that can use multiple CPUs/cores Postgres can create indexes in a non-blocking way (through the CREATE INDEX CONCURRENTLY syntax), and it can create partial indexes (for example, if you have a model with soft deletes, you can create an index that ignores records marked as deleted) Postgres is known for protecting data integrity at the transaction level. This makes it less vulnerable to data corruption.

11:48

What would you want this for anyway? We dont really have time-series data. I guess the finishes maybe but those are so infrequent. Logs?

log everything

11:49

spy on the tees

Thats illegal

just put teehistorian into db instead of on filesystem

haha

(not serious)

today the way to say its a joke for non obvious jokes is /s

11:50

u need to modernize deen

11:50

teehistorian :D

will there be aday where teehistorian data is public

o gosh i hate reading docs send halp

chillerdragon

o gosh i hate reading docs send halp

well i would also hate reading that mysql crap docs

11:52

http://pqxx.org/development/libpqxx/#finding-everything

libpqxx: the official C++ language binding for PostgreSQL

None

yes please i need the teehistorian data to feed my teeworlds AI so it can learn better on how to cheat finishes axaxax

11:55

i dont feel like the docs are bad but in general i prefer examples like on stackoverdlow over docs

good docs should have examples

ye

and if your interface doesn't support short examples, you might have a bad interface (or overly complex software for some reason)

11:56

dafok is all this unique ptr magic do i have to use it or can i use normal pointers?

where

12:41

unique ptr is probs better

image.png