Opens profile photo
Follow
DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»
@ThePracticalDev
The Twitter account that launched dev.to. Built on 🌱
dev.toJoined August 2014

DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»β€™s Tweets

Topics to follow

Sign up to get Tweets about the Topics you follow in your Home timeline.

Carousel

In the last few minutes of #DevDiscuss, does anybody have any news to share, like a project, a personal win, or any other announcement? Promote yourself!
Liz Lemon Teaches The Selfie High Five GIF
GIF
8
A lot of concurrency issues can be solved by the database server. Upserts, SELECT FOR UPDATE, transactions, etc will make your life simpler.
Quote Tweet
Time for #DevDiscuss! Tonight’s topic is… SQL 101. - What are your tips for early-career devs interested in exploring SQL? - Any SQL resources/courses to recommend? - What’s your top SQL tip for data analysis?
Coding Work From Home GIF by Domme Space
GIF
2
5
23
Database querying is so hairy. One misformed query and BAM SQL Injection. Interested in these replies
Quote Tweet
Time for #DevDiscuss! Tonight’s topic is… SQL 101. - What are your tips for early-career devs interested in exploring SQL? - Any SQL resources/courses to recommend? - What’s your top SQL tip for data analysis?
Coding Work From Home GIF by Domme Space
GIF
1
1
13
Familiarize yourself with the query planner. Look at the execution plans for your queries. Some upfront indexing helps a lot but sometimes the planner behaves oddly depending on your data. For postgres, pganalyze is an awesome tool.
Quote Tweet
Time for #DevDiscuss! Tonight’s topic is… SQL 101. - What are your tips for early-career devs interested in exploring SQL? - Any SQL resources/courses to recommend? - What’s your top SQL tip for data analysis?
Coding Work From Home GIF by Domme Space
GIF
5
11
Two rules for new devs when it comes to working with databases: 1) Use a different tool to connect to production than you do to connect to your local/test/qa environments. If you can't use a different tool, have some kind of visual marker that tells you you're messing with prod.
Quote Tweet
Time for #DevDiscuss! Tonight’s topic is… SQL 101. - What are your tips for early-career devs interested in exploring SQL? - Any SQL resources/courses to recommend? - What’s your top SQL tip for data analysis?
Coding Work From Home GIF by Domme Space
GIF
2
7
38
Show this thread
Even though it is cool nowadays to learn all the NoSQL stuff and different database, be aware that chances are you'll have to deal with a RDBMS for sure , eventually. So learn the basics: JOINs, indexing, GROUP BY, locking and isolation levels, correlated subqueries #DevDiscuss
6
40
If you want to learn about relational databases, the single best thing you can do is get a job with an established (>5 yrs old) company. See the database after some of the growing pains are sorted out. Learn the patterns. 1/? #DevDiscuss
Quote Tweet
Time for #DevDiscuss! Tonight’s topic is… SQL 101. - What are your tips for early-career devs interested in exploring SQL? - Any SQL resources/courses to recommend? - What’s your top SQL tip for data analysis?
Coding Work From Home GIF by Domme Space
GIF
2
2
23
Show this thread
I'm no expert at SQL but Tutorialspoint has helped me a lot in understanding how to normalize a database and how to run complex queries using the different kinds of joins.
Quote Tweet
Time for #DevDiscuss! Tonight’s topic is… SQL 101. - What are your tips for early-career devs interested in exploring SQL? - Any SQL resources/courses to recommend? - What’s your top SQL tip for data analysis?
Coding Work From Home GIF by Domme Space
GIF
3
10
Replying to
Early-career dev tips: β€’ SQL is amazingly powerful (especially with CTEs and windowing functions) and can scale much better than many (usually NoSQL advocates) give it credit for when properly indexed β€’ learn to index properly β€’ sqlite isn't just a toy #DevDiscuss
4
7
44
Time for #DevDiscuss! Tonight’s topic is… SQL 101. - What are your tips for early-career devs interested in exploring SQL? - Any SQL resources/courses to recommend? - What’s your top SQL tip for data analysis?
Coding Work From Home GIF by Domme Space
GIF
10
11
34
At my work project, I've the chance to work with a custom template engine for creating backend configurations that helps to populate the content and layout of what shows on the frontend to users. Its magical but also painful to work with πŸ˜† Ever work with blackboxes like this?
2
1
18
Time to vote on the topic of tonight's #DevDiscuss Twitter chat (9 PM ET/2 AM UTC)!
  • Anti-harassment tooling
    21.1%
  • Vent session
    21.1%
  • SQL 101
    31.1%
  • Code editor preferences
    26.7%
90 votesFinal results
1
I tell people I have versatile work, but it really is versatile. I go from wrangling websockets to coaching public speakers, to pair testing with colleagues, to designing testing for embedded to cloud, to decision making in board room in cadence of half-a-day.
1
3
23