#plsqlsequentialcontrol zoekresultaten
BOOST PRODUCTIVITY, TIGHTEN CONTROL AND SIMPLIFY QUALITY MANAGEMENT WITH PSL DATATRACK 2025 - engineering-update.co.uk/2025/12/18/boo…
My coworker shared the following blog with me yesterday: cs.cmu.edu/~pavlo/blog/20… The short summary of the blog is why Postgres databases way of reading and writing multiple queries (MVCC - Multi Version Concurrency Control) is pretty darn bad compared to other databases.
Hot take: There is no good way to reuse SQL query logic. Not CTEs. Not UDFs. Not stored procedures. I've tried them all and they don't work. So I built ExoQuery to give SQL the polymorphic API it should have had. Here's how it works 👇 exoquery.com/blog/interface…
SQL Execution Order 📘 Save it now.. #sql
The old way is dead. With Higgsfield's Sora 2, every video you make is a paycheck. You can create cinematic UGC and sell it on sites like Fiverr. No camera needed. It's unlimited and globally available. Let me explain this.
How PostgreSQL Works: Internal Architecture Explained 1. 𝐏𝐫𝐨𝐜𝐞𝐬𝐬-𝐁𝐚𝐬𝐞𝐝 𝐀𝐫𝐜𝐡𝐢𝐭𝐞𝐜𝐭𝐮𝐫𝐞: PostgreSQL follows a process-per-connection architecture, meaning each client connection is handled by a dedicated operating system process. 2. 𝐖𝐫𝐢𝐭𝐞 𝐀𝐡𝐞𝐚𝐝…
𝗢𝗸𝗲 𝗺𝗮𝗿𝗶 𝗸𝗶𝘁𝗮 𝗯𝗮𝗵𝗮𝘀 𝗸𝗮𝗽𝗮𝗻 𝗵𝗮𝗿𝘂𝘀 𝗺𝗲𝗺𝗶𝗹𝗶𝗵 𝗠𝘆𝗦𝗤𝗟 𝗮𝘁𝗮𝘂 𝗣𝗼𝘀𝘁𝗴𝗿𝗲𝗦𝗤𝗟 Kalau butuh feature yang komplit atau data model aplikasi kamu kompleks: Postgres If performance matters: Kalau aplikasi kamu read-heavy: MySQL Kalau aplikasi kamu…
Ending my periodic plasma calibration subroutine. END PLSCAL (2024:038:001228:2T)
a discussion to make Postgres multi-threaded has just started few days ago reading the thread is very interesting seeing experienced individual discussing low level os details. postgresql.org/message-id/31c…
The first paragraph is critical to understanding Postgres. Once a developer knows this, they will be mindful with their queries. The work the db does will be appreciated.
SQL is the backbone of your data career. Writing good SQL scripts is an art. Here's how you can master it in 2023 🧵
Bonus 🤩 Here's my Youtube playlist explaining each concept in detail and solving the practise problems! youtube.com/playlist?list=…
SQL is an essential skill to have as a Data Scientist 🧑💻 Here are two handy SQL cheat-sheets to revise SQL commands 🚀
"Push-based Outbox Pattern with Postgres Logical Replication" event-driven.io/en/push_based_…
event-driven.io
Push-based Outbox Pattern with Postgres Logical Replication - Event-Driven.io
Event-Driven by Oskar Dudycz
A @biantris pediu mais cedo uma lista dos tópicos mais importantes de SQL, então fiz um roadmapzinho com indicações do que estudar e em que ordem para ir do básico ao avançado. gist.github.com/coproduto/5e8c… Se gostarem, deem um RT por favor para que possa chegar em mais gente :)
Understand Your PostgreSQL Workloads Better with pg_stat_monitor percona.com/blog/understan…
percona.com
Understand Your PostgreSQL Workloads Better with pg_stat_monitor
Gaining additional insights and understanding your PostgreSQL workload is critical, and pg_stat_monitor can help you do both.
How to Throttle MySQL Load With ProxySQL percona.com/blog/2020/10/0… #mysql #proxysql #percona
Wrote one mad ass SQL query this afternoon and I'm so proud of myself. This query optimized my data retrieval by 100% 💥
#PostgreSQL 12 - Generated column "This is an SQL-standard feature that allows creating columns that are computed from expressions rather than assigned, similar to a view or materialized view but on a column basis." git.postgresql.org/gitweb/?p=post…
Bulk Data Movement to SQL Databases in Hybrid Cloud prgress.co/2rRwWOi
Something went wrong.
Something went wrong.
United States Trends
- 1. Colts 44K posts
- 2. Philip Rivers 19.9K posts
- 3. Brock Purdy 13.2K posts
- 4. #FTTB 6,149 posts
- 5. Niners 7,947 posts
- 6. Kittle 8,186 posts
- 7. Dee Winters 1,768 posts
- 8. Ballard 2,638 posts
- 9. #WWERaw 21.1K posts
- 10. #SFvsIND 2,130 posts
- 11. #ForTheShoe 2,389 posts
- 12. Tonges 1,136 posts
- 13. Alec Pierce 3,535 posts
- 14. Jennings 15.6K posts
- 15. Adam the Woo 1,938 posts
- 16. Jonathan Taylor 3,237 posts
- 17. Tyler Warren 2,340 posts
- 18. #LADS2ndAnniversary 4,928 posts
- 19. Pelicans 4,767 posts
- 20. Steichen N/A