Login

Recent searches

No recent searches

Search options

Not available on mastodon.xyz.
mastodon.xyz is one of the many independent Mastodon servers you can use to participate in the fediverse.
A Mastodon instance, open to everyone, but mainly English and French speaking.

Administered by:

Server stats:

812
active users

mastodon.xyz: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.4

#sql

43 posts42 participants3 posts today
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 :)

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

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.
ExploreLive feeds
About