nrw.social ist einer von vielen unabhängigen Mastodon-Servern, mit dem du dich im Fediverse beteiligen kannst.
Wir sind eine freundliche Mastodon Instanz aus Nordrhein-Westfalen. Ob NRW'ler oder NRW-Sympathifanten, jeder ist hier willkommen.

Serverstatistik:

2,9 Tsd.
aktive Profile

#SQL

41 Beiträge41 Beteiligte9 Beiträge heute

Back on tech matters, lately I've been revisiting the Mahalanobis distance.

I had an intention ten years ago to seek an SQL method for deriving it, but it never became pressing enough, and the process using it - via an external call out - was only once once annually.

Returning to the same process ten years later, I've dug a little deeper and found that the callout had only been doing on each separate "variable" - and was thus equivalent to doing each as a simple "z-score".
#SQL #mathstodon

Can we standardize on a #query language for #observability?
It's probably going to end up with good-old #SQL 😁

I shared my notes from last week's #KubeCon EU talk about the #CNCF 's working group that looks into observability query language standardization.
linkedin.com/feed/update/urn:l

www.linkedin.com#query #observability #kubecon | Dotan Horovits 🇮🇱🎗Can we standardize on a #query language for #observability? It's probably going to end up with good-old SQL 😁 The Cloud Native Computing Foundation (CNCF) has a working group (WG) looking into observability query language standardization. They gave a fascinating talk last week at #KubeCon Europe. The group, led by Christopher Larsen of Netflix and Vijay Samuel of eBay, has done a comprehensive research among end users and DSL (domain specific languages) designers, to understand what's out there and what works. A very interesting conclusion is that relational approach with an SQL-like language is the best path. Why? because we should recognize that DevOps and SREs are no longer the main folks querying observability data. we need to cater for developers, data scientists, platform engineers and more. You see also the data analytics community moving back to SQL after the hype of NoSQL. Ultimately, SQL is a common language. And don't worry, the idea is to adapt it to time series, and some syntactic sugaring to make it more intuitive. For more background on the working group: https://lnkd.in/d_m6eUbY And check out the semantic specification draft and chime in with your comments: https://lnkd.in/dTf3ijeV Credits to Chris Larsen (WG lead), Alolita S. (Apple, TAG co-chair) and 🇨🇭🇧🇷Pereira Braga (Google) for the interesting talk and for pushing the WG forward.

Question, my colleague want's a small database with only a few tables ( #Mariadb / #mysql #sql ) - Data pushed with PowerShell Scripts

He also wants a small Web UI to search in this database with "basic" filtering

I've found #Adminer (adminer.org/de/) which looks simpler then things like phpMyAdmin

Is this a good choice ? thx

www.adminer.orgAdminer - Datenbank-Verwaltung in einer einzigen PHP-Datei Adminer ist für: MySQL, MariaDB, PostgreSQL, CockroachDB, SQLite, MS SQL, Oracle. Andere per Plugin verfügbar: Elasticsearch, SimpleDB, MongoDB, Firebird, Clickhouse.