Results for "sql".

PostgreSQL Is Not Slow. Your Queries Are

PostgreSQL isn’t slow, your queries are. Learn the 7 real causes of slow database performance, from missing indexes and N+1 queries to lock contention and connection overload, with practical fixes.…

Deep Dive: How Keycloak 24 Manages 10k Users with PostgreSQL 17 and Redis 8.0

Keycloak 24’s default configuration chokes on 2k concurrent users—but with PostgreSQL 17 and Redis...…

Christophe Pettus: Managed Postgres, Examined: Amazon RDS for PostgreSQL

First in a series of dispassionate surveys of the major managed-Postgres offerings. This post is about Amazon RDS for PostgreSQL — what AWS calls “tr……

PExA: Parallel Exploration Agent for Complex Text-to-SQL

LLM-based agents for text-to-SQL often struggle with latency-performance trade-off, where performance improvements come at the cost of latency or vice versa. We reformulate text-to-SQL generation with…

I built an open-source SQL client with Flutter over the past 3 years

offline SQL injection vulnerability scanner in Python looking for honest feedback

# [Hiring] Fullstack Developer — Rust / TypeScript / PostgreSQL — licensed Social Media Platform — Berlin Hybrid — €50–80k + Equity

What 200 Concurrent Users Taught Me About SQLite Performance

I was about to release Autentico 2.0. The feature work was done, tests were passing, docs were...…

PostgreSQL and the OOM Killer: Why We Use Strict Memory Overcommit

SQL Tutorial is live

Learn Postgres and Drizzle ORM interactively…

I got tired of ad-heavy JSON & SQL formatters, so I built my own (100% Client-Side)

Hi everyone, Like most of you, I constantly need to format a messy JSON file, decode a JWT, or clean...…

Running SQLite in the browser with sql.js and WASM — a practical guide with Google Drive sync

Most tutorials on client-side data storage reach for IndexedDB, localStorage, or a third-party sync...…

The Monday Elephant #2: SQL Queries to List Users and Groups

Bahtiarbeck95 Gmail.com

Learn how to deploy PlanetScale Postgres and MySQL databases via Cloudflare and connect Cloudflare Workers.…

Behavioral Intelligence Platforms: From Event Streams to Autonomous Insight via Probabilistic Journey Graphs, Behavioral Knowledge Extraction, and Grounded Language Generation

Contemporary product analytics systems require users to pose explicit queries, such as writing SQL, configuring dashboards, or constructing funnels, before insights can surface. This pull-based paradi…

RCSB PDB AI Help Desk: retrieval-augmented generation for protein structure deposition support

Motivation: Structural Biologists have contributed more than 245,000 experimentally determined three-dimensional structures of biological macromolecules to the Protein Data Bank (PDB). Incoming data a…

The Best (Query) Plans of Mice and Men

Or rather, of elephants 🐘 and men. At $work, we use PostgreSQL a lot. So much in fact, that we tend to be paranoid frugal when adding even more stuff to it. In ……

Behind the Scenes of a Self-Evolving AI: The Architecture of Tian AI

Deep dive into Tian AI's architecture — three-layer thinking engine, 34GB SQLite knowledge base, self-modification system, and evolution engine.…

I Built an Open-Source Platform Foundation for Accounting-Centric Business Apps

A look at NGB Platform — an open-source .NET and PostgreSQL foundation for documents, catalogs, accounting, registers, audit history, reporting, and vertical business applications.…

FastOMOP: A Foundational Architecture for Reliable Agentic Real-World Evidence Generation on OMOP CDM data

The Observational Medical Outcomes Partnership Common Data Model (OMOP CDM), maintained by the Observational Health Data Sciences and Informatics (OHDSI) collaboration, enabled the harmonisation of el…

Pgbackrest is no longer being maintained

Reliable PostgreSQL Backup & Restore. Contribute to pgbackrest/pgbackrest development by creating an account on GitHub.…

Serving the For You feed

Serving the For You feed One of Bluesky's most interesting features is that anyone can run their own custom "feed" implementation and make it available to other users - effectively enabling custom alg…

russellromney/honker

russellromney/honker "Postgres NOTIFY/LISTEN semantics" for SQLite, implemented as a Rust SQLite extension and various language bindings to help make use of it. The design of this looks very solid. It…