Skip to content
Navigation menu
Search
Search
Log in
Create account
DEV Community
Close
select * from SQL
Follow
Posts on tips and tricks, using and learning about SQL for database development and analysis.
Posts
Left menu
👋
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Database Design: "How to Create a Robust and Scalable Data Model"
Huzaifa
Huzaifa
Huzaifa
Follow
May 18
Database Design: "How to Create a Robust and Scalable Data Model"
#
apache
#
postgres
#
sql
#
database
2
reactions
Comments
Add Comment
3 min read
Open-source SPL Eliminates Tens of Thousands of Intermediate Tables from Databases
jbx1279
jbx1279
jbx1279
Follow
May 21
Open-source SPL Eliminates Tens of Thousands of Intermediate Tables from Databases
#
database
#
programming
#
sql
Comments
Add Comment
8 min read
SAS Function setDateByNumberBDays
Dutra
Dutra
Dutra
Follow
May 18
SAS Function setDateByNumberBDays
#
sas
#
sql
#
proc
2
reactions
Comments
Add Comment
1 min read
SAS Function isBrHolidayworkingDaysBetweenDates
Dutra
Dutra
Dutra
Follow
May 18
SAS Function isBrHolidayworkingDaysBetweenDates
#
sas
#
sql
#
proc
2
reactions
Comments
Add Comment
1 min read
SAS Functions previous and next BusinessDay
Dutra
Dutra
Dutra
Follow
May 18
SAS Functions previous and next BusinessDay
#
sas
#
sql
#
datefunctions
#
proc
2
reactions
Comments
Add Comment
1 min read
Create Stored Procedures using Embedded Python
InterSystems Developer
InterSystems Developer
InterSystems Developer
Follow
for
InterSystems
May 18
Create Stored Procedures using Embedded Python
#
python
#
sql
#
beginners
#
tutorial
2
reactions
Comments
Add Comment
5 min read
How to build a music player part 2: Introduction MySQL database
Themba🇿🇦
Themba🇿🇦
Themba🇿🇦
Follow
May 15
How to build a music player part 2: Introduction MySQL database
#
database
#
webdev
#
beginners
#
sql
Comments
Add Comment
3 min read
A Quick Guide to AI-Powered Data Visualization: Create a Smart Dashboard with LogicLoop.
Busayo Samuel
Busayo Samuel
Busayo Samuel
Follow
May 12
A Quick Guide to AI-Powered Data Visualization: Create a Smart Dashboard with LogicLoop.
#
beginners
#
tutorial
#
sql
#
analytics
11
reactions
Comments
Add Comment
6 min read
25 SQL tricks for beginners.
H.Brian
H.Brian
H.Brian
Follow
May 20
25 SQL tricks for beginners.
#
database
#
sql
4
reactions
Comments
1
comment
2 min read
Managing Calendar Availability in Supabase
Ivan Afanasev
Ivan Afanasev
Ivan Afanasev
Follow
May 18
Managing Calendar Availability in Supabase
#
tutorial
#
postgres
#
sql
#
react
2
reactions
Comments
Add Comment
3 min read
SAS Function isBrHoliday
Dutra
Dutra
Dutra
Follow
May 17
SAS Function isBrHoliday
#
sas
#
sql
#
datefunctions
#
procfcmp
2
reactions
Comments
Add Comment
1 min read
SAS Function isBusinessDay
Dutra
Dutra
Dutra
Follow
May 18
SAS Function isBusinessDay
#
sas
#
sql
#
datefunctions
#
proc
2
reactions
Comments
Add Comment
1 min read
pg_hint_plan in views? No. But in UDFs, Yes
Franck Pachot
Franck Pachot
Franck Pachot
Follow
for
AWS Heroes
May 17
pg_hint_plan in views? No. But in UDFs, Yes
#
postgres
#
yugabytedb
#
distributed
#
sql
1
reaction
Comments
Add Comment
10 min read
Managing Dataflow and SQL Database with Concurrency Control
Dwarves Foundation
Dwarves Foundation
Dwarves Foundation
Follow
May 4
Managing Dataflow and SQL Database with Concurrency Control
#
database
#
concurrency
#
sql
1
reaction
Comments
Add Comment
8 min read
My Favorite Free Courses to Learn Data Science in Depth
javinpaul
javinpaul
javinpaul
Follow
May 19
My Favorite Free Courses to Learn Data Science in Depth
#
datascience
#
machinelearning
#
sql
#
python
30
reactions
Comments
Add Comment
15 min read
Description of important clauses in SQL and Apache age query format part 2
Talha Munir 🇵🇸
Talha Munir 🇵🇸
Talha Munir 🇵🇸
Follow
May 12
Description of important clauses in SQL and Apache age query format part 2
#
apache
#
apacheage
#
postgressql
#
sql
Comments
Add Comment
2 min read
Description of important clauses in SQL and Apache age query format part 1
Talha Munir 🇵🇸
Talha Munir 🇵🇸
Talha Munir 🇵🇸
Follow
May 12
Description of important clauses in SQL and Apache age query format part 1
#
sql
#
postgres
#
database
Comments
Add Comment
2 min read
Exploring Advanced and Modern Concepts in SQL with Practical Examples.
Mwenda Harun Mbaabu
Mwenda Harun Mbaabu
Mwenda Harun Mbaabu
Follow
May 19
Exploring Advanced and Modern Concepts in SQL with Practical Examples.
#
datascience
#
data
#
sql
#
mysql
27
reactions
Comments
5
comments
4 min read
7 Bad Practices to Avoid When Writing SQL Queries for Better Performance 🚀
Abdelrahman Mohamed Allam
Abdelrahman Mohamed Allam
Abdelrahman Mohamed Allam
Follow
May 19
7 Bad Practices to Avoid When Writing SQL Queries for Better Performance 🚀
#
sql
#
performance
#
database
9
reactions
Comments
2
comments
4 min read
BigQuery deduplication strategies
Sagnik Bandyopadhyay
Sagnik Bandyopadhyay
Sagnik Bandyopadhyay
Follow
Apr 30
BigQuery deduplication strategies
#
bigquery
#
sql
#
googlecloud
#
data
1
reaction
Comments
Add Comment
5 min read
Postgres Concurrency : What could go wrong (part 1)
Lucas Barret
Lucas Barret
Lucas Barret
Follow
May 18
Postgres Concurrency : What could go wrong (part 1)
#
postgres
#
sql
5
reactions
Comments
Add Comment
4 min read
How ACID is CitusDB?(compared to YugabyteDB)
Franck Pachot
Franck Pachot
Franck Pachot
Follow
for
YugabyteDB
Apr 26
How ACID is CitusDB?(compared to YugabyteDB)
#
distributed
#
sql
#
database
#
yugabytedb
Comments
Add Comment
4 min read
Interpreting Low-Code from the perspective of open-source SPL
jbx1279
jbx1279
jbx1279
Follow
Apr 29
Interpreting Low-Code from the perspective of open-source SPL
#
programming
#
lowcode
#
sql
#
datascience
Comments
Add Comment
8 min read
TiDB: Distributed MySQL with Foreign Key but not Serializable
Franck Pachot
Franck Pachot
Franck Pachot
Follow
Apr 28
TiDB: Distributed MySQL with Foreign Key but not Serializable
#
distributed
#
sql
#
database
#
tidb
Comments
Add Comment
5 min read
MySQL 8.0: Invisible Columns
Slava Rozhnev
Slava Rozhnev
Slava Rozhnev
Follow
May 16
MySQL 8.0: Invisible Columns
#
mysql
#
tutorial
#
sql
3
reactions
Comments
Add Comment
2 min read
Generate Random Text Strings in PostgreSQL
Franck Pachot
Franck Pachot
Franck Pachot
Follow
for
AWS Heroes
May 15
Generate Random Text Strings in PostgreSQL
#
postgres
#
tips
#
sql
#
database
2
reactions
Comments
Add Comment
1 min read
PIVOT & UNPIVOT operators
Olesia
Olesia
Olesia
Follow
May 15
PIVOT & UNPIVOT operators
#
sql
#
database
#
dataengineering
#
datascience
2
reactions
Comments
2
comments
3 min read
Analyzing Uber and Uber Eats Expenses Using DBT, Postgres, Gmail, Python, SQL And PowerBI
Stefen
Stefen
Stefen
Follow
May 15
Analyzing Uber and Uber Eats Expenses Using DBT, Postgres, Gmail, Python, SQL And PowerBI
#
powerbi
#
dbt
#
sql
#
python
Comments
Add Comment
9 min read
Range indexes for LIKE queries in YugabyteDB
Franck Pachot
Franck Pachot
Franck Pachot
Follow
for
YugabyteDB
Apr 22
Range indexes for LIKE queries in YugabyteDB
#
yugabytedb
#
postgres
#
distributed
#
sql
Comments
Add Comment
8 min read
Tutorial for Middle/Senior Level Developer: General Query Solution
InterSystems Developer
InterSystems Developer
InterSystems Developer
Follow
for
InterSystems
Apr 25
Tutorial for Middle/Senior Level Developer: General Query Solution
#
tutorial
#
programming
#
sql
Comments
Add Comment
19 min read
Why ETL Becomes ELT or Even LET?
jbx1279
jbx1279
jbx1279
Follow
May 14
Why ETL Becomes ELT or Even LET?
#
database
#
bigdata
#
sql
#
programming
Comments
Add Comment
8 min read
When To Use SQL vs NoSQL: An Expert Guide to Databases
Dom | Five.Co
Dom | Five.Co
Dom | Five.Co
Follow
Apr 24
When To Use SQL vs NoSQL: An Expert Guide to Databases
#
sql
#
database
#
datascience
1
reaction
Comments
Add Comment
11 min read
SQL vs. NoSQL - cutting through the Tech Twitter noise