Créer un compteSe connecter

Recherches récentes

Aucune recherche récente

Options de recherche

Disponible uniquement lorsque vous êtes connecté.
pouet.chapril.org est l'un des nombreux serveurs Mastodon indépendants que vous pouvez utiliser pour participer au fédiverse.
Chapril https://www.chapril.org est un projet de l'April https://www.april.org

Administré par :

Statistiques du serveur :

1,1K
comptes actifs

pouet.chapril.org: À proposAnnuaire des profilsPolitique de confidentialité

Mastodon: À proposTélécharger l’applicationRaccourcis clavierVoir le code sourcev4.3.7

#sql

41 messages41 participants2 messages aujourd’hui
Public
Michael Simons

Today is rest day, in all dimensions.

So why not computing the administrative areas around the world I've visited while running and cycling with @duckdb #SQL and a bit of #Java

github.com/michael-simons/biki

Doing all the #spatial stuff directly from within the db, working on temp tables.

Eventually getting a deeply nested #JSON structure out of it:

github.com/michael-simons/biki

Thanks @lukaseder for inspiration, @hannes for that piece of tech :)

Database schema and Flask application for tracking mileages on bikes - michael-simons/biking3
GitHubbiking3/bin/collect_administrative_areas.java at main · michael-simons/biking3Database schema and Flask application for tracking mileages on bikes - michael-simons/biking3
Public
Marcos Dione

Not sure if I asked this before: Does anyone use anything in particular to inject #apache logs into #SQL databases? I have been looking around and asking around and the only solid I got was "do not expect an apache module for that; it would introduce too much latency to each request" in #httpd@libera.chat.

#SysAdmin#SRE
Public
avelino

Implementing SQL JOIN Support in ChronDB via PostgreSQL Protocol

The game of creating databases using #git internals continues
this week was the time to implement inner/left/right join in the #postgresql protocol

I tried to explain a little about the architecture implemented to perform joins

moclojer.com/blog/implementing

#sql #sql #opensource @opensource @foss

www.moclojer.comImplementing SQL JOIN Support in ChronDB via PostgreSQL ProtocolLearn how ChronDB, a Git-based database, now supports SQL JOIN operations through PostgreSQL protocol. This technical deep dive covers INNER JOIN and LEFT JOIN implementation, performance optimizations, and how to query related data across tables in a version-controlled database environment.
Public *
Python Rennes

[édition : la PEP a été validée le 10 avril. Merci @anthony]
une proposition d'évolution de #python (PEP) a été proposée pour ajouter le concept de t-string : peps.python.org/pep-0750/.

"t" pour #template, le concept ressemble beaucoup aux f-strings avec un découplage entre la création du template et l'intégration des valeurs à y mettre dedans. Cela permet notamment d'implémenter différentes vérifications et transformations de valeur pour éviter les risques d'injection #SQL ou #HTML par exemple

Python PEPs
Python Enhancement Proposals (PEPs)PEP 750 – Template Strings | peps.python.orgThis PEP introduces template strings for custom string processing.
Public
geraldew

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

ExplorerFlux en direct
À propos