Shreyansh Gupta
@_backslashzero
💻 Software Engineer • Sharing my learnings
Tal vez te guste
#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 Tendencias
- 1. Virginia Tech 6,751 posts
- 2. James Franklin 6,459 posts
- 3. Sonic 3 10.7K posts
- 4. GOTY 22.8K posts
- 5. Grok 4.1 11.2K posts
- 6. Moana 32.9K posts
- 7. Expedition 33 35.1K posts
- 8. Zelda 59.9K posts
- 9. Blacksburg N/A
- 10. #TheGameAwards 41K posts
- 11. Ted Cruz 17.8K posts
- 12. Va Tech N/A
- 13. Baton Rouge 2,614 posts
- 14. Hokies 1,324 posts
- 15. Comey 33.6K posts
- 16. FEMA 7,905 posts
- 17. Marr Chase 13.5K posts
- 18. Until Dawn 3,405 posts
- 19. #RestoreTheSnyderVerse 44.4K posts
- 20. Brent Pry N/A
Something went wrong.
Something went wrong.