Shreyansh Gupta
@_backslashzero
💻 Software Engineer • Sharing my learnings
You might like
#TIL The SQL Row values syntax can also be used in the WHERE clauses. It is most commonly seen in the INSERT statements. Check out the usage here - use-the-index-luke.com/sql/partial-re… #SQL #Databases
#DoYouKnow Ensuring that the database executes the query in a pipelined manner is more important than a fast execution! Read more here - use-the-index-luke.com/sql/sorting-gr… #SQL #Databases
#DoYouKnow? The 2 main ingredients that make an index slow are - 1. The table access 2. Scanning a wide index range #Databases #SQL
#TIL A seemingly important, yet overlooked, consideration for optimizing SQL queries is the use of bind parameters to enable execution plan cache. Read more here - use-the-index-luke.com/sql/where-clau… #Databases #SQL
#DoYouKnow? If your index is getting too big in size, you can index only a subset of the values using Partial Indexes. Read more here - use-the-index-luke.com/sql/where-clau… #Databases #SQL
#TIL We can create partial indexes on tables. Useful when the table also has deleted records but we want to index only the non-deleted records. Read more here - haseebeqx.com/posts/how-to-a… #RubyOnRails #PostgreSQL
#TIL We can include columns in covering index without having to create index structures for all possible values of all the columns. Read more here - haseebeqx.com/posts/how-to-a… #RubyOnRails
#TIL You can get the explain output for ActiveRecord queries using the explain method. Read more here - haseebeqx.com/posts/rails-ex… #RubyOnRails
Read examples for optimizing queries on @hashnode! shreyanshgupta.hashnode.dev/example-for-op… #MySQL #SQL #Databases
Learn how to write efficient queries in MySQL on @hashnode! shreyanshgupta.hashnode.dev/how-to-write-e… #MySQL #SQL #Databases
Learn about Indexes in MySQL and when to use them on @hashnode! shreyanshgupta.hashnode.dev/indexes-in-mys… #MySQL #Indexing #Databases
Learn about Data types in MySQL on @hashnode! shreyanshgupta.hashnode.dev/data-types-in-… #MySQL #SQL #Databases
Check out the different tools in Ruby on Rails to perform Strong migrations on @hashnode! shreyanshgupta.hashnode.dev/strong-migrati… #RubyOnRails #Ruby #MySQL #PostgreSQL
Learn about ACID transactions in databases on @hashnode! shreyanshgupta.hashnode.dev/acid-transacti… #Databases #Transactions
Check out this video. It shows a really informative take on the practicality of CAP Theorem. youtu.be/qWvzyIiR8iA #100DaysOfCode
youtube.com
YouTube
CAP Theorem: not what we thought it was, not what we are looking for...
Learn to migrate databases with large amounts of data without downtime. Check out this article on "gh-ost" - an Online Schema Change tool on @hashnode! shreyanshgupta.hashnode.dev/gh-ost-an-onli… #Databases #MySQL #100DaysOfCode
#TIL about the #SQL IGNORE statement. It can be used with INSERT / UPDATE / DELETE to ignore the violating rows instead of failing with an error. Read more here - geeksforgeeks.org/sql-insert-ign…
Learn about the different Replication formats in databases on @hashnode! shreyanshgupta.hashnode.dev/replication-fo… #Databases #Replication #Logging
Learn about writing safer migrations on @hashnode! shreyanshgupta.hashnode.dev/strong-migrati… #RubyOnRails #Databases #Concurrency
United States Trends
- 1. #IDontWantToOverreactBUT N/A
- 2. #TSCollection N/A
- 3. $BNKK 1,091 posts
- 4. Victory Monday 4,272 posts
- 5. #MondayMotivation 40.5K posts
- 6. Zelda 34.5K posts
- 7. Jake Paul 8,776 posts
- 8. Good Monday 55K posts
- 9. #RestoreTheSnyderVerse 8,476 posts
- 10. Anthony Joshua 6,503 posts
- 11. #MondayVibes 3,128 posts
- 12. WILLIAMEST DESTINY 650K posts
- 13. Guma 25.3K posts
- 14. Angel Reese 2,692 posts
- 15. $NXXT 1,514 posts
- 16. Happy Founders N/A
- 17. Founders Day N/A
- 18. Miyamoto 8,501 posts
- 19. $AMZN 7,119 posts
- 20. Peyz 10.2K posts
Something went wrong.
Something went wrong.