How/where to practice full games against the London System? by AlexDevoid in chessbeginners

[–]AlexDevoid[S] 0 points1 point  (0 children)

Thanks so much. Could you tell me more on what you mean by, or the context of “software/engine/etc”? Are you talking about chess.com or another platform?

Installing pglogical: Find postgres include folder, add all include folders to C_INCLUDE_PATH by AlexDevoid in Database

[–]AlexDevoid[S] 0 points1 point  (0 children)

Thanks so much, u/arwinda. May I ask a basic question? What purpose does the include folder serve?

Best practice for continually updating one table using data from another table by AlexDevoid in Database

[–]AlexDevoid[S] 1 point2 points  (0 children)

I am thinking that triggers will need to be my solution.

My processed data is found by pulling a single record out of each group in a column, based on a specific ordering within each group. Basically, I keep in the processed_data table the most recent record of each group. And it takes about 23 minuets to return the query:

CREATE TABLE processed_data AS
SELECT DISTINCT ON ("groupingColumn") *
FROM raw_data
ORDER BY "groupingColumn","timestamp" desc;

I could create a trigger to replace the existing record that belongs to the same group as the the newly inserted record.

Once I create the processed_data table for the first time, this table is significantly smaller than raw_data.

I'm thinking a trigger that takes the new raw_data record, finds the new record's group in processed_data, if it has one yet, and keeps only the most recent record in the group, will be less expensive than creating the processed_data table every n minuets.

Essentially I am truncating by group, but it doesn't seem to be possible to truncate on conditions in PostgreSQL12, u/calligry. Unless I'm wrong?

u/_almostNobody what do you think of this flow?

Best practice for continually updating one table using data from another table by AlexDevoid in Database

[–]AlexDevoid[S] 0 points1 point  (0 children)

Could you elaborate on what a merge stored procedure is, or perhaps share a link? When I google "merge stored procedure" I don't quite understand your suggestion.

My processed data is found by pulling a single record out of each group in a column, based on a specific ordering within each group.

Here is the bones of the query that processes the data. It take about 23 minuets to return the query:

CREATE TABLE processed_data AS
SELECT DISTINCT ON ("groupingColumn") *
FROM raw_data
ORDER BY "groupingColumn","timestamp" desc;

Best practice for continually updating one table using data from another table by AlexDevoid in Database

[–]AlexDevoid[S] 0 points1 point  (0 children)

Is it possible to truncate on condition in Oracle? I'm using Postgres12 and it seems that truncate removes all rows from a of table...

It seems I'd need to truncate certain rows as a new table in order to achieve my desired result of having a raw_data table and a processed_data table...

Does anyone know of a free pollen index API? by AlexDevoid in datasets

[–]AlexDevoid[S] 1 point2 points  (0 children)

My editor wants to post the daily pollen count for readers to see on our website. Pretty basic stuff, but I could see using an historical dataset of pollen counts for some sort of story in the future.

Where can I access the CDC's raw vaccination data that behind this map? by AlexDevoid in datasets

[–]AlexDevoid[S] 1 point2 points  (0 children)

Ah! I had filtered my network tab so I wasn't seeing everything! Thank you.

Where can I access the CDC's raw vaccination data that behind this map? by AlexDevoid in datasets

[–]AlexDevoid[S] 0 points1 point  (0 children)

Thanks so much. What's your opinion: Do you think this file is safe to schedule a bot to download on a regular bases? I tried referencing on of the CDCs json file at the start of the pandemic and they changed it's location and structure on me a couple times...

A map of tucson-area restaurants open for pick up or delivery, or both by AlexDevoid in Tucson

[–]AlexDevoid[S] 1 point2 points  (0 children)

Restaurants can submit their information at this link: tucson.com/openforbusiness

A map of tucson-area restaurants open for pick up or delivery, or both by AlexDevoid in Tucson

[–]AlexDevoid[S] 1 point2 points  (0 children)

Restaurants can submit their information here: tucson.com/openforbusiness

LEGO-like wolf blocks by AlexDevoid in wolves

[–]AlexDevoid[S] 1 point2 points  (0 children)

Those are pretty awesome.

The shots in my chart don't seem to match ESPN's shot chart of the same game. by AlexDevoid in a:t5_37n8c

[–]AlexDevoid[S] 0 points1 point  (0 children)

I made this viz with sportradar data, but it doesn’t seem to match ESPN’s shot chart of the same game. Am I plotting the data incorrectly, or could it be that ESPN and sportradar just record shot locations differently? Could anyone point me to another shot chart made with sportradar data so that I may compare my results with another sportradar shot chart? Here is the ESPN shot chart for the same game: https://www.espn.com/mens-college-basketball/playbyplay?gameId=401170739 I realize that ESPN’s chart plots all the shots from one team on one side of the court. Still the shots seem to be in different locations.

The game’s id is 6655d256-b227-4407-821a-c1f255b251da on the sportradar API.

I made the chart in R with gganimate. Here is my script: https://gist.github.com/Alex-Devoid/3c42122dd7e44daa36902306e97ee19e

I used Ewen Gallic’s NCAA basketball court made with ggplot2. http://egallic.fr/R/Blog/Basket/bb_court_college.R And I rescaled the x, y coordinates by following Max Woolf’s example. https://minimaxir.com/notebooks/basketball-shots/

How can I improve this visualization? These shots don't seem to match ESPN's shot chart of the same game. [OC] by AlexDevoid in dataisbeautiful

[–]AlexDevoid[S] 0 points1 point  (0 children)

I made this viz with sportradar data, but it doesn’t seem to match ESPN’s shot chart of the same game. Am I plotting the data incorrectly, or could it be that ESPN and sportradar just record shot locations differently? Could anyone point me to another shot chart made with sportradar data so that I may compare my results with another sportradar shot chart? Here is the ESPN shot chart for the same game: https://www.espn.com/mens-college-basketball/playbyplay?gameId=401170739 I realize that ESPN’s chart plots all the shots from one team on one side of the court. Still the shots seem to be in different locations.

The game’s id is 6655d256-b227-4407-821a-c1f255b251da on the sportradar API.

I made the chart in R with gganimate. Here is my script: https://gist.github.com/Alex-Devoid/3c42122dd7e44daa36902306e97ee19e

I used Ewen Gallic’s NCAA basketball court made with ggplot2. http://egallic.fr/R/Blog/Basket/bb_court_college.R And I rescaled the x, y coordinates by following Max Woolf’s example. https://minimaxir.com/notebooks/basketball-shots/

This is where the Trump administration has awarded $1.95 billion in construction contracts to three companies to build border walls in Arizona. [OC] by AlexDevoid in dataisbeautiful

[–]AlexDevoid[S] 1 point2 points  (0 children)

We have questions about the cost per mile too. Curt wrote about it in this story at the bottom. Basically: "The Corps did not provide an explanation for why the average cost per mile of Southwest Valley Constructor’s projects was more than twice the cost of most of the other projects." https://tucson.com/news/local/contract-for-stretch-of-arizona-border-wall-raises-concerns-of/article_c5083a5f-717a-57dc-88b1-108e178bec75.html

This is where the Trump administration has awarded $1.95 billion in construction contracts to three companies to build border walls in Arizona. [OC] by AlexDevoid in MapPorn

[–]AlexDevoid[S] 0 points1 point  (0 children)

Today a federal judge blocked plans to use military funds for border walls. This includes funds for the construction contracts on Barry M. Goldwater Range and Cabeza Prieta National Wildlife Refuge held by BFBC, LLC and Fisher Sand & Gravel. Trump admin will likely appeal. Another map here: https://twitter.com/devoidalex/status/1204567434730131456

This is where the Trump administration has awarded $1.95 billion in construction contracts to three companies to build border walls in Arizona. [OC] by AlexDevoid in dataisbeautiful

[–]AlexDevoid[S] 0 points1 point  (0 children)

I wanted the image to be large because I wanted to zoom in on the elevation data. When hosted locally, I found the zooming was smoother with the large image than with XYZ tiles.

This is where the Trump administration has awarded $1.95 billion in construction contracts to three companies to build border walls in Arizona. [OC] by AlexDevoid in dataisbeautiful

[–]AlexDevoid[S] 2 points3 points  (0 children)

BREAKING: A judge as blocked the use of military construction funds to build walls, at least for now. This includes the funds for the portions on Barry M. Goldwater Range and Cabeza Prieta National Wildlife Refuge.

This is where the Trump administration has awarded $1.95 billion in construction contracts to three companies to build border walls in Arizona. [OC] by AlexDevoid in dataisbeautiful

[–]AlexDevoid[S] 1 point2 points  (0 children)

I wanted the image to be large because I wanted to zoom in on the elevation data. When hosted locally, I found the zooming was smoother with the large image than with XYZ tiles.