Setting Up PostgreSQL in VS Code — From Download to Your First Query (Plus Password Rescue)
PostgreSQL is one of the most popular open-source relational databases in the world, and you don't need to leave your editor to work with it. In thi…
Последние новости
⚑ Сообщить о проблемеTech news from the best sources
Все темы
AI
Gear
News
Tech
agents
ai
api
architecture
automation
beginners
career
database
devchallenge
devops
discuss
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
security
showdev
testing
tutorial
typescript
webdev
My PostgreSQL Database Went from 139 GB to 29 GB. Here's Why.
Background Recently I was migrating our databases from RDS to Snowflake Postgres . I was using pg_dump and pg_restore to take a dump of source datab…
Supabase in 2026: Is This Open Source Backend Worth a Try?
If you have ever started a side project and spent the first weekend wiring up a database, user sign-ups, file uploads and an API before writing a si…
Website to Vector Database: A Small, Traceable Pipeline
A vector database can store vectors. It cannot tell you which page produced a passage or whether that passage is stale. This example uses one docume…
Model Instruments as First-Class Records: Calibration Status, Check Readings and Out-of-Tolerance Holds in a Food ERP
By Isaac Muthui, CEO, Tamalaki Business Network Ltd. Originally published at factoraerp.com . Most factory software treats a measurement as a number…
RAG Context Budget: Pack Evidence Without Burying the Answer
When a RAG answer is wrong, the reflex is often to raise top_k . More retrieved chunks feels safer. In production, it can do the opposite: the one u…
TIL: Install GBase Database as root, Initialize the Instance as gbasedbt
When installing GBase Database (GBase 8s) manually on Linux, one common source of confusion is the instruction not to use root . Does that mean you…
TIL: Why GBase Database Manual Installation Doesn't Create an Instance by Default
If you're installing GBase Database (GBase 8s) manually for the first time, you might encounter a surprising result: the software installation compl…
DocuFlow: Turning Invoice PDFs into Structured Financial Data with Python and Docker
DocuFlow: Turning Invoice PDFs into Structured Financial Data Invoices are easy to overlook when they’re just files sitting in a folder. But once yo…
Processing 1,249 Finished Matches: Pipeline Notes
One match day, 1,249 finished matches across the data set. The daily export landed with 546 standings rows, 200 scorer lines and 418 rows of match s…
The File Format: Pages, Headers, and Magic Bytes
Series: nosqlite devlog, Part 2 The first article was about the why. This one is where things get concrete. I remember the exact moment I opened a h…
Snowflake Meets Collibra: A Data Engineer Interviews a Governance Expert
Collibra helps a company know its data: what it means, where it came from, if it is correct, and who can use it. This interview explains it in plain…
schemagate tops BIRD Mini-Dev in SQLite, PostgreSQL and MySQL
BIRD Mini-Dev is 500 text-to-SQL questions over 11 real databases, in three dialects. It is scored by execution accuracy: run the query, and compare…
From 100 Million Events to 1,200 Pixels: Engineering a Data-Heavy Dashboard
Your dashboard has a chart that is about 1,200 pixels wide. Behind it sits a table that grows by a few million rows a day. Somebody opens the page,…
Model Allergens as Data, Not Label Text: Material Flags, Line State and Changeover Gates in a Food ERP
By Isaac Muthui, CEO, Tamalaki Business Network Ltd. Originally published at factoraerp.com . In a lot of factory systems, allergens live in exactly…
How We Used FalkorDB to Make a Security Alert Explain Itself
Our entry for Graph Hacks by WeMakeDevs × FalkorDB The problem: an alert with no context A security analyst might see hundreds of alerts a day. One…
PostgreSQL Constraint Naming Convention: Which Pattern to Use, and How to Find the Names That Drifted
Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: Use the pattern PostgreSQL alrea…
VALGRAPH
Building VALOGRAPH: Real-Time Valorant Tactical Graph Intelligence & Persistent Agent Memory with FalkorDB and Groq Competitive gaming moves in…
How I Used FalkorDB to Trace Software Security Risks in Warden
You’re right—you want the article body , based on the actual README. Use the title separately, then paste everything under Post content into Dev.to.…
Deploy your own PocketBase backend to a remote env in less than an hour
Context Every once in a while I have to stand up a new backend/DB. I used to just use Supabase, but I don't like the idea of not owning my data, and…
We loaded FalkorDB's GitHub into FalkorDB: Now it explains itself
We chose the dataset where a wrong answer would get caught fastest: a year of FalkorDB's own GitHub history, loaded into FalkorDB. Ask Aevion "Who k…
We Built FFlake at Graph Hacks, and Graphs Made More Sense Than We Expected
By the FFlake team | FalkorDB Graph Hacks 2026 Honestly, building a project during a hackathon is a different experience when the clock is actually…
Your company's knowledge doesn't go missing. It goes wrong.
How we built Strata, a company brain on FalkorDB that notices when a document has become false, for Graph Hacks. Code: https://github.com/manasdutta…
BlastShield AI: an evidence-first incident commander built on FalkorDB
The safest cloud response starts with a path, not a prompt BlastShield AI: an evidence-first incident commander built on FalkorDB When a cloud incid…
A Practical Guide to SQL Joins, Subqueries, CTEs, and Window Functions.
A hospital database rarely stores every useful detail in one table. Patient details may be stored separately from visit records. Doctor, department,…
Seven Alerts at 2 AM: Building an AI On-Call Agent with a Graph Database
It's 2 AM. Your phone buzzes, then buzzes again. Seven alerts in four minutes. Frontend says Orders failing . The API gateway is throwing 5xx errors…
Exploring Hospital Data: Window Functions, Joins, CTEs and Subqueries
Introduction While working on my hospital dataset, I realised that SQL is not just about retrieving data. It can also help me compare hospital visit…
Model Pest Control So Activity Has a Location and an Owner: Device, DeviceCheck, Sighting and CorrectiveAction
By Isaac Muthui, CEO, Tamalaki Business Network Ltd. Originally published at factoraerp.com . In most factory systems, pest control does not exist a…
Why Flat Vector DBs Break Agent Swarms — And How We Built AgentMesh AI with FalkorDB
Why Flat Vector DBs Break Agent Swarms — And How We Built AgentMesh AI with FalkorDB If you have built multi-agent systems using frameworks like Lan…
Logging in PL/SQL that survives ROLLBACK (and 4 mistakes to avoid)
You get a call: last night's batch failed, the transaction rolled back, and now someone asks "what happened?" You open your log table. It's empty. I…