Backend Basics for Frontend Engineers: Dive into SQL and APIs with Node.js
If you've spent most of your career building beautiful UIs, managing state, and wrestling with CSS, the backend can feel like someone else's problem. …
Latest News
⚑ Report a ProblemTech news from the best sources
All topics
- игры
AI
Gear
News
Tech
agents
ai
api
architecture
automation
beginners
career
claude
devchallenge
devops
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
tutorial
typescript
webdev
Ваш PostgreSQL болеет молча. Десяток запросов, чтобы это увидеть
Пятница, вечер. Один эндпоинт начал отвечать восемь секунд вместо двухсот миллисекунд, а в Grafana всё зелёное. PostgreSQL редко падает громко — он не…
MP3 - SQLi, XSS, and CSRF WriteUp
Introduction For Machine Problem 3, our group — Aki, Lark, and Carl — was tasked with finding and fixing security vulnerabilities in a sample web appl…
SQL Pattern Series #1: The Presence Pattern
Thinking in terms of existence instead of lists SQL Pattern Series #1 of 21 A collection of practical SQL patterns that help developers recognize comm…
I Didn't Want to Open Excel Just to Generate Sequential Numbers in VS Code
While working in VS Code, I occasionally need sequential numbers. Something like this: user_001 user_002 user_003 Or test data for SQL: INSERT INTO us…
DuckDB 1.5.3 Iceberg updates, PostgreSQL TDE extension & AI index tuning
DuckDB 1.5.3 Iceberg updates, PostgreSQL TDE extension & AI index tuning Today's Highlights Today's highlights include DuckDB's enhanced Iceberg i…
Quack-Mate: a chess engine in SQL
We have all seen SQL pushed past its comfort zone to build things like 3D renderers or cellular automata. Naturally, I wondered about a classic comput…
One Practical SQL Trigger Example You Can Actually Use
One UPDATE statement. One trigger. One automatic audit record — no extra code required. Triggers are one of those SQL features that can seem a little …
Медленные запросы в Impala: как анализировать profile и не выносить SQL наружу
Когда Impala-запрос начинает выполняться заметно дольше обычного, первое место, куда обычно идут смотреть, — query profile. Там есть план выполнения, …
A-Z Database Glossary
A comprehensive reference of database terms from A to Z written for beginners and anyone learning how data is stored, managed, and retrieved. Each ter…
SQL Injection Protection in Flask: A Practical Guide. Part 5 of e2ee chat series
The Problem Most developers think their database is safe. It's not. SQL injection attacks can destroy everything. What is SQL Injection? If you write …
Oracle ORA-00022 오류 원인과 해결 방법 완벽 가이드
ORA-00022 invalid session ID 는? ORA-00022 에러는 Oracle 데이터베이스에서 세션 ID가 유효하지 않을 때 발생하는 오류입니다. 주로 DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION , ALTER SYSTEM KILL…
Before SQL, We Had to Tell Computers Everything. Then One Idea Changed That Forever.
Here's something most SQL tutorials skip entirely: SQL wasn't just a new syntax. It was a new way of thinking . Before SQL existed, most systems were …
Миграции в Go-проекте: PostgreSQL в Docker и goose на практике
Когда я начал поднимать PostgreSQL через Docker для своих проектов, всё выглядело просто: описал сервис в docker-compose.yml , запустил контейнер - ба…
How to Correctly Read a PostgreSQL EXPLAIN ANALYZE Output
A slow query lands in your lap. You run EXPLAIN ANALYZE and get back a wall of indented text that looks like someone fed a query plan through a blende…
1 Minute SQL Tips with WoWSQL — 28 May 2026
1 Minute PostgreSQL Tip: Indexing JSONB for Faster Lookups 🚀 Ever struggled with slow queries on your JSONB columns? You're not alone. Many developers…
Oracle ORA-00018 오류 원인과 해결 방법 완벽 가이드
ORA-00018란? ORA-00018 에러는 Oracle 데이터베이스에서 허용 가능한 최대 세션 수를 초과했을 때 발생하는 오류입니다. 새로운 사용자나 애플리케이션이 데이터베이스에 접속을 시도할 때, 이미 SESSIONS 파라미터에 설정된 한도에 도달한 경우 신규 접…
Последовательное иерархическое распределение сумм. Создание БД. Распределение сумм по правилам средствами PostgreSQL
В первой статье была описана задача распределения сумм затрат между отделами по заданным правилам, с учётом того что отделы могут передавать свои затр…
SQLite Bugfix, PostgreSQL Migrations & Filesystem API Paradigm
SQLite Bugfix, PostgreSQL Migrations & Filesystem API Paradigm Today's Highlights This week, we dive into a critical SQLite predicate evaluation b…
SiteRows example #1:
Hello world! I'm starting this series of examples/use-cases of siterows.com, the new app I recently built. Without further ado... 🔹 Quick reminder of …
Полиморфные ссылки в PostgreSQL: три попытки помочь оптимизатору
Недавно я опубликовал статью о полиморфных ссылках в реляционных базах — болезненном для производительности паттерне с дискриминированным внешним ключ…
Vector‑native RAG on Oracle: embeddings, HNSW/IVF, and hybrid search under database governance
Key Takeaways Storing vectors in an Oracle VECTOR column alongside content, metadata, and provenance means retrieval happens inside the database. Exis…
SchemaSpy vs SchemaCrawler - Which Database Documentation Tool is Right for You?
Both SchemaSpy and SchemaCrawler are free, open-source tools for documenting and analysing relational databases over JDBC. Both have been around for o…
SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns
SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns Today's Highlights This week, we dive into SQLite's build process with SQLITE_DQ…
How I Built an End-to-End HR Attrition Dashboard Using MySQL & Power BI
Losing great employees is incredibly expensive for businesses. To show potential employers how I tackle real-world business problems using data engine…
Introducing Oracle Support in Dory
Introducing Oracle Support in Dory Dory now supports Oracle Database. If your team keeps core business data, finance data, ERP data, order systems, re…
DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives
DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives Today's Highlights This week features significant advancements for DuckDB'…
The N+1 Query That Killed Our Database, And How I Fixed It
Everything Worked…But Not Well APIs are affected by the way data is retrieved from the database, and that's something that affected a recent teammate …
qrrot — база данных со встроенным ИИ
Написать свою in-memory базу данных — это своеобразный способ изучить Go под капотом и сделать значимый пет-проект. Создавать обычную обертку над map …
SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec
SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec Today's Highlights This week's highlights feature a practical checklist f…