Laravel Pro Tips

Recent Tweets for #sql

#eloquent #security #sql

๐Ÿ”ฅ Laravel tip: Remember to use bindings in your raw queries. You can pass an array of bindings to most raw query methods to avoid SQL injection. #php #laravel #sql #AI #Java #javascript #100DaysOfCode #learning #web3 #webdevelopment #freelancer #ู…ุทูˆุฑ_ูˆูŠุจ

Code example from devThaer's tweet
Thaer Fayyad | ู…ุทูˆุฑ ูˆูŠุจ Twitter avatar for devThaer

Thaer Fayyad | ู…ุทูˆุฑ ูˆูŠุจ

#eloquent #performance #sql

๐Ÿ”ฅ #Laravel Tip: Eloquent includes methods like โ€˜hasโ€™, to help create simple and easy-to-read queries. However, they donโ€™t always generate efficient SQL, which can lead to poor performance. Hereโ€™s an example of how a โ€˜hasโ€™ query can be refactored to make it much faster at scale.

Code example from mattkingshott's tweet
Matt Kingshott Twitter avatar for mattkingshott

Matt Kingshott

#eloquent #sql #query builder

๐Ÿ”ฅ #Laravel Eloquent Tip - You can use "as" in Eloquent Query Builder to return any column with a new name, exactly like in a regular SQL query.

Code example from mvpopuk's tweet
Marian Pop ๐Ÿ‡บ๐Ÿ‡ฆ Laravel Magazine Twitter avatar for mvpopuk

Marian Pop ๐Ÿ‡บ๐Ÿ‡ฆ Laravel Magazine

#joins #sql

A nice SQL trick - you can update a table from another table using joins ๐Ÿ‘€ Just added a `deleted_at` column to a table and want it populated by one of it's relations, just do an update statement and join them. One simple, yet powerful query ๐Ÿคฏ

Code example from OliverNybroe's tweet
Oliver Nybroe Twitter avatar for OliverNybroe

Oliver Nybroe

View all tweets

Recent Articles for #sql

#eloquent #sql

Clear orderBy in Laravel's Eloquent Builder

If you've tried to use orderBy on a previously ordered query in Laravel, you'll probably find it doesn't work. There's a great reason for that, which we'll explain at the end of the post.

Read full article [codecourse.com]

#sql #transactions #data integrity

Using Database Transactions to Write Safer Laravel Code

In web development, data integrity and accuracy is really important. So, making sure that we write code that stores, updates and deletes data in our databases in a safe way is imperative.

Read full article [laravel.io]
View all articles