ViewTube

Oracle vs PostgreSQL Explained | Key Technical Differences** Oracle Database or PostgreSQL—which one is right for your ...

SQL injection shown safely on toy data in a throwaway PostgreSQL 16 schema, then fixed. A PL/pgSQL search that concatenates ...

SQL Server vs PostgreSQL | Database Migration Considerations Planning to migrate from Microsoft SQL Server to PostgreSQL?

Stored functions, procedures and triggers in PostgreSQL 16, measured on 100000 generated orders, and when that logic belongs ...

Predicting what PostgreSQL 16 really does at each isolation level, with every demo run in two real sessions. READ COMMITTED ...

How hashing works, with real hash values from PostgreSQL 16's internal hash functions. A hash function is deterministic, fixed ...

An eight-step method for a slow query, run end to end on PostgreSQL 16 with 20000 generated customers and 220000 orders: ...

Modelling data that changes over time in PostgreSQL 16. A price list with a daterange validity column: [ ) half-open bounds by ...

Three end-to-end optimization case studies on PostgreSQL 16 with generated data, each taken through the same loop: symptom, ...

Loops in procedural SQL: when they help (going through result rows, array elements, counting up to a condition), LOOP with ...

A cursor lets you process a query result piece by piece instead of all at once. Why cursors have a bad reputation and when to ...

I added up the same 100000 prices twice in Python and got two different totals. Floating-point addition rounds the running total at ...

Where a cache belongs and how to keep it consistent, measured on PostgreSQL 16 with 100000 generated orders. PostgreSQL ...

When a serial primary key hits 2147483647, the sequence, the column and every foreign key all need widening. What each fix ...

Triggers run an action before, after or instead of an operation on a table. When they are worth using and what they cost with ...

What a query execution plan is: the tree of steps the database works out before SELECT, INSERT, UPDATE and DELETE. The ...

The SQL injection antipattern: where it comes from (a parameter from the application pasted into the query text), where it can ...