LEAD vs LAG #SQL #쇼츠
NewLearning 뉴러닝
2024. 6. 30.
LEAD와 LAG를 비교하는 쇼츠입니다~ SQL 관련 쇼츠에요. #개발자 #SQL #쇼츠
Recommanded Videos
부트캠프 1기 - 004 - 첫 번째 과제
부트캠프에 참여 중인 분들에게 첫 번째 과제를 제시합니다. 잘 수행하셔서 좋은 결과를 얻으시면 좋겠습니다. :)
2024. 7. 18.
Run Postgres in a Docker Container (Easiest PostgreSQL Setup)
Backend Engineering Mind Map - https://calcur.tech/mindmap Mentorship to land six figure engineering roles - https://calcur.tech/mentorship 💯 FREE Courses (100+ hours) - https://calcur.tech/free-courses Timestamps: 00:00 - Intro 01:46 - Run Postgres within Docker 04:29 - Connect with pgAdmin 05:15 - Connect with psql (terminal) 06:36 - Connect from Code (Django) 08:14 - Resetting Postgres 10:11 - Persist Data with Volumes 🏆 C++ Mastery Course - https://cppmastery.com ⚛️ FREE React Course (20 hours) - https://calcur.tech/free-react-course ✅ Data Structures & Algorithms - https://calcur.tech/dsa-youtube Backend Python Course - https://calcur.tech/backend-python ~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~ ✉️ Newsletter - https://calcur.tech/newsletter 📸 Instagram - https://www.instagram.com/CalebCurry 🐦 Twitter - https://twitter.com/calebCurry 🔗 LinkedIn - https://www.linkedin.com/in/calebcurry ▶️ Subscribe - http://calcur.tech/subscribe 👨🏻🎓 Courses - https://www.codebreakthrough.com ~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~ ↪ My Amazon Store - https://www.amazon.com/shop/calebcurry 🅿 Patreon - http://calcur.tech/patreon-calebcurry 🅖 GitHub Sponsors - https://github.com/sponsors/CalebCurry Ⓟ Paypal - http://paypal.me/calcur
2024. 9. 20.
Build Full Stack Social Media App in React Native #3 - User Profile
Hello everyone 👋, In this video you will learn how fetch data from Supabase using simple functions and implement user profile screen in the full stack Social Media App in React Native. Visit the live website for more cool projects: https://codewithnomi.com Source Code: https://codewithnomi.com/projects/social-media-app 🏞️ Assets: https://drive.google.com/uc?export=download&id=1gfAgQEF38zKe91fvkGm0hTHWA0oSx6QR Supabase User Management (function and trigger): https://supabase.com/docs/guides/auth/managing-user-data Supabase React Native Auth: https://supabase.com/docs/guides/auth/quickstarts/react-native Learn Expo Router: https://youtu.be/jJl-DZ3d8k8 If you appreciate my work and you would like to support my channel: https://www.buymeacoffee.com/codewithnomi 🚨 more videos on react native: Wallpaper App: https://youtu.be/Feqq9e04svw Firebase Auth & Chat: https://youtu.be/wncM96HYcxw Fitness App: https://youtu.be/asMSo4DLq6s Food Recipe App : https://youtu.be/cdnneQjsoT0 Movie App : https://youtu.be/Q1xQuCpYIFE Onboarding UI with Lottie Animations: https://youtu.be/4-GKgqIUBNo AI Voice Assistant with ChatGPT & DALL-E : https://youtu.be/nf3t5p2a5Dg Travel App UI : https://youtu.be/vV9zIDgT4Ik Weather App : https://youtu.be/953vyZMO4cM Coffee App UI : https://youtu.be/mhyuMy4aI-M Food Delivery App : https://youtu.be/v-zxqkz1T8E Youtube Clone App: https://youtu.be/AVovt3gFmsg Login | SignUp UI : https://youtu.be/RhF4iUCiwSs Fast Food App : https://youtu.be/x5hX06YdRvI App Store UI : https://youtu.be/Wp6JtHj4lyM Fruit Shop UI : https://youtu.be/UwW__s37agw Firebase Authentication React Native: https://youtu.be/idPGWpVLHP0 Food Delivery App : https://www.youtube.com/playlist?list=PLKWMD009Q4qReQz5FOcvBik9WBJanJVZd Learn React Native: https://www.youtube.com/playlist?list=PLKWMD009Q4qTGuqXxRq51f8OoDaIoJ1yo #Hashtags #expo #reactnative #javascript #tailwindcss #programming #typescript #speedcode #coding #design #appdevelopment #reactjs #ui #uiux #reactnavigation #reactnativetutorial #react #animation #reactjs #navigation #navigationbar #uidesign #mobiledevelopment #iosdeveloper #buildinpublic #opensource #reactnativeapp #reactjstutorial #typescript
2024. 7. 30.
Contextual RAG is stupidly brilliant!
Anthropic introduces Contextual RAG and here are some key points! Embeddings+BM25 is better than embeddings on their own; Voyage and Gemini have the best embeddings of the ones we tested; Passing the top-20 chunks to the model is more effective than just the top-10 or top-5; Adding context to chunks improves retrieval accuracy a lot; Reranking is better than no reranking; All these benefits stack: to maximize performance improvements, we can combine contextual embeddings (from Voyage or Gemini) with contextual BM25, plus a reranking step, and adding the 20 chunks to the prompt. 🔗 Links 🔗 https://www.anthropic.com/news/contextual-retrieval ❤️ If you want to support the channel ❤️ Support here: Patreon - https://www.patreon.com/1littlecoder/ Ko-Fi - https://ko-fi.com/1littlecoder 🧭 Follow me on 🧭 Twitter - https://twitter.com/1littlecoder Linkedin - https://www.linkedin.com/in/amrrs/
2024. 9. 23.
Next.js / Supabase: CRUD, Authentication, RPC, Database, Functions, Buckets, Server Actions
In this comprehensive course, you'll learn everything you need to know about #Supabase for #Next.js development: Effortless Authentication: Implement login with Google, GitHub, and email/magic links. Database Management: Master Supabase's database features using the SQL editor and table editor. Access Control: Secure your data with Row Level Security (RLS) policies. Automate Workflows: Create functions and triggers to react to database events. Protect Your App: Implement server-side authorization and protect specific pages. Handle Complex Logic: Build server-side actions for advanced functionality. And More... #codewithlari #supabase #nextjs14 #typescript #rpc #postgresql Let's connect on linkedIn: https://www.linkedin.com/in/laribright/ Github: https://github.com/laribright/supabase-nextjs Want to buy me a coffee?: https://www.buymeacoffee.com/laribright SQL https://github.com/laribright/supabase-nextjs/blob/deployment/sql.txt Docs: Middleware: https://supabase.com/docs/guides/auth/server-side/creating-a-client?environment=middleware https://supabase.com/docs/guides/auth/server-side/oauth-with-pkce-flow-for-ssr Timestamps: 0:00 Intro 02:52 Getting the source code 04:14 - Project walkthrough 06:07 - Supabase 14:54 - Nextjs Supabase Client (Supabase SSR) 23:20 - Email Passwordless Authentication Magic Link 33:53 - Google / Github Authentication 43:54 - Routes protection (Retrieve current user) 49:17 - Signout 51:56 - Middleware, 53:58 - SQL, User schema, Functions - Triggers, RLS, 01:14:40 - Fetch user data (getUser vs getSession) 01:19:55 - Supabase types 01:24:09 - Supabase Bucket / User UPDATE 01:46:38 - Server Actions / supabase RPC 🚀 02:01:50 - Protecting Server Page 02:06:49 - Outro
2024. 3. 15.
NextJS 라우팅 방식의 장점과 다른 방식들과의 차이점?!
안녕하세요 보아스입니다. Nextjs 는 왜 폴더 구조 기반의 라우팅을 선택하게 되었을까요? 이에 대한 답을 찾기 위해서 먼저 폴더 구조 기반 외에 다른 라우팅 방식은 어떤 것들이 있는지 살펴보았어요. 중에서 Nextjs 는 왜 이런 방식으로 라우팅을 하게 되었는지, 이 방식의 장점도 살펴보았습니다. 늘 그렇듯이 함께 성장하는 여러분 모두를 응원합니다. 그럼 오늘도 화이팅입니다.
2024. 6. 29.