all AI news
Upsert in SQL
Sept. 25, 2023, 8:34 p.m. |
Simon Willison's Weblog simonwillison.net
Anton Zhiyanov is currently on a one-man quest to write detailed documentation for all of the fundamental SQL operations, comparing and contrasting how they work across multiple engines, generally with interactive examples.
Useful tips in here on why "insert... on conflict" is usually a better option than "insert or replace into" because the latter can perform a delete and then an insert, firing triggers that you may not have wanted to be fired.
Via Hacker News
conflict databases documentation examples interactive multiple operations postgresql sql sqlite tips work
More from simonwillison.net / Simon Willison's Weblog
Fast groq-hosted LLMs vs browser jank
1 day, 6 hours ago |
simonwillison.net
AI counter app from my PyCon US keynote
2 days, 4 hours ago |
simonwillison.net
Understand errors and warnings better with Gemini
2 days, 22 hours ago |
simonwillison.net
Jobs in AI, ML, Big Data
Software Engineer for AI Training Data (School Specific)
@ G2i Inc | Remote
Software Engineer for AI Training Data (Python)
@ G2i Inc | Remote
Software Engineer for AI Training Data (Tier 2)
@ G2i Inc | Remote
Data Engineer
@ Lemon.io | Remote: Europe, LATAM, Canada, UK, Asia, Oceania
Artificial Intelligence – Bioinformatic Expert
@ University of Texas Medical Branch | Galveston, TX
Lead Developer (AI)
@ Cere Network | San Francisco, US