Lightnews — Scholar-powered news

Alexander Güntert

@gntert.bsky.social

2K followers 1K following 200 posts

Data Dude, interested in Open Data / Science / History/ Public Transport https://github.com/alexanderguentert Working at @opendatazurich

github.com

Posts Media Videos Starter Packs

Pinned

Alexander Güntert @gntert.bsky.social · Nov 10

An alle, die an #OpenData in und aus der #Schweiz interessiert sind. Ich habe ein Starterpack erstellt. Alles tolle Leute. Folgt denen! Da ich nicht alle kenne, bitte gern unten reinschreiben, wen man noch ergänzen sollte 🙂
go.bsky.app/GRtmEja

1 4 15

Reposted by Alexander Güntert

Open Knowledge Foundation Deutschland e. V. @okfde.bsky.social · 3h

📣 Linked Open Data für Verwaltungen

Seit Jahren fordern Menschen aus der Community, dass öffentliche Daten nicht nur veröffentlicht, sondern verlinkbar und semantisch strukturiert bereitgestellt werden. Jetzt online: eine Checkliste für Akteur:innen, die Ähnliches planen.

🔗 okfn.de/blog/2025/10...

Checkliste Linked Open Data für Verwaltungen

Die Forderung nach mehr Linked Data aus der Verwaltung ist nicht neu und wird seit Jahren von Stimmen aus der CodeFor-Community und der OKF vorgetragen. Dennoch gibt es bislang nur wenige Beispiele, …

okfn.de

1 2 2

Reposted by Alexander Güntert

NetScience @netscience.bsky.social · 12d

Network Science, and three of its avengers, featured in the latest @veritasium.bsky.social video (one of the largest youtube channels for Science education)!! youtu.be/CYlon2tvywA?... @stevenstrogatz.com Duncan Watts @barabasi.bsky.social

Something Strange Happens When You Trace How Connected We Are

YouTube video by Veritasium

youtu.be

13 21

Alexander Güntert @gntert.bsky.social · 18d

Using print to debug 🫣

5 14

Alexander Güntert @gntert.bsky.social · 28d

Ohja, die waren toll!

Alexander Güntert @gntert.bsky.social · Sep 11

Yesterday, I had to install @postgresql.org and pgAdmin for a #DataEngineering training course and nearly went nuts because I couldn't connect pgAdmin to the local database. As it turned out, you always have to set a user password for this (which I didn't 🫣).

Alexander Güntert @gntert.bsky.social · Sep 11

I know that you're a keyboard aficionado, so I interpret that as: The keyboard is perfectly fine for the average user 😜

1 2

Alexander Güntert @gntert.bsky.social · Sep 11

Insane Setup 🤯. Are you Happy with the Case, Keyboard quality? I was thinking about a tuxedo Notebook years ago but got a refurbished ThinkPad instead, because I read the quality was better than tuxedo.

1 2

Reposted by Alexander Güntert

Simon Späti 🏔️ @ssp.sh · Sep 8

However, making money from open-source is hard, but I still hope that many will pursue this path. When deciding on a tool, I will always pick the open-source one.

To me, it builds trust, and because it's shared as a gift for anyone to use, it makes me want to support it more.

1 1 3

Alexander Güntert @gntert.bsky.social · Sep 2

Post-K-Pop, Love that!

Alexander Güntert @gntert.bsky.social · Sep 2

Nice! I Just updated my bucket list.

Alexander Güntert @gntert.bsky.social · Aug 26

Another great destination in the Aarhus area: Moesgaard Museum. Interesting exhibits from the #StoneAge to the #Vikings for the #Archeology nerds in the family (yes, that's me, but not only 😅). Also impressive modern Danish architecture again.

A staircase showing human Evolution with statues of different human species.

The famous Grauballe man, a bog body from the Iron age, found in Denmark.

1 2

Alexander Güntert @gntert.bsky.social · Aug 25

Today I visited Dokk1 in Aarhus, Denmark. It not only is a public library, it also has a great family area with all kinds of games and playgrounds. And on top there is a stunning view! Loved it!

Alexander Güntert @gntert.bsky.social · Aug 23

And the actual Job is ... [Checks notes] ... Excel

1 3

Alexander Güntert @gntert.bsky.social · Aug 22

Beaches and Bunkers in Hirtshals, Denmark.

Alexander Güntert @gntert.bsky.social · Aug 16

😂

Alexander Güntert @gntert.bsky.social · Aug 16

Go to: Settings - Languages

1 1

Reposted by Alexander Güntert

Florin Hasler @florihas.bsky.social · Aug 15

If you are a journalist, political scientist, developer or someone interested in #data on political affairs, parliamentary proceedings, political actors, decrees, etc., please test our #OpenAPI and give us feedback on your observations, any issues or missing options! ❤️opendata.ch/news/test-ou...

Test Our Open Parl Data API – Opendata.ch

46 cities. 26 cantons. 2 countries (🇨🇭🇱🇮). For a year, we have been collaboratively building our open API for harmonized parliamentary data to promote transparency, innovation and participation in Swiss politics. Our data infrastructure imports data from 74 national, cantonal and municipal parliaments (some APIs, mostly websites) and partially* cleans, harmonizes and publishes them openly

opendata.ch

2 4

Alexander Güntert @gntert.bsky.social · Aug 9

Thank you for sharing! You made some interesting points. I'm curious how your journey continues. I'm on Linux with my private notebook for 10 years now, but your requirements are higher than mine. I basically use standard Ubuntu.

1 1

Reposted by Alexander Güntert

Ustinoffs Hausgeist 🎃 @ustinoff.bsky.social · Aug 2

Hab Palantir Freeware installiert.

Schickt mal alle ein paar Namen.

6 3 35

Reposted by Alexander Güntert

Libby Heeren @libbyheeren.bsky.social · Jul 29

Don't go overestimating how much people know in comparison to you. We all know bits & pieces. No one knows it all. You have nuggets of knowledge that other people don't have. If you talk to those other people & share a little of what you know & listen, everyone benefits. You all get nuggets! #databs

3 2 29

Alexander Güntert @gntert.bsky.social · Jul 28

It's a CAS at @fhnw.ch www.fhnw.ch/de/weiterbil...

CAS Data Engineering

Nachhaltige und hochverfügbare Daten-Infrastrukturen On-Prem oder in der Cloud planen, aufbauen und überwachen

www.fhnw.ch

Alexander Güntert @gntert.bsky.social · Jul 28

Very cool, thank you! I'm doing a data engineering course in fall. Your resources will definitely be a helpful addition.

1 1

Alexander Güntert @gntert.bsky.social · Jul 27

@tobilg.com Is it possible to set some default SQL for @sql-workbench.com? Like sql-workbench.com/query=SELECT * FROM READ_CSV("...");? I have an idea to facilitate access to our #opendata.

SQL Workbench - Rapid prototyping SQL Queries & Data Visualizations

An online SQL Workbench based on DuckDB that can query and visualize remote CSV, JSON, Parquet and Arrow data, as well as local files.

sql-workbench.com

1 1 6

Alexander Güntert @gntert.bsky.social · Jul 23

Da bin ich heute auch vorbei geradelt 😀

Reposted by Alexander Güntert

Robert Seyfriedsberger @seyfro.at · Jul 22

Wer #OpenData als Transparenzspielerei abtut, verkennt die strategische Dimension: In einer datengetriebenen Gesellschaft entscheidet der Umgang mit Informationen über Effizienz, Fairness – und Milliarden. #GovTech #Digitalisierung #OpenByDefault 9/10

1 4 5