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.
Optimize Rails app performance with ChatGPT
ka8725 profile

Optimize Rails app performance with ChatGPT

#chatgpt #sql #postgres #performance
1
Comments
5 min read
JDBC program for Delete operation
realnamehidden1_61 profile

JDBC program for Delete operation

#jdbc #java #advancedjava #sql
5
Comments
1 min read
Awesome SQL Code Review Tools for Developers
surajondev profile

Awesome SQL Code Review Tools for Developers

#sql #codequality #beginners #webdev
100
Comments 6
4 min read
Let's MERGE INTO Postgres !
yet_anotherdev profile

Let's MERGE INTO Postgres !

#postgres #sql
5
Comments 2
2 min read
LIMIT vs. FETCH in SQL
nalgeon profile

LIMIT vs. FETCH in SQL

#sql
14
Comments 1
2 min read
Join Elimination - Advanced SQL tuning
pawsql profile

Join Elimination - Advanced SQL tuning

#discuss #mysql #postgres #sql
74
Comments 1
3 min read
Introduction to SQL keys
aviatorifeanyi profile

Introduction to SQL keys

#database #sql #datascience #data
5
Comments
4 min read
Best Practices for SQL Coding and Development
dbvismarketing profile

Best Practices for SQL Coding and Development

#sql
Comments
11 min read
REST API with ASP.NET Core 7 and SQL Server
kashifsoofi profile

REST API with ASP.NET Core 7 and SQL Server

#rest #api #csharp #sql
12
Comments 1
7 min read
Joins in DBMS
aryan_shourie profile

Joins in DBMS

#sql #dbms #database
17
Comments 2
3 min read
Mastering the Art of SQL Queries: Unleashing the Power of Data
sohammanjrekar profile

Mastering the Art of SQL Queries: Unleashing the Power of Data

#sqlqueries #sql #database
1
Comments
3 min read
Comparing IF, IIF, and CASE
ranggakd profile

Comparing IF, IIF, and CASE

#mssql #programming #learning #sql
4
Comments
3 min read
Advance SQL tricks.
brianmk profile

Advance SQL tricks.

#sql #datascience #database
10
Comments 1
1 min read
Exploring PostgreSQL's EXCLUDE Operator: Advanced Data Constraints
rozhnev profile

Exploring PostgreSQL's EXCLUDE Operator: Advanced Data Constraints

#sql #postgressql #tutorial
4
Comments 1
3 min read
Using Triggers to Map Database Relationships in Custom Claims
mansueli profile

Using Triggers to Map Database Relationships in Custom Claims

#postgres #sql #supabase #triggers
3
Comments
6 min read
TEMPORARY FUNCTION IN SQL
stevephary profile

TEMPORARY FUNCTION IN SQL

#sql #datascience #database
3
Comments
2 min read
DROP TABLE while being read: wait or wound?
franckpachot profile

DROP TABLE while being read: wait or wound?

#distributed #sql #postgres #yugabytedb
1
Comments
8 min read
Interpreting Low-Code from the perspective of open-source SPL
jbx1279 profile

Interpreting Low-Code from the perspective of open-source SPL

#programming #lowcode #sql #datascience
Comments
8 min read
Don't miss out on the new features in SQL Server 16.x
notte profile

Don't miss out on the new features in SQL Server 16.x

#sql #database #datascience #sqlserver
5
Comments 2
2 min read
Oracle MERGE to UPDATE SQL
rmaurodev profile

Oracle MERGE to UPDATE SQL

#sql #oracle #database
Comments
3 min read
How to connect multiple databases to Django project
karthiknarayan profile

How to connect multiple databases to Django project

#django #sql #python #backend
16
Comments 1
2 min read
Routable computing engine implements front-end database
jbx1279 profile

Routable computing engine implements front-end database

#database #sql #bigdata #programming
Comments
5 min read
The Trade-offs Between Database Normalization and Denormalization
er_dward profile

The Trade-offs Between Database Normalization and Denormalization

#database #sql #mysql #postgres
14
Comments 1
4 min read
Sequelize Migration
bhavinvirani profile

Sequelize Migration

#sequelize #node #sql #database
2
Comments
2 min read
Analyzing Uber and Uber Eats Expenses Using DBT, Postgres, Gmail, Python, SQL And PowerBI
stefentaime profile

Analyzing Uber and Uber Eats Expenses Using DBT, Postgres, Gmail, Python, SQL And PowerBI

#powerbi #dbt #sql #python
Comments
9 min read
Creating a Node.js web app service and SQL Database in Azure
lomosa profile

Creating a Node.js web app service and SQL Database in Azure

#webapp #node #azure #sql
8
Comments
4 min read
Approximate Count for hash sharded YugabyteDB tables
franckpachot profile

Approximate Count for hash sharded YugabyteDB tables

#yugabytedb #postgres #distributed #sql
Comments
4 min read
SQL Case Study - Tiny Shop Sales
shahbazpycread profile

SQL Case Study - Tiny Shop Sales

#sql #join #subquery
3
Comments 2
6 min read
How to write SQL query in Ruby On Rails
ka8725 profile

How to write SQL query in Ruby On Rails

#sql #postgres #rails #railsdevelopment
Comments
4 min read
Parallel Scan in YugabyteDB (ysql_select_parallelism=-1)
franckpachot profile

Parallel Scan in YugabyteDB (ysql_select_parallelism=-1)

#yugabytedb #distributed #sql #database
Comments
3 min read
Seamlessly Save and Load Reports from SQL Server Database to Blazor Pivot Table
jollenmoyani profile

Seamlessly Save and Load Reports from SQL Server Database to Blazor Pivot Table

#blazor #webdev #sql #productivity
Comments
16 min read
Subqueries Unraveled: Exploring SQL’s Hidden Power
john-maina profile

Subqueries Unraveled: Exploring SQL’s Hidden Power

#sql #datascience #data
1
Comments 6
3 min read
25 SQL tricks for beginners.
brianmk profile

25 SQL tricks for beginners.

#database #sql
27
Comments 2
2 min read
How to pivot data using Dynamic SQL in SQL Server
notte profile

How to pivot data using Dynamic SQL in SQL Server

#sql #database #dataengineering #mssql
5
Comments 4
3 min read
Exploring Advanced and Modern Concepts in SQL with Practical Examples.
grayhat profile

Exploring Advanced and Modern Concepts in SQL with Practical Examples.

#datascience #data #sql #mysql
41
Comments 13
4 min read
Postgres Concurrency : What could go wrong (part 2)
yet_anotherdev profile

Postgres Concurrency : What could go wrong (part 2)

#postgres #sql
6
Comments 2
3 min read
Generate SQL Script in PostgreSQL
franckpachot profile

Generate SQL Script in PostgreSQL

#postgres #tips #sql #database
2
Comments
1 min read
How does the in-memory database bring memory’s advantage into play?
jbx1279 profile

How does the in-memory database bring memory’s advantage into play?

#database #sql #bigdata
Comments
12 min read
A Worthy Sequel: An Overview of Next-Gen NoSQL Databases
ndewald profile

A Worthy Sequel: An Overview of Next-Gen NoSQL Databases

#prove #sql #database #learning
2
Comments
4 min read
Deploying an App Service in Azure and Connecting to SQL Database
arbythecoder profile

Deploying an App Service in Azure and Connecting to SQL Database

#appservice #azure #database #sql
3
Comments
3 min read
SQL Case Study 2: Human Resources
shahbazpycread profile

SQL Case Study 2: Human Resources

#sql #join #cte #data
2
Comments 1
4 min read
Open-source SPL Eliminates Tens of Thousands of Intermediate Tables from Databases
jbx1279 profile

Open-source SPL Eliminates Tens of Thousands of Intermediate Tables from Databases

#database #programming #sql
5
Comments
8 min read
7 Bad Practices to Avoid When Writing SQL Queries for Better Performance 🚀
abdelrahmanallam profile

7 Bad Practices to Avoid When Writing SQL Queries for Better Performance 🚀

#sql #performance #database
28
Comments 4
4 min read
Building a Node.js Server with Microsoft SQL Database Integration
unlikelycreator profile

Building a Node.js Server with Microsoft SQL Database Integration

#node #sql #mssql #react
1
Comments
2 min read
How to Query 1st, 2nd, or Nth Largest attribute in SQL Table
muneebkhan4 profile

How to Query 1st, 2nd, or Nth Largest attribute in SQL Table

#sql #postgres #backend #webdev
Comments
3 min read
Postgres Concurrency : What could go wrong (part 1)
yet_anotherdev profile

Postgres Concurrency : What could go wrong (part 1)

#postgres #sql
9
Comments
4 min read
How to Survive Phase III of Flatiron School
caseyconlan profile

How to Survive Phase III of Flatiron School

#pyth #flatironschool #coding #sql
1
Comments
4 min read
How to access the ERD (Entity-Relationship Diagram) of your database schema in MySQL Workbench
alumassy profile

How to access the ERD (Entity-Relationship Diagram) of your database schema in MySQL Workbench

#mysql #database #dataanalysis #sql
43
Comments 1
2 min read
SAS Function setDateByNumberBDays
vanhurter profile

SAS Function setDateByNumberBDays

#sas #sql #proc
2
Comments
1 min read
SAS Function isBrHolidayworkingDaysBetweenDates
vanhurter profile

SAS Function isBrHolidayworkingDaysBetweenDates

#sas #sql #proc
2
Comments
1 min read
SAS Functions previous and next BusinessDay
vanhurter profile

SAS Functions previous and next BusinessDay

#sas #sql #datefunctions #proc
Comments
1 min read
Create Stored Procedures using Embedded Python
intersystemsdev profile

Create Stored Procedures using Embedded Python

#python #sql #beginners #tutorial
2
Comments
5 min read
MySQL Basic Select challenges
sn0wf1re profile

MySQL Basic Select challenges

#sql #mysql
Comments
2 min read
Managing Calendar Availability in Supabase with SQL generate_series
ivaaan profile

Managing Calendar Availability in Supabase with SQL generate_series

#tutorial #postgres #sql #react
3
Comments
3 min read
SQL Constraints 101: Ensuring Data Accuracy and Integrity
aviatorifeanyi profile

SQL Constraints 101: Ensuring Data Accuracy and Integrity

#sql #database #data #datascience
1
Comments 4
6 min read
SAS Function isBrHoliday
vanhurter profile

SAS Function isBrHoliday

#sas #sql #datefunctions #procfcmp
2
Comments
1 min read
SAS Function isBusinessDay
vanhurter profile

SAS Function isBusinessDay

#sas #sql #datefunctions #proc
2
Comments
1 min read
pg_hint_plan in views? No. But in UDFs, Yes
franckpachot profile

pg_hint_plan in views? No. But in UDFs, Yes

#postgres #yugabytedb #distributed #sql
3
Comments
10 min read
MySQL 8.0: Invisible Columns
rozhnev profile

MySQL 8.0: Invisible Columns

#mysql #tutorial #sql
3
Comments
2 min read
Introduction to SQL set operators
aviatorifeanyi profile

Introduction to SQL set operators

#sql #database #datascience #analytics
11
Comments 1
5 min read
loading...