ByteByteGo·3yEP50: Visualizing a SQL Query
The most useful engineering conversation you’ll hear each week (Sponsored) Dev Interrupted is the No. 1 source for what the smartest minds in development are thinking about. Hear career-changing wisdom by leaders from companies like Slack, Stripe, and Shopify delivered to your inbox every week.
KDnuggets·3ySQL Query Optimization Techniques
Learn how to optimize SQL queries for faster and more memory efficient execution. Topics include using EXIST() instead of COUNT(), using varchar instead of char, avoiding subqueries in WHERE clause, ordering JOINs from a larger table to a smaller table, and using regexp_like instead of LIKE clause.
RUBYLAND·3yPairing with GPT-4
GPT-4 can be helpful for Ruby developers in creating a Ruby script that downloads a RubyGem, parses the docs using YARD, and stores the data in a SQLite database. However, GPT-4 has limitations and may require additional troubleshooting and refinements. The provided post offers step-by-step instructions for creating the script and addresses common issues encountered.
The Art of Simplicity·3yThe lost art of writing SQL queries
Most (junior) developers no longer are able to write anything but the most trivial queries. If you want to sharpen your SQL skills, have a look at https://www.sql-practice.com/. Here you get a whole list of exercises that require writing SQL queries. If you get stuck hints are available that help you get on the right track.
Foojay.io·3y5 Great Reasons to use jOOQ
JOOQ is an internal domain-specific language (DSL) modelling the SQL language as an API directly in Java. This provides compile-time type safety to your query and enables a lot of other interesting features that I'll show later. JOOQ's code generator also generates stubs for your stored procedures.
