14 - Server-side Logic Execution / User-defined Functions (CMU Advanced Databases / Spring 2023)

preview_player
Показать описание

15-721 Advanced Database Systems (Spring 2023)
Carnegie Mellon University
  1. CMU Database Group
  2. databases
  3. carnegie mellon university
Рекомендации по теме
14 - Server-side 1:13:48

14 - Server-side Logic Execution / User-defined Functions (CMU Advanced Databases / Spring 2023)

NextJS 14 0:04:30

NextJS 14 ways to test if code will be executed server or client side

How to create 0:03:41

How to create server side logic with Backand

Next.js 14 Tutorial 0:07:29

Next.js 14 Tutorial - 56 - Server-only Code

Next.js 14 Tutorial 0:06:07

Next.js 14 Tutorial - 47 - Server-side Rendering (SSR)

DON'T Make This 0:05:14

DON'T Make This Mistake with Next.js Server Components (BAD performance!)

Senior Programmers vs 0:00:34

Senior Programmers vs Junior Developers #shorts

Build Modern Next 0:42:51

Build Modern Next 14 Server Side App with Server Actions, Infinite Scroll & Framer Motion Animat...

Server-Side Rendering (SSR) 0:09:01

Server-Side Rendering (SSR) & Hydration in Angular Explained

SSTI Complete Lab 0:03:57

SSTI Complete Lab Breakdown: Server-side template injection in a sandboxed environment

Next.js: Authentication (Best 0:12:14

Next.js: Authentication (Best Practices for Server Components, Actions, Middleware)

Server Side Data 0:10:11

Server Side Data Fetching in NextJS | NextJS in Hindi

The ultimate guide 0:06:43

The ultimate guide to web performance

This Data Fetching 0:07:19

This Data Fetching Combo is OP

The Simple Solution 0:05:14

The Simple Solution to Traffic

Next.js 14 Tutorial 0:06:08

Next.js 14 Tutorial - 58 - Context Providers

How to Deploy 0:06:21

How to Deploy Java Web Application in WebLogic Server

Client-side Rendering vs 0:18:23

Client-side Rendering vs Server-side Rendering

Advanced SQL Tutorial 0:06:15

Advanced SQL Tutorial | Stored Procedures + Use Cases

Learn Next.js 14 6:19:23

Learn Next.js 14 Server Actions With This One Project (UseFormStatus, UseFormState, Error Handling)

Next.js 14 Tutorial 0:09:01

Next.js 14 Tutorial - 49 - React Server Components (RSC)

What Are Server 0:01:00

What Are Server Actions in Next.js?

NestJS in 100 0:02:21

NestJS in 100 Seconds

How to Improve 0:09:55

How to Improve Performance in React with Code Splitting

Комментарии
Автор

Super wholesome to let Sam finish up like that :)

StasPakhomov-wjnn
Автор

The last part of the lecture is a very nice motivation for the next lectures about query optimizers

thomasziereis
Автор

1:00:00 Just wanted to point out that "call?" is not a constant string value that is being passed around, but the name of the first colum of the CTE. Its value is 'false' if the base case of the recursion is reached, and 'true' in the recursive case.

What makes this stuff so hard to read IMHO is that the SELECT comes before the WHERE which is the other way around from the `if` in the original code.
Maybe it is easier to read if you swap their order (which is no longer valid SQL but fast and loose reasoning is morally correct and all that):

(WHERE i1 >= n SELECT (false, 0, 0, 0, 0, p1)) UNION ALL (WHERE i1 < n SELECT (true, i1+1, p1*x, x, n, 0))

w-mcode