SQL-like Queries in FSRS Plugin for Obsidian
SQL-like Queries in FSRS Plugin for Obsidian Spaced repetition in Obsidian usually works as "show all cards with due earlier than today." That's enoug…
Latest News
⚑ Report a ProblemTech news from the best sources
All topics
AI
Gear
News
Tech
agents
ai
api
architecture
automation
beginners
career
database
devchallenge
devops
gemma
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
tutorial
typescript
webdev
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. …
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 …
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 …
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 파라미터에 설정된 한도에 도달한 경우 신규 접…
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 …
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 …
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…
Chai aur SQL — A Beginner's Journey into Databases
SQL stands for Structured Query Language. It is the language we use to talk to relational databases like MySQL, PostgreSQL, and SQLite. What is a Serv…
DuckDB 1.5.2 Release, DuckLake v1.0 & PostgRESTxn for Atomic PG Transactions
DuckDB 1.5.2 Release, DuckLake v1.0 & PostgRESTxn for Atomic PG Transactions Today's Highlights DuckDB announces its 1.5.2 patch release with perf…
PostgreSQL 17 in Production: Partitioning Improvements, COPY Progress, and the Features That Actually Matter
PostgreSQL 17 in Production: What Actually Matters PostgreSQL 17 shipped with a mix of incremental improvements and a few genuine breakthroughs. After…
Building an African Economic Data Pipeline with Python, DuckDB & World Bank API
Every data engineer knows the struggle: finding a project that's both technically impressive and genuinely useful. Today I'll walk you through AfriDat…
DuckDB 1.5.3 Adds Quack Client-Server, SQLite Gets Cypher Graph Extension
DuckDB 1.5.3 Adds Quack Client-Server, SQLite Gets Cypher Graph Extension Today's Highlights This week, DuckDB releases version 1.5.3 with the Quack c…