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.
Beware The Missing Foreign Key Index: A Postgres Performance Gotcha
jbranchaud profile

Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

#sql #postgres #database #performance
92
Comments 6
12 min read
Quick post about the SQLite UPSERT and the new RETURNING clause.
mliakos profile

Quick post about the SQLite UPSERT and the new RETURNING clause.

#sql #sqlite
4
Comments
2 min read
SQL vs NoSQL - Which is better for you?
sayanide profile

SQL vs NoSQL - Which is better for you?

#database #sql #tutorial #productivity
5
Comments 3
5 min read
SQLAlchemy Core in Python: Getting Started
bhuma08 profile

SQLAlchemy Core in Python: Getting Started

#sql #python #database #beginners
7
Comments
2 min read
Bases de datos: Vistas
gareisdev profile

Bases de datos: Vistas

#beginners #database #sql
5
Comments 1
2 min read
Ծրագրային անվտանգություն՝ SQL Injection (մաս 2)
narek_babajanyan profile

Ծրագրային անվտանգություն՝ SQL Injection (մաս 2)

#owasp #security #sql
5
Comments
2 min read
Funções - PostgreSQL
alexandrel0pes profile

Funções - PostgreSQL

#postgres #database #sql
5
Comments
5 min read
PostgreSQL: como permitir acesso de leitura a apenas algumas colunas de uma tabela?
ferreira_mariana profile

PostgreSQL: como permitir acesso de leitura a apenas algumas colunas de uma tabela?

#postgres #sql
7
Comments
2 min read
Sanitizing SQL in Rails/ActiveRecord
nicklevenson profile

Sanitizing SQL in Rails/ActiveRecord

#rails #activerecord #ruby #sql
7
Comments
3 min read
PlanetScale CLI Basics
nickelkr profile

PlanetScale CLI Basics

#database #sql #mysql
15
Comments
5 min read
Inner and Outer Joins in SQL
kirstybrews profile

Inner and Outer Joins in SQL

#sql #database #beginners
10
Comments 2
3 min read
Visualizing Covid-19 PostgreSQL Data With Arctype
rettx profile

Visualizing Covid-19 PostgreSQL Data With Arctype

#postgres #tutorial #sql #analyst
2
Comments
7 min read
Ծրագրային անվտանգություն՝ SQL Injection (մաս 1)
narek_babajanyan profile

Ծրագրային անվտանգություն՝ SQL Injection (մաս 1)

#security #sql #injection #owasp
3
Comments
1 min read
Opensource Introduction to SQL eBook 💡
bobbyiliev profile

Opensource Introduction to SQL eBook 💡

#sql #database #webdev #books
27
Comments
3 min read
Rule-based Query Optimization
devozerov profile

Rule-based Query Optimization

#sql #calcite #presto #cockroachdb
4
Comments
7 min read
Database Modeling With Ecto Part 2 - has many and belongs to Relationships
cultofmetatron profile

Database Modeling With Ecto Part 2 - has many and belongs to Relationships

#elixir #phoenix #sql #posgresql
8
Comments 1
7 min read
Automate Backup database SQL Server in docker container.
pobx profile

Automate Backup database SQL Server in docker container.

#sql #linux #docker
8
Comments 1
2 min read
Arel Notes
konnorrogers profile

Arel Notes

#arel #ruby #rails #sql
27
Comments
4 min read
Do Product Led Growth Companies Have Higher Revenue Retention?
rettx profile

Do Product Led Growth Companies Have Higher Revenue Retention?

#growth #product #sql #finance
6
Comments
7 min read
Sql Joins Cheat Sheet
hoanganhlam profile

Sql Joins Cheat Sheet

#sql #cheatsheet
6
Comments 1
1 min read
Querying Your In-Memory-Data-Grid: Why and How?
nfrankel profile

Querying Your In-Memory-Data-Grid: Why and How?

#sql #cache #inmemorydatagrid #query
5
Comments
8 min read
PostgreSQL: How to update large tables
gsandec profile

PostgreSQL: How to update large tables

#sql #codereview #tutorial #postgres
5
Comments
4 min read
Be careful using ROLLBACK on nested transaction in SQL Server!
hanewali profile

Be careful using ROLLBACK on nested transaction in SQL Server!

#sql
6
Comments
3 min read
What is SQL mainly used for?
katholder profile

What is SQL mainly used for?

#sql #database #programming #devops
2
Comments
3 min read
Loading Test Data into PostgreSQL
grschafer profile

Loading Test Data into PostgreSQL

#postgres #sql #tutorial
5
Comments 1
9 min read
SQL Joins
danyson profile

SQL Joins

#sql #database #tutorial
23
Comments 1
3 min read
Ordering fuzzy search results by relevancy using trigrams
anakbns profile

Ordering fuzzy search results by relevancy using trigrams

#sql #postgres #performance
5
Comments
5 min read
Best Practices to Become a Data Engineer
ralphbrooks profile

Best Practices to Become a Data Engineer

#python #datascience #sql
9
Comments
11 min read
How to make the most out of #100DaysOfCode
jo profile

How to make the most out of #100DaysOfCode

#100daysofcode #sql #mysql #postgres
7
Comments
3 min read
SqlAlchemy: simplify complex joins
sarcxd profile

SqlAlchemy: simplify complex joins

#python #sql #sqlalchemy
5
Comments
3 min read
Understanding 'Cursor' in SQL
fahadhassan1213 profile

Understanding 'Cursor' in SQL

#sql #mysql #database
4
Comments 1
1 min read
SQL Migrations with Cobra & Golang Migrate
lucasnevespereira profile

SQL Migrations with Cobra & Golang Migrate

#go #sql #cli #webdev
18
Comments
4 min read
Relational vs Non-Relational Database | Simple Explanation 🚀
saumyanayak profile

Relational vs Non-Relational Database | Simple Explanation 🚀

#database #programming #codenewbie #sql
3
Comments 1
4 min read
4 Free AWS courses on PostgreSQL
vishnuchilamakuru profile

4 Free AWS courses on PostgreSQL

#database #postgres #beginners #sql
4
Comments 1
1 min read
How Database Load Balancing Completes the 3-Tiered Architecture
devgraph profile

How Database Load Balancing Completes the 3-Tiered Architecture

#database #sql #webdev #cloud
6
Comments
5 min read
Should SQL Query through REST API be a GET or a POST?
niolap profile

Should SQL Query through REST API be a GET or a POST?

#help #sql #database
6
Comments 8
1 min read
Sequelize's "Super Many-to-Many" Associations
michaelpaulkunz profile

Sequelize's "Super Many-to-Many" Associations

#javascript #sql #beginners
7
Comments
4 min read
Daily Share Price Notifications using Python, SQL and Africas Talking - Part One
ken_mwaura1 profile

Daily Share Price Notifications using Python, SQL and Africas Talking - Part One

#python #tutorial #postgres #sql
24
Comments 6
12 min read
I want to manually delete rows, so tell me about all referenced tables
adrian_bartosz profile

I want to manually delete rows, so tell me about all referenced tables

#sql
6
Comments
1 min read
PIVOT-UNPIVOT
soumitrabanerjee profile

PIVOT-UNPIVOT

#sql #database
7
Comments
1 min read
Postgres Full Text Search
siddhantk232 profile

Postgres Full Text Search

#postgres #sql #database
3
Comments
5 min read
Flask app with postgreSQL
anja profile

Flask app with postgreSQL

#python #sql
6
Comments
1 min read
Creating PostgreSQL Test Data with SQL, PL/pgSQL, and Python
grschafer profile

Creating PostgreSQL Test Data with SQL, PL/pgSQL, and Python

#tutorial #postgres #sql #python
11
Comments 1
15 min read
Oracle Cheat Sheet
nehasoni__ profile

Oracle Cheat Sheet

#database #sql #beginners
30
Comments 2
5 min read
What is Stored Procedure in SQL
abdurrehmaan profile

What is Stored Procedure in SQL

#sql #mysql #database #beginners
6
Comments
1 min read
How Database Load Balancing Completes the 3-Tiered Architecture
devgraph profile

How Database Load Balancing Completes the 3-Tiered Architecture

#database #sql #architecture #cloud
5
Comments
5 min read
Custom traits in Apache Calcite
devozerov profile

Custom traits in Apache Calcite

#calcite #sql #database
4
Comments
7 min read
Combining SQL outer joins with inner joins
mariszin profile

Combining SQL outer joins with inner joins

#sql
5
Comments
2 min read
Getting started with PostgreSQL Set Operators
rettx profile

Getting started with PostgreSQL Set Operators

#postgres #sql #database #tutorial
7
Comments
4 min read
Quick-start SQL Server 2019 in Docker
hanewali profile

Quick-start SQL Server 2019 in Docker

#sql #docker
4
Comments
1 min read
Popular string functions in MySQL - Replace and Reverse
jo profile

Popular string functions in MySQL - Replace and Reverse

#sql #mysql
4
Comments
1 min read
Using SQL or NoSQL
nevergarden profile

Using SQL or NoSQL

#sql #nosql
7
Comments 3
1 min read
Avoid SQL Server scalar-valued functions in WHERE statements at all cost!
hanewali profile

Avoid SQL Server scalar-valued functions in WHERE statements at all cost!

#sql #5days5blogposts
4
Comments
4 min read
Popular string functions in MySQL - CONCAT and SUBSTRING
jo profile

Popular string functions in MySQL - CONCAT and SUBSTRING

#sql #mysql
3
Comments
2 min read
Programming with SQLite
markm208 profile

Programming with SQLite

#sql #sqlite #cpp #python
5
Comments
2 min read
Can I get a dash of regular expression in my KQL?
anatdagan profile

Can I get a dash of regular expression in my KQL?

#kusto #regex #sql #syntax
7
Comments
1 min read
TypeORM - Multiple DB Calls vs Single DB Call
yoshi_yoshi profile

TypeORM - Multiple DB Calls vs Single DB Call

#node #sql #typescript #database
12
Comments
6 min read
3 small tips to make your SQL Server experience easier
hanewali profile

3 small tips to make your SQL Server experience easier

#sql #5days5blogposts
8
Comments
5 min read
How To Find Unused Stored Procedures In SQL Server
sqlinsix profile

How To Find Unused Stored Procedures In SQL Server

#sql #programming #codequality
6
Comments
3 min read
SQL Review - Useful queries for mySQL
jo profile

SQL Review - Useful queries for mySQL

#mysql #sql #postgres
9
Comments
1 min read
loading...