Home Assitent – deye microinverter

GitHub – Hypfer/deye-microinverter-cloud-free: Documentation and tooling to use Deye microinverters without the solarman cloud

GitHub – StephanJoubert/home_assistant_solarman: Home Assistant component for Solarman collectors used with a variety of inverters.

GitHub – kbialek/deye-inverter-mqtt: Reads Deye solar inverter metrics and posts them over mqtt

VZLOGGER:

GitHub – markussiebert/homeassistant-addon-vzlogger: vzlogger as addon for homeassistant supervisor

GitHub – volkszaehler/vzlogger: Logging utility for various meters & sensors

SmartMeter ist „freigeblinkt“:

vzlogger ohne middleware: „api“:“null“

The Digital Antiquarian – filfre.net

The Digital Antiquarian (filfre.net)



e.g. read about » Elite (or, The Universe on 32 K Per Day) The Digital Antiquarian (filfre.net)

A universe in 32 K, an icon of British game development, and the urtext of a genre of space-combat simulations, the sheer scope of David Braben and Ian Bell’s game of combat, exploration, and trade can inspire awe even today.

» Hall of Fame The Digital Antiquarian (filfre.net)

The best graphic adventure ever made for the Commodore 64 and the starting point of the LucasArts tradition of saner, fairer puzzling, this intricately nonlinear and endlessly likable multi-character caper deserves a spot here despite a few rough edges.

» A New Force in Games, Part 3: SCUMM The Digital Antiquarian (filfre.net)

In this video Scott and Mark use Copilot to create a asteroid game

https://build.microsoft.com/en-US/sessions/e9568a77-7cf7-451e-a14b-a347313b2494?source=/favorites

GitHub Copilot is a powerful AI tool that helps you write code faster and better. Join Scott Hanselman and Mark Russinovich as they use GitHub Copilot to create a fun and interactive application from scratch. You will learn how LLMs that power GitHub Copilot work under the cover, LLM capabilities and limitations, and the difference between finetuning and prompt engineering. Whether you are a beginner or an expert, it will inspire you to explore new possibilities with GitHub Copilot and LLMs

A python package that gives you easy access to the most valuable datasets of Germany

https://github.com/bundesAPI/deutschland

https://github.com/bundesAPI

Auf dem API-Portal des Bundes und hier auf GitHub.com/bundesAPI finden Sie Dokumentationen zu Programmierschnittstellen von Verwaltungsleistungen und Informationsportalen des Bundes. Die Dokumentionen liegen idR. im API-Dokumentationsformat OpenAPI 3 vor und sind insofern sowohl menschen- als auch maschinenlesbar.

Momentan finden sich auf bund.dev bereits Dokumentationen zu mehr als 30 Programmierschnittstellen – wobei die Zahl online verfügbarer und dokumentierbarer Schnittstellen aufgrund des „Gesetzes zur Änderung des E-Government-Gesetzes und zur Einführung des Gesetzes für die Nutzung von Daten des öffentlichen Sektors“ (2. Open-Data-Gesetz) bis 2024 stark anwachsen wird.
https://de.wikipedia.org/wiki/Lilith_Wittmann

SourceGrid

SourceGrid is a free open source grid control. Supports virtual grid, custom cells and editors, advanced formatting options and many others features SourceGrid is a Windows Forms control written entirely in C#, goal is to create a simple but flexible grid to use in all of the cases in which it is necessary to visualize or to change a series of data in a table format. There are a lot of controls of this type available, but often are expensive, difficult to be customize or not compatible with .NET. SourceGrid allows users to have customizable datasource which is not in DataSet format.

Free Controls: https://www.syncfusion.com/products/communitylicense

Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL

https://trino.io

Trino is a highly parallel and distributed query engine, that is built from the ground up for efficient, low latency analytics.

Access data from multiple systems within a single query. For example, join historic log data stored in an S3 object storage with customer data stored in a MySQL relational database.

https://github.com/andreas5588/trino

Open Source Data Quality and Profiling download | SourceForge.net

31 Data lineage tools – DBMS Tools

Ultorg: General-Purpose, User-Friendly Database Software

Intersystems IRIS \ Docker \ Openflights Dataset

Some links about the topic from title

https://github.com/andreas5588/openflights_dataset

https://community.intersystems.com/post/using-docker-container-group-iris-openflights-dataset-and-apache-zeppelin

https://community.intersystems.com/post/tips-and-tricks-brand-new-load-data-command

https://hub.docker.com/r/andreasschneiderixdbde/openflights-iris-zeppelin

https://hub.docker.com/r/andreasschneiderixdbde/openflights-iris

https://openexchange.intersystems.com/package/openflights_dataset

https://www.kaggle.com/datasets/sherrytp/airline-delay-analysis/code

The Million Song Dataset Challenge aims at being the best possible offline evaluation of a music recommendation system
https://www.kaggle.com/c/msdchallenge/overview

https://www.sqlservercentral.com/articles/departures-from-origins-and-arrivals-at-destinations

Do you want to query complex data structures in an iterative way? Do you have access to hierarchical data structures that need to be queried? This course will teach you the tools required to solve these questions. You will learn how to write recursive queries and query hierarchical data structures. To do this, you will use Common Table Expressions (CTE) and the recursion principle on a wide variety of datasets. You will, for example, dig into a flight plan dataset and learn how to find the best and cheapest connection between two airports. After completing this course, you will understand the principle of recursion, and be able to identify and create hierarchical data models.

https://www.datacamp.com/courses/hierarchical-and-recursive-queries-in-sql-server

This article aims at showing good practices on how to retrieve data with SQL using practical examples on the data above. The following topics are covered:

  • operations on columns
  • most common joins
  • aggregations and window functions
  • tips to handle complex queries

https://www.mit.edu/~amidi/teaching/data-science-tools/tutorial/queries-with-sql/

Have you ever wondered about the differences between a subquery and a common table expression (CTE) in SQL? The concepts seem very similar, but knowing the difference – and when to use each one – will help you write efficient and readable queries.

https://learnsql.com/blog/sql-subquery-cte-difference/