DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
The old MySQL bug (detective story)

The old MySQL bug (detective story)

1
Comments
2 min read
When To Use SQL vs NoSQL: An Expert Guide to Databases

When To Use SQL vs NoSQL: An Expert Guide to Databases

1
Comments
11 min read
620. Not Boring Movies leetcode solution

620. Not Boring Movies leetcode solution

5
Comments
1 min read
610. Triangle Judgement

610. Triangle Judgement

4
Comments
1 min read
1050. Actors and Directors Who Cooperated At Least Three Times leetcode solution

1050. Actors and Directors Who Cooperated At Least Three Times leetcode solution

5
Comments
1 min read
Range indexes for LIKE queries in YugabyteDB

Range indexes for LIKE queries in YugabyteDB

Comments
8 min read
AI tool to automatically write, optimize, edit, and debug SQL

AI tool to automatically write, optimize, edit, and debug SQL

Comments
2 min read
DROP IF EXISTS & CREATE IF NOT EXISTS in Oracle, MySQL, MariaDB, PostgreSQL, YugabyteDB