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.
Handling NULL in the DBs
irinabezgina profile

Handling NULL in the DBs

#database #dataengineering #sql
5
Comments 1
2 min read
Unwrap Oracle Home .plb
franckpachot profile

Unwrap Oracle Home .plb

#oracle #troubleshooting #sql #database
17
Comments
2 min read
Use Chance.js and Fony.js in your SQL queries😎
loiclefevre profile

Use Chance.js and Fony.js in your SQL queries😎

#javascript #backend #database #sql
Comments
20 min read
Learning SQL? Here's a grab bag of links.
virtualandy profile

Learning SQL? Here's a grab bag of links.

#sql #postgres #mysql #postgressql
3
Comments 5
3 min read
“Multi-AZ” in Amazon RDS and how it may differ from High Availability or resilience to failures
franckpachot profile

“Multi-AZ” in Amazon RDS and how it may differ from High Availability or resilience to failures

#sql #database #resilience #availability
19
Comments
12 min read
Comand Line Tools to Export SQL Server Query to CSV
jfraziz profile

Comand Line Tools to Export SQL Server Query to CSV

#sql #database #productivity #tooling
7
Comments
5 min read
The power of MERGE in PostgreSQL 15
rozhnev profile

The power of MERGE in PostgreSQL 15

#sql #postgres #tutorial
Comments
3 min read
BigQuery deduplication strategies
sagnikbanerjeesb profile

BigQuery deduplication strategies

#bigquery #sql #googlecloud #data
4
Comments
5 min read
Understanding SQL Joins: A Beginner's Guide
katerinamykhailyk profile

Understanding SQL Joins: A Beginner's Guide

#sql #beginners #database #programming
Comments
5 min read
A Simple Guide to Graph Databases for Beginners.
chidera profile

A Simple Guide to Graph Databases for Beginners.

#apacheage #postgres #sql
4
Comments
2 min read
Creating a database with Azure SQL database.
keneojiteli profile

Creating a database with Azure SQL database.

#azure #sql #learning #cloud
2
Comments
2 min read
TiDB: Distributed MySQL with Foreign Key (not production ready) and not Serializable
franckpachot profile

TiDB: Distributed MySQL with Foreign Key (not production ready) and not Serializable

#distributed #sql #database #tidb
Comments
5 min read
🦦 What OtterTune hates the most in PostgreSQL🐘 is solved in YugabyteDB🚀
franckpachot profile

🦦 What OtterTune hates the most in PostgreSQL🐘 is solved in YugabyteDB🚀

#postgres #yugabytedb #distributed #sql
9
Comments
10 min read
Cypher: How to Determine Degree Centrality and Rank Nodes by Influence Using Cypher Queries
m4rcxs profile

Cypher: How to Determine Degree Centrality and Rank Nodes by Influence Using Cypher Queries

#apacheage #postgres #sql
3
Comments
2 min read
How ACID is Citus? (compared to YugabyteDB)
franckpachot profile

How ACID is Citus? (compared to YugabyteDB)

#distributed #sql #database #yugabytedb
8
Comments 3
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.