18:45Build smarter search without AI: Fuzzy matching for applications | Data Exposed
Microsoft Developer
Video of a talk by Haki Benita at Citus Con: An Event for Postgres. Haki presents a few lesser known, but useful PostgreSQL features you may have never heard about! For example, do you know how you can get the number of inserted and update rows in an upsert? How to create reproducible random data for testing and demonstrations? Match a text against multiple patterns without complicated condition? How about using \copy with multi-line queries? All that and more Postgres database tips in this talk from the EMEA livestream at Citus Con. Haki Benita is a technical lead and DBA specializing in databases, web development, and performance tuning. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 01:56 Lesser known features from PG 10+ ⏩ 02:40 # of updated & inserted rows at upsert ⏩ 07:18 Sleeping ⏩ 09:07 Match against multiple patterns ⏩ 11:55 Generate reproducible random data ⏩ 14:26 Dollar quoting ⏩ 17:51 Prevent setting the value of an auto-generated key ⏩ 20:34 Add constraints without validating immediately ⏩ 22:49 PSQL tips ⏩ 26:26 Q&A with Haki & Claire ✅ Learn more: Watch more Citus Con talks: https://aka.ms/cituscon-playlist 📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon 📌 Let’s connect: Twitter – @CitusCon, https://twitter.com/CitusCon #CitusCon #PostgreSQL #Database
Published 2022-04-26 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.
18:45Microsoft Developer
02:01
20:24
01:40
19:55Microsoft Developer
57:29
09:02Allow Google Analytics to measure visits. Your history stays in your browser. Privacy details