Shreyansh Gupta @_backslashzero
💻 Software Engineer • Sharing my learnings shreyanshgupta.hashnode.dev Joined August 2015-
Tweets119
-
Followers33
-
Following85
-
Likes63
#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
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

NeetoDeploy @NeetoDeploy
80 Followers 52 Following Platform-as-a-service solution for deploying your applications on the cloud with minimum friction. Alternative of Heroku & render. @NeetoHQ product.
Prateek Arora @Prateek_Codes
443 Followers 128 Following Working as Software Engineer @BigBinary | documenting my Journey ✌🏼| Ruby on Rails 💎 and ReactJS ⚛️ | Google Scholar Udacity 2K18💫
Abhay V Ashokan @abhayvashokan
143 Followers 302 Following Tech-lead at @BigBinary (he/vim) | In theory, theory and practice are the same. In practice, they are not.
Raghuram Bachu 🐯 @RaghuramBachu
358 Followers 303 Following Living in the moment, Coder, Online and Offline Tutor, Moving closer towards becoming Full Stack Developer
AndresJiAr @AndresJiAr
1K Followers 3K Following 💻 Student #100DaysOfCode ⚡️ HTML • CSS • JavaScript • React • GraphQL 🎧 Music enthusiast 🙍♂️ He / his / him
Puneet Tiwari @heyitspuneet
256 Followers 567 Following Software Engineer @KridaFans @AltCampus Alumni #javascript #elixir #ruby
Somaditya Basak @5n0w_cr45h
615 Followers 5K Following Remote Jobs @ Mercor: https://t.co/vJBj4rLs91
Vikas Chandra @_VikasChandra
2K Followers 3K Following Project Lead for Plug-in Development Environment (PDE), Committer in JDT, Platform, Equinox, GMF
Harshaan Nihal Khan @klassynihal
240 Followers 552 Following Software Engineer @HiSaeloun @AltCampus Alumni
Sunny Singh @sunnyssr_1507
288 Followers 346 Following 💻 Software Engineer ❤️ JavaScript, Inclusive Design, OSS, Inclusion and Community.
Remoter [Remote Jobs] @remoter_net
50 Followers 112 Following Find your next Remote Job in a few hours💪 Hire the best remote workers👨💻 Made by @dzumax
Tejas Aithal (。◕�... @Tejas_Aithal
798 Followers 1K Following Wheels and cozy indoors enthusiast. Placing small bets across the internet.
Ankit 🦊 @nnnkit
588 Followers 248 Following
corebapp | no code pl... @corebapp
756 Followers 2K Following corebapp is a cloud-native platform that allows you to create complex business applications without writing code. #waylesscode #nocode #corebapp
Akash Sharma @simply__akash
115 Followers 398 Following Frontend Engineer | Cricket Enthusiast | Gamer | Found Footage horror connoisseur.
pywarriors @pywarriors
286 Followers 2K Following Pywarriors is an online platform to learn about the Python Programming Language https://t.co/TlkWkMV8gB
Amit Gupta @a_myth_gupta
57 Followers 151 Following Programming enthusiast and guitar lover, always looking for new things to do and learn.
Vineet Aggarwal @Vineet_1921
2 Followers 158 Following
Ryan Singer @rjs
50K Followers 6 Following Fractional CPO. Author of Shape Up. Former Head of Strategy at 37signals. [email protected]
Ben Eater @ben_eater
23K Followers 78 Following Scaling education somehow. Formerly @khanacademy. Now making things at https://t.co/O7StbNzWXo, https://t.co/wxK2GObTmU, and sometimes https://t.co/hZEJcP4Lr9
Markus Winand @MarkusWinand
9K Followers 265 Following SQL Renaissance Ambassador. Author, Trainer, Coach. PhD in Common Sense. Creator of https://t.co/6oKhq87B43 and https://t.co/RrIy2AY7Tl.
Marco Roth @marcoroth_
3K Followers 2K Following Full-Stack Web Developer • OSS Contributor • Electronic Music Addict • Ruby/Rails, JavaScript/Stimulus • Hotwire Contributors Team • @StimulusReflex Core ✌🏼
Shlomi Noach @ShlomiNoach
2K Followers 55 Following Engineer and database geek @planetscaledata. Open source author. Previously at @GitHub.
Prateek Arora @Prateek_Codes
443 Followers 128 Following Working as Software Engineer @BigBinary | documenting my Journey ✌🏼| Ruby on Rails 💎 and ReactJS ⚛️ | Google Scholar Udacity 2K18💫
Hussein Nasser @hnasr
81K Followers 647 Following Backend and Database Courses https://t.co/Qonec4YftL YouTube https://t.co/FfDg8cnVCI Author of https://t.co/PcX2tDsIxC Engineer @esri
Rosa @rosapolis
4K Followers 199 Following 🇪🇺❤️ cities, maths, theoretical computer science, learning languages, puzzles & bicycles 🐶 Human to Mochi 👩🏻💻 Principal programmer @ 37signals - she/her
Robert Haas @robertmhaas
2K Followers 96 Following VP, Chief Database Scientist at EnterpriseDB; PostgreSQL Major Contributor, Committer 🇺🇦
Abhay V Ashokan @abhayvashokan
143 Followers 302 Following Tech-lead at @BigBinary (he/vim) | In theory, theory and practice are the same. In practice, they are not.
Ben Sheldon (he/him) @bensheldon
1K Followers 822 Following I help small teams do big things and help big teams have big impact. I build @dayoftheshirt, @panlexicon, and @brompt too.
Write of Passage @1WriteofPassage
6K Followers 1K Following Where great writing happens | Our Final Cohort starts October 7
Irina Nazarova @inazarova
4K Followers 1K Following CEO @evilmartians, co-founder @any_cable, running #SFRuby
Arbaaz @arbaazio
371 Followers 1K Following Building - https://t.co/l0QW683K0u Ex-Director Eng @InVideoOfficial, Ex Co-Founder & CTO @proxwrks, Ex @Delta_Exchange
James Gosling @errcraft
32K Followers 70 Following I'm no longer active on Twitter, or even paying attention. I've moved over to Mastodon @[email protected]
Axel Rauschmayer (als... @rauschma
61K Followers 378 Following I’m mainly on Mast*d*n: https://t.co/jLenO6e5ZL • Other ways of connecting with me: https://t.co/fvpPa89Isz…
Andrew Wilkinson @awilkinson
329K Followers 4K Following Co-founder of Tiny w/ @_Sparling_. We own @Dribbble, @Serato, @Letterboxd, @AeroPress, and 35+ other wonderful companies. Author of Never Enough.
Jason Fried @jasonfried
309K Followers 214 Following Started & runs 37signals (makers of Basecamp, HEY, and ONCE). Non-serial entrepreneur, serial author. DM or email me at [email protected].
Kris Hamoud @krishamoud
3K Followers 358 Following Sometimes I just am places. Infra @kit. Builder of StockScent
Brandur @brandur
7K Followers 231 Following Engineering @ Crunchy Data. Ex-Heroku, Ex-Stripe. Occasional writer. Themes: web APIs, Postgres, software resilience, and efficient human interfaces.
Simon Eskildsen @Sirupsen
11K Followers 801 Following co-founder & ceo @turbopuffer, former infra @Shopify 1k→1m RPS
Clearer Thinking @ClearerThinkng
2K Followers 52 Following We build interactive tools and mini-courses you can use to change your habits, make better decisions, and achieve your goals.
Peter Zhu @peterzhu2118
2K Followers 124 Following Staff Developer at @ShopifyEng. Ruby core committer. Photography geek. Mastodon: @[email protected] Bluesky: @peterzhu.ca Instagram: @peterzhu.photos
Sanjay @Sanjay_0508
151 Followers 1K Following Engineering @chainguard_dev • AI/ML • Building @Timestamperr • Prev LFX '23 mentee @CloudNativeFdn • 20y/o
Yann LeCun @ylecun
949K Followers 764 Following Professor at NYU. Chief AI Scientist at Meta. Researcher in AI, Machine Learning, Robotics, etc. ACM Turing Award Laureate.
Greg Molnar @GregMolnar
3K Followers 339 Following Father of 2, OSCP Certified Penetration Tester and a Ruby Developer since 2010 Security for Rails Developers: https://t.co/72XgWS3eOV
Xavier Noria @fxn
12K Followers 530 Following Everlasting student · Rails Core · Zeitwerk · Freelance · Life lover
Nate Berkopec @nateberkopec
25K Followers 90 Following Ruby and Rails applications, made fast. 日本語: @nateberkopec_ja
Short Ruby Newsletter @shortrubynews
2K Followers 331 Following Curated Ruby and Rails Newsletter - created by @lucianghinda Sponsorship https://t.co/Z9uVjLkHCU
Lucian Ghinda @lucianghinda
5K Followers 3K Following Product Engineer, Ruby on Rails Developer Curator of @shortrubynews Trainer at https://t.co/XFRrJeCJ6K
Lawrence Yeo @moretothat
13K Followers 112 Following Writer. Illustrator. Storyteller. Author of The Inner Compass: https://t.co/GvMKUSsh0T
37signals @37signals
133K Followers 13 Following Official account of the team behind Basecamp, HEY, and ONCE.
Addy Osmani @addyosmani
353K Followers 2K Following Engineering leader, @GoogleChrome • Author • Great user, developer & AI experiences • @ChromiumDev @ChromeDevTools • @GoogleDeepMind
RubyCademy @RubyCademy
4K Followers 0 Following We’re passionate about sharing the best Ruby code examples possible! Launchkit by RubyCademy: 🔗 https://t.co/KfnCm9a5Ry
Andrew Ng @AndrewYNg
1.3M Followers 1K Following Co-Founder of Coursera; Stanford CS adjunct faculty. Former head of Baidu AI Group/Google Brain. #ai #machinelearning, #deeplearning #MOOCs
Arslan Ahmad @arslan_ah
1K Followers 315 Following Empowering Engineers to Ace Coding and System Design Interviews | Creator of 'Grokking' Course Series | Founder Design Gurus
Akshay 🚀 @akshay_pachaar
227K Followers 484 Following Simplifying LLMs, AI Agents, RAGs and Machine Learning for you! • Co-founder @dailydoseofds_• BITS Pilani • 3 Patents • ex-AI Engineer @ LightningAI
Cognition @cognition
146K Followers 32 Following Makers of Devin, the first AI software engineer. We are an applied AI lab building end-to-end software agents. Join us: https://t.co/JZDd4Vik4P
Prof. Feynman @ProfFeynman
1.4M Followers 0 Following A universe of atoms, an atom in the universe. Tribute to the great explainer. Tweets about Science and Wisdom. Portrait by L.V Patten.
Abhishek Bose @avi8787
892 Followers 445 Following Ex-Head of Community @PestoTech | Founder of @RemoteIndian | Member of @developer_dao
Ruby On Remote @RubyOnRemote
1K Followers 278 Following Curated remote ruby jobs and companies. Work where you feel best. Follow us for job alerts.
Swastik Yadav @swastikb380
483 Followers 115 Following Software Engineer || Building micro saas in public || Writes about code, AI, & life.