livellosegreto.it is one of the many independent Mastodon servers you can use to participate in the fediverse.
Livello Segreto è il social etico che ha rispetto di te e del tuo tempo.

Administered by:

Server stats:

1.2K
active users

#sql

35 posts35 participants6 posts today

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.

New problem, new library! This time, I made a small utility for Laravel to limit a group of models on the table.

github.com/Laragear/Capstone

I talked about the implementation on my Medium blog, but in a nutshell, it uses a subquery to keep only the records you don't want to delete, like the latest five.

Limit the number of model records by amount or date. - Laragear/Capstone
GitHubGitHub - Laragear/Capstone: Limit the number of model records by amount or date.Limit the number of model records by amount or date. - Laragear/Capstone