apsw: Another Python SQLite Wrapper
Discussion | hackernews | Author: tosh

#Databases

We solved SQLite's single-writer limitation
Discussion | hackernews | Author: marcobambini

#Databases

The BM25 Weighting Scheme
Discussion | hackernews | Author: ankitg12

#Databases

SQLite 3.54.0 Released
Discussion | hackernews | Author: thunderbong

#Databases

JSON Tiles: Fast Analytics on Semi-Structured Data (2021) https://lobste.rs/s/7mllxi #pdf #databases #performance

How shredding JSON is giving Logfire 1000x query speedups https://lobste.rs/s/6vjx1k #databases #performance

The latest update for #Devart includes "SecureBridge 12.1, EntityDAC 4.1, and dbExpress drivers: Support for RAD Studio 13 Florence Release 2, SQL Server 2025, and #MySQL 9.7".

#devops #databasetools #databases https://opsmtrs.com/3KjDrTB

567 - Managing the databases you put in Fabric makes sense. Managing every database you own from inside Fabric is a harder sell, and nobody's explained the why yet.

youtu.be/caiTPz9yaVI

#microsoftfabric #databases #dataplatform #powerbi

Consistency is not a localized property https://lobste.rs/s/rhy5zp #databases #programming #ai

"Architecting for Scale: Decoding SaaS Deployment Patterns and Database Strategies on AWS" by Gonzalo

#saas #architecture #databases #web-development #serverless

Chris van Eijk: infinite recursion detected in policy: causes and fixes
tech_blogs_planetscale

#Databases

SQLite 3.54 is out, with project benchmarks showing about 4% better CPU performance than the previous release on Linux.

The useful caveat: real-world gains depend on how a…

https://en.hacks.gr/sqlite-3-54-peripoy-7-5-tachytero-apo-tin-ekdosi-3-51-stis-dokimes-linux/

#SQLite #OpenSource #Databases

Christophe Pettus: All Your GUCs in a Row: parallel_setup_cost and parallel_tuple_cost
tech_blogs_planetscale

#Databases

Christophe Pettus: All Your GUCs in a Row: parallel_leader_participation
tech_blogs_planetscale

#Databases

Chris van Eijk: new row violates row-level security policy: the causes
tech_blogs_planetscale

#Databases

"Financial Data Modeling - The Event Sourcing Pattern" by Robert McCauley

#nosql #financial-services-industry #financial-services #databases #non-relational-database

Álvaro Hernández: Scaling Citus without limits: announcing Query Routers in StackGres
tech_blogs_planetscale

#Databases

Shaun Thomas: PG Phriday: Against the WAL
tech_blogs_planetscale

#Databases

Does normalisation survive data algebra? Mostly no, and that’s good news. When every fact is stored once as a couplet, the 1NF–5NF climb has nothing to fix. What’s left is a new question: when should you denormalise? #databases #datascience

robinbloor.substack.com/p/does-norma...

Using the Tidyverse with Databases (Part 2)

By Vebash Naidoo — Take your dbplyr skills further! This follow-up explores more advanced database interactions using tidyverse syntax in R.

🔗 Read here: buff.ly/UWl9rrP

More R resources 👉 buff.ly/tTCN5MD

#RStats #tidyverse #Databases 🚀