#sql Development Tutorials & Tips | Roast Dev

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

How to Get the Raw SQL Query from Laravel Query Builder

When working with Laravel's Eloquent ORM or Query Builder, you may often need to debug or inspect the raw SQL query being executed. Laravel provides several ways to retrieve the raw SQL query, includi...

18.03.2025 0 Read More

Supercharge Your Jupyter Notebook: SQL Command Magic for IPython

Find the executable notebook here.Jupyter Notebooks are widely used for data analysis and scientific computing, but working with databases inside them has always been somewhat cumbersome. While librar...

18.03.2025 0 Read More

Calculate the Hierarchy of Recursive References — From SQL to SPL #11

Problem description & analysis: A certain table in the MS SQL database has a multi-level self-association structure, where the second field parent node ID is a foreign key pointing to the...

18.03.2025 0 Read More

Scalable GraphQL: Why you need DataLoaders

TL;DR DataLoaders solve the N+1 query problem in GraphQL by batching and caching database queries, reducing response times by upto 85% and allowing your API to scale efficiently with data gro...

19.03.2025 0 Read More

You, Too, Can Scale Postgres to 2 PB and 1 T Metrics per Day

One Timescale Cloud database service is now ingesting a trillion metrics per day and storing almost two petabytes of data, challenging all assumptions that Postgres can’t scale. 🔍 Jump to the ful...

20.03.2025 0 Read More

SQL vs. NoSQL: The Debate That Shouldn't Exist

For years, the tech community has framed SQL and NoSQL as competitors, each with passionate advocates. In reality, they are complementary technologies, each suited to particular tasks. Modern applicat...

19.03.2025 0 Read More

SQL Unleashed: Optimize Your Queries and Recalibrate Your Coding Journey" to a level two heading by using

Ever spent hours debugging a slow SQL query and wondered, “What am I missing?” Today, let's dive into a powerful technique—using Common Table Expressions (CTEs) and indexing—to optimize your S...

19.03.2025 0 Read More

SQL evaluation framework for accurate query assessment

Explore a systematic approach to evaluating SQL query generation by comparing results against predefined gold queries while accounting for valid variationsBy Yaswanth VudumulaThis article was original...

19.03.2025 0 Read More

Twitter Stuck Signing Up? No Email, Phone Field Broken?

Let’s talk about something we’ve all dealt with: signing up for a new app or service and hitting a wall because the email never arrives or the phone number field just won’t cooperate. Frustratin...

20.03.2025 0 Read More

Mastering SQL Server CONTAINS for Advanced Text Search

Finding relevant text data efficiently requires full-text search capabilities. SQL Server’s CONTAINS function allows searching for words, phrases, and synonyms in indexed columns. How to use...

20.03.2025 0 Read More

How to Get the Raw SQL Query from Laravel Query Builder

Supercharge Your Jupyter Notebook: SQL Command Magic for IPython

Calculate the Hierarchy of Recursive References — From SQL to SPL #11

Scalable GraphQL: Why you need DataLoaders

You, Too, Can Scale Postgres to 2 PB and 1 T Metrics per Day

SQL vs. NoSQL: The Debate That Shouldn't Exist

SQL Unleashed: Optimize Your Queries and Recalibrate Your Coding Journey" to a level two heading by using

SQL evaluation framework for accurate query assessment

Twitter Stuck Signing Up? No Email, Phone Field Broken?

Mastering SQL Server CONTAINS for Advanced Text Search

#reading

#popular