Auto-aggregated global tech articles · 71 posts
Originally published on tamiz.pro. You feed two names into a matching engine and get a similarity score. Easy enough. But what happens when two strings look nothing alike yet mean the same thing — or look nearly identical but mean completely different things? This isn't a hypothetical. When we ran
This is a submission for Weekend Challenge: Generosity Edition What I Built Generosity has a targeting problem. Money follows attention, attention follows disasters, and disasters get covered where the cameras already are. The places that quietly need the most are often the places nobody
Here is a story [1] about the first version of B-link optimization for Innodb that is the most used B-tree engine in MariaDB. It started from a sketch on a chocolate wrapper and after some attempts ended up with significant p95 improvement for certain B-tree operations. Thx Zhao Song for his work in
Background : In migration projects involving different databases, incompatibility of SQL syntax is often encountered. Question : If there is a large amount of code that needs to be rewritten, manual processing would be time-consuming and prone to errors. Is it possible to achieve automatic conversi
pg_anon found 1 of the 8 personal-data columns in my PostgreSQL database. The one it caught was email, and only because "email" is spelled the same in Spanish and English. The other seven — nombre, apellido, telefono, direccion, fecha_nac, tarjeta_ult4 and rut — walked straight through, unmasked.
Originally published at nlocoding.com 41% of enterprise database engineers already use AI tools daily to generate, optimize, or review SQL—up from just 14% in 2023 (Gartner, 2026). The new database arms race is invisible. Enterprises process 7.4x more data per person than they did five years ag
1. TL;DR & Problem Statement Definition: A fully managed database service providing automated provisioning, high availability, patching, backups, and horizontal read scalability for relational engines (PostgreSQL, MySQL, MariaDB, Oracle, SQL Server, and Amazon Aurora). Problem Solved: Elimi
The bug report that has no bug Someone got charged twice for one order. The report lands with a screenshot and an angry emoji, and you start pulling threads expecting to find the broken line of code that did it. You won't find it. The payment service is fine. The tests pass. The review was thoro
For a few weeks I ran a proper multi-agent orchestrator. The concept was right, and I still think the people building those tools are pointed the correct way. But the bill was absurd, and it took me a while to work out why. It wasn't the coding. It was the talking about the coding. Every turn, age
You sit down Friday with one messy GitHub issue. You want a usable plan before Monday morning. You paste the text into a chat agent. The reply looks polished, complete, and very sure. It adds Kafka, Redis, and a new auth service. The issue never named those systems. You do not have a brownfield bu
Il problema: SQL non e uno standard unico Sulla carta, SQL e uno standard. Nella pratica, ogni database parla il suo dialetto. MySQL usa i backtick per quotare gli identificatori, PostgreSQL le virgolette doppie, SQLite le accetta entrambe ma preferisce le virgolette. MySQL ha AUTO_INCREMENT, Post
I’m building a small Go HTTP service with PostgreSQL. Most requests are synchronous, but I’m starting to add work that doesn’t need to finish before returning a response: sending notifications, processing uploads, and similar tasks. My current thought is to run those jobs in a small in-process worke
GeoLens is an internal catalog and map builder for spatial data. Drop in a vector or raster file, or connect a WFS, OGC API Features, or ArcGIS service, and the data lands in PostGIS, tiled and searchable. Build a map from those layers in the browser and share it by link or embed. I built this becau
Hey! 👋 I recently shipped ailineart.com, an AI line art generator that turns photos and text prompts into clean line art (sketch, pencil, woodcut, watercolor styles). It's a solo-built, bootstrapped SaaS with a free tier and paid subscriptions. Plenty of posts cover "I picked Next.js and it was gre
Every RAG prototype wants a vector database before it wants a data model. That is usually backwards. The first hard question is not which ANN index has the nicest benchmark chart. It is whether anyone has decided how fresh the embeddings must be, who owns deletes, where tenant boundaries live, how
This week, the AI space saw a surge in open-source enthusiasm, with new tools and libraries capturing developer attention. While the headlines focus on stars and strategic partnerships, we’re diving into the nitty-gritty of how we’ve built a self-hosted Postiz instance using Docker Compose and conne
Last June, a junior analyst pushed a "helpful" GenAI assistant to our internal Tableau-connected lakehouse. Within forty minutes, the agent generated a SELECT * across a 40-terabyte partitioned table joined against a cross-region S3 bucket. The query didn't just fail; it locked the Databricks SQL Wa
Source: https://github.com/nwnuyhs/flatbb (MIT; added after the comments below asked for it) I've just released Flatbb 0.1.5, a flat, lightweight forum written in plain PHP 8.1. MIT licensed, free. No framework, no Composer, no build step. Upload, open the installer, done in 2 minutes. Runs on the
Got tired of getting billed every time a Zapier polling trigger ran just to find zero new rows. Last week I finally bit the bullet and migrated all 42 of our workflows over to a self-hosted n8n instance. The cost difference is honestly ridiculous: Before: - Zapier Pro: $89/mo - Make Pro: $159/mo - T
submitted by /u/der_gopher [link] [留言]
41–60 / 71
